Not able to add datasource in a job

sanygup · Post by **sanygup** » Wed Jan 02, 2013 6:58 am

I am trying to add datasource in "ODBC Connector"

But following error is coming "Failed to send the request to the handler: The agent id <<hostname:31531>> is not available."

I have used netstat -an |grep 3153 and following entries are coming:
tcp 0 0 *.31533 *.* LISTEN
tcp 0.0 *.31538 *.* LISTEN

and no entry for port '31531'.

I have start/stop the DS engine, ASB Node agent and looging agent and no error is coming, all seems ok.

Also I am not to telnet the engine using 31531 port.

Environement I am using :
AIX 6.1, Information server 8.5, Websphere ND 7.0.15, DB 9.7 fix pack 3a.

Separately installed DB2 on separate AIX lpars on active passive cluster mode. WAS is on separate lpar on cluster mode with two nodes. Datastage engine is on same machine as WAS (with service tier).

Please provide the solution of aboe issue.

Thanks in advance.

jerome_rajan · Post by **jerome_rajan** » Thu Jan 03, 2013 1:09 am

Is that a runtime error or is it something you see when you try to view data?

sanygup · Post by **sanygup** » Thu Jan 03, 2013 9:18 am

Hi Rajan,

No not at run time. I am facing this error even on clicking on datasource button (under ODBC connector).

I am not able to locate any service running on port no. 31531 when I run netstat -an command.

I have tried to stop and start nodeagent and engine many times but have not found any success.

sanygup · Post by **sanygup** » Mon Jun 24, 2013 8:54 am

resolved:
Please check if any listener port such as orb_listener port is not having 0 value and also not equal to any other websphere cluster node port.
Assign unique port number and restart the server.

iq_etl · Post by **iq_etl** » Fri Jul 12, 2013 3:16 pm

Just wanted to add some information here in case it's useful to anyone else.

We were getting the same error, and discovered (in our case) that the ASBNode service will refuse to start a listener on TCP port 31531 if you have the following empty config files in place:

/path/to/datastage/ASBNode/conf/https.conf
/path/to/datastage/ASBServer/conf/https.conf

Background: we enabled SSL on our 8.7 server but then reverted to cleartext / non-SSL. When we reverted, we didn't delete the empty https.conf files. And the TCP 31531 listener refused to start again until we did delete them.