AnsweredAssumed Answered

Load Datawarehouse job failing in 14.3 patch 5 version

Question asked by Anant_Raj_89 on May 18, 2016
Latest reply on May 20, 2016 by Nika_Hadzhikidi

Hi All,

 

When we are running the load datawarehouse job every time it's getting failed below is the error we are getting in the logs

 

Error occurred while processing domain attributes.

SQL error code: 904

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ZZ_INV_SWD_STRAT": invalid identifier

 

 

Executed:

select zz__inv_inv_rsn, zz_inv_bus_val_cls, zz_inv_dec_unt, zz_inv_exec_stat, zz_inv_grp_stkhlders, zz_inv_prj_typ, zz_inv_rec_bus_unt, zz_inv_sgmnt, zz_inv_steer_cmmt, zz_inv_strat_pll, zz_inv_swd_strat from dwh_inv_investment_ln

Derived from statement:

<?xml version="1.0" encoding="UTF-8"?>

<statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">

  <sql dbVendor="all">

    <text>

          select @select@ from @from@

        </text>

    <param name="select" direction="IN" dynamicReplacement="@select@" expressionListDelimiter=","/>

    <param name="from" direction="IN" dynamicReplacement="

Error 5/13/16 3:10 PM

Data warehouse is not up to date, DWH meta column zz__inv_inv_rsn, zz_inv_bus_val_cls, zz_inv_dec_unt, zz_inv_exec_stat, zz_inv_grp_stkhlders, zz_inv_prj_typ, zz_inv_rec_bus_unt, zz_inv_sgmnt, zz_inv_steer_cmmt, zz_inv_strat_pll, zz_inv_swd_strat is not in DWH table dwh_inv_investment_ln hence quiting from domain updates

 

Note - all the above attributes are custom and linked to the lookups

 

Please assist

Outcomes