Getting error while creating Structures for Json in Hierachical Mapper.

manodwhb — Sat, 16 Nov 2024 05:16:38 GMT

Hi ,

I am getting below error while creating Structures for Json in Hierachical Mapper.

Overall:Error
1: Error - An exception occurred parsing the document being imported. (15)
Exception: java.lang.ClassCastException: java.lang.String cannot be cast to com.oaklandsw.transform.rep.json.tokener.JSONObject
at com.oaklandsw.transform.rep.json.tokener.JSONTokenTool.aggregate(JSONTokenTool.java:41)
at com.oaklandsw.transform.rep.json.tokener.JSONArray.getTypicalElement(JSONArray.java:1213)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonArray(JsonTokenImporter.java:95)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonObject(JsonTokenImporter.java:80)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonArray(JsonTokenImporter.java:110)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonObject(JsonTokenImporter.java:80)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.parseSubclass(JsonTokenImporter.java:54)
at com.oaklandsw.transform.rep.AbstractFileReader.parse(AbstractFileReader.java:122)
at com.oaklandsw.util.AbstractXmlReader.parse(AbstractXmlReader.java:69)
at com.oaklandsw.transform.importing.Importer.doImportParse(Importer.java:991)
at com.oaklandsw.transform.rep.json.JsonSampleImporter.doImportSubclass(JsonSampleImporter.java:55)
at com.oaklandsw.transform.importing.Importer.doImport(Importer.java:884)
at com.oaklandsw.transform.importing.Importer.run(Importer.java:787)
at com.oaklandsw.transform.importing.ImportWizard$ImporterRunner.run(ImportWizard.java:407)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Re: Getting error while creating Structures for Json in Hierachical Mapper.

Haitao — Tue, 16 Jul 2019 14:16:37 GMT

Please share your steps and if possible your project.

Re: Getting error while creating Structures for Json in Hierachical Mapper.

manodwhb — Wed, 17 Jul 2019 14:43:11 GMT

@hnie , I need to convert complex xml into Json and trying to use tHMap.

my job looks like below.

tfilinputxml-->tHMap--->tFileoutputRaw. where i need to know the configuration details for tHMap.

Re: Getting error while creating Structures for Json in Hierachical Mapper.

rriahi — Thu, 18 Jul 2019 10:56:53 GMT

Hi,

can you please send us a part from your xml and how the json file should be?

Re: Getting error while creating Structures for Json in Hierachical Mapper.

manodwhb — Fri, 09 Aug 2019 12:09:26 GMT

I have fixed this error by creating structures.

topic Re: Getting error while creating Structures for Json in Hierachical Mapper. in Talend Studio

Getting error while creating Structures for Json in Hierachical Mapper.

Re: Getting error while creating Structures for Json in Hierachical Mapper.

Re: Getting error while creating Structures for Json in Hierachical Mapper.

Re: Getting error while creating Structures for Json in Hierachical Mapper.

Re: Getting error while creating Structures for Json in Hierachical Mapper.