Stop Automated/Random Changes To TI Processes (Code Control)

Suggest and discuss enhancements for TM1
Post Reply
User avatar
mce
Community Contributor
Posts: 313
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Stop Automated/Random Changes To TI Processes (Code Control)

Post by mce » Fri Mar 07, 2014 12:47 pm

Hi,

Each time when we save a TI processes, regardless of any changes in the TI process, it keeps changing a line of the .pro file that starts with 565. This line is automatically generated and updated by TI everytime a TI process changes.

Here is an example of this line in a pro file.

Code: Select all

565,"yqxzORL[lI;8LmvyyBwXS^Z3Zapc7;HH8sCEoIAgZ0Qr[emuQZY6_XSlVIe\DBhl=au>DmLHX=LW1jnGS`Z:bDts\P?`3P]d]\Ne_gBk46g\[j5\DwMbz7Rvqk_A`CbK<]TI?9:uZfohGAOaR>7ifdw3q7O2C82n][5eUc@c4pS??2pQ@hNdYQnqQI90WTCFHYrYoKX`"
Here is my question:

Is there a way to stop TM1 updating or changing this line of the pro files in everytime we save the file?

Unfortunately this changing line of the pro files broke my code revision control system.

Regards,
Last edited by mce on Sat Mar 08, 2014 10:56 am, edited 1 time in total.

Wim Gielis
MVP
Posts: 2421
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Automated Changes To Processes

Post by Wim Gielis » Fri Mar 07, 2014 3:21 pm

Hello

Can I ask you why you would need that property? Or put differently, can't you ignore it?
Are you checking the timestamp of the *.PRO file maybe?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

Duncan P
MVP
Posts: 588
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Automated Changes To Processes

Post by Duncan P » Fri Mar 07, 2014 6:48 pm

That's not the only line that can sometimes have random values that are nothing to do with what you have entered in the process.

Unfortunately the only guaranteed way to avoid false changes is to write a program to strip the process down to the bits of it that you use and store that in your SCM system. However getting the list of which line headings correspond to which features is not trivial. It would require hours of very careful experimentation to know that you had got the lot. I vaguely remember that the one you are looking at is a (loosely) encrypted version of the password for the ODBC connection - which you are probably not even using anyway.

The problem is that entries for features that you don't happen to be using (e.g. ODBC entries for a text source) are still filled with random junk, and get saved with new random junk every time you change anything.

User avatar
Alan Kirk
Site Admin
Posts: 6111
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Automated Changes To Processes

Post by Alan Kirk » Fri Mar 07, 2014 7:02 pm

What Duncan said. (And his memory is correct, 565 is the encrypted data source password for ODBC/ODBO, though it was unencrypted in versions prior to 8.3.)

Which leads me to my point; the headings can change from version to version. Not so much that a heading is used in something different in version y compared to version x, but rather that a heading may disappear, or a new heading may appear without any change to the actual TI code. I'd therefore be wary of relying on the .pro files alone for software control. I don't know what you're using or how but you'd probably need to just extract the code from the four tabs to be sure that nothing changes. (And even that wouldn't cover you against parameter or data source changes.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
Harvey
Community Contributor
Posts: 218
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Automated Changes To Processes

Post by Harvey » Fri Mar 07, 2014 11:43 pm

Yes, this "feature" makes it very difficult to detect changes correctly for a revision control system.

I find it very annoying, but it's usually enough for me to just manually roll back the ones I know for sure haven't changed. This would be a lot more difficult in a large project with multiple team members, so it would be nice if it weren't the case.

However, I wouldn't look for the changes to come from IBM. Look for a way to deal with it within your particular revision control system, or by scripting something to avoid the conflict.
Flow OLAP - thinking outside the cube.

User avatar
mce
Community Contributor
Posts: 313
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Automated Changes To Processes

Post by mce » Sat Mar 08, 2014 10:54 am

Thanks for the replies.

I have about 200 processes in a TM1 server and we have a number of TM1 servers instances and each server has about 80% of the processes shared between different instances. Moreover we are working in a team of TM1 developers.
In order to manage and control the changes to the processes and to other code objects and to synchronize the shared ones across different environments, we use a code revision control system (subversion) and file comparison tools (such as winmerge).

However, having TM1 process files automatically and randomly changing in each save makes it very difficult to track changes to the process files. A process file seems to have changed, although it is effectively the same except the line that starts with 565 code, which does not make any difference to the way the process works.

I think IBM should fix this issue to avoid process files keep changing in each and every time regardless of having any ODBC password in the TI process.

Kind regards
Last edited by mce on Sat Mar 08, 2014 11:01 am, edited 1 time in total.

Duncan P
MVP
Posts: 588
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Automated and Random Changes To TI Processes

Post by Duncan P » Sat Mar 08, 2014 11:00 am

Given the general tone does this now make sense in the Enhancements section, just in case an IBM TM1er happens to be passing by?

User avatar
mce
Community Contributor
Posts: 313
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: Automated and Random Changes To TI Processes

Post by mce » Sat Mar 08, 2014 11:06 am

Duncan P wrote:Given the general tone does this now make sense in the Enhancements section, just in case an IBM TM1er happens to be passing by?
Yeah, it would be good if moderators can move this topic to Enhancements category of the Forum, if it is possible.

User avatar
Alan Kirk
Site Admin
Posts: 6111
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Automated and Random Changes To TI Processes

Post by Alan Kirk » Sun Mar 09, 2014 10:02 pm

mce wrote:
Duncan P wrote:Given the general tone does this now make sense in the Enhancements section, just in case an IBM TM1er happens to be passing by?
Yeah, it would be good if moderators can move this topic to Enhancements category of the Forum, if it is possible.
Done; the heading of the thread has been tweaked to show the nature of the enhancement requested.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Post Reply