cancel
Showing results for 
Search instead for 
Did you mean: 

CPMB/LOAD_INFOPROV_UI - Doesn`t work after Model Transport

former_member182305
Active Participant

Hello Experts.

I am in BPC 10.1 , CPMBPC 810 0009

I had a Model in QAs and I transported it to PRD, I have the exact model in PRD and in QA. To import transactional Data to the model I use a Data manager that has the process chain CPMB/LOAD_INFOPROV_UI - Load Transactional Data From InfroProvider UI.

It work perfectly in DEV. But when I run the Data Manager in PRD it never ends. I even try to import little amoun of data (12 records) but it takes forever and do nothing.

Any ideas what could be happening??'

Accepted Solutions (0)

Answers (4)

Answers (4)

harsha_jalakam
Active Contributor

Hi,

Since the validation has been passed successfully, I hope it isn't a issue with Data Manager or with the Transformation file.
Just check/troubleshoot with the following and check if it helps,
1.Light Compress the cube and check again.

2.Wait until a data manager to be completed and check its stats in UJSTAT and check if any stats can help in debugging further.

3. Take the help of DBA and ask if the indexes/stats are similar to that of QA or not.If not, change the current to the optimized level.

Also is the issue seen only with Load infoprovider package or with all the other packages?

Regards,

Harsha

former_member182305
Active Participant
0 Kudos

Hello Harsha Jalakam,

Thank you very much for the post. The issue on the Source was fixed, now the problem is that the load gets complete after around 14 hours, when in DEV it takes 1 hr. I have a similar cube in PRD where I load the same amount of data and takes also 1 hr. It is just for one model that we have the issue. I'll chec the indexes/ stat with the DBA buc I already Light Compressed the cube, and problem is the same.

Regards.

former_member186338
Active Contributor

Please check your transformation file in PROD etc...

Anyway you have provided very little info to help you...

former_member182305
Active Participant
0 Kudos

Thank you very much for the answer Vadim, I am not sure what information to provide, since it is the exact same thing I have in DEV that I have in PRD. Already check Tranformation and Conversion files they are the same.

former_member186338
Active Contributor
0 Kudos

Try to validate transformation and conversion files in prod

former_member182305
Active Participant
0 Kudos

After your comment I validated the tranformation file and it Seems to be ok.

former_member186338
Active Contributor
0 Kudos

And what about package run after validation?

former_member182305
Active Participant
0 Kudos

It also passed the TEST.

former_member186338
Active Contributor
0 Kudos

Then accept the correct answer and close the question. LoOKs like the issue was in the transformation file validation.

former_member182305
Active Participant
0 Kudos

I selected very small amount of data ot test the Tranformation file. The tranformation file passed but the DM hasn´t. Im going to stop it in Tcode sm37 and run it again with the new Tranformation file.

former_member182305
Active Participant
0 Kudos

It seems that the Tranformation file is just fine, but the Package (process Chain) is not working properly.

former_member182305
Active Participant
0 Kudos

Hello Vadim,

I am checking everything and it seems that the Source InfoProvider has some issues. Bc I checked everything, Tranformation files, CoverFiles, tested in DEV the same scenario, with lots of data, etc. The responsible for the InfoProvider will check it try to load the info to BPC again.

former_member186338
Active Contributor
0 Kudos

Can you test data load on a medium dataset?