Rule file mismatch in architect and .rux file
-
- 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
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.
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.
- Elessar
- Community Contributor
- Posts: 355
- 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
Hi,
It can be your temporary *.rux file stored in "C:\Users\<user>\AppData\Roaming\Applix\TM1" folder.
It can be your temporary *.rux file stored in "C:\Users\<user>\AppData\Roaming\Applix\TM1" folder.
- Steve Rowe
- Site Admin
- Posts: 2423
- 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
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....
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
www.infocat.co.uk
-
- 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
Hello Steve,
How to fix this, can i change my blob and rux file
How to fix this, can i change my blob and rux file
-
- MVP
- Posts: 3128
- 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
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.
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
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
-
- 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
But why does this happen, Is it TM1 problem?
-
- MVP
- Posts: 3128
- 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
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) ?
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
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
-
- 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
I generally use architect, could you please suggest how to fix this
- PavoGa
- MVP
- Posts: 618
- 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
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
Cleveland, TN
-
- MVP
- Posts: 2832
- 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
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.
- macsir
- MVP
- Posts: 785
- 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
Thanks, guys. Helps me a lot.