TM1 replication issue

[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

[Steve Vincent]

to set up replication it must in effect delete the destination cube and recreate it. there is no way around that.

all you need to do set the replication up and on each cube untick "copy rules". once set up for T1 to T-sync, do the same for t-sync to T2. Then run replication once then manually copy the rules from T1 to T2. the next time it replicates it shouldn't touch the rules, leaving the models intact.