IBM Support

Data transformation job creation failed with error "RestApiResponseUnsuccessful 200"

Troubleshooting


Problem

Creating ETL data transformation job failing with error "RestApiResponseUnsuccessful 200"

Symptom

image 4406

Cause

DS Admin credentials expired and watch for the additional error "Invalid universe credentials found"

Environment

Cloud Pak for Data 2.5
OpenShift 3.11

Diagnosing The Problem

log into conductor pod and  follow the below steps:
 
$ oc rsh is-en-conductor-0
sh-4.2$ cd /opt/IBM/InformationServer/ASBNode/bin
sh-4.2 $ env | grep PASS
(returns passwords for
DSADM_PASSWORD
ISADMIN_PASSWORD
)
./DirectoryCommand.sh -url https://is-servicesdocker:9446 -user isadmin -password <PASS> -list USERS,isadmin -details

Resolving The Problem

Executing the following command will fix the 

$ oc rsh is-en-conductor-0
sh-4.2$ cd /opt/IBM/InformationServer/ASBNode/bin
sh-4.2 $ env | grep PASS

./DirectoryCommand.sh -user isadmin -password <ISADM PASSWORD> -url https://is-servicesdocker:9446 -datastage_server is-en-conductor-0.en-cond -set_default_ds_credentials "dsadm~<DSADM PASSWORD>"
Validated the fix by creating a new ETL job under the data transformation projecte.

Document Location

Worldwide

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSHGYS","label":"IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m0z000000GpDjAAK","label":"Transforming data with ETL"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 June 2020

UID

ibm16235678