Clarity PPM

Expand all | Collapse all

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

  • 1.  Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 02:20 AM

    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



  • 2.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 03:55 AM

    Hi Asha,

     

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

     

    Regards

    Suman Pramanik 



  • 3.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 06:06 AM
      |   view attached

    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



  • 4.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 06:10 AM

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



  • 5.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 08:32 AM
      |   view attached

    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



  • 6.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 08:54 AM

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



  • 7.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-05-2018 04:13 AM
      |   view attached

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



  • 8.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-05-2018 04:16 AM

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

     

    Regards
    Suman Pramanik



  • 9.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-08-2018 01:44 AM
      |   view attached

    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



  • 10.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-08-2018 02:10 AM

    Hi Asha,

     

    Sure, I will take a look.

     

    Regards
    Suman Pramanik 



  • 11.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-08-2018 05:15 AM
      |   view attached

    HI Suman,

     

    Any update on this?

     

     

    Thanks,

    S.Asha Chandran



  • 12.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 06:37 AM

    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.



  • 13.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 08:46 AM
      |   view attached

    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



  • 14.  Re: Load Data Warehouse Access Rights job and  Load Data Warehouse - Full Load job failed

    Posted 01-04-2018 09:23 AM

    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.