FDMEE LCM Import issue for IMPORT_FORMAT Artifact


Issue: Unable to import , LCM IMPORT_FORMAT artifact alone. But rest of the Artifacts able to import except IMPORT_FORMAT.

ErpIntegrator.log having below errors.

[2016-02-16T10:34:41.141+01:00] [ErpIntegrator0] [ERROR] [ERPI-102101] [oracle.apps.erpi.model] [tid: 25] [userId: <anonymous>] [ecid: 00iYbO0Pq8SDOd85njDCiZ0001lk0000yA,0:1:4:3:3:4:3:3:3:4:4:4:4:4:3:4:3:3:3:3:3:4:3:1:1:1:3] [APP: AIF#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.aif.lcmintegration.util.XmlImportExportViewObjectImpl] [SRC_METHOD: importXML] Exception encountered while importing artifact[[
oracle.jbo.ReadXMLException: JBO-25025: Rowset with XML tag ImportGroupsAdapterVO cannot be loaded.

Caused by: oracle.jbo.RowReadXMLException: JBO-25026: Row oracle.jbo.Key[BC_Format_Import ] with XML tag ImportGroupsAdapterVORow cannot be loaded.

Caused by: oracle.jbo.AttributeReadXMLException: JBO-25027: Attribute ImportFormatItemAdapterVO at index 21 with XML tag ImportFormatItemAdapterVO cannot be loaded.

Caused by: oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[BC_Format_Import ERP 1 ].
at oracle.jbo.server.ViewObjectImpl.updateRowSetFromXML(ViewObjectImpl.java:18546)
… 39 more
## Detail 0 ##
oracle.jbo.RowReadXMLException: JBO-25026: Row oracle.jbo.Key[BC_Format_Import ] with XML tag ImportGroupsAdapterVORow cannot be loaded.

The issue is caused by duplicate Records for Source Import_Format artifact in  TBHVIMPITEMADAPTER DB table

select * from TBHVIMPITEMADAPTER where impgroupkey = ‘BC_Format_Import’;

“IMPSEQ” “IMPGROUPKEY” “IMPMAPTYPE” “IMPFLDFIELDNAME” “IMPSOURCECOLUMNID1” “IMPSOURCECOLUMNID2” “IMPSOURCECOLUMNID3” “IMPSOURCECOLUMNID4” “IMPSOURCECOLUMNID5” “IMPCONCATCHAR”
“1” “BC_Format_Import” “ERP” “ICP” “10134” “” “” “” “” “”
“2” “BC_Format_Import” “ERP” “UD1” “10136” “” “” “” “” “”
“3” “BC_Format_Import” “ERP” “UD2” “10135” “” “” “” “” “”
“4” “BC_Format_Import” “ERP” “ACCOUNT” “10135” “” “” “” “” “”
“5” “BC_Format_Import” “ERP” “ENTITY” “10133” “” “” “” “” “”
“6” “BC_Format_Import” “ERP” “ICP” “10134” “” “” “” “” “”
“7” “BC_Format_Import” “ERP” “UD1” “10136” “” “” “” “” “”
“8” “BC_Format_Import” “ERP” “UD2” “10135” “” “” “” “” “”
“9” “BC_Format_Import” “ERP” “ACCOUNT” “10135” “” “” “” “” “”
“10” “BC_Format_Import” “ERP” “ENTITY” “10133” “” “” “” “” “”

To Fix this

Remove the duplicate records in TBHVIMPITEMADAPTER DB table based on IMPSEQ column.

Then Re_Export LCM and do the Import LCM

Note : IMPSEQ is not Primary key (Sometime IMPSQL having duplicates) . so use RowId to delete duplicate records.

Eg:

DELETE FROM “FDMEE”.”TBHVIMPITEMADAPTER” WHERE ROWID = ‘AAASrkAAAAAAETWAAA’ AND ORA_ROWSCN = ‘11987502’ and ( “IMPSEQ” is null or “IMPSEQ” is not null )
DELETE FROM “FDMEE”.”TBHVIMPITEMADAPTER” WHERE ROWID = ‘AAASrkAAAAAAETWAAB’ AND ORA_ROWSCN = ‘11987502’ and ( “IMPSEQ” is null or “IMPSEQ” is not null )
DELETE FROM “FDMEE”.”TBHVIMPITEMADAPTER” WHERE ROWID = ‘AAASrkAAAAAAETWAAC’ AND ORA_ROWSCN = ‘11987502’ and ( “IMPSEQ” is null or “IMPSEQ” is not null )

Thanks,

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s