E1: OMW: Error Restoring Object Using OMW (Doc ID 1681510.1)

Last updated on JUNE 22, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.

Symptoms

When restoring an object (P574210 in this case) using OMW from par/zip file saved in older release, it failed with error below appear in the log

Feb 07 09:09:36.372002 - 4380/3204 WRK:Starting jdeCallObject         OMWSpecFetch() failed for the table JDESPECTYPE_DSTMPL in the data source  at location JDESPECLOC_REMOTEUSER with the JdeSpec error of JDESPECRESULT_JAVAEXCEPTION.
Feb 07 09:09:36.372003 - 4380/3204 WRK:Starting jdeCallObject         OMWOLObject::CopyRDBTAM() finish reading source records for JDESPECTYPE_DSTMPL with status true
Feb 07 09:09:36.372004 - 4380/3204 WRK:Starting jdeCallObject         ORACLE DBInitReq conn=0D8B8FE8 requ=40F91168 127.0.0.1 (E1Local) reuse
Feb 07 09:09:36.372005 - 4380/3204 WRK:Starting jdeCallObject         SELECT  COUNT(*)  FROM SPEC_DV020414F.F98743DV020414F  WHERE  ( DTOBNM = 'W574210A' )
Feb 07 09:09:36.372006 - 4380/3204 WRK:Starting jdeCallObject         ORACLE DBFetch conn=0D8B8FE8 requ=40F91168 maxrows=1
Feb 07 09:09:36.372007 - 4380/3204 WRK:Starting jdeCallObject         ORACLE DBFetch conn=0D8B8FE8 requ=40F91168 fetched=1
Feb 07 09:09:36.372008 - 4380/3204 WRK:Starting jdeCallObject         Returning from jdeSpecGetCount for JDESPECTYPE_DSTMPL with a count of 0
Feb 07 09:09:36.372009 - 4380/3204 WRK:Starting jdeCallObject         OMWOLObject::CopyRDBTAM() found 0 final target records for JDESPECTYPE_DSTMPL
Feb 07 09:09:36.372010 - 4380/3204 WRK:Starting jdeCallObject         Entering JDB_InsertTable (Table F98211) (hRequest 2BA26678)
Feb 07 09:09:36.372011 - 4380/3204 WRK:Starting jdeCallObject         ODBC:S DBResetRequest req=2BCCF8B8 con=0B2726D8 env=01FFFE70 dbc=079006A8 spid=77 TOOLS910E A (JDE@TOOLS910E)
Feb 07 09:09:36.372012 - 4380/3204 WRK:Starting jdeCallObject         INSERT INTO JDE910.SY910.F98211 VALUES ('39148e3f-af39-4be3-8103-75ff105b0968',2,'154E','W574210A|JDESPECTYPE_DSTMPL|',' ',' ',' ',0,0,0,0.000000,0.000000,0.000000,'P98220','TOOLS910B','CL6807948',114038,90936.000000,' ',' ')

Issue happen to P4210 as well.


Changes

 

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