Erased BPC Cube from BW, still apears in BPC Admin

[former_member182305]

Hello Experts,

I am having Time out Problems in BPC.When I create and Dimension or an Environment, or I do a change, I am getting Error 500. The issue is that this Time out error seems that is creating versions of the model in BW.

I erased the modesl directly from BW, but when I go to the BPC Admin they seem like they still existe. I went also to TCode UJFS and I see that the components from the deleted model still exist.

When I go to the Admin and I try to delet again the model I get a Time Out error. I also tried the program UJA_REFRESH_DIM_CACHE. Didn't updated the Admin and still see the model.

How do I delete it or how do I fix this error??

Best Regards.

[former_member186338 · Accepted solution]

"I erased the modesl directly from BW" - absolutely bad idea! The model references are located in a lot of BPC tables! You have a corrupted system...

[former_member182305 · Accepted solution]

Do I need to reinstall BPC? or Creating another environment will be enough?

Regards.

[former_member186338 · Accepted solution]

I am not an expert in recovering from disaster like this For safety I will prefer to reinstall BPC!

[former_member200327 · Accepted solution]

I doubt that just re-installing BPC will help.

Can you try removing this Environment?

If this doesn't work can you restore system from backup taken before you deleted cubes?

[former_member186338 · Accepted solution]

By reinstall I mean complete reinstall Or full server restore from backup.

[former_member182305 · Accepted solution]

HI Gersh,

I haven't try to erase the Environment because I have there Dimensions, Templates, Etc. I created a New environment (Copied from the environmentShell) There I created a New model (copied from plannint) and Im copy - Pasting all the previous job, that is why I haven't try to erase the model.

I am also having the same problem, when modifying the Model with the new dimensions, A TimeOut Error came, no changs are saved but in BW I see another version of the model.

What seems to be the problem?

I do that again with the Fiddle opened but the only thing I see is the 500 Time out error:

Any ideas what the problem could be? I also checked Tcode SM50, the process for CL_SERVER_INFO================CP is in execution.

In Tcode ST22 no error apears.

But in BW everytime I tried to save the changes made a New model appears.

Any Ideas.

Regars Gurus.

[former_member186338 · Accepted solution]

Hi Sebastian,

You environment is corrupted. And the whole BPC system may be also corrupted to some extend...

You may get any possible errors in future.

If you have a complete server backup without issues - restore it. If not - reinstall BPC server completely and recreate dimensions and models (from some text files...).

Vadim

[former_member182305 · Accepted solution]

Hello Vadim,

I will ask the basis team to do that, I have one last question. BPC is installed in the same server as BW. So it will be enogh to reinstall BPC, or do you recomento to reinstall everything??

Regards.

[former_member186338 · Accepted solution]

Including BW!

[manohar_pappireddy · Accepted solution]

Hi,

Check this thread once.May be helpful for you.

creating bpc cubes multiple times instead of ov... | SCN

Regards,

Manohar

[lucas_costa3]

Hi Sebastien,

You don't need to reinstall the whole bpc. What you need is to clean the "dirt" entries from the bpc tables.

If you're not going to use the environment (appset) anymore, just run the following programs:

- UJS_ACTIVATE_CONTENT (Clean the environment flag on)

- UJAA_CLEAN_DELETED_APPSET

Now, if you wish to clear the entries only from the model you deleted manually, you would need to create an abap code enhancing the logic within class CL_UJAA_CLEAN_DELETED_APPSET, method: REMOVE_APPLICATIONS

This method performs a series of tasks to clean the model like deleting BI stuff, app folders, app parameters and whole series of BPC table entries .

Cheers,

[former_member182305]

Thank you Very much for the post Lucas.

I want to share what happened in this case. I checked with the Basis team, we run some tests and the issue was that a parameter for response was very short. It was 60 sec, insted of 60 sec, he moved it to 600.

Then doing another test we notice the next:

When you make a change in a model in BPC and you enter to the TCODE rsa1 during the proces you will see 2 CUBES in BW. It seems like another Version of the cube is created and when the process is finished the old version is erased or replace or some similar action.

The problem here was that the proces didn't finish, a TIME OUT error came and the version didn't get erased or replace.

When the Basis increase the time in the parameter, we didn't get the error no more.

Anyway to prevent errors I create another environment based on the ENVIRONMENTSHELL and make everything again.

I want to thank you all for your posts

Regards GURUS.

[former_member186338]

rdisp/max_wprun_time?

[damovand]

Hi,

Thank you for sharing this information.  I am sure this will help other BPC users.  Thank you again.

Best Regards,

Leila