Troubleshooting

[jdecnc]

Every once in a while we have a few UBE's that will never end. At a certain point you can look at the various tables that should be updated and see that all data has been processed. When you look at the task manager on the app server the runbatch job is not getting any CPU time but the memory continues to increment as if the job is still running. hat I would like to know is there an application out there that you are aware of that can be used to see where the to basically look inside of the job to see where it is in the process. I could actually use something simular to this for performance tuning as well to see where in the process from start to finish (on successful jobs) is consuming the most amount of time. If you are aware of any such programs it would be great if you could share the name and any other perks the tool has provided you.

Thanks in advance.

 

[masimons]

Tools 8.98 introduces a number of features for exactly this purpose, including the ability to turn on debug on the fly and see where exactly in the UBE the processing is currently. There is a pretty good video about it on ilearning.oracle.com as part of the 8.98 TOI.

Hope this helps!

 

[cncjunior1]

If you terminate the job does it dump the call stack in the job log? If it does that should give you an idea where to start looking.

 

[jdecnc]

Unfortunately not. Here is what we get.

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\jdecache\jdecm_rb.c Line:247 iParam: 0000000404
4372/4756 WRK:Starting jdeCallObject Mon Oct 06 23:54:08.380000 jdecm_rb.c2482
CMRB000006 - ERROR: Memory allocation failed

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\jdecache\Jdecm.c Line:68 iParam: 0000000404

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\jdecache\Jdecm.c Line:68 iParam: 0000000404

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\jdecache\Jdecm.c Line:68 iParam: 0000000404

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\jdecache\Jdecm.c Line:68 iParam: 0000000404

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\jdecache\Jdecm.c Line:68 iParam: 0000000404

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\jdecache\Jdecm.c Line:68 iParam: 0000000404
4372/4756 WRK:Starting jdeCallObject Mon Oct 06 23:54:08.380001 jdecm_rb.c2938
CMRB999998 - ERROR: lpCursor[05EA6CF8] has invalid lpCursor->lpCurrent

MEMORY ALLOCATION FAILURE
File: \server_builds\b9\system_8.96.2.1_mk\common\Jdekrnl\Ube\K2PDFUtils.C Line:104 iParam: 0000000316
4372/4756 WRK:Starting jdeCallObject Mon Oct 06 23:54:08.380002 ntexhnd.cpp101
Exception code: C0000005 ACCESS_VIOLATION

4372/4756 WRK:Starting jdeCallObject Mon Oct 06 23:54:08.426000 ntexhnd.cpp142
IMAGEHLP.DLL or its exported procs not found. CallStack can not be written.

 

[e1venky]

Hey I got the same error

4032/2944 MAIN_THREAD Mon Oct 20 19:02:51.437003 zdrv.cpp373
Creating XML Session

4032/2944 MAIN_THREAD Mon Oct 20 19:02:58.671000 XMLRequest.cpp1264
ICU0000017 - ICU CodePage for 1252 is ibm-1252.

4032/2944 MAIN_THREAD Mon Oct 20 19:02:58.921000 jdepref.c208
GetRecipientPreferences :No email address found for contact, assuming workcenter email an8<1806> idln<0>

4032/2944 MAIN_THREAD Mon Oct 20 19:02:58.921001 jdepref.c208
GetRecipientPreferences :No email address found for contact, assuming workcenter email an8<1806> idln<0>

4032/2944 MAIN_THREAD Mon Oct 20 19:03:59.000000 Jdeknube.c2868
KNT0000XXX - JDENET_ReceiveMsg failed. Error = 11

4032/2944 MAIN_THREAD Mon Oct 20 19:04:04.390000 ntexhnd.cpp101
Exception code: C0000005 ACCESS_VIOLATION

Basically I tried to submit an UBE with Report Definition for XML Publisher. Any clues how to overcome this error.

Venky