IBM Support

Calculation errors in the aurora log file after loading data with FastMap

Troubleshooting


Problem

When the GRC Calculations feature is configured and a large number of objects are loaded by using FastMap, it sometimes reports repetitive exceptions to the aurora log.

Symptom

When you open the aurora log file, several exceptions like the following are observed.

com.ibm.db2.jcc.am.SqlException: [jcc][t4][10342][11669][4.26.14] Application must execute a rollback. The unit of work has already been rolled back in the database but other resource managers involved in this unit of work might not. To ensure integrity of this application, all SQL requests will be rejected until the application issues a rollback.  ERRORCODE=-4497, SQLSTATE=null
    at com.ibm.db2.jcc.am.b7.a(b7.java:794)
    at com.ibm.db2.jcc.am.b7.a(b7.java:66)
    at com.ibm.db2.jcc.am.b7.a(b7.java:88)
    at com.ibm.db2.jcc.am.Agent.copyAsUnchainedSQLException(Agent.java:590)
    at com.ibm.db2.jcc.am.Agent.chainDeferredExceptionsToAgentOrAsConnectionWarnings(Agent.java:548)
    at com.ibm.db2.jcc.am.Sqlca.getJDBCMessage(Sqlca.java:336)
    at com.ibm.db2.jcc.am.SqlExceptionContainer.getMessage(SqlExceptionContainer.java:80)
    at com.ibm.db2.jcc.am.SqlTransactionRollbackException.getMessage(SqlTransactionRollbackException.java:54)
    at com.ibm.ws.rsadapter.impl.DB2Helper.isAuthException(DB2Helper.java:271)
    at com.ibm.ws.rsadapter.impl.DatabaseHelper.isAnAuthorizationException(DatabaseHelper.java:1039)
    at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:1196)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:108)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:395)
    at com.openpages.aurora.service.persistence.PersistenceManager.updateSelective(PersistenceManager.java:2291)
    at com.openpages.aurora.service.calc.TBCalcAuroraManager.donePollQueue(TBCalcAuroraManager.java:138)
    at com.ibm.openpages.api.service.ejb.calc.impl.TBCalcQueueProcessor$2.execute(TBCalcQueueProcessor.java:113)
    at com.openpages.sdk.common.TransactionWrapper.execute(TransactionWrapper.java:70)
    at com.openpages.sdk.common.TransactionWrapper.execute(TransactionWrapper.java:61)
    at com.ibm.openpages.api.service.ejb.calc.impl.TBCalcQueueProcessor.run(TBCalcQueueProcessor.java:110)
    at com.ibm.ws.threading.internal.PolicyTaskFutureImpl.run(PolicyTaskFutureImpl.java:715)
    at com.ibm.ws.threading.internal.PolicyExecutorImpl.runTask(PolicyExecutorImpl.java:1135)
    at com.ibm.ws.threading.internal.PolicyExecutorImpl$GlobalPoolTask.run(PolicyExecutorImpl.java:189)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.lang.Thread.run(Thread.java:820)

 

Document Location

Worldwide


[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"ARM Category":[{"code":"a8m50000000ClALAA0","label":"Administration and Configuration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.2.0","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS4PJS","label":"IBM OpenPages on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM OpenPages with Watson

Component:
Administration and Configuration

Software version:
8.2.0

Document number:
6239256

Modified date:
08 May 2025

UID

ibm16239256

Manage My Notification Subscriptions