I know adTempus v3.0.5 is available for some time now, but yesterday I took the time to upgrade our server.
Every thing went fine except that :
- The console took a very long time to start and even when the window appear the icon of my server stays gray (inaccessible) for almost a minute.
- The application event log on the server shows a lot of event id 1737 : Starting up database ‘adtempus_XXXXXX’.
- The SQL server log also show a lot of the following events :
- SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
- SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
- SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
- Starting up database 'adtempus_XXXXXX’.
I found a solution :
- First install Microsoft SQL Server Management Studio Express (MSSMSE) on your atTempus server
- Open a connection to the SQL Server Express with (MSSMSE)
- Open the properties dialog of the adtempus database
- Select the options page
- Set the ‘Auto Close’ option to false
- Restart SQL Server and adTempus
Just for the record, while I was searching for a solution I tried to run the ‘adTempus Database Installation and Configuration wizard’ (adtdbconfig). This was a bad idea.
The wizard remove the ‘Integrated Security’ parameter from the connection string of the adTempus service, as a result, after that the service refused to start. I had to fixed that manually in the registry
