E1: UBE: Case Study on UBE Error "Unable to initialize" (Doc ID 1532132.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

Symptoms

UBE R31410 ends in error when being submitted to the Job Queue getting an Error State when timing out after an 1 hour and the Call Object Kernel process is attached to Kanban Process (DcLink Process).

 UBE log appended to CallObject Kernel log (namely JDEDEBUG.log):

--UBE--[6]-- ubeReport_EntryPoint START
--UBE--[0]-- Unable to initialize
                (COBK) KERNEL type = KERNEL_NET
                (COBK) INSERT INTO SVM7334.F986110 (JCJOBQUE, JCJOBPTY, JCJOBSTS, JCENHV, JCUSER, JCPSWD, JCJOBTYPE, JCSBMDATE, JCSBMTIME, JCJOBNBR, JCEXEHOST, JCORGHOST, JCPROCESSID, JCACTDATE, JCACTTIME, JCSRVBLOBA, JCFUNO, JCPRTQ, JCFNDFUF1, JCFNDFUF2) VALUES ('DCSHOP','5','E','DUA7334','DCLINK7','******',' ',112276,90655.000000,251490.000000,'nzaxs26ch','nzaxs26ch',24182950.000000,112276,90655.000000,LONGVARBINARY_DATA,'UBE','6010','Printer In BLOB','R31410_DC0018_251490_PDF')

 

Notes:

  • As defined in UDC H93/LL (UBE Logging Level), it is important to check log with key words "--UBE--[0]" because UBE kernel represent log.
  • Job Status (F986110.JCJOBSTS) is written through UBE Kernel.
  • Additional information on UBE logging level as defined in UDC H93/LL (UBE Logging Level)

 

CodeDescription  
0 Error Messages
1 Informative Messages
2 Section Level Messages
3 Object Level Messages
4 ER Level Messages
5 SQL Statements
6 UBE Function Messages

 

 

Example of clean log:

--UBE--[6]-- ubeReport_EntryPoint START
Oct  1 17:01:42 ** 24182950    KERNEL type = KERNEL_UBE
--UBE--[0]-- Start Time : 17:01:42
--UBE--[6]-- Call jdeActiveRptFlag to get report Updateable flag in thread ID 0
Oct  1 17:01:42 ** 24182950    ORACLE DBInitReq conn=20174278 requ=209840c8 nzaxs26ch (ERPD) new
Oct  1 17:01:42 ** 24182950    UPDATE UA7334.F983051  SET VRPID='R31410    ',VRVERS='DC0018    ',VRREPORTID=0l,VRVERSIONID=0l,VRJD='"WK" Release Work Order - Shop Floor (status = 40)',VREXCL='0',VRUSER='LWESTON   ',VRVCD=112122,VRVED=112275,VRPROPTMID=0l,VRPOID=0l,VROPCR='1',VRVLISTMODE=2,VRVERTXTID=2l,VRCHKOUTSTS='N',VRCHKOUTDAT=112122,VRUSR0='JTROUGHT  ',VRVRSAVAIL='Y',VRENHV='UA7334    ',VRMKEY='NZ2KS19CH      ',VRPODATA=LONGVARBINARY_DATA,VRDSTNM='T31410    ',VRVCC1='   ',VRVCC2='   ',VRVCC3='   ',VRVCC4='   ',VRVCC5='   ',VRFRMTSTR=' ' WHERE  ( VRPID = 'R31410' AND VRVERS = 'DC0018' )
--UBE--[6]-- UBEReport_LoadSpecifications Start
--UBE--[1]-- Currency Flag is Z
--UBE--[1]-- Output is disabled. No PDF file will be created for this report.
--UBE--[6]-- Processing Init Report at Report Level
--UBE--[6]-- UBEReport_StartProcessing Start
--UBE--[1]-- No ER detected for INIT_REPORT event.  Clearing values for report level RV and ER Variables.
--UBE--[6]-- Processing Do Init Printer at Report Level
--UBE--[6]-- K2Print START
--UBE--[0]-- Printer Name is JDE_Default_Print_Queue
--UBE--[6]-- K2PRINT END
--UBE--[2]-- Starting UBE Message Loop
--UBE--[2]-- Process Init Report Header Section
--UBE--[2]-- Process Init Section
--UBE--[2]-- InitSection for Work Order Processing

(End of exmple)

 

Same issue is happening in client's environment in handling Kanban process which callobject kernel is calling R31410.

1. Log in to ERP8 (e.g., JPD7334 where default UBE and BSFN are mapped to server)
2. (G3115) P3157 - Kanban consumption then look for existing Kanban
3. Highlight it and (row exit) Check Out (which submits R31410 to server)
4. Log out
5. Log in (so same user handle attaches to exiting callobject kernel process)
6. Look for Kanban through P3157 and highlight to (row exit) Check In (this is to check out again so if there is another kanban skip this)
7. Highlight it and (row exit) Check Out
8. Go to WSJ and verify that Submitted Job R31410 ends in error --UBE--[0]-- Unable to initialize
  : It is working fine in our testing environment

 

Changes

Upgraded DSI version to DcLink7 which request Kanban processing through XML request in logic server.

By default, timeout settings for DSI integration is 1 hour. Now issue is coming DSI process got timeout and new connection got associated same CallObject Kernel process ID then this DSI routine always fails.

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