topic Re: SAS ESP 5.2 - DB2 Connector Connectors could not be started for the project in SAS Data Management

SAS ESP 5.2 - DB2 Connector Connectors could not be started for the project

junny — Sun, 03 Nov 2019 02:22:08 GMT

Hello Everyone!

I am Junny, I am looking for some help to solve an issue with SAS ESP (5.2 on linux Redhat) & DB2 Connector.

We are trying to publish data from DB2 Database into SAS ESP. The DB2 Client was installed and tested succesfully in the server.

The problem is when I try to start my test. I have this settings in my connection string in Source Window:

When I test my continuous query, I got this message:

Connectors could not be started for project XXXXXXXXX

In the xml_server log, we can see more details

2019-11-02T16:43:48,621; INFO ; 00000099; DF.ESP; (Http.cpp:1409); [XMLServer0001] websocket start: /subscribers/JS_Test_odbc_db2_v2/cq1/scr_e013?counts=true&format=json&info=5&mode=streaming&pagesize=10000&schema=true&snapshot=true

2019-11-02T16:43:48,622; INFO ; 00000093; DF.ESP; (dfESPpubsubServer.cpp:2063); [PubSub0011] Subscriber: Client negotiation successful, client version: 5.2, server version: 5.2, project: JS_Test_odbc_db2_v2, continuous query: cq1, window: scr_e013, total active clients = 2

2019-11-02T16:43:50,694; ERROR; 00000107; DF.ESP; (dfESPdbConnector.cpp:1812); [Connectors0022] dfESPdbConnector::connectToDB(): Database driver error: HY000 (-2143305326) : (34) Could not find extension: (tkedb2)

2019-11-02T16:43:50,694; ERROR; 00000107; DF.ESP; (dfESPdbConnector.cpp:1812); [Connectors0022] dfESPdbConnector::connectToDB(): Database driver error: IM003 (-2130708301) : (32) Could not load tkedb2 Extension.

2019-11-02T16:43:50,694; INFO ; 00000107; DF.ESP; (dfESPconnector.cpp:1378); [Connectors0087] dfESPconnector::setState(): Connector Connector_db2_eventost in group default has new state: finished

Any idea what is this error -- Database driver error: IM003 (-2130708301) : (32) Could not load tkedb2 Extension --?

Thanks and Best Regards,

Re: SAS ESP 5.2 - DB2 Connector Connectors could not be started for the project

SASKiwi — Sun, 03 Nov 2019 04:46:09 GMT

It looks like your SAS software is not configured correctly to use DB2. Have you completed the post-installation tasks for DB2 as documented here?

https://documentation.sas.com/?docsetId=dplyml0phy0lax&docsetTarget=p03m8khzllmphsn17iubdbx6fjpq.htm&docsetVersion=3.4&locale=en#p1ogv5yto7v1s8n17e12v4v3tcp0

Re: SAS ESP 5.2 - DB2 Connector Connectors could not be started for the project

junny — Tue, 05 Nov 2019 01:14:19 GMT

Hi SASkiwi,

Thanks a lot for your reply. We saw these post lnstallation activities, but
we did not find these files in our installation:
workspaceserver_usermods.sh and sas-compsrv files.
In addition, I must mention that we do not have SAS/ACCESS to DB2 licensed.

The following products are included in our license:

*PRODNUM1209 = CDFORCL Data Connector to Oracle;
*PRODNUM1213 = TKCDFTS Common TK Extensions for CAS Data Feeders;
*PRODNUM1219 = TKORACLE SAS TK Ext for Oracle;
*PRODNUM194 = ORACLEBNDL SAS/ACCESS to ORACLE;
*PRODNUM745 = ESPORD SAS Event Stream Processing;

Thanks and best regards,
JZ

Re: SAS ESP 5.2 - DB2 Connector Connectors could not be started for the project

SASKiwi — Tue, 05 Nov 2019 19:12:26 GMT

Yes, that would be another explanation for your errors.