"Posting: Single Ledger" concurrent request hanging
Posting: sinlge ledger concurrent program someitmes hangs and does not comlpete. it remains in running status untill we terminate it and post manually the journals.
there is also a workaround we apply each time it hangs:
- Cancel the posting programs
(Posting Single Ledger) using Auto.request (XXBA: Scheduled Programs
responsibility) - Create table gl_bc_packets_hists_bkp_DDMMYY as select * from
GL_BC_PACKETS_HISTS; - Truncate table GL.GL_BC_PACKETS_HISTS;
- Insert into GL_BC_PACKETS_HISTS (select* from
GL_BC_PACKETS_HISTS_BKP_ DDMMYY) - Commit;
- Run Gather Table statistics (GL, gl_bc_packets, 100, , , NOBACKUP,
DEFAULT, LASTRUN, Y) - Run Gather Table statistics (GL, gl_bc_packets_hists, 100, , ,
0