If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Replication Issue

Started by kanwar, 01 Oct 2011 02:05:42 PM

Previous topic - Next topic

kanwar

Hi All,

Before I begin explaining the problem, let me tell you the basic TM1 setup that I have:

A TM1 production server T1 that has cubes with rules associated with them.

Another TM1 server T_sync that is a copy of T1 but without any rules, only the cubes, so it won't  have any rule calculated values in it. This server has a replication connection with T1 and synchronizes data frequently with it. The other TM1 regional servers get synchronized using this T_sync TM1 server(They have a replication connection with T-sync)

Now this is what I'm trying to do:

* I've created a TM1 server T2 that is an exact copy of T1 (with all the cubes and associated rules) and would act as a backup server. This server needs to be in sync with T1.   

Now, to keep it in sync with T1, I'm only allowed to create a replication with T-sync server and not with T1, so I did that, created a replication connection with T_sync. The problem that I'm facing here is:

whenever I right click on the T_sync replication icon in T2 and select synchronize data, nothing gets synchronized. This is what I get in the log file:

20111001182338 [admin_pwd] => Synchronization to "T_sync" started.

20111001182338 [admin_pwd] => Current R&S values: LastSyncTime=20111001182209 LastSyncTimeMaster=20111001182210 LastSyncStarRecord=20111001180002.

20111001182338 [admin_pwd] => Start: Replication of objects not yet copied.

20111001182338 [admin_pwd] => End: Replication of objects not yet copied.

20111001182339 [admin_pwd] => Synchronization to "T_sync" completed. LastSyncTime=20111001182209 LastSyncTimeMaster=20111001182340 LastSyncStarRecord=20111001180002.

* So I figured out that I need to double click on the replication connection and replicate the individulal cubes first before synchronization can begin.
Now the problem that I face here is that replicating the cube deletes the rule file associated with that cube (remember I mentioned T_sync has all the rules removed). I want the rule files to stay, and still be able to synchronize data with T_sync.


What possible solutions do I have to achieve this functionality?

Thanks in advance,
Kanwar