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

 Bala Bhargavi Samanthakurthi (Bala Bhargavi S)
TCS
AST
TCS
IN
Bala Bhargavi S Member since 2017 4 posts
TCS
Posted: Sep 23, 2021
Last activity: Aug 4, 2022
Posted: 23 Sep 2021 5:16 EDT
Last activity: 4 Aug 2022 10:25 EDT
Closed

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

Hi,

we are using pega 8.2.8 version. While running a report definition on external database table mapped class, Following error is appeared.

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState: 0A000 Message: ResultSet type 1004 is not supported. DatabaseException caused by prior exception: java.sql.SQLFeatureNotSupportedException: ResultSet type 1004 is not supported. | SQL Code: 200035 | SQL State: 0A000


***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform 8.2.8
Reporting
Data Model

Posted: 3 years ago
Updated: 3 years ago
Posted: 27 Sep 2021 8:59 EDT
Updated: 27 Sep 2021 9:42 EDT
Srujan Kumar (srujankumar)
Sunera Technologies Inc
Director
Sunera Technologies Inc
AU

@Bhargavi: We are facing similar issue.  After Removing Enable Paging Option- Data Access Tab, It works as expected, Did you get any other workaround to it. 

To see attachments, please log in.

Related content:

Discussion

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

Question

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

Question Solved

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

Question Solved

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

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

There was a problem getting a list: code: 0 SQLState: 42703 Message: ERROR: column PC0.buddyname does not exist Position: 203

Question Solved

There was a problem getting a list: code: 6576 SQLState: 65000 Message: ORA-06576: not a valid function or procedure name

Question Solved

I have created an data table. When Im trying to call this data table in a step im getting the error "Error: ** ** An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: XX000 Message: ERRO

Question

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

Question

Pega 73 Upgrade Error - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PXSAVEDATETIME": invalid identifier

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