InfoObject /CPMB/XXXXXXX cannot be deleted because of references

[Former Member]

Hi,

When I try to restore Quality Backup in Dev system using UJBR, I am getting below error

InfoObject  "/CPMB/XXXXXXX" cannot be deleted because of references

I have BW info object which is having reference as "/CPMB/XXXXXXX". So, deletion of environment is getting failed bcos of this reference to the BW info object. We tried deactivating the BW info object and tried restoring, but, its throwing the same error.

We can neither delete BW info object nor delete the reference for BW info object, as it is being used by info cubes and queries.

Do we have any alternative for this?

[Former Member]

Hi Rajendra,

Out of curiosity, may I ask why did you end up in the path of using BPC generated Infoobjects to build something in BW?

What are the issues did face upon using BPC generated Infoobjects other than the one u have posted?

In the long run how is it meeting business requriements?

Thanks,

Arun

[Former Member]

Hi Rajendra,

Is it a very bad practice to use BPC objects in your BW system like what is happening in your system.

if you want to sync QA and DEV, bad news for you is you need to remove all those objects inside your BW system before you can delete BPC environment. then restore BPC.

you need to create new infoobjects and not using BPC's definitions.

Andy

[Former Member]

Hi Andy,

Thanks for the confirmation. I will figure out whether it is feasible to delete reference in Dev systems info object to delete complete environment in Dev system.

Hi Gersh,

As you said that QA environment can be restored in Dev with a New Name, will that solve my issue? For example, currently APPLE is the environment existing in both QA and Dev. While restoring, I am trying to delete APPLE in Dev, which is throwing error, bcos ACCT dimension is used as a reference for my BW info object and ACCT dimension is not getting deleted. As per your statement, I should restore environment in Dev with APPLE2, which will definitely throw the same error. Because, the same technical name existing in Dev, which can not be replaced with QA's ACCT dimension technical name, unless ACCT dimension technical name in Dev is completely removed. Am I making sense?

Please provide me your input. If this doesn't work, I should take help of BASIS team to copy the QA image in Dev.

[Former Member]

Hi Rajendra,

If you restore into a different name then are you going to transport the new one into QA?!

I would assume you want to sync the 2 system, so you would want to be working in one environment and then start using transports for any new developments.

what is your main reason to restore QA into DEV with the same technical name?

Andy

[former_member200327]

Fortunately you are mistaken. When you restore APPLE as APPLE2 all Dimensions will have different BW technical names.

Now you have issue with deletion; if you restore with different Env name you don't have to delete the old Env.

Problem you are going to face is whatever BW object you built with that object will stop working because they'll refer to the old Environment.

Hope this make sense for you.

[Former Member]

Thanks Andy & Gersh for your inputs.

It seems, I have only two options now.

1) Delete reference "/CPMB/XXXXXXX" for the BW info object ZB_ACCT, so, I can delete APPLE from Dev completely. Restoring will be successful.

2) Ask BASIS team to copy QA image in Dev, which takes time, but, it works. It worked last time also.

Please conclude this.

[former_member200327]

It looks like you are trying to replace your Dev systems Environment with QA system Environment - this is never a good idea. Your transports will be all messed up.

If you just need QA environment in Dev simple restore it with a new name.