DataStage Errors while viewing data using View Data on Oracle Connector Stage

DataStage Errors while viewing data using View Data on Oracle Connector Stage

Most of the times the following error occurs for “view data” and “test connection” actions in Connector stage properties, even though the job itself runs successfully without any warnings

An Exception occurred while trying to receive the response form the handler: An exception was received from the handler: Error loading connector library libccora10g.so. libcIntsh.so.10.1: cannot open shared object filr: No such file or directory

Root cause of this error is 

Node agents were not started after adding the oracle environment variables to the dsenv file

If the jobs are unable to run, please refer to the Oracle connectivity guide and verify if all the Installation and configuration requirements are met. Also any changes to dsenv file will require the node agents to be restarted.

To fix this problem

Restart node agents

 

 

Author: Kuntamukkala Ravi

ETL Consultant by Profession, Webmaster by Passion

Leave a Reply

Your email address will not be published. Required fields are marked *