Getting following error - Multiple markers at this line - net.sf.json cannot be resolved to a type

[RanjithMeda]

I am trying to read JSON data from and file using tExtractJSONFields and then load into MongoDB using tmongodboutput

I am getting below error while doing that

Execution failed : org.talend.commons.exception.PersistenceException: org.talend.designer.runprocess.ProcessorException: Job compile errors 

At least job "Job_Name" has a compile errors, please fix and export again.

Error Line: 8697

Detail Message: net.sf.json cannot be resolved to a type

There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

[anselmopeixoto]

Hi @RANJITH MEDA​ 

What versions of Talend Studio and Java are you using?

[RanjithMeda]

Hello @Anselmo Peixoto​ 

I am using Java 8 and Talend 7.3.1

[anselmopeixoto]

Hi @RANJITH MEDA​ 

Although Java 8 is considered supported by Talend 7.3.1 according to the documentation, I suggest you try using Java 11 that is the recommended version.

[Anonymous]

Hello,

From your above error message, could you please check if the JAVA_HOME path is set properly and JAR used by your component is supported or compatible.

In Talend 7.3.1, the default version of this jar is json-lib-2.4.5-talend Jar, please check if your .m2 path contains the correct jar version

• {Studio installation folder}\configuration\.m2\repository\net\sf\json-lib\json-lib Replace the jar in case you are using an older version of the jar. To replace the jar, delete the older jar from {Studio installation folder}\configuration\.m2\repository\net\sf\json-lib\json-lib.

(Note: Make sure to take a backup before deleting these folders), restart Studio and then download the default json-lib-2.4.5-talend.jar through tWriteJSON component in Studio.

• If the existing jar is already json-lib-2.4.5-talend inside {Studio installation folder}\configuration\.m2\repository\net\sf\json-lib\json-lib, to avoid jar size issue, then download the latest JSON-lib jar and check the size of the jar. If the size is different, please use the latest version of json-lib-2.4.5-talend.jar downloaded automatically through Studio.

Feel free to let us know if it is OK with you.

Best regards

Sabrina

[RanjithMeda]

Hello @Xiaodi Shi - I checked JAVA_HOME and it looks fine.

I see 2 folders in \configuration\.m2\repository\net\sf\json-lib\json-lib 2.4.6-talend and 2.4.5-talend. Deleted both of them and installed again. Still getting same error.

[Anonymous]

Hello,

Could you please try to use tLibraryLoad component to force the library in the job?

Best regards

Sabrina

[RanjithMeda · Accepted solution]

Hello,

I replaced .m2 folder with my colleagues .m2 folder (he doesn't face this issue) and it is working fine now!

[Anonymous]

Hello,

Great it works and feel free to let us know if there is any further help we can give.

Best regards

Sabrina