My Oracle Support Banner

When Importing an XML file via DataManager Not All Records are Inserted into the Database (Doc ID 807160.1)

Last updated on MARCH 07, 2019

Applies to:

Oracle Utilities Energy Information Platform - Version 1.5.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When importing data into the customer database from an XML file in Data Manager, not all records are imported. No error occurs indicating that the record(s) were not imported. This behavior is verified by manually confirming if the records in the XML file were imported into the database.

This occurs when importing data in the Compact XML format.

Example of XML File

<?xml version="1.0" encoding="utf-8"?>
<LODESTAR_IMPORT ACTION="ADDUPDATE" BATCHSIZE="50" ONERROR="STOP"
LSFORMAT_VERSION="2.0">
  <ROWS>
    <ROW TBL="LSADDRESSFORMAT">
      <ADDRESSFORMAT V="US Format" />
      <VAL1NAME V="US Format" />
      <LSUSER V="PWRLINE" />
      <LSTIME V="2008-01-01 12:00:00" />
    </ROW>
  </ROWS>
  <ROWS>
    <ROW TBL="LSSERVICETYPE">
      <SERVICETYPE V="E" />
      <DESCRIPTION V="Electric" />
      <LSUSER V="PWRLINE" />
      <LSTIME V="2008-01-01 12:00:00" />
    </ROW>
    <ROW TBL="LSSERVICETYPE">
      <SERVICETYPE V="G" />
      <DESCRIPTION V="Gas" />
      <LSUSER V="PWRLINE" />
      <LSTIME V="2008-01-01 12:00:00" />
    </ROW>
  </ROWS>
</LODESTAR_IMPORT>

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
Cause
Solution
 Patch Information
 Workarounds
References


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