EGL: Deadlock Occurred on Temporary Tables During Budget Checking
Last updated on AUGUST 16, 2016
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 8.4 SP1 to 9 [Release 8.4 to 9]
Information in this document applies to any platform.
Enterprise, Financials, General Ledger, Commitment Control
The budget checking process is abending with the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 227) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205
Dynamic Stmt : FSPKGCBL_D_HD000_1
This means that there is deadlocking on shared temp tables, e.g. KK_SRC_TMP and KK_TDET_TMP (_TMP). Deadlocks in this situation may mean the application is running out of non-shared temp tables (_TMPxxx) because these tables would not be used if there were non-shared temp tables (KK_SRC_TMPxxx and KK_TDET_TMPxxx in this case) available.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms