Support Article
ORA-01013 running BIX extract in 7.4
SA-72664
Summary
Post upgrade to Pega 7.4 and Business Intelligence Exchange (BIX) 7.4, BIX extraction fails with SQLTimeoutException.
Error Messages
Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:929) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1026) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3923) ~[ojdbc7.jar:12.1.0.1.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc7.jar:12.1.0.1.0]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:511) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:399) ~[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:2906) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:2898) ~[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:?]
Steps to Reproduce
Run the extract rule.
Root Cause
A defect or configuration issue in the operating environment.
There is a timeout of 30 seconds when running the BIX extract query.
Resolution
- Apply HFix-50605.
- Add a new Dynamic System Setting (DSS) as below.
BIX/selectQueryTimeout on Pega-Rules
- Set the value such that it is higher than the 30 second timeout. The value for the DSS is in seconds.
For example, to increase the timeout to 60 seconds, set this DSS to 60.
Published February 7, 2019 - 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.