topic Re: SAS ESP 5.2 Oracle pub/sub connector fails to start in Streaming Analytics

SAS ESP 5.2 Oracle pub/sub connector fails to start

AsSASsin — Mon, 25 Mar 2019 20:57:01 GMT

Hi all,

I'm trying to set a project into Event Stream Processing Studio with the ESP 5.2 version.

On the system the services are correctly running and I started the dfesp_xml_server with the logging options:

./dfesp_xml_server -pubsub 5000 -http 5001 -loglevel common.http=trace -logconfig "/data/sas/viya/config/etc/SASEventStreamProcessingEngine/default/esp-logger.xml" &

I have to use an oracle connector for publishing/subscripting and in my project I configured the input connector with database connector:

The problem is when I try to start my test, because I have an information popup which shows me this message "Could not start connector".

I tried to start the dfesp_db_adapter from command line, but I have the same message into the linux console:

dfesp_db_adapter -c "driver=oracle;uid=myID;pwd=myPW;path=dbIP/service" -k pub -h dfESP://localhost:5001/db_sub/cq_01/tradesWindow -j debug

license ID: <xxxxxxxxx-0175xxx31>
license ID: <xxxxxxxxx-0175xxx31>
Connector failed to start
Could not start connector

I noticed also that in the logging path (in my configuration xml file ) I haven't any log.

Any ideas?

Is it a configuration problem or what?

Thank you very much.

Re: SAS ESP 5.2 Oracle pub/sub connector fails to start

AndyT_SAS — Tue, 26 Mar 2019 18:29:03 GMT

There are normally error messages that go with the "connector failed to start". The DB connector/adapter will try to connect to the database as part of the start up process.

This could be because of how the logging is set up. What do you have configured in the esp.logger file?

Re: SAS ESP 5.2 Oracle pub/sub connector fails to start

AsSASsin — Tue, 26 Mar 2019 20:54:44 GMT

I used this note to configure logging:

http://support.sas.com/kb/60/591.html

What I’m trying to understand is why the ESP studio tells me that could not import the connectors.

Re: SAS ESP 5.2 Oracle pub/sub connector fails to start

AndyT_SAS — Wed, 27 Mar 2019 11:40:38 GMT

ESP Studio is reflecting the message from the ESP XML server about the connector not starting. Can you try running without the -logconfig option to see if there are any additional messages about the connector not starting?