Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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)
Hi John,
we have raised support case for this issue:
case number:
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.
@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
Hello @AXK0121B ,
Looks to me the error is irrelative to trail version. Please work with PS team to move it forward smoothly.
Regards,
John.