E1: UBE: UBEs Remain in Wait Status Indefinitely While Queue Field in WSJ Remains Blank on OneWorld Xe or ERP8

(Doc ID 650769.1)

Last updated on AUGUST 14, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version S23 to SP24 [Release S23 to SP24]
Generic UNIX
Generic Windows

Symptoms

For some reason all jobs submitted to a non-AS/400 remain in 'W' (Wait) status indefinitely. The problem is either specific to newly installed Windows clients, or on environment to which a new non-AS/400 server was added to a system initially using one or more AS/400 servers.

In addition to the fact the UBE does not process, the Queue field in Work with Submitted Jobs is blank:

This problem is known to happen only in OneWorld Xe or ERP8.


In the UBE kernel debug log we can see the INSERT against F986110 (Job Master Table) of the job record:

Sep 20 11:59:32 ** 3080/4036 ODBC:I DBInitRequest(new) conn=02381A20 hd=02711180 dr=026F4EF0 SERVER A (JDE@SERVER - B7333 Server Map)

Sep 20 11:59:32 ** 3080/4036 INSERT INTO APPLIB/F986110 VALUES (' ','5','W','PD7333','USER','******',' ',106263,115932.000000,97.000000,'SERVER','USER',3080.000000,106263,115932.000000,LONGVARBINARY_DATA,'UBE','6009','Printer In BLOB','R0006P_XJDE0001_97_PDF')


Note the insert statement does not contain a queue: INSERT INTO APPLIB/F986110 VALUES (' ','5','W','PD7333','USER','******',' ..

No errors are reported in the client, server, or UBE logs

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