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.
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.5;8.7","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21614653