XMLExtract Issue

CloverDX Platform
1

Hi,

Im running a Jobflow that reads a lot of xml files one by one in a graph if it encounters an xml with an invalid format the job continues and only that xml process fails, that is good, but im trying to delete the xml with error thats where the probleme starts, the jobflows fails with the following error:

Component [DeleteFiles:DELETE_FILES5] finished with status ERROR. (In0: 1 recs)
Failed to delete sandbox://rmartinez_dev/data-in/XstoreO … 234553.xml

The graph fails with the following error:

Component [XMLExtract:XMLEXTRACT] finished with status ERROR. (Out0: 166 recs, Out1: 2 recs, Out2: 0 recs, Out3: 0 recs, Out4: 1 recs, Out5: 0 recs, Out6: 0 recs, Out7: 0 recs, Out8: 6 recs, Out9: 0 recs, Out10: 2 recs, Out11: 0 recs, Out12: 0 recs, Out13: 240 recs, Out14: 1 recs, Out15: 0 recs, Out16: 0 recs, Out17: 0 recs, Out18: 15 recs, Out19: 2 recs, Out20: 0 recs, Out21: 15 recs, Out22: 2 recs, Out23: 1 recs, Out24: 2 recs, Out25: 0 recs, Out26: 15 recs, Out27: 0 recs, Out28: 0 recs, Out29: 0 recs, Out30: 6 recs)
SAX parsing exception
Content is not allowed in trailing section.

The file gets stuck untill i run the graph succesfull then i can delete it manually.

Is there a way i can force a delete or move the file because those invalid files cannot stay in that folder.

Any help is apreciated thanks,

Ricardo Martinez

2

Any thoughts on this situation?

3

Hi Ricardo,
We are currently working on this issue in a support ticket with your colleague Madeline. We will update you with our findings then.
Thanks Eva

4

Thanks.

5

This question has been answered in a support ticket. Resolution:

If an XMLExtract or JSONExtract component receives a file with a specific type of syntax error, it might happen that the component fails (as expected) but the XML/JSON files are not unlocked properly for further transactions. This issue appeared in an older version of CloverETL and has been resolved in version 4.3.0-M2.