IBM Support

DataStage DSXImportService.sh NO Permission error

Troubleshooting


Problem

Problems executing DSXImportService to import. The engine and domain (WAS) tiers are on separate servers and appropriate IS and DS Hosts are specified. /IBM/InformationServer/ASBNode/bin/DSXImportService.sh -ISHost < ip address> -ISUser -ISPassword -DSHOST -DSProject -DSXFile /etl/myproject_IDS1.dsx -Overwrite -Verbose 12:19:18.756 com.ibm.CORBA.iiop.ClientDelegate@1a7a1a7a invoke:824 P=343673:O=0:CT ORBRas[default] Received SystemException org.omg.CORBA. NO_PERMISSION: SERVER (id=1234567, host=hostname) TRACE START: org.omg.CORBA.NO_PERMISSION: java.rmi.AccessException: ; nested exception is: com.ibm.websphere.csi.CSIAccessException: SECJ0053E: Authorization failed for ??? while invoking (Home)ACS_server. ear#ACS_server.jar#SessionService create::2 JACC Authorization failed for bean: SessionService vmcid: 0x0 minor code: 0 completed: No

Cause

The key difference is the use  of the real hostnames instead of IP addresses
 
The command has to connect to the services tier and authenticate and then look up credentials for the Engine tier connection - this lookup requires the engine tier registered node name and will not work with an alias or IP address.
 
So, it is possible to use IP addresses for the -ISHost argument but not for the -DSHost argument.

Resolving The Problem

Specify the hostnames in the command
DSXImportService.sh -ISHost IShostname:9080 -ISUser isuser -ISPassword xxxxxx -DSHOST dshostname:31585 -DSProject RESTORE_PROJ -DSXFile /etl/myproject_IDS1.dsx -Overwrite -Verbose

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21622909