Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am getting this error "Unrecognized type id_byte[] " .I am copying tables from one db to another db.I didn't had issues with most of the tables.With this error I couldn't find the error comes where .I tried changing all the datatype to varchar but still it is not accepting.I don't have any idea of this error.
Thanks for suggestions if you have any idea,
Regards,
Manoj
Hi,
I'm copying data of tables from Oracle to Snowflake.Just the tables are dynamic , schema remains constant.
There is a column of datatype byte[] on a table of oracle.But generally I use the datatype dynamic for all tables it is working ,but I don't know why it is not accepting the datatype byte[].
If I copy the table manually it means one to one in another job,there are no issues.I think maybe on the snowflake side it couldn't identify the datatype (byte[]).
This column in the database is of datatype Raw(16) which is recogonized as byte[] in talend.
Regards,
Manoj
Hi Shong,
Thanks for your reply.It is really a good solution.I have found another solution that as we have a mass volume of tables and datas,the tables which causes the problem we will choose just the columns which are not causing the problem.
We have an excel sheet which has the list of tables with the columns and the where conditions.
So in the conditions I will eliminate the columns which has the issues.For now its okay I guess ,but If the column which has an issue is important then I have to go through the steps you have proposed.Thank you very much,your reply is very clear,I hope it will be useful for me in future.
Have a good day,
Manoj
Hi Shong,
I'm having the same issue while using dynamic schema for varbinary columns in the source. My source is SAP Hana and target is Snowflake. Tried modifying the mapping xmls but doesnt seem to work. Getting a Unrecognized type id_byte[] error.
Any advice would be highly appreciated
Hello,
I am also facing the similar error, could you please help me you have find any solution?
[FATAL] 14:56:22 eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf- tDBOutput_1 Unrecognized type id_Object
java.lang.UnsupportedOperationException: Unrecognized type id_Object
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.diToAvro(IncomingSchemaEnforcer.java:306) ~[talend-codegen-utils-0.31.0.jar:?]
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.addDynamicField(IncomingSchemaEnforcer.java:173) ~[talend-codegen-utils-0.31.0.jar:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBInput_1Process(jobitemmastercdstosf.java:4090) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBInput_3Process(jobitemmastercdstosf.java:2675) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tJava_6Process(jobitemmastercdstosf.java:1491) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBConnection_2Process(jobitemmastercdstosf.java:1353) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tJava_14Process(jobitemmastercdstosf.java:4855) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBConnection_3Process(jobitemmastercdstosf.java:4715) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tRESTClient_3Process(jobitemmastercdstosf.java:6860) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tJava_3Process(jobitemmastercdstosf.java:5934) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tFileInputDelimited_1Process(jobitemmastercdstosf.java:5774) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.runJobInTOS(jobitemmastercdstosf.java:8210) [classes/:?]
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.main(jobitemmastercdstosf.java:7670) [classes/:?]
Exception in component tDBOutput_1 (jobitemmastercdstosf)
java.lang.UnsupportedOperationException: Unrecognized type id_Object
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.diToAvro(IncomingSchemaEnforcer.java:306)
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.addDynamicField(IncomingSchemaEnforcer.java:173)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBInput_1Process(jobitemmastercdstosf.java:4090)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBInput_3Process(jobitemmastercdstosf.java:2675)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tJava_6Process(jobitemmastercdstosf.java:1491)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBConnection_2Process(jobitemmastercdstosf.java:1353)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tJava_14Process(jobitemmastercdstosf.java:4855)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tDBConnection_3Process(jobitemmastercdstosf.java:4715)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tRESTClient_3Process(jobitemmastercdstosf.java:6860)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tJava_3Process(jobitemmastercdstosf.java:5934)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.tFileInputDelimited_1Process(jobitemmastercdstosf.java:5774)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.runJobInTOS(jobitemmastercdstosf.java:8210)
at eim_itemmaster.jobitemmastercdstosf_0_1.jobitemmastercdstosf.main(jobitemmastercdstosf.java:7670)
job ended : 2023-01-20 14:56:22
[statistics] disconnected