Error Message: SQL error. Stmt #: Deadlock or timeout

Error Message: SQL error. Stmt #: Deadlock or timeout

Document number: 27217

The error message " SQL error. Stmt # 609 Error Positions:0 Return: 8601 [IBM][CLI Driver][DB2/6000] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE 40001 (SQLSTATE 40001)-911" may occur if you are trying to submit a report and the process is already in use. At times, when you are submitting a report, you will be trying to access a database table that is already in use. The numbers may be different, but the structure of the message will be the same.

If you have received this error, wait fifteen minutes and try to submit your report again. You do not have to close the browser and may be able to use the same report. The majority of times, the report will submit successfully after a brief wait.

If you still can not submit a the report after fifteen minutes, if could mean that a process is too large and taken all the resources or that the process is hung. You will need to submit a NorthStar ticket to have this resolved. For more information on NorthStar, see Eureka! Document 70001 — How to create a service ticket in NorthStar.