Load Datawarehouse job failing in 14.3 patch 5 version

[Anon Anon]

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

[Nika Hadzhikidi]

Hi Anant,

 

Looks like one of your custom attributes is causing an issue.

Please can you do the following:
1. Connect to PPM UI - Objects - Investment - Attributes.
2. Uncheck the attribute ZZ_INV_SWD_STRAT from being enabled for Data Warehouse
3. Save
4. Run Load Data Warehouse job with Full Load

 

This should help, please let me know how it goes.

 

Thanks -Nika

[Anon Anon]

Thanks

 

I tried by unchecking the include in data warehouse for those custom attributes, it worked.

 

My Issue why this is happening with investment object, when i create a custom attribute in that and run datawarehouse job, it fails.

[Nika Hadzhikidi]

Anant,

If you try checking this one back, and running Data Warehouse job with Full Load, does it work? Don't check them all at once as if you have too many, you may be hitting a known issue with character limits.

If adding one works, try adding the rest, run a Full Load and see if you have any errors in bg-dwh.log, if yes, share them here. Thanks -Nika

[Anon Anon]

Hi Nika,

There are no error in bg-dwh.log file, the error which i am getting is in bg-ca.log file

 

below shown is the error

 

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

[Anon Anon]

Hi Nika,

The issue whenever i try to create a  custom attribute in investment object and try to run load datawarehouse job it fails, however we have one DEV environment where this is working absolutely fine.

[Nika Hadzhikidi]

Hi Anant,

 

Thanks for your update.
It looks like your issue is not directly with Load Data Warehouse job, but with the part where it tries updating the domain attributes.
Please try running the command:

 

admin content-jaspersoft csk restoreDomains -userName superuser -password superuser

 

This should updates all the OOTB domains to restore them to default and will also run the dynamic domain updates to add all the custom attributes. See if this command works and let me know.

 

Hope this helps -Nika