This may be a bit abstract, but here goes:
Basically, I have a master TI that launches a bunch of other TI's in a certain order. When doing this on my development environment, all is well and the full set of TI's finish in 5 minutes. An exact copy of this TM1 server, migrated to my test environment, ends up cutting the string of TI's at some point and restarts. This behaviour is repeated for hours if I let it run. The TM1 servers are an exact copy of each other, their behaviour is just different when ran on different servers. The problem occurs when running the TI's, which extract data from several cubes and summarize them in one reporting cube, but only for the production plant is continues to loop for a long time (it has never finished successfully so far). The server on which it fails is more powerful though, so it seems unlikely that it would play a role.
Has anyone ever experienced such behaviour? All I could find was one thread from a couple of years ago, but there was no real conclusion as to what may be the issue.
TI restarts at some point
-
- Posts: 17
- Joined: Tue May 24, 2011 4:39 pm
- OLAP Product: Cognos TM1
- Version: 9.x + 10.x
- Excel Version: 2003+2007
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TI restarts at some point
Are you sure that there aren't any other processes running on the production server which could cause locking contention and therefore a rollback?Nick_Blommaerts wrote:This may be a bit abstract, but here goes:
Basically, I have a master TI that launches a bunch of other TI's in a certain order. When doing this on my development environment, all is well and the full set of TI's finish in 5 minutes. An exact copy of this TM1 server, migrated to my test environment, ends up cutting the string of TI's at some point and restarts. This behaviour is repeated for hours if I let it run. The TM1 servers are an exact copy of each other, their behaviour is just different when ran on different servers. The problem occurs when running the TI's, which extract data from several cubes and summarize them in one reporting cube, but only for the production plant is continues to loop for a long time (it has never finished successfully so far). The server on which it fails is more powerful though, so it seems unlikely that it would play a role.
Has anyone ever experienced such behaviour? All I could find was one thread from a couple of years ago, but there was no real conclusion as to what may be the issue.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 17
- Joined: Tue May 24, 2011 4:39 pm
- OLAP Product: Cognos TM1
- Version: 9.x + 10.x
- Excel Version: 2003+2007
Re: TI restarts at some point
I'm sure that this was not the case. I've been looking for this issue since Friday, obviously as soon as I post for help here it appears I have found the issue.Alan Kirk wrote:Are you sure that there aren't any other processes running on the production server which could cause locking contention and therefore a rollback?Nick_Blommaerts wrote:This may be a bit abstract, but here goes:
Basically, I have a master TI that launches a bunch of other TI's in a certain order. When doing this on my development environment, all is well and the full set of TI's finish in 5 minutes. An exact copy of this TM1 server, migrated to my test environment, ends up cutting the string of TI's at some point and restarts. This behaviour is repeated for hours if I let it run. The TM1 servers are an exact copy of each other, their behaviour is just different when ran on different servers. The problem occurs when running the TI's, which extract data from several cubes and summarize them in one reporting cube, but only for the production plant is continues to loop for a long time (it has never finished successfully so far). The server on which it fails is more powerful though, so it seems unlikely that it would play a role.
Has anyone ever experienced such behaviour? All I could find was one thread from a couple of years ago, but there was no real conclusion as to what may be the issue.
On my server for this country, it appears someone has added the following at some point to the config file, which I completely overlooked:
PerformanceMonitorOn=T
After removal, the loops are gone. I've tried to put it back and the loops are back again as well. What I find strange is that on one server it doesn't give issues, on the other it does, even though the specs of the servers are largely the same (see attachment).
- Attachments
-
- servercomparison.png (19.14 KiB) Viewed 3344 times
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: TI restarts at some point
If the removal of
PerformanceMonitorOn=T
fixed your issue, you might want to check whether the cube logging for the }stats cubes is turned on and turn it off. Not sure if the logging of those might actually have caused your problem but it is still recommendable to do turn it off just in case you want to use Performance Monitor.
PerformanceMonitorOn=T
fixed your issue, you might want to check whether the cube logging for the }stats cubes is turned on and turn it off. Not sure if the logging of those might actually have caused your problem but it is still recommendable to do turn it off just in case you want to use Performance Monitor.