Rule file mismatch in architect and .rux file

Post Reply
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Rule file mismatch in architect and .rux file

Post by spartan »

Hello,

I have noticed that the rule file in the architect of a cube is different from the .rux file of the same cube. In rux file a or codition was included but in architect it was not displayed.

Could any one help me out.
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Rule file mismatch in architect and .rux file

Post by Elessar »

Hi,

It can be your temporary *.rux file stored in "C:\Users\<user>\AppData\Roaming\Applix\TM1" folder.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Rule file mismatch in architect and .rux file

Post by Steve Rowe »

This is usually because of a mismatch between the .blob which holds the formatting and .rux which holds the rules.
When you look at the rules through the front end you are looking at the .blob, but the DB is using the .rux
This can happen when rules are promoted from live to dev for example, if you only copy the .rux then you get the correct new behaviour on the server but see the old rules in the front end.

Very very confusing....
Technical Director
www.infocat.co.uk
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Re: Rule file mismatch in architect and .rux file

Post by spartan »

Hello Steve,

How to fix this, can i change my blob and rux file
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Rule file mismatch in architect and .rux file

Post by Wim Gielis »

It's not blob but BLB.
Delete the BLB file and restart TM1 (or wait for a good moment to have it restarted).
You might lose formatting of the rules by removing the BLB files though.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Re: Rule file mismatch in architect and .rux file

Post by spartan »

But why does this happen, Is it TM1 problem?
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Rule file mismatch in architect and .rux file

Post by Wim Gielis »

That's not easy to say.

Did you perhaps use different rules editors ? Like Architect / Performance Modeler / PAW (/ the old Advanced Rules editor if that would somehow still work) ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
spartan
Posts: 47
Joined: Thu Jun 21, 2018 8:33 am
OLAP Product: IBM cognos
Version: 10.2.2
Excel Version: 2013

Re: Rule file mismatch in architect and .rux file

Post by spartan »

I generally use architect, could you please suggest how to fix this
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: Rule file mismatch in architect and .rux file

Post by PavoGa »

spartan wrote: Fri Oct 26, 2018 12:02 pm I generally use architect, could you please suggest how to fix this
When you migrate, IF you shutdown the target server, removal all .blb files before restarting. I've never seen that fail.

Or, if using the editor, paste in the correct rule file and save. I want to say that may not work all the time, but it has been so long ago trying it, I do not really recall. We remove the .blb files.

Or try some of the other suggestions as posted.
Ty
Cleveland, TN
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Rule file mismatch in architect and .rux file

Post by tomok »

spartan wrote: Fri Oct 26, 2018 11:41 am But why does this happen, Is it TM1 problem?
The only time I've experienced the issue is because of a mistake made in the migration of objects from one server to another. Let's say you have a cube called MyCube, that has rules. This means there are two files pertaining to the rules: MyCube.rux and MyCube.blb. If you make changes to the rules and migrate those changes to production, but only migrate MyCube.rux, then you'll have a mismatch. The rules actually being executed in production will be whatever is in the MyCube.rux but if you open Architect you'll see what is in the old MyCube.blb file. Simple answer is to always make sure you migrate both the .rux and .blb file.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Rule file mismatch in architect and .rux file

Post by macsir »

Thanks, guys. Helps me a lot. :D
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply