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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.