topic Re: Qlik Replicate ADABAS ODBC connection with Connx in Qlik Replicate

Qlik Replicate ADABAS ODBC connection with Connx

michelabarsottini — Wed, 27 Jul 2022 14:54:22 GMT

Hi all,

for a customer project we need to connect Qlik Replicate to Adabas database using the ODBC connection with the ODBC driver Connx supplied by Software AG (as far as we know it's the only one available on the market).

We created on the machine the System DSN and the connection works, we tested with an external client on the Replicate machine and we were able to connect and make queries. The ODBC is 64bit and compliant to Replicate prerequisites.

When we test the connection from Replicate the Attunity Replicate Server Service crashes and we can see the following error in the logs:

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: An exception occurred!!! (win32_exception_handler.c:150)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: exception code is 3221225477 (win32_exception_handler.c:152)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: tid=9128 (win32_exception_handler.c:155)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: exception as string is EXCEPTION_ACCESS_VIOLATION (win32_exception_handler.c:158)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: for more details about win32 exceptions, look at http://msdn.microsoft.com/en-us/library/aa908962.aspx (win32_exception_handler.c:161)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: exception record (nest level = 0): (win32_exception_handler.c:42)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: exception code: 3221225477 (win32_exception_handler.c:44)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: exception flags: 0 (win32_exception_handler.c:46)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: exception address: 70249862 (win32_exception_handler.c:48)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: exception has 2 information parameters (win32_exception_handler.c:50)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: write violation error (win32_exception_handler.c:64)

00009128: 2022-07-27T16:32:50 [AT_GLOBAL ]E: violating address is 0 (win32_exception_handler.c:75)

Any suggestions?

Thanks a lot

Michela

Re: Qlik Replicate ADABAS ODBC connection with Connx

shashi_holla — Wed, 27 Jul 2022 16:15:35 GMT

Hi @michelabarsottini

Could you please share the complete log? Is there any warning/error for SERVER component in the log prior to these AT_GLOBAL errors?

Re: Qlik Replicate ADABAS ODBC connection with Connx

michelabarsottini — Wed, 27 Jul 2022 16:22:09 GMT

Hi @shashi_holla,

There are no warnings or errors, even if I increase the log level this is the only error we have. Here the full log, I redacted the customer info.

00003000: 2022-07-27T16:22:49 [AT_GLOBAL ]I: Attunity Replicate Server Log (V2022.5.0.291 <customer_host> Microsoft Windows Server 2012 (build 9200) 64-bit, Revision:a82fb96beb16d0018595df2a09cbd912edbc4f05, PID: 5892) started at Wed Jul 27 16:22:49 2022 (at_logger.c:2693)

00003000: 2022-07-27T16:22:49 [AT_GLOBAL ]I: <license_info>, all sources, targets: (Oracle), all hosts (at_logger.c:2696)

00003000: 2022-07-27T16:22:49 [AT_GLOBAL ]I: Log file encryption base "uKD7GGyORvmQGKdxrfwO3Q==" (at_logger.c:2708)

00003000: 2022-07-27T16:22:49 [UTILITIES ]I: Scheduler configuration has been loaded. (scheduler.c:373)

00003000: 2022-07-27T16:23:01 [SERVER ]I: Bundled Endpoint Server is listening on port 51703 (ar_endpoint_servers_mgr.c:682)

00003000: 2022-07-27T16:23:02 [TASK_MANAGER ]I: Feature flags for process are: (ar_feature_flags.c:232)

00003000: 2022-07-27T16:23:02 [SERVER ]I: Client session (ID 134010277) allocated (dispatcher.c:276)

00009628: 2022-07-27T16:23:02 [REST_SERVER ]I: Agent was started successfully (listening on port 3552). (atctl_serve.c:402)

00009128: 2022-07-27T16:32:50 [SERVER ]I: Going to connect to ODBC connection string: DSN=<dsn_name>;UID=<user>; (odbc_endpoint_imp.c:3058)