unable to open project - non standard port
Posted: Fri Jul 31, 2015 1:54 pm
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
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