E1: XMLP: Publish Report Definition Error When Trying to Republish Report Definition (RD) Jobs in Web Environments From P95630 and P986110B
(Doc ID 1947717.1)
Last updated on AUGUST 15, 2018
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
When trying to republish Report Definition (RD) jobs from web (J) environments, it fails with the below error message:
"Publish Report Definition Error
An error occurred attempting to publish this Report Definition. Please see logs to determine the source of the error."
UBE Kernel debug log shows the below error messages:
Nov 19 23:43:27.706002 - 2392/3768 MAIN_THREAD ODB0000164 - STMT:00 [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'JDE_DEVELOPMENT.TESTDTA.F956311A'.
Nov 19 23:43:27.706004 - 2392/3768 MAIN_THREAD ODB0000164 - STMT:01  [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.
Nov 19 23:43:27.706006 - 2392/3768 MAIN_THREAD ODB0000155 - SQLNumResultsCols failed. Table F956311A, ODBC DSN ENTSERVER.
Nov 19 23:43:27.706008 - 2392/3768 MAIN_THREAD ODB0000027 - JDBODBC_DescribeTable failed. Table F956311A.
Nov 19 23:43:27.706010 - 2392/3768 MAIN_THREAD JDB9900168 - Failed to initialize db request
Nov 19 23:43:27.706012 - 2392/3768 MAIN_THREAD JDB9909007 - Unable to obtain driver request handle
Nov 19 23:43:27.706014 - 2392/3768 MAIN_THREAD JDB3400009 - Failed to perform Insert for F956311A
Nov 19 23:43:27.706016 - 2392/3768 MAIN_THREAD Exiting JDB_InsertTable with Failure (Table F956311A)
Nov 19 23:43:27.706017 - 2392/3768 MAIN_THREAD JDB_InsertTable failed for F956311A tag table
Another set of message from the UBE Kernel log:
3583 Wed Aug 1 12:25:29.603226 dbperfrq.c477
OCI0000179 - Error - ORA-00942: table or view does not exist
3583 Wed Aug 1 12:25:29.603251 jdb_drvm.c995
JDB9900170 - Failed to execute db request
3583 Wed Aug 1 12:25:29.603270 jdb_exet.c6109
JDB3400009 - Failed to perform Insert for F956311A
3583 Wed Aug 1 12:25:29.603286 xmlpextern.cpp1179
JDB_InsertTable failed for F956311A tag table
3583 Wed Aug 1 12:25:29.603319 XMLPServerDispatch.cpp414
Unable to insert report definition job control record
First time submission of the RD job is successful even though republishing is failing.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document