UBE spec corrupted

[gigi]

Hi all
we installed TR 9.1.5.2 Our architecture is made up by: Database server Oracle 12, Enterprise server Windows 2012 + TR 9.1.5.2, Web Server Oracle Linux + WLS 12 + TR 9.1.5.2

When we deploy to enterprise server a package with an ube, randomicly when we try, the first time, to submit this UBE to enterprise server, ube specs are downloaded to enterprise server corrupted (size 0 kb) from package tables.
Analizyng problem we discovered tracing in metadata kernel log (attacched).
This logs display error in accessing table SY910.F988259 and package table.


Anyone has encountered same problem?
Thanks in advance
Luigi

-----------------------------------------------------
7532/9592 MAIN_THREAD Sat May 30 10:48:11.881002 IPCMISC.C299
process 7532 <jdenet_k> registered in entry 6

7532/9592 MAIN_THREAD Sat May 30 10:48:11.896000 NETCFG.C297
Starting Kernel of Type:METADATA KERNEL

7532/9592 SYS:Metadata Sat May 30 10:48:12.864000 ServerDispatch.cpp249
INITIALIZING METADATA SERVER KERNEL

7532/9592 SYS:Metadata Sat May 30 10:48:13.238000 ServerDispatch.cpp307
KNT0000999 - Metadata Kernel Thread Pool Setting: size 50, increment 5

7532/9592 SYS:Metadata Sun May 31 11:36:17.377000 dbperfrq.c471
OCI0000178 - Unable to execute - SELECT COUNT(*) FROM SY910.F988259 WHERE ( DBIPADD = :KEY1 AND DBPORTNUM = :KEY2 AND DBQUSTA = :KEY3 )

7532/9592 SYS:Metadata Sun May 31 11:36:17.377001 dbperfrq.c477
OCI0000179 - Error - ORA-01460: unimplemented or unreasonable conversion requested

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377002 dbfetch.c163
OCI0000056 - Unable to fetch - SELECT * FROM PD910.F98761FULLPDC WHERE ( RSOBNM = :KEY1 AND RSVERS = :KEY2 ) ORDER BY RSOBNM ASC,RSVERS ASC,RSRCRDTP ASC,RSGNCID1 ASC,RSGNCID2 ASC,RSWEVENT ASC,RSGNCID3 ASC

7532/9592 SYS:Metadata Sun May 31 11:36:17.377003 JDB_DRVM.C1005
JDB9900401 - Failed to execute db request

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377004 dbfetch.c169
OCI0000057 - Error - ORA-01002: fetch out of sequence

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377005 JDB_DRVM.C1065
JDB9900172 - Failed to execute db fetch

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377006 SpecMisc.c3876
copySpecs() - jdeSpecFetch() failed with error code, JDESPECRESULT_JDBFAILED. Record was selected from repository using the key, R58S0005.+.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377007 SpecMisc.c3126
copyBetweenRepositories() - Failure to copy RDASPEC records for report_version R58S0005_+

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377008 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\gbrlink.ddb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377009 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\gbrlink.xdb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377010 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\gbrspec.ddb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377011 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\gbrspec.xdb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377012 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\rdaspec.ddb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377013 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\rdaspec.xdb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377014 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\rdatext.ddb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377015 spkgutil.c4999
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2\rdatext.xdb. Error: 13.

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377016 spkgutil.c5036
PKGUTL0075 - ERROR: Failed to delete non-empty path D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58S0005\VEBRIC2. Error: 41

7532/7308 WRK:Metadata job 1917 Sun May 31 11:36:17.377017 SpecMisc.c4728
Spec Cache creation for R58S0005_VEBRIC2 Failed, job = 2594

 

[gigi]

Add an info. If we delete Runtime cache folder for report with corrupted specs and resubmit that report, it runs corrctly.
gg

 

[78aspide78]

Hi Gigi,
take a look at database log too, trace the select and resolve the binding parameters.

It's related always to custom be or standard be too?

 

[78aspide78]

Just another input: check again the NLS_LANGUAGE setup.

 

[gigi]

Thanks a lot aspide for the inputs. We already checked database server logs and there aren't any trace in the alert.
Problem occurs with standard and custom reports.

NLS_Language
client side : AMERICAN_AMERICA.WE8MSWIN1252
server side
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_TERRITORY AMERICA
NLS_LANGUAGE AMERICAN

 

[DBohner-(db)]

Luigi,

Is the issue with only this one UBE, or randomly others on first try?

Is there really a space in the UBE name, or is that a copy/paste issue? There shouldn't be a space:
PKGUTL0074 - ERROR: Failed to delete file D:\JDEdwardsPPack\E910\PD910\spec\runtimeCache\R58 S0005\VEBRIC2\rdatext.xdb. Error: 13.

One thing to try, and often works on similar spec issues... Export the Spec, and Re-Import it. That simple action has resolved dozens of Spec Issues at different clients.

(db)

 

[gigi]

db,
space in the ube name is only a copy/paste problem.

Problem is random (standard or custom UBE) on first try. Not related to only this report.

thanks
gg

 

[Chan Rana]

Gigi,
To me the root cuase are the below two errors the resulting are the after effects. I think there is some data type or mismatch happening while trying to select which is cuasing to fail everything. Dig in more on Error - ORA-01460 which can give you some more clues.

7532/9592 SYS:Metadata Sun May 31 11:36:17.377000 dbperfrq.c471
OCI0000178 - Unable to execute - SELECT COUNT(*) FROM SY910.F988259 WHERE ( DBIPADD = :KEY1 AND DBPORTNUM = :KEY2 AND DBQUSTA = :KEY3 )

7532/9592 SYS:Metadata Sun May 31 11:36:17.377001 dbperfrq.c477
OCI0000179 - Error - ORA-01460: unimplemented or unreasonable conversion requested


Chan

 

[gigi]

yes Chan ....... in the past days we found related to error ORA-01460, some Oracle bugs solved for jdbc driver.

Metadata Kernel which technology use to connect to database server? jdbc? or does it use oracle client installed on enterprise server? If it uses jdbc driver, which version?
thanks
gg

 

[gigi]

Oracle confirmed me that metadata kernel uses Oracle client installed locally, not uses jdbc driver
gg

 

[ajpw76]

gigi,

We are having the very same issue with the same errors for custom and jde reports.
We are on 9.10 and the same tools release.

Did this situation ever get resolved?

 

[soyer]

same issue here

Has anyone found a solution to this yet?
We just upgraded to 9.1.5 and having the same issue.
Thanks.

Soyer

 

[soyer]

Is this happening only with CUSTOM reports ?
If we manually delete the UBE cache and submit again it works OK.
Have you found a workaround ?

Thanks.

 

[jayshomp]

Not sure if you guys are still having this issue, but I have 2 different clients with the same issue and was working on it with Oracle for months. They finally found a bug with the Oracle client and released a patch to fix, and so far we have not seen a repeat of the issue since applying the patch and no ORA errors in the metadata log and database alert logs.

E1: DB: ORA-03137 or ORA-01460 or ORA-01002 Errors in JDE E1 Kernel logs and/or Oracle Database Alert log (Doc ID 2117827.1)