Troubleshooting
Problem
When setting up the DataStage environment file (dsenv) to set variables for external 3rd party database clients the agents need to be restarted to also reflect the changes in the environment file. However, you may still encounter the error after the agents have been restarted "Failed to send the request to the handler" when trying to view data with the Teradata Common Connector.
Symptom
General Health Check from ISALite will report "The maximum number of sessions has been reached" this points to an agent that is trying to connect to a port that is in use, probably by an agent process that was hung or not shutdown properly.
Resolving The Problem
As root, shutdown the agent processes:
cd <install_dir>/InformationServer/ASBNode/bin
./NodeAgent.sh stop
Check for any IS agent processes that may still be running:
ps -ef | grep -i agent
If the IS agent processes are still running you need to kill these processes with -9 option:
kill -9 <PID of rogue agent process>
Verify the agent process is gone:
ps -ef | grep -i agent
Restart the agents:
./NodeAgent.sh start
When the agents are started cleanly they will load the correct DataStage environment information so the connectors can work as needed.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21614653