get_owner_list failed Error in Qlik Replicate

[AXK0121B]

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.

[john_wang · Accepted solution]

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.

[AXK0121B]

@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)

[AXK0121B]

@john_wang 

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

[AKV0524]

Hi John,

we have raised support case for this issue:

case number: 

00157327

Case Details - Qlik Community

[john_wang]

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.

[AXK0121B]

@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

[john_wang]

Hello @AXK0121B ,

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

Regards,

John.