Remove replication properties from an App Object

[omacoder]

We have an off-site system that is entirely replicated from the source system. We do this via replication over federation. All objects at this target site have the replication icon attached to them and also have the SI_REPLICATION_INFO property in CI_AppObjects.

I had to promote one of the universes form the off-site system back to the source system.

Now, this universe, at the source system, shows this replication icon and has the replication info in CI_AppObjects that came along with it in the promotion.

I can no longer replicate this universe from the source system to the target system because it says I cannot replicate a replicated universe.

So, I would like to understand how I can remove the replication info from the universe at the source system, probably having to use SDK, (.NET preferred).

Are there any suggestions?

This is the property that I believe I need to delete on the CUID on the base system.

[former_member203619 · Accepted solution]

Hi Brian,

While I don't have a .NET sample, I have some java code that you can use which should work to remove it. If you take the code below and paste it into a file called test.jsp and put it into the directory

C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\AdminTools

on your BOE server, you can run it by opening a browser and going to "http://myserver:8080/AdminTools/test.jsp"

<%@page import="com.crystaldecisions.sdk.occa.infostore.*" %>
<%@page import="com.crystaldecisions.sdk.occa.security.ILogonTokenMgr" %>
<%@page import="com.crystaldecisions.sdk.framework.CrystalEnterprise" %>
<%@page import="com.crystaldecisions.sdk.framework.IEnterpriseSession" %>
<%@page import="com.crystaldecisions.sdk.properties.*" %>
<%@page import="com.crystaldecisions.sdk.framework.ISessionMgr" %>
<%@page import="java.net.*" %>
 <% //CMS logon information
String cms = "localhost:6400";
String webServer = "localhost";
String userid = "Administrator";
String pwd = "Password1";
String auth = "secEnterprise";

String boObjectID = "7777";
//Log onto the CMS and create a logon token
IEnterpriseSession entSession;
ISessionMgr entSessionMgr = CrystalEnterprise.getSessionMgr();
entSession = entSessionMgr.logon(userid, pwd, cms, "secEnterprise");
IInfoStore infoStore = (IInfoStore) entSession.getService("", "InfoStore");
IInfoObjects infoObjects = infoStore.query("select * from CI_INFOOBJECTS where SI_ID = " + boObjectID);
IInfoObject boInfoObject = (IInfoObject) infoObjects.get(0);
IProperties boProperties = boInfoObject.properties();
boProperties.remove("SI_REPLICATION_INFO");
infoStore.commit(infoObjects);
%>

[omacoder · Accepted solution]

Thank you Shawn for the quick response! I got it to remove that property.
However the icon in Launchpad still shows it as a replicated object. Any suggestions on this part?

[omacoder · Accepted solution]

Nvm, got it! Easy peas.

boProperties.remove("SI_ORIGINATING_CLUSTER_NAME");

boProperties.remove("SI_ORIGINATING_CLUSTER");