XMLExtract Issue

Support/help with CloverETL implementation problems

rickymartin06
Posts: 12
Joined: Tue Jun 14, 2016 3:19 pm

XMLExtract Issue

Postby rickymartin06 » Thu May 18, 2017 3:12 pm

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

rickymartin06
Posts: 12
Joined: Tue Jun 14, 2016 3:19 pm

Re: XMLExtract Issue

Postby rickymartin06 » Mon May 22, 2017 9:14 pm

Any thoughts on this situation?

jandikovae
Posts: 23
Joined: Fri Nov 04, 2016 8:51 am

Re: XMLExtract Issue

Postby jandikovae » Mon May 29, 2017 7:31 am

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
---
Eva Jandikova
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

rickymartin06
Posts: 12
Joined: Tue Jun 14, 2016 3:19 pm

Re: XMLExtract Issue

Postby rickymartin06 » Tue May 30, 2017 6:49 pm

Thanks.

jandikovae
Posts: 23
Joined: Fri Nov 04, 2016 8:51 am

Re: XMLExtract Issue

Postby jandikovae » Thu Jun 01, 2017 12:40 pm

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.
---
Eva Jandikova
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support


cron