cancel
Showing results for 
Search instead for 
Did you mean: 

Light Optimize Error

Former Member
0 Kudos

Hi Experts

Light optimize process chain is failing with below error message we are on BPC10 Version.

Error :!:000 Model Financial Package Status : ERROR

Issue:

Light process chain is failing from last few days, with below error(screen shot attached).  If we re-run thechain it is getting successfully completed with any failure.

even some  time it will complete successfully.

Analysis done:

  1. No huge loads are running during that time
  2. In RZ10/11 rdisp/max_wprun_time : 3600
  3. it is failing at Collapse Step–there was no log at that step

Please need help in this

Many Thanks

Purushottam

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member200327
Active Contributor
0 Kudos

Hi Purushottam,

Do you use BIA?

If you go to that cube in the back-end and select Collapse tab you should be able to see compression logs. They should tell the reason why it failed.

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh

we are not using any BIA.

I had checked at collapse step , there is no log available.

Thanks

former_member200327
Active Contributor
0 Kudos

So, if you click "Apply changes" on that screen does it show anything? Or it says "No logs found ..."?

Former Member
0 Kudos

Hi Gersh

Sorry for Late reply

i am able to see logs but all are sucessful. please find the attached screen shot.

former_member200327
Active Contributor
0 Kudos

This means that it fails before coming to compression. Can you please check log of your Light Optimize Process Chain to see at what step it failed?

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh

Thanks for your response

every time It is failing at collapse step ,please find that attached screen shot.

Many Thanks

gajendra_moond
Contributor
0 Kudos

Hi Purushottam

Do not turn the BPC model to Load Mode (step-3) and try again.

former_member200327
Active Contributor
0 Kudos

Hi Purushottam,

Can you please check if anything is being done in your Roll Up step?

It looks like your LO DM Package is scheduled to run at 2 AM. Can you please check if you have any error messages around that time in SLG1? Or if you have any ST22 dumps around that time?

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh

Thanks for you response

In ST22 i had see Dump with time out. As Light optimize process chain not  running background job, currently it is running as dialog , can we make it as background. ?

or we need to increase RDISP/MAX_WPRUN_TIME   to MAX with help of basis ?

former_member200327
Active Contributor
0 Kudos

No, you can't make LO to run in background. Right now you have 10 min timeout for dialog processes. It seems not enough for amount of data you processing.

You can either ask Basis increasing that limit or check if you can run LO more frequently.

P.S. This can explain why it was completing every other time - 1st attempt was compressing some requests, so 2nd needed less time to compress.

Former Member
0 Kudos

Hi,

Alternatively, you can always create normal BI chain for a cube with all Light Optimization chain steps in it (except load dynamic variant) and call it via /CPMB/TRIGGER_BW_CHAIN. This should execute in background.

Thanks

Best Regards,

Prashant Vankudre

gajendra_moond
Contributor
0 Kudos

Hi Purushottam

Please check the Model/cube mode. Are you executing this process via a process chain or a stand alone DM package? Is there any process chain running prior to this DMP? Does that process chain convert it to "Load mode"?

Former Member
0 Kudos

Hi

Cube mode is in planning mode only , there is no step for changing the mode.

Yes , few package links before this light optimize process chain.

we are NOT execting through process chain , this light optimize was scehdule after completion of all

Process chains.

Thanks