Some problems upgrading adTempus from 2.0.4 to 3.0.5

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

Next PostNewer Post Previous PostOlder Post Home