My Oracle Support Banner

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.

Symptoms

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][208][2] [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 [42000][8180][2] [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:

OCI0000178 - Unable to execute - INSERT INTO CRPDTA.F956311A (RJRPDOUGUD, RJRPDPRST, RJRPDFUSS1, RJRPDFUSS2, RJRPDFUSS3, RJRPDFUSS7, RJRPDFUSS8, RJRPDFUSS9, RJRPDFUSC1, RJRPDFUSC2, RJRPDFUSC3, RJRPDFUSM1, RJRPDFUSM2, RJRPDFUSN1, RJRPDFUSN2, RJRPDFUSU1, RJRPDFUSU2, RJRPDFUSU3, RJMKEY, RJUSER, RJUTIME) VALUES (:BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21)

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.