Product(s):	Exor NEM Data Loader
	Version(s):	04.07.00.01
	Environment:	N/A
	Area:	Load
	Subarea:	N/A

Background

The NEM Data Loader is used by Area 5 to transfer events to NEM from their event management system.  These are loaded using Process Monitor in Exor.  Sometimes the errors they receive at their side do not tell them the full issue so they contact us to find out more details.  To see the issue go into Process Monitor and query records for NEM Data Loader.

*update* an alert has been created that emails Area 5 users Ozlem Tilkidagi whenever there's a failure, with full details.  However Ozlem's account has been locked since 16th January so may not be working there anymore.  New recipients can be added by updating the mail setup for the Triggered Event titled 'Area 05 NEM Loader Fail'.

Issue

When user transfers XML file into the system (NEM Data Loader process) the error message is shown:

Error validating file: ORA-31154: invalid XML document

ORA-19202: Error occurred in XML processing

LSX-00213: only 0 occurrences of particle “Speed Limit”, minimum is 1

Solution

The XML misses at least one mandatory field, in this case ‘Speed Limit’ element is missed in Schedules part in XML file. (see specification ‘Initial Asset & NOMS National Stage – NEM Data Loader v1.1’). We need to pass these errors back to the user who raised the SR so the XML can be fixed and resubmitted.  The issue has been resolved by adding the missed line with corresponding value in XML file and uploading the file into the system.

 XML file:

……….

    <Schedule>

       <PlannedStartDate>2018-06-28T01:00:00</PlannedStartDate>

       <PlannedCompleteDate>2018-06-28T02:00:00</PlannedCompleteDate>

       <SpeedLimit>40 MPH</SpeedLimit>                  <-- was missed in the original XML file

    </Schedule>

……

Original Author:

Renatas