Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Veera Reddy Saddala (VeeraSaddala)
American Express Services Europe Ltd

American Express Services Europe Ltd
GB
VeeraSaddala Member since 2017 32 posts
American Express Services Europe Ltd
Posted: Oct 8, 2018
Last activity: Oct 8, 2018
Posted: 8 Oct 2018 1:19 EDT
Last activity: 8 Oct 2018 3:00 EDT
Closed

SQL Error code: 29540 SQLState: 99999 while running the Report definition with unexposed column

Hi,

While running report definition with un exposed column we are getting below exception in 7.3v.

Error:
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 29540 SQLState: 99999 Message: ORA-29540: class com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader does not exist DatabaseException caused by prior exception: java.sql.SQLException: ORA-29540: class com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader does not exist | SQL Code: 29540 | SQL State: 99999

Is there any way we can resolve this?

Have seen similar issues in the community with 7.2.1 shown in below link.

https://community.pega.com/knowledgebase/articles/understanding-and-troubleshooting-user-defined-functions

WIll it be applicable for 7.3 as well? Please advise.

Thanks,

Veera

To see attachments, please log in.
Reporting

Related content:

Question Solved

getting here was a problem getting a list: code: 22835 SQLState: 99999 while running Report definition

Question

SQL error in ListView: There was a problem getting a list: code: 0 SQLState: 42601 message

Question

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState:

Question

SQL Error code: 17009 SQLState: 99999 Closed Statement DatabaseException caused by prior exception: java.sql.SQLException: Closed

Discussion

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState: 0A0

Question Solved

Error: An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 08006 Message: An I/O error occurred while sending to the backend. DatabaseException caused by prior exception: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend. | SQL Code: 0 | SQL State: 08006

Question

Problem writing an instance to the database: code: -302 SQLState: 22001

Question

Inclusion of unexposed column in Report Definition

Question Solved

Error while getting the list of checkedout rules: code: -1 SQLState: -1 Message: Database-TableWithNoColumns

Question Solved

Pega 8.7.1 - There was a problem getting a list: code: 0 SQLState: HY008

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice