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
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