Skip to main content
Contact a Moderator

Question

2
Replies
249
Views
 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: October 8, 2018
Last activity: October 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

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

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 Solved

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

Question Solved

Error While Running Report Definition

Question

Inclusion of unexposed column in Report Definition

Question Solved

Pega 7.2.2 Report-definition support to MYSQL Error code: 1064

Question Solved

Error on running a Report Definition "Failed to create Java VM | SQL Code:0 | SQL State XX000"

Question

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

Question

SQLState 57014, Error code -952: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -952, SQLSTATE: 57014, SQLERRMC: null

Question Solved

There was a database problem when performing an RDBExecute: code: 0 SQLState: <none> Message: No value has been inserted

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