unable to open project - non standard port

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
hsahay
Premium Member
Premium Member
Posts: 175
Joined: Wed Mar 21, 2007 9:35 am

unable to open project - non standard port

Post by hsahay »

Hi

We have a 11.3 installation on Linux and somehow datastage has been installed on port 9445 instead of 9443.

Our sys admin says he just accepted all defaults during installation and yet it got installed at 9445 instead of 9443. Anybody knows why ?

In any case, I can live with that. I have been able to use the clients by using server:port for the server ....

But while running the job using DSJOB, our jobs are failing with the below error -

ERROR: Failed to open project

Last recorded error message =
java.rmi.RemoteException: Connection to https://qxdstage5:9443 refused; nested exception is:
org.apache.http.conn.HttpHostConnectException: Connection to https://qxdstage5:9443 refused


This is how we are calling DSJOB

${DS_JOB} \
-server ${DS_SERVER} \
-user ${DS_USER} \
-password ${DS_PWD} \
-run \
-param INPUT_FILENAME=${input_filename} \
-param INPUT_DIR=${input_dir} \
-param SCHEMA_FILENAME=${schemaFile} \
-param INSERT_STMT="${insert_stmt}" \
-param DATA_DIR=${DATA_DIR} \
-param SCRIPT_DIR=${SCRIPT_DIR} \
-param SQLSVR_USER=${SQLSVR_USER} \
-param SQLSVR_PWD=${SQLSVR_PWD} \
-param SQLSVR_DB=${SQLSVR_DB} \
-mode NORMAL \
-warn 0 \
-wait \
-jobstatus \
-userstatus \
${DSPROJECTNM} \
${DS_JOB_NM}


DS_SERVER is an environment variable defined as QXDSTAGE5.

Even when i change it to QXDSTAGE5:9445, i still get the same error. Why is it still going to 9443 ?

What do i need to do to make this run successfully ?

Here is a list of all our other ports in this installation -

WC_defaulthost=9080
WC_adminhost=9060
WC_defaulthost_secure=9445
WC_adminhost_secure=9043
BOOTSTRAP_ADDRESS=2825
SOAP_CONNECTOR_ADDRESS=8881
SAS_SSL_SERVERAUTH_LISTENER_ADDRESS=9403
CSIV2_SSL_SERVERAUTH_LISTENER_ADDRESS=9404
CSIV2_SSL_MUTUALAUTH_LISTENER_ADDRESS=9405
ORB_LISTENER_ADDRESS=9107
DCS_UNICAST_ADDRESS=9353
SIB_ENDPOINT_ADDRESS=7283
SIB_ENDPOINT_SECURE_ADDRESS=7286
SIB_MQ_ENDPOINT_ADDRESS=5558
SIB_MQ_ENDPOINT_SECURE_ADDRESS=5578
SIP_DEFAULTHOST=5075
SIP_DEFAULTHOST_SECURE=5076
IPC_CONNECTOR_ADDRESS=9633
vishal
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Post by mandyli »

where is coming from 9443?

Here are the default ports;

dsrpc.port=31542
isf.agent.port=31531
logging.agent.port=31533
was.admin.host.port=9060
was.default.host.port=9080
was.secure.admin.host.port=9043
was.secure.default.host.port=9443


Thanks
Man
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The installation program starts with the documented default port number and, if it is not useable, increments by one until it finds a useable port number and uses that. I don't believe that the algorithm used for checking port availability is perfect, but it fails conservatively which means that you always get a genuinely available port number. Several of the sites I have installed recently at version 11.3 have come up with 9445 as the WAS secure host port (the one on which interactive services listen).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hsahay
Premium Member
Premium Member
Posts: 175
Joined: Wed Mar 21, 2007 9:35 am

Post by hsahay »

Thanks Ray ....now what do i have to do for the dsjob -server command to consider the port I am specifying in the environment variable DS_SERVER=qxdstage5:9445 ?

Why does it look for 9443 ?
vishal
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Who says it's looking for port number 9443?

The only time it looks for this port number is during installation, at which time the value is used as an initial value from which to begin searching for an available port number.

Once installation has been completed, the port number on which the services listen is established in the metadata repository and can be retrieved by various means.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hsahay
Premium Member
Premium Member
Posts: 175
Joined: Wed Mar 21, 2007 9:35 am

Post by hsahay »

Ray

I use dsjob -Server command where server - qxdstage5:9445

Do I need to use a different command line when using a server with a port ?

Currently I am getting the below error where despite the 9445 port i specify in my dsjob command it still goes looking for 9443 for some reason.


ERROR: Failed to open project

Last recorded error message =
java.rmi.RemoteException: Connection to https://qxdstage5:9443 refused; nested exception is:
org.apache.http.conn.HttpHostConnectException: Connection to https://qxdstage5:9443 refused
vishal
Post Reply