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

 sriram dandamudi (sriramd5315)
Cognizant

Cognizant
ES
sriramd5315 Member since 2017 2 posts
Cognizant
Posted: Aug 31, 2021
Last activity: Sep 1, 2021
Posted: 31 Aug 2021 10:04 EDT
Last activity: 1 Sep 2021 16:32 EDT
Closed

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

Hi,

we have a requirement to customize GetNextWork functionality. As part of that we have modified ListView named "GetNextWork.All". This modified list view is creating and error :   

There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "pegadata"
  Position: 496 .

 

Please provide me suggestion on this error.

Thanks in advance

To see attachments, please log in.
Pega Platform 8.5.4
Reporting
Case Management
Insurance
Senior System Architect

Related content:

Question Solved

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

Question

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

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

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

Question

Tried RDB-Delete for Pega Internal Table -- There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "*" Position: 8

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

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

Question

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

Question

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

Question

There was a problem getting a list: code: 1461 SQLState: 72000 Message: ORA-01461: can bind a LONG value only for insert into a LONG column

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