agent at nsads-dev2:31531 is not available

suneelchallagali · Post by **suneelchallagali** » Thu Feb 18, 2010 12:55 pm

Hi i have created a job which load data from sequential file into database

job flow

SEQ_ FILE ------> ODBC Connector

The job was working fine earlier. but now when i am trying to test the connection i am getting an error stating that.

An Execption occured while trying to send the request to the handler. the agent nsads-dev2:31531 is not available.

can any one help me out.

DSguru2B · Post by **DSguru2B** » Thu Feb 18, 2010 1:16 pm

What is nsads-dev2 ? Is this your server name? Can you connect to it from outside of DataStage?

suneelchallagali · Post by **suneelchallagali** » Thu Feb 18, 2010 1:33 pm

nsads-dev2 is server name. what do you mean by can you connect outside the datastage i dint get it please can you explain in detail

thank you

DSguru2B · Post by **DSguru2B** » Thu Feb 18, 2010 2:16 pm

I mean use your favourite sql tool, acess or something to connect to the database and see if its up and running.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 18, 2010 4:29 pm

Check that all services are running, particularly the WebSphere Application Server and the ASBAgent. That's where port number 31531 gets involved. Check, too, that the machine name nsads-dev can be resolved to an IP address (using ping is sufficient).