Service starts and stops

Post Reply
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Service starts and stops

Post by Martin Ryan »

I've just installed 9.4 on a 64 bit machine for testing purposes. When I start the service I get a message telling me the service started then stopped. I checked in the logs and found this in the tm1server.log
tm1server.log wrote: 5304 INFO 2008-10-30 11:10:20,186 TM1.Server Data Directory: c:\tm1data64bit\data
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Admin Host: tm1host
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Logging Directory: c:\tm1data64bit\logs
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Configuration Directory: c:\tm1data64bit
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Port: 14719
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Client Message Port: 0
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Export Admin Server Certificate: 0
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Admin Server Certificate Authority: C:\Program Files\Cognos\TM1\bin\ssl\applixca.pem
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Admin Server SSL Cert ID: tm1adminserver
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Admin Server SSL Cert ID: tm1adminserverSSL Mode:
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Export Server Certificate:
5304 INFO 2008-10-30 11:10:20,186 TM1.Server SSL Certificate: C:\Program Files\Cognos\TM1\bin\ssl\tm1svrcert.pem
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Certificate Authority: applixca.pem
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Client Export Server Certificate:
5304 INFO 2008-10-30 11:10:20,186 TM1.Server DH 512 File: C:\Program Files\Cognos\TM1\bin\ssl\dh512.pem
5304 INFO 2008-10-30 11:10:20,186 TM1.Server DH 1024 File: C:\Program Files\Cognos\TM1\bin\ssl\dh1024.pem
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Private Key Password File: C:\Program Files\Cognos\TM1\bin\ssl\tm1cipher.dat
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Password Key File: C:\Program Files\Cognos\TM1\bin\ssl\tm1key.dat
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Security Mode:
5304 INFO 2008-10-30 11:10:20,186 TM1.Server Start time: Thu Oct 30 2008 11:10:20 AM
5304 ERROR 2008-10-30 11:10:20,186 TM1.Server Failure initializing Performance Monitor: 80070002
I've set PerformanceMonitorOn=F in the .cfg file put I still get the same error.

The data is from an existing 8.4.5 model so it's got to upgrade to unicode, but I'd have thought that should be straightforward?

Running the shipped-with Planning Sample is ok, so I guess it must be something to do with my cfg file or data set. But my cfg file is virtually the same as the working Planning Sample.

My cfg file:
tm1s.cfg wrote: [TM1S]
ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
UseSSL=T
ServerName=running64bitInstall
DataBaseDirectory="C:\TM1Data64Bit\Data"
LoggingDirectory="C:\TM1Data64Bit\Logs"
AdminHost=TM1
PortNumber=14719
ClientMessagePortNumber=12346
Language=ENG
SaveTime=
DownTime=
ProgressMessage=True
AllowSeparateNandCRules=T
ClientVersionMinium=844
PerformanceMonitorOn=F
TIA,
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Andy Key
MVP
Posts: 351
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Service starts and stops

Post by Andy Key »

There is a known bug with upgrading dimensions that were created in versions 6 and 7, but it doesn't look as if your system is getting that far.

Do you get the same messages if you start the system as an application?

(The bug is reported as fixed in 9.4 MR1 - which should be released towards the end of November.)
Andy Key
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Service starts and stops

Post by Steve Vincent »

<swears at yet again completely useless TM1 "guides">
There is no syntax guide to the use of PerformanceMonitorOn in the 9.4 guides. I think it was F or T but can't be sure. How about removing all the } cubes and then starting the server to see if the flag is being kept by the model somewhere? If that starts, you should then be able to move the necessary } entries (security, attributes etc) in afterwards.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Service starts and stops

Post by Martin Ryan »

Somethings don't change, even with a new vendor!

The error message was misleading, it's nothing to do with Performance Monitor, it was the licence file. I copied the licence file from the Planning Manager DB and away it went.

It's still crashing during startup though. Will isolate that problem now, seems not to like some of my feeders.

As a side note, it's interesting that the licence ships with the install now.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Service starts and stops

Post by stephen waters »

As a side note, it's interesting that the licence ships with the install now.

Martin

And this also means that if you go through default install the planning sample db will start and run automatically as a service!

In the past, the sample database would be set up to run automatically as a service but fail to start due to the lack of a license key. This changed when they started to included a license key in the install (Feb 2008?).

By the way, just because 9.1 onwards comes with an unlimited 32 bit license key doesn't mean users no longer need a license!
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: Service starts and stops

Post by Martin Erlmoser »

i will add another issue/question to this thread :)
i have a tm1server where "deactivating chores" takes between 6 to +30 sec for all chores

if deactivating only takes 6 sec for all chores there is no problem .. but sometimes it's more, i think it depends on the tm1version of course .. i had a problem earlier with version u1 that the server did'nt restart (i used net stop, net start) because the service was already stopped but the process was running and deactivating the chores - so net start caused an error :lol:
i noticed what the problem was and added a 60s wait between stop and start.. (and another "backup" net start some hours later)

it's no problem but i'm interested in your experiences so.. How long takes deactivating chores on your tm1server? (on which version?
9.1 SP3 U2 HF2

Code: Select all

3908   INFO   2008-11-01 20:00:36,622   TM1.Server   --------------------Session End--------------------
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: cub_SAP_COPA
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: cub_SAP_TotalCosts
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: dim_LPCS_BU_PG_Copy
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: dim_SAP_CostElement_Key
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: dim_TC_OrgCenter_ContArea
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: SYS_FX_Rates
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: SYS_SaveDataAll
3908   INFO   2008-11-01 20:00:36,622   TM1.Chore   Deactivating chore: SYS_UserWatch
3908   INFO   2008-11-01 20:00:42,622   TM1.Chore   Deactivating chore: TM1_flatfile_LPCS_MA
9.1 SP3 U1

Code: Select all

368   INFO   2008-10-03 19:00:13,156   TM1.Server   --------------------Session End--------------------
368   INFO   2008-10-03 19:00:13,156   TM1.Chore   Deactivating chore: cub_SAP_COPA
368   INFO   2008-10-03 19:00:18,156   TM1.Chore   Deactivating chore: cub_SAP_TotalCosts
368   INFO   2008-10-03 19:00:23,156   TM1.Chore   Deactivating chore: dim_LPCS_BU_PG_Copy
368   INFO   2008-10-03 19:00:28,156   TM1.Chore   Deactivating chore: dim_SAP_CostElement_Key
368   INFO   2008-10-03 19:00:30,156   TM1.Chore   Deactivating chore: dim_TC_OrgCenter_ContArea
368   INFO   2008-10-03 19:00:34,156   TM1.Chore   Deactivating chore: SYS_FX_Rates
368   INFO   2008-10-03 19:00:39,156   TM1.Chore   Deactivating chore: SYS_SaveDataAll
368   INFO   2008-10-03 19:00:43,156   TM1.Chore   Deactivating chore: SYS_SaveDataAll_4Hours
368   INFO   2008-10-03 19:00:48,156   TM1.Chore   Deactivating chore: TM1_flatfile_LPCS_MA
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Service starts and stops

Post by Steve Vincent »

Ours are near as damn it instant, v 9.0 SP3
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Post Reply