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
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
-
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.
Please sign in to leave a comment.
Comments 4