topic Re: get_owner_list failed Error in Qlik Replicate in Qlik Replicate

get_owner_list failed Error in Qlik Replicate

AXK0121B — Wed, 10 Apr 2024 14:24:23 GMT

We are connecting to ProgressDB using ODBC DSN, Connection was implemented successfully.

When we are trying to get the table details we are getting the below error.

SYS-E-HTTPFAIL, Command get_owner_list failed when getting the list.

SYS,GENERAL_EXCEPTION,Command get_owner_list failed when getting the list.,Failed to get owners '' RetCode: SQL_ERROR SqlState: 08S01 NativeError: 0 Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054

Do we have to give any particular access, the user has access to all the tables in Progress DB.

Re: get_owner_list failed Error in Qlik Replicate

john_wang — Thu, 11 Apr 2024 00:16:46 GMT

Hello @AXK0121B ,

Thanks for reaching out Qlik Community!

Not very sure what's the platform of Qlik Replicate server. If you have configured an 64-bit ODBC DSN, then we may troubleshoot the issue by:

1. Set SERVER --> Logging --> Server Logging Level --> SERVER : set to Verbose

2. Recreate the error then check "repsrv.log", we can get the SQL statement which Replicated used to get available tables list or views list

3. Manually execute the same SQL in "isql" command (in Linux), or any other 3rd party ODBC Test Tool (in Windows) to understand the failure reason.

Hope this helps.

John.

Re: get_owner_list failed Error in Qlik Replicate

AXK0121B — Thu, 11 Apr 2024 12:56:38 GMT

@john_wang

We have checked the logs, we are getting the below error.

00005656: 2024-04-11T08:48:58:451459 [SERVER ]I: ODBC driver version: '07.16.0337 (B0863, U0702)' (ar_odbc_conn.c:633)
00005656: 2024-04-11T08:49:32:810950 [SERVER ]I: ODBC driver version: '07.16.0337 (B0863, U0702)' (ar_odbc_conn.c:633)
00005656: 2024-04-11T08:49:32:810950 [SERVER ]I: Failed to get 'ddoe27.dll' syntax, working with the default (odbc_endpoint_imp.c:5061)
00005656: 2024-04-11T08:49:32:810950 [SERVER ]I: Source endpoint 'OdbcWithCdc' is using provider syntax '<default>' (provider_syntax_manager.c:888)
00005656: 2024-04-11T08:49:32:810950 [SERVER ]E: RetCode: SQL_ERROR SqlState: 08S01 NativeError: 0 Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 [1022502] (ar_odbc_conn.c:985)
00005656: 2024-04-11T08:49:32:810950 [SERVER ]E: Failed to get owners '' [1022506] (odbc_util.c:1923)
00005656: 2024-04-11T08:49:32:810950 [STREAM_COMPONEN ]E: Command get_owner_list failed when getting the list. [1022502] (endpointshell.c:5839)

Re: get_owner_list failed Error in Qlik Replicate

AXK0121B — Thu, 11 Apr 2024 14:09:25 GMT

@john_wang

We have checked the logs, we are getting the log error.

Re: get_owner_list failed Error in Qlik Replicate

AKV0524 — Thu, 11 Apr 2024 17:10:05 GMT

Hi John,

we have raised support case for this issue:

case number:

00157327

Case Details - Qlik Community

Re: get_owner_list failed Error in Qlik Replicate

john_wang — Fri, 12 Apr 2024 02:04:21 GMT

Thank you @AKV0524 , @AXK0121B , our support team will work with you.

BTW, seems there is an incorrect configuration, see the line:

2024-04-11T09:58:41:390179 [SERVER ]I: Failed to get 'ddoe27.dll' syntax, working with the default

Please upload the Diag Packages to the support case.

thanks,

John.

Re: get_owner_list failed Error in Qlik Replicate

AXK0121B — Wed, 17 Apr 2024 04:45:49 GMT

@john_wang We are currently using a trail ODBC version for progressDB, which we downloaded from

https://www.progress.com/odbc/openedge

will this be the reason we are getting the below error ?

2024-04-11T09:58:41:390179 [SERVER ]I: Failed to get 'ddoe27.dll' syntax, working with the default

Re: get_owner_list failed Error in Qlik Replicate

john_wang — Wed, 17 Apr 2024 06:23:20 GMT

Hello @AXK0121B ,

Looks to me the error is irrelative to trail version. Please work with PS team to move it forward smoothly.

Regards,

John.