I am getting the error below. I do not know why because the XML was passed by the tXSDValidator. I have also checked the XML and there are no characters or invisible characters in the prolog. Please let me know if I have set the job up correctly?.
Exception in component tFileInputXML_17 java.util.concurrent.ExecutionException: org.xml.sax.SAXParseException: Content is not allowed in prolog. at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at java.util.concurrent.FutureTask.get(FutureTask.java:83) at org.talend.xml.sax.simpleparser.SimpleSAXLooper.handleException(SimpleSAXLooper.java:63) at org.talend.xml.sax.SAXLooper.handleTaskResponse(SAXLooper.java:155) at whsmith_jobs.nested_json_test_24_0_1.Nested_json_test_24.tFileList_3Process(Nested_json_test_24.java:1318) at whsmith_jobs.nested_json_test_24_0_1.Nested_json_test_24.runJobInTOS(Nested_json_test_24.java:1916) at whsmith_jobs.nested_json_test_24_0_1.Nested_json_test_24.main(Nested_json_test_24.java:1652) Caused by: org.xml.sax.SAXParseException: Content is not allowed in prolog.
There is some thing wrong withe the XML document. Indeed content is not allowed in XML prolog: http://www.tizag.com/xmlTutorial/xmlprolog.php Take a look into your document and at first try to delete the prolog. Sometimes it is a problem of unsupported character set. By the way, figure out if your document have as first ever byte something not ASCII char (mostly used as flag that this file is an unicode encoded file). This first byte often caused this error.
Thanks for you response but I dont think the XML is wrong. It has been through the tXSDValidator without any issue. It has also been through several sub jobs and worked correctly.The data has been extracted and inserted in a DB. My job is made up of several sub jobs that each loop through the same group of XML files using there own tFileList component and send the data to separate database tables of the same database. If the last sub job also uses its own tFileList I get the contents not allowed in prolog error. If the last sub job shares the previous sub jobs tFileList I dont. Is there a way arround this bug?