EGL9.2: Online Journal Post Abends At Step FTDOCAE_LIBR.GenDocSq.Step08 When Multiple Reversal Journals Imported via Spreadsheet Are Posted at Same Time. (Doc ID 1992534.1)

Last updated on APRIL 26, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

When multiple users attempt to concurrently post reversal journals online imported via spreadsheet template encounter an error for at least one user.

Steps to Replicate:
-----------------------
The issue can be reproduced at will with the following steps:

Run the spreadsheet import process with reversal journals having more than 1500 journal lines.
Run online edit.
Run online Post - all three users needs to run the process at the same time for their respective journals.
At least one of the users will get an SQL error.


Error:
------
A SQL error occurred. Please consult your system log for details.

Click OK

Process 347307 ABENDED at Step FTDOCAE_LIBR.GenDocSq.Step08 (SQL) -- RC = 8601 (108,524)

Click OK

CallAppEngine: Application GL_JP: AppEngine error. (2,653) GL_JOURNAL.ProcessJournal.OnExecute Name:LaunchRequest PCPC:2223 Statement:57
Called from:GL_JOURNAL.ProcessJournal.OnExecute Name:LaunchProcess Statement:38
Called from:JRNL_PANELS_WRK.PB_POST.FieldChange Name:post_jrnl Statement:4
Called from:JRNL_PANELS_WRK.PB_POST.FieldChange Name:pb_post_fc Statement:75
Called from:JRNL_PANELS_WRK.PB_PROCESS.FieldChange Statement:28

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.

Trace file is showing following error:


PSAPPSRV.12056 (22) 1-89009 07.02.48 0.007000 Cur#0.12056.notSamTran RC=0 Dur=0.000000 XER rtncd=5 msg=[Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205
PSAPPSRV.12056 (22) 1-89010 07.02.48 0.000000 Cur#1.12056.FSDEV RC=0 Dur=0.000000 Rollback

Cause

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