Error message in NWA

[former_member250429]

Dear Gurus,

I am getting below error message frequently  on NWA page of SAP BW system ( SAP Netweaver 7.0  BI Java & Enterprise Portal Rel 700 SP21 )

"Cannot change transaction isolation during distributed transaction and when the connection is shared. DataSource name: "SAPSR3DB", current isolation level is "TRANSACTION_READ_UNCOMMITTED", new isolation level is "TRANSACTION_READ_COMMITTED""

In Trace file i can below logs

#1.#D666200050030080000005D4001420AA0004C83B3AB51423#1346056620413#com.sap.engine.services.dbpool#sap.com/irj#com.sap.engine.services.dbpool#J2EE_GUEST#0#SAP J2EE Engine JTA Transaction : [0672ffffff8200d3d]#n/a##a72ee9cbefd611e19f6bd66620005003#Thread[ThreadPool.Worker5,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error#1#/System/Server#Java#dbpool_0315##Cannot change transaction isolation during distributed transaction and when the connection is shared. DataSource name: "SAPSR3DB", current isolation level is "TRANSACTION_READ_UNCOMMITTED", new isolation level is "TRANSACTION_READ_COMMITTED".#3#SAPSR3DB#TRANSACTION_READ_UNCOMMITTED#TRANSACTION_READ_COMMITTED#

#1.#D666200050030080000005D5001420AA0004C83B3AB51589#1346056620414#com.sap.engine.services.dbpool#sap.com/irj#com.sap.engine.services.dbpool#J2EE_GUEST#0#SAP J2EE Engine JTA Transaction : [0672ffffff8200d3d]#n/a##a72ee9cbefd611e19f6bd66620005003#Thread[ThreadPool.Worker5,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error#1#/System/Audit#Java###Exception {0}#1#com.sap.engine.services.dbpool.exceptions.BaseSQLException: Cannot change transaction isolation during distributed transaction and when the connection is shared. DataSource name: "SAPSR3DB", current isolation level is "TRANSACTION_READ_UNCOMMITTED", new isolation level is "TRANSACTION_READ_COMMITTED".

        at com.sap.engine.services.dbpool.cci.ConnectionHandle.setTransactionIsolation(ConnectionHandle.java:357)

        at com.sapportals.wcm.service.taskqueue.JDBCTaskQueueFactory.getConnection(JDBCTaskQueueFactory.java:145)

        at com.sapportals.wcm.service.taskqueue.OpenSQLTaskQueue$DeadlockHandler.tryAgain(OpenSQLTaskQueue.java:796)

        at com.sapportals.wcm.service.taskqueue.OpenSQLTaskQueue.getRaw(OpenSQLTaskQueue.java:306)

        at com.sapportals.wcm.service.taskqueue.TaskQueue.get(TaskQueue.java:128)

        at com.sapportals.wcm.service.taskqueue.TaskQueueReader.get(TaskQueueReader.java:68)

        at com.sapportals.wcm.service.taskqueue.TaskQueueReader.get(TaskQueueReader.java:58)

        at com.sapportals.wcm.service.indexmanagement.TaskQueueReaderTask.run(TaskQueueReaderTask.java:54)

        at com.sapportals.wcm.service.scheduler.SchedulerEntry.run(SchedulerEntry.java:174)

        at com.sapportals.wcm.service.scheduler.crt.PoolWorker.run(PoolWorker.java:108)

        at java.lang.Thread.run(Thread.java:770)

Can somebody suggest me something to get it resolve ?

Regards

[Former Member]

Hello ,

Can you check the SAP Note No. 719778.

Regards

shrikant

[former_member250429]

Dear Shrikant

Thanks for your response and precious time !!!!

To me SAP note suggested by you does not seems to be applicable for current scenario.

As SAP note 719778 is mainly for BaseSQLException: ResourceException in method and

BaseResourceException: Cannot get connection for {0} seconds

But error logs above indicates BaseSQLException: Cannot change transaction isolation during distributed transaction and when the connection is shared.

Regards