Page 1 of 1
Service starts and stops
Posted: Thu Oct 30, 2008 11:24 am
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
Re: Service starts and stops
Posted: Thu Oct 30, 2008 12:26 pm
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.)
Re: Service starts and stops
Posted: Thu Oct 30, 2008 4:56 pm
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.
Re: Service starts and stops
Posted: Thu Oct 30, 2008 4:58 pm
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
Re: Service starts and stops
Posted: Thu Oct 30, 2008 6:37 pm
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!
Re: Service starts and stops
Posted: Mon Nov 03, 2008 11:16 am
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
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
Re: Service starts and stops
Posted: Mon Nov 03, 2008 2:09 pm
by Steve Vincent
Ours are near as damn it instant, v 9.0 SP3