topic Re: Java issue , Qlik Replicate with source SAP ODP in Qlik Replicate

Java issue , Qlik Replicate with source SAP ODP

toni_lajsner — Fri, 15 Dec 2023 13:35:59 GMT

Hi,

We are starting to experience a strange issue while adding new tables to our task. This problem occurs when we attempt to access table settings.

f we only attempt to save and resume the task, the entire task fails. We have tested this option multiple times.

Has anyone else faced this issue?

Re: Java issue , Qlik Replicate with source SAP ODP

Dana_Baldwin — Fri, 15 Dec 2023 15:55:33 GMT

Hi @toni_lajsner

I've extracted the error message as text to make it easier to search. I'll check our solution database and post again:

SYS-E-HTTPFAIL, Unsupported: design time metadata.java.lang.illegalArgumentException: No enum constant
com.qlik.sap.endpoints.odp.model.DbType.RSTR.

Re: Java issue , Qlik Replicate with source SAP ODP

Dana_Baldwin — Fri, 15 Dec 2023 15:59:50 GMT

Hi @toni_lajsner

I don't see this listed in our solution database. What is the full version number of Qlik Replicate you are using so I can check release notes in later versions?

Thanks,

Dana

Re: Java issue , Qlik Replicate with source SAP ODP

shashi_holla — Fri, 15 Dec 2023 21:48:57 GMT

@toni_lajsner

Could you please check the data type of all columns in the newly added table and if there is any data type which is not listed as per the user guide link below:

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/SAP%20ODP/SAP_ODP_data_types_source.htm

Based on the error message, data type could be on the table could be RSTR which is not supported.

Please check and confirm.

Re: Java issue , Qlik Replicate with source SAP ODP

toni_lajsner — Mon, 18 Dec 2023 09:17:50 GMT

Hi @Dana_Baldwin We are using following version May 2023 (2023.5.0.322).

/Toni

Re: Java issue , Qlik Replicate with source SAP ODP

toni_lajsner — Mon, 18 Dec 2023 10:18:03 GMT

Hi @shashi_holla
This is the table definition, and all data types are present and supported by Qlik.

/Toni

Re: Java issue , Qlik Replicate with source SAP ODP

Dana_Baldwin — Mon, 18 Dec 2023 17:29:32 GMT

Thanks @toni_lajsner

There are no documented fixes related to this error. Please open a support case for this issue and attach a diagnostics package and the create table SQL statement for one of the newly added tables that triggers this issue. If more than one table was added at the time the issue started, we may need to see the table structure of all the new tables added at that time to see which one it is. Based on what Shashi shared one of them may have an unsupported data type in one of the columns.

Thanks,

Dana

Re: Java issue , Qlik Replicate with source SAP ODP

toni_lajsner — Tue, 19 Dec 2023 09:28:31 GMT

I have received another picture from my collage and it seems that we have one more column with data type RawString , can it be that this is the one that creates the issue ?

//Toni

Re: Java issue , Qlik Replicate with source SAP ODP

Dana_Baldwin — Tue, 19 Dec 2023 16:53:16 GMT

Hi @toni_lajsner

I'm not sure. "Raw" is listed as a supported data type. Please open a support case so we can look more thoroughly into this.

Thanks,

Dana