Master Data package fail monthly without good error

[Former Member]

Hello Experts,

We have been experiencing a monthly issue that seems to occur sporadically each month at random days of the month.  We have a scheduled Master Data package that runs at midnight every night.  There are times of the month where the package will fail with the following error 'Error in Admin module or a component used by Admin module'  This error does not really tell us anything.  Then when we run the package again a couple of hours later without making any changes, it runs successfully.

Thanks,

Robert

[Former Member]

Hi Robert,

Possibly this type issue came when the dimension are not process after add or removed member.You can run the program UJA_REFRESH_DIM_CACHE through SE38 hope this will solve your problem.

Khokan

[Former Member]

Hello Khokan,

We have done this before.  How would this fix our problem?  Would we need to schedule a refresh between the ERP to BW load and the BW to BPC load?  I am not sure how we would do this.

Also, the problem will happen on the midnight BW to BPC load and fail.  Then we will just kick off the same package again at 7am without making any changes and it will run successfully.  This is why this issue is so frustrating because there does not seem to be any consistency when it fails without any description.

Thanks,

Robert

[former_member193143]

Hello Robert Bryan,

Did you automate process of data loading..?

if yes are you using single process chain for both processes( I mean from ERP-BW and then BW-BPC) or seperate process chains..?

Thank you very much..

Saida Reddy Gogireddy

[Former Member]

Hello Saida,

Yes, we have both of the processes automated.  The ERP-BW load happens at 10pm and then the scheduled BW-BPC starts at midnight (12am).

Thanks,

Robert

[former_member193143]

Hello Bryan,

I completely agree with Andy, The loading process from ERP to BW is not finished and the load is initiated from BW to BPC that why you are getting such kind of error.

In order to avoid this kind of inconsistency create a meta chain, interlink those 2 two process chain.

so the moment when the load is completed from ERP to BW then its automatically triggers BW to BPC load. if the load fails from ERP to BW, load will not trigger from BW to BPC.

I don't know the reason why you people schedule those process chains separately..is there any reason for that ..?

Thank you very much ..

Saida Reddy Gogireddy

[Former Member]

Hi Robert,

Do you have master data update from ECC to BW every night as well?

make sure the load into BPC is after ECC to BW load.

You can also check in the BPC logs and ST22 in BW to see if there is anything funny.

Andy

[Former Member]

Hi Andy,

Yes, we have ECC to BW multiple times a day during our month end close process but it is always run nightly at 10 pm before the midnight BW to BPC load.

We have also looked at the ST22 logs and not seen anything out of the normal when these packages fail.  The other thing is that we kick it off again a couple hours later and it runs successfully.  No changes are done between the failure and then the successful run.

Thanks,

Robert

[Former Member]

Hi Robert,

Try wait longer between the BW load and BPC load.

try increase the by an hour or 2 and see if that fixes the problem.

It might be that BW load job is not finished while BPC load kicks off.

Andy