Support Article
BIX extract errors out due to Database exception
SA-100201
Summary
Database exception occurs and the Business Intelligence Exchange (BIX) Extract errors out.
Error Messages
[STANDARD] [ ] [ ] (exec.SqlQueryResultSetExecutor) ERROR - An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 57014 Message: ERROR: canceling statement due to user request DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request | SQL Code: 0 | SQL State: 57014 com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: 57014 Message: ERROR: canceling statement due to user request DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request | SQL Code: 0 | SQL State: 57014 at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:381) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:360) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:577) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:421) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:185) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:2945) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:2937) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryResultSetExecutor.executeQuery(SqlQueryResultSetExecutor.java:89) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryResultSetExecutor.executeQuery(SqlQueryResultSetExecutor.java:72) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryResultSetExecutor.executeQuery(SqlQueryResultSetExecutor.java:48) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.SqlReportResultSetExecutor.executeQuery(SqlReportResultSetExecutor.java:104) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.SqlReportResultSetExecutor.executeSql(SqlReportResultSetExecutor.java:88) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.SqlReportResultSetExecutor.execute(SqlReportResultSetExecutor.java:67) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.rd.SqlReportResultSetExecutor.execute(SqlReportResultSetExecutor.java:41) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.ExtractImpl.doExtract(ExtractImpl.java:1636) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.ExtractImpl.runExtract(ExtractImpl.java:1179) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.ExtractImpl.init(ExtractImpl.java:907) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.ExtractImpl.parseAndRunExtractCommand(ExtractImpl.java:852) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.access.ExtractImpl.executeCommandLineExtract(ExtractImpl.java:781) ~[prprivate.jar:?] at com.pega.pegarules.data.internal.PRDataProviderImpl.executeCommandLineExtract(PRDataProviderImpl.java:1665) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.executeCommandLineExtract(Executable.java:8508) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_pxextractdatawithargs_b390b959167377f95f63ce79c39386b3.step2_circum0(ra_action_pxextractdatawithargs_b390b959167377f95f63ce79c39386b3.java:312) ~[?:?] at com.pegarules.generated.activity.ra_action_pxextractdatawithargs_b390b959167377f95f63ce79c39386b3.perform(ra_action_pxextractdatawithargs_b390b959167377f95f63ce79c39386b3.java:89) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_cxprunbixextracts_4518dd2617553eab043e2cb05def449d.step1_1_circum0(ra_action_cxprunbixextracts_4518dd2617553eab043e2cb05def449d.java:273) ~[?:?] at com.pegarules.generated.activity.ra_action_cxprunbixextracts_4518dd2617553eab043e2cb05def449d.step1_0_circum0(ra_action_cxprunbixextracts_4518dd2617553eab043e2cb05def449d.java:225) ~[?:?] at com.pegarules.generated.activity.ra_action_cxprunbixextracts_4518dd2617553eab043e2cb05def449d.perform(ra_action_cxprunbixextracts_4518dd2617553eab043e2cb05def449d.java:84) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?] at com.pegarules.generated.activity.ra_action_cxprunextracts_3919457045a30fdc8b7a4dc8c6e19638.step6_circum0(ra_action_cxprunextracts_3919457045a30fdc8b7a4dc8c6e19638.java:623) ~[?:?] at com.pegarules.generated.activity.ra_action_cxprunextracts_3919457045a30fdc8b7a4dc8c6e19638.perform(ra_action_cxprunextracts_3919457045a30fdc8b7a4dc8c6e19638.java:181) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?] at com.pega.platform.executor.jobscheduler.internal.ActivityExecutor.runActivity(ActivityExecutor.java:33) ~[pega-executor.jar:?] at com.pega.platform.executor.jobscheduler.internal.ActivityExecutor.executeActivity(ActivityExecutor.java:25) ~[pega-executor.jar:?] at com.pega.platform.executor.jobscheduler.internal.ActivityProcessor.execute(ActivityProcessor.java:55) ~[pega-executor.jar:?] at com.pega.platform.executor.jobscheduler.internal.ActivityProcessor.run(ActivityProcessor.java:108) ~[pega-executor.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1371) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1114) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:995) ~[prprivate.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImplForModules.doWithRequestorLocked(PRSessionProviderImplForModules.java:55) ~[prprivate.jar:?] at com.pega.platform.executor.jobscheduler.internal.JobSchedulerProcessor.execute(JobSchedulerProcessor.java:48) ~[pega-executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobRunTimeImpl.execute(JobRunTimeImpl.java:67) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobRunTimeDecorator.execute(JobRunTimeDecorator.java:57) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobRunTimeDecorator.execute(JobRunTimeDecorator.java:57) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobExecutionTemplate.executeJob(JobExecutionTemplate.java:45) ~[executor.jar:?] at com.pega.platform.executor.jobscheduler.scheduler.internal.JobExecutionTemplate.run(JobExecutionTemplate.java:35) ~[executor.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_171] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_171] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_171] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_171] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_171] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_171] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171] Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
Steps to Reproduce
- Create a BIX extract.
- Run the extract.
Root Cause
The query that was run to fetch records for the extract, timed out. This was because a large number of records was fetched.
Resolution
Perform the following local-change:
- Create following Dynamic System Settings (DSS).
Purpose: "BIX/selectQueryTimeout" on "Pega-Rules"
- Set the value to a value which higher than 30 to avoid query timeout.
Published February 10, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.