Support Article
Report Definition is giving error for non exposed properties
SA-21006
Summary
Report Definition is giving error for non exposed properties.
ERROR MESSAGES
** ** An error occured on executing the query for the report definition - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PAL_DATA"."PR_READ_FROM_STREAM": invalid identifier
Error Messages
** ** An error occurred on executing the query for the report definition - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PAL_DATA"."PR_READ_FROM_STREAM": invalid identifier
Steps to Reproduce
- Create Report Definition.
- Add non exposed property.
- Run Report Definition.
Root Cause
The root cause of this problem is defect or misconfiguration in the PRPC operating environment.
For PR_READ_FROM_STREAM to work, user must have UDFs installed in PAL_DATA schema.
Root Cause
Reason is that the UDFs have been corrupted.
Resolution
Perform the following local-change:
Reinstall the UDF by running the following udf SQL function on the database.
In the Distribution Media or the place where the PRPC is been Installed.
(or)
Go to the location: ..\ schema\generated\DBNAME\install
Perform the following steps:
1. Run the SQL dropudf script on the DB first.
2. Open the folder udfstatements.
3. Now run the scripts present there on the DB.
4. Now open the Archives folder in the Media.
5. Go to UDF folder and reimport the prreadstream.jar in the application from designer studio.
6. Stop the server and clear temp folder.
7. Restart and test the changes.
Published March 16, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.