AnsweredAssumed Answered

Data Warehouse Job Fails

Question asked by shiva.s43 on May 4, 2017
Latest reply on May 8, 2017 by shiva.s43

Hi,

 

I have just upgraded to V15.2 and trying to set up the data warehouse. I have set up the datawarehouse db details in CSA. Created Link between Clarity and DWH database. Now when I run the Load datawarehouse job for the first time I getting below error.

 

dwh_sec_load_master - A serious error occurred during job execution:
Unable to begin processing by logging start in logtable DWH_CFG_LOG

 

Couldn't execute SQL: DELETE FROM DWH_CFG_LOG WHERE ID_JOB= -1

 

[CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'DWH_CFG_LOG'.

 

dwh_sec_load_master - org.pentaho.di.core.exception.KettleJobException:
Unable to begin processing by logging start in logtable DWH_CFG_LOG

 

Couldn't execute SQL: DELETE FROM DWH_CFG_LOG WHERE ID_JOB= -1

 

[CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'DWH_CFG_LOG'.
    at org.pentaho.di.job.Job.beginProcessing(Job.java:1044)
    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:
Couldn't execute SQL: DELETE FROM DWH_CFG_LOG WHERE ID_JOB= -1

 

[CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'DWH_CFG_LOG'.

 

    at org.pentaho.di.core.database.Database.execStatement(Database.java:1432)
    at org.pentaho.di.core.database.Database.execStatement(Database.java:1380)
    at org.pentaho.di.core.database.BaseDatabaseMeta.getNextBatchIdUsingLockTables(BaseDatabaseMeta.java:1980)
    at org.pentaho.di.core.database.BaseDatabaseMeta.getNextBatchId(BaseDatabaseMeta.java:200

 

 

Please help in resolving this issue and run the datawarehouse job successfully.

 

Thanks,

Shiva

Attachments

Outcomes