Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIACM Adding wrong Table maintenance task in Load Plan

Question
3
Views
0
Comments

Hi,

We are having an issue only in production environment , where BIACM is adding table maintenance task for W_PARTY_ORG_DS in W_PARTY_PER_DS dimension group. This causes the load plan to fail, when the load plan randomly executes these SDE dimension groups in parallel. Can some experts please provide "pointers" where this can be debugged, since BIACM is kind of a black box when it comes to load plan generations. Is there a code or SQL query we can look at which might indicate the reason for discrepancy ? In development environment the Party per dimension group has the correct table maintenance task i.e Initialize: W_PARTY_PED_DS.

ODI version # 11.1.1.9.0

OBIA version # 11.1.1.10.2

pastedImage_1.png

Any help appreciated.

Thanks,

Ashwin