SAP Knowledge Base Article - Preview

2400709 - Oracle connection issue in Studio - SAP Event Stream Processor

Symptom

  • Oracle 12C Client is installed on the server where SAP Event Stream Processor (ESP) is installed.
  • The service is created for Oracle DB via ESP Studio.
  • However, when discovering the service, the following error is observed:

Connected to configured server view connections
Warning: Some required fields are incomplete in Server-wide:newservice1, enter required data before using service
[FAILURE:Unable to determine capabilitities of adapter type db_in][CODE:702020][EXCEPTION:xmlrpc call Connection.reset() failed msg: 2016-11-28 15:18:46 DBInput_Adapter::resetConnection - Error getting connection from service

[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]
DBInput_Adapter::reset() Connection initialization failed]
java.lang.Exception: xmlrpc call Connection.reset() failed msg: 2016-11-28 15:18:48 DBInput_Adapter::resetConnection - Error getting connection from service

[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]
DBInput_Adapter::reset() Connection initialization failed
at com.sybase.esp.cluster.plugins.servicetypes.adapter.InternalAdapter.reset(InternalAdapter.java:161)
...
at java.lang.Thread.run(Thread.java:812)
Warning: Some required fields are incomplete in Server-wide:ip6, enter required data before using service
[FAILURE:Unable to determine capabilitities of adapter type db_in][CODE:702020][EXCEPTION:xmlrpc call Connection.reset() failed msg: 2016-11-28 15:21:14 DBInput_Adapter::resetConnection - Error getting connection from service

[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]
DBInput_Adapter::reset() Connection initialization failed]
java.lang.Exception: xmlrpc call Connection.reset() failed msg: 2016-11-28 15:21:17 DBInput_Adapter::resetConnection - Error getting connection from service

[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]
DBInput_Adapter::reset() Connection initialization failed
at com.sybase.esp.cluster.plugins.servicetypes.adapter.InternalAdapter.reset(InternalAdapter.java:161)
...
at java.lang.Thread.run(Thread.java:812)


Read more...

Environment

  • SAP Event Stream Processor (ESP) 5.1 SP12
  • Linux on AMD/Intel x86_64
  • Oracle Client 12c

Product

SAP Event Stream Processor 5.1

Keywords

sqlplus,oracle,connect,dataservice,service,tnsnames.ora,ORACLE_HOME,$ORACLE_HOME,odbc,odbc.ini,.odbc.ini,odbinst.ini,discover,esp,streaming,streaming.sh,oracle client,PATH,$PATH,LD_LIBRARY_PATH,$LD_LIBRARY_PATH,ODBC DataService, , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.