AnsweredAssumed Answered

Load Data warehouse fails

Question asked by Sreeram601 on May 20, 2016
Latest reply on Jun 8, 2016 by johsa07

Hi,

 

While running the Load Data warehosue job, we faced with the following error(please see the screenshot)

 

I've enabled the custom object and all the custom attributes (both custom object and Pre-defined object)

 

When I ran first time, I got the first error(dwh_error)and second time, I got different error(dwh_error1).

 

While running the query "select * from DWH_meta_columns where DWH_Coulmn = 'Custom_attribute_Key'", I've two rows which are similar only with the differences in the following fields and their values

 

1. ATTRIBUTE_DATA_TYPE

  - NUMBER(30)

  - NUMBER(32)

2. ATTRIBUTE_CODE

  - DWH_PK

  - Custom_table_ID

3. Extended Type

  - Null

  - Lookup

 

So will this be the cause for the first error "Couldn't execute SQL: ALTER TABLE DWH_ODF_WM_BUDGET_LINE ADD WM_BUDGET_LINE_KEY NUMBER(32)

 

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01430: column being added already exists in table"

 

Also for the second error - Merge, how do I solve it?

 

Please advise ASAP

 

Could you please help?

 

FYI, we've set the DWH schema with the same database as Clarity schema. DB link has been created. Timeslicing has been run before Load DWH.

 

Thanks

 

Sreeram

Attachments

Outcomes