Tag Archives: kettle

[Solved] kettle Error: Unexpected problem reading shared objects from XML file

ETL error:

Unexpected problem reading shared objects from XML file: null

An error occurred while reading the shared file (continue loading the message)

“A fatal error occurred while reading the shared object” when creating a new transformation for the kettle

“Unexpected problem reading shared objects from XML file: null”

When saving KTR and KJB, an error message will pop up: “unable to save shared objects”

”Unexpected problem reading shared objects from XML file:“

Problem:

This is caused by improper operation when developing shared DB connection (database connection).

Solution:

Find it kettle/shared.XML (usually in C:\users\user\.Kettle) file; delete the content between <sharedobjects >… </sharedobjects> to solve this problem;

The solution to the java.lang.ClassCastException: [B cannot be cast to java.lang.String error in kettle

Problem description: a field queried from the database is json type data, and then an error is reported in the json input step java.lang.ClassCastException: [B cannot be cast to java.lang.String

The cause of the problem: The data queried from the database is not a String type, but a binary byte array, so an error is reported during json parsing.

Solution: In the field selection step, set the field type to String type, and set Binary to Normal to Yes.