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

 jaideep Deshi (jaideep2943)
Instellars
Lead Decisioning Architect
Instellars
IN
jaideep2943 Member since 2024 4 posts
Instellars
Posted: Oct 10, 2023
Last activity: Nov 7, 2023
Posted: 10 Oct 2023 11:36 EDT
Last activity: 7 Nov 2023 10:20 EST
Closed

An I/O error occurred while sending to the backend.  | SQL Code: 0 | SQL State: 08006 

 
com.pega.pegarules.pub.database.ConnectionException: 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 
***Edited by Moderator Marissa to add Capability tags***
To see attachments, please log in.
Pega Platform 8.8.3
Pega Platform 8.8.1
System Administration
Financial Services
Decisioning Architect

Posted: 1 year ago
Posted: 7 Nov 2023 9:29 EST
Anthony Gourtay (Anthony_Gourtay)
Proximus
Expert Engineer - PEGA Application Management
Proximus
BE

@AnthonyR4693

not 100% sure but I think that it's the timeout defined from the application to receive the reply from the request.

You wait for too long the reply from the DB/query and your connection is timed out from your PEGA session.

As such, the connection with the query you launched is gone.

You're getting this technical error since connection is already closed.

This is a protection from session crash but if it happens too quickly/often, you can foresee either query tuning or to increase the timeout period.

Regards

Anthony

 

To see attachments, please log in.

Related content:

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

ORA-01460: unimplemented or unreasonable conversion requested   | SQL Code: 1460 | SQL State: 72000 while sending data in mail

Question

SQL Code: 208 | SQL State: S0002 after 7.3 upgrade from 7.2.2

Question

ERROR - I/O Exception occurred while writing or flushing the stream

Question

code: 10314 SQLState: S0011 Message: An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536.

Question Solved

Getting DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out. | SQL Code: 0 | SQL State: HY008

Question Solved

Oracle migration issue : NL Exception was generated DSRA0010E: SQL State = 08006, Error Code = 17,002

Question

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

Question Solved

Generating Section Using Backend Code

Question

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

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