E2B XML Import Error: Error has occurred while extracting the data from XML file. in E2bReceive.ExtractXML_Data Fn, Error#: 0,Desc.: (Doc ID 1332402.1)

Last updated on JULY 07, 2016

Applies to:

Oracle Argus Interchange - Version 5.1 and later
Information in this document applies to any platform.
***Review currency on 10-Mar-2013***
***Reviewed for currency: 06-JAN-2015***

Symptoms

The following errors appear in the ESM Import Log file when trying to import E2B/XML cases and the file is not loaded.

"13-Jun-2011 4:02:45 PM: ========== Start Receive Process ============"
"13-Jun-2011 4:02:45 PM: ========== Start Receive Process for File : D:\Program Files\Relsys\ESM\In\ORACLE000000000000206I.xml=========="
"13-Jun-2011 4:02:46 PM: Error has occurred while extracting the data from XML file. in E2bReceive.ExtractXML_Data Fn, Error#: 0,Desc.: "
"13-Jun-2011 4:02:46 PM: For E2b Type: 3, Report ID: 377, <SAFEETYREPORTID> GB-ORACLE-LACK001385SAE02, <COMPANYNUMB> GB-ORACLE-LACK001385SAE02, <AUTHORITYNUMB>
Unable to find the Case ID using the SQL: select NVL(case_xref,-1) case_xref from safetyreport sr where sr.report_id = (select report_id from ( select max(report_id) report_id from safetyreport S where S.status = 102 and s.reportacknowledgment.reportacknowledgmentcode = '01' and s.companynumb = (select ss.companynumb from safetyreport ss where ss.report_id =377) UNION select max(report_id) from safetyreport S where S.status = 102 and s.reportacknowledgment.reportacknowledgmentcode = '01' and s.authoritynumb = (select ss.authoritynumb from safetyreport ss where ss.report_id =377) ) B where report_id is not null and rownum = 1 )"
"13-Jun-2011 4:02:46 PM: Following Errors while updating database for SAFETYREPORTID is 'GB-ORACLE-LACK001385SAE02'
"
"13-Jun-2011 4:02:47 PM: ========== Finish Receive Process for file D:\Program Files\Relsys\ESM\In\ORACLE000000000000206I.xml =========="
"13-Jun-2011 4:02:47 PM: ========== Finish Receive Process ========== "

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