SAP Knowledge Base Article - Preview

2405344 - Issue while reading data from Oracle DB with running project - SAP ESP 5.1

Symptom

 

In ESP Studio

  • Right mouse clicked on the Oracle odbc DataService and selected 'Discover', the command is successful and returns a list of tables
  • When running a project, that is connecting to the same Oracle odbc DataService, results in the following errors:

[SP-3-100005] Error opening connection to database. [IM002][0][unixODBC][Driver Manager]Data source name not found, and no default driver specified]
[SP-3-100005] Error rolling back transaction from database. [08003][unixODBC][Driver Manager]Connection does not exist
[SP-3-100005] Error opening connection to database. [IM002][0][unixODBC][Driver Manager] Data source name not found, and no default driver specified]
[SP-3-100005] Error rolling back transaction from database. [08003][unixODBC][Driver Manager]Connection does not exist
[SP-3-148001] ConnectionReader(SLTE_USER_IN) connection reset error:  DBInput_Adapter::resetConnection - Error getting connection


 


Read more...

Environment

  • SAP Event Stream Processor (ESP) 5.1
  • Oracle 12g
  • Linux

Product

SAP Event Stream Processor 5.1

Keywords

oracle,install,odbc , 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.