Skip to Content
0

Issue with Promotion Management Tool when migrating webi and Xcelcious Dashboard

Dec 17, 2016 at 05:54 AM

1.1k

avatar image
Former Member

Hi,

We are using BI Platform 4.2 SP3 .

We are trying to promote one webi report created on top of Bex(OLAP Connection) and One Xcelcious Dashboard 4.2(with 4 BI web service connection) from our DEV server to the Quality server using promotion management tool from CMC. In First instance Job went successful however server path was still pointing to Dev server so I rollback completely that instance and again when I promote the job then it finishes with partial success along with error as:-For Folder-> " Resolution Status=Copied, Dependency Status=All the required dependencies are included., Commit Status=Commit attempted and failed., Promotion Status=Failure : The property SI_CUID of info object with id number 7587 is not unique. Table = 'CMS_InfoObjects7'. Column = 'SI_CUID'. The server supplied the following details: The property of an object is not unique." For Dasboard,Webi and OLAP connection error as:-" Resolution Status=Copied, Dependency Status=Some of the required dependencies are not selected., Commit Status=Commit attempted and failed., Promotion Status=Failure : Must create object under it's defined root folder." While all four BI web service connection went partial success with warning as :-" Resolution Status=Copied, Dependency Status=Some of the required dependencies are not selected., Promotion Status=No errors detected."

I checked there are no duplicate folders or reports are there in Destination server. Missed to mention that prior to Promotion I had promoted the override settings for BI web service and OLAP connection and made them active with server credential changed to Quality.

Please help me what could be the steps to make the job success.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

avatar image
Former Member Oct 26, 2017 at 05:31 PM
5

I had the same issue and a very similar experience with promotion management/rolling back. I found that the SI_CUID and SI_GUID of the failing object was associated with an "orphaned" OBJECTID. I determined the CUID by logging into the source and using the properties. On the failing target I logged directly into the database and issued the query:

SQL> select OBJECTID, SI_CUID, SI_GUID from CMS_INFOOBJECTS7 where SI_CUID='<CUID You Found from Source>';
Verified it was not associated with anything and then proceeded to delete.

SQL> delete from CMS_INFOOBJECTS7 where OBJECTID=<ID from the above query> (Run this on the target database where failures occured)

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 20, 2017 at 04:25 PM
1

Empty recycle bin in CMC and try the migration.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

This helped.. Thanks!

0
Kuldeep Ghosh Dec 19, 2016 at 03:37 PM
0

Are you also trying to promote the objects along with security?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 23, 2016 at 04:12 PM
0

No I want to simply promote without any security

Share
10 |10000 characters needed characters left characters exceeded
Nitin Kumar May 30, 2017 at 05:31 PM
0

Did you get the solution, i am also facing the same issue

Share
10 |10000 characters needed characters left characters exceeded