SAP Knowledge Base Article - Preview

2301479 - Timeout error caused by wrong snapshot value

Symptom

A simple SQL statement executed by SAP ME times out, but cannot be explained by number of records in the tables nor production load. An exception like

javax.ejb.EJBException: nested exception is: com.sap.engine.services.dbpool.exceptions.BaseSQLException: The transaction ( JTA Transaction : 2099969 ) has timed out after "900" seconds. The specified timeout is "900" seconds. Statement was cancelled. 

is thrown.


Read more...

Environment

SAP Manufacturing Execution

Microsoft SQL Server

Product

SAP Manufacturing Execution 15.0 ; SAP Manufacturing Execution 15.1 ; SAP Manufacturing Execution 5.2 ; SAP Manufacturing Execution 6.0 ; SAP Manufacturing Execution 6.1

Keywords

KBA , MFG-ME , SAP Manufacturing Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.