Error:
Sorry, an error occured loading the new transformation from the repository:
Error reading information from input stream
Invalid byte 1 of 1-byte UTF-8 sequence
Why:
I am modifying transformation XML file and instead of writing sql in "table input" step i directly replace query in xml file with in xml SQL tags.
As you know guys if we paste sql from UI in "Table input" step then kettle automatically convert special characters in SQL query to some readable form, already mentioned in other post read below link
Link 1
Replace Special Char from string for "table input step" kettle transformation
https://j4info.blogspot.com/2016/02/replace-special-char-from-string-for.html
Link 2
Function to process each character of String [SQL server]
http://j4info.blogspot.com/2016/02/function-to-process-each-character-of.html
Solution :
On other hand if you would like to modify XML file from transformation then you have you replace special character in some format (see above link in the same article).
In my case there was same space like character in sql query (not space in actual,select char(160)).Space can be identify in notepad plus plus shown as small orange dot in place of space if clicked on "Show all Character" button.
But my space is showing space only means it is some special kind of character and we need to replace it " " so that kettle can read it.
Sorry, an error occured loading the new transformation from the repository:
Error reading information from input stream
Invalid byte 1 of 1-byte UTF-8 sequence
Why:
I am modifying transformation XML file and instead of writing sql in "table input" step i directly replace query in xml file with in xml SQL tags.
As you know guys if we paste sql from UI in "Table input" step then kettle automatically convert special characters in SQL query to some readable form, already mentioned in other post read below link
Link 1
Replace Special Char from string for "table input step" kettle transformation
https://j4info.blogspot.com/2016/02/replace-special-char-from-string-for.html
Link 2
Function to process each character of String [SQL server]
http://j4info.blogspot.com/2016/02/function-to-process-each-character-of.html
Solution :
On other hand if you would like to modify XML file from transformation then you have you replace special character in some format (see above link in the same article).
In my case there was same space like character in sql query (not space in actual,select char(160)).Space can be identify in notepad plus plus shown as small orange dot in place of space if clicked on "Show all Character" button.
But my space is showing space only means it is some special kind of character and we need to replace it " " so that kettle can read it.
