Problem Description:
********************************
Unable to authenticate a user in Group Job and getting the error as unable to validate the connection profile.
It’s a shared profile and it has been validated from Datamaker without any issues. You were able to publish the variable to test data using the same profile.
Diagnosis:
********************************
We ran the below query in Test Data and noticed that the shared profile connection string was shown as "NULL" in the database.
SELECT * FROM gtrep_profile where prof_db_dbms is null or prof_db_dbms=''
Resolution:
********************************
In the "Edit the connection profile" window, we have selected another DBMS and switched back to Oracle. This time saving it and validating again has shows the connection string correctly in the database and it also worked from TDOD.