Tuesday

ORA 24323 - Report Builder

Yesterday we encountered a weird issue with Report Builder. One of the developers, while working on a report, encountered the following error:

ORA-24323: value not allowed
==> select * from mytable

Report Builder: Release 6.0.8.27.0 - Production on Thu Jun 12 10:10:05 2008

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter Username:
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 4792266.

Review your concurrent request log and/or report output file for more detailed information.



The developer proceeded to make several changes but received the same error. Then they pulled up other reports and the error occured there as well. They contacted us thinking that there may be something wrong with the environment.

I have never used Report Builder but a quick search turned up 2 possible solutions:

1. A mandatory value received incorrect or null data.
2. Your not connected to the database in report builder.

I asked the developer to verify that the SQL they were working on was valid by pasting it into sqlplus and executing it and to verify that they are connected to the database.

A short while later they let me know that once you receive the error above, it seems Report Builder loses connection to the database. At that point they have to reconnect and if the query is fine they no longer receive the error.

6 comments:

Anonymous said...

Hi, I found the same Issue just Today .. 07 of July 2008 ..

While Working in a new report wich contains a really simple query with a JOIN of 2 tables ... The query is Runing in SQL Plus, and reports accept it in the DATA MODEL ... but when I run the Report, this error comes out and I lose my connection to Oracle ...

- Adrian Lozano

Anonymous said...

OK I found out... thnx my a friend carlos

This error is caused by the monster numer of rows that my query is getting... So the DB is LAcking of Memory haha to handle all that ..

Solution, Place a Dates range like..

Where dateofcreation between 'x' and 'y'

Anonymous said...

i am just opening reports builder and doing the connection, and i am getting the error! I have not opened any report!

Still searching why this is occurring!

Anonymous said...

Hi all. I had the same problem yestarday(30 of July 2009). When I start report I got oracle error ora-24323 value not allowed. When I execute the SQL by SQL editor I lose the connection in database. Today I fix the problem. In my SQL there was many occurrence of parameters. I optimize my SQL and report works properly now.

Dimitar Drambozov, Bulgaria!

Rafique Niazi (ACES) said...

Just Disconnect from database and re-connect Reports Builder with database. The Error Will Be gone..

M. Rafique Niazi.
Rawalpidi.
Pakistan

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.