Load Data Warehouse Access Rights job and Load Data Warehouse - Full Load job failed

[Asha.41]

hi,

 

The  Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load is getting failed and we get the below error. We have checked the database connections but everything looks fine. Recently we have changed the password and updated in NSA. please share your thoughts.

 

dwh_sec_load_master - org.pentaho.di.core.exception.KettleDatabaseException:  Error occured while trying to connect to the database  Error connecting to database: (using class com.ca.clarity.jdbc.oracle.OracleDriver) [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied         at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)      at org.pentaho.di.core.database.Database.connect(Database.java:353)      at org.pentaho.di.core.database.Database.connect(Database.java:306)      at org.pentaho.di.core.database.Database.connect(Database.java:294)      at org.pentaho.di.job.Job.beginProcessing(Job.java:966)      at org.pentaho.di.job.Job.execute(Job.java:474)      at org.pentaho.di.job.Job.run(Job.java:407) Caused by: org.pentaho.di.core.exception.KettleDatabaseException:  Error connecting to database: (using class com.ca.clarity.jdbc.oracle.OracleDriver) [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied        at org.pentaho.di.core.database.Da

Thanks,

asha

[Suman Pramanik]

Hi Asha,

 

Did you check in CSA if the connection to DWH is showing available and DB link is working?

 

Regards

Suman Pramanik 

[Asha.41]

HI Suman,

 

We checked CSA and the database is available.

 

Still we are getting the same error. Should we update the password anywhere else other than CSA?

 

 

Thanks,

S.Asha Chandran

[Suman Pramanik]

Once you update the password, you need to restart all the services and then check the CSA again 

[Asha.41]

Yes. we have updated with new password and restarted all the services and tried running the job but it still fails.

 

 

Thanks,

S.Asha Chandran

[Suman Pramanik]

After the restart of services you are able to see the DWH connection available. Did you check the DB link?

[Asha.41]

Db link has no issues, we restarted the services also but still no luck

[Suman Pramanik]

What was the output you got when you executed the DB LINK query

 

Regards
Suman Pramanik

[Asha.41]

Hi Suman,

 

We didn’t receive any error while executing DB link query.

 

We have raised a ticket 00926724 with CA but we didn’t get any response Could you please assign the request to AP?

 

 

Thanks,

S.Asha Chandran

[Suman Pramanik]

Hi Asha,

 

Sure, I will take a look.

 

Regards
Suman Pramanik 

[Asha.41]

HI Suman,

 

Any update on this?

 

 

Thanks,

S.Asha Chandran

[Arunprasath Ramachandran]

Did you updated the Transaction DB Password as well in the  NSA.

Could you please check the Database link is updated  in DWH DB and check if you are able to query using the DB Link.

[Asha.41]

HI Arun,

 

I have updated the database password in connection details in NSA other than that should we update the password anywhere?

 

Thanks,

S.Asha Chandran

[Arunprasath Ramachandran]

Can you run the below query  in the DWH  Schema to confirm there is no issues with the DB Links,

 

SELECT count(1) FROM CMN_SEC_USERS@<DBLINKNAME>

 

<DBLINKNAME> - Configured in the CA PPM System Administration Side[NSA] in Data Warehouse  connection.