2 Replies Latest reply on Aug 22, 2013 10:26 PM by pb

    Upgrade database 8 to 9 problem

    Rookie

      I've got problems upgrading my database from 8 to 9. I followed the directions in SKB 5607. I can live with losing my old results but would like to keep my groups and configuration etc.

       

      I guess there is a problem with converting dates (European notation, could that be the issue?)

       

      ...

      2013-08-22T11:37:17.9525627Z 0005 I DatabaseInstaller.cs:412|Calculating latest asset result for each machine...

      2013-08-22T11:37:17.9525627Z 0005 I DatabaseInstaller.cs:412|Upgrading asset values: 0 of 3 complete...

      2013-08-22T11:37:18.2952853Z 0005 E DatabaseInstaller.cs:561|SQL install script error: System.Data.SqlClient.SqlException (0x80131904): Er is een rekenkundige overloopfout opgetreden bij het converteren van expression naar het gegevenstype datetime.

      De instructie is beëindigd.

      Upgrading asset lists: 0 of 3 complete...

         bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

         bij System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

         bij System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

         bij System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

         bij System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

         bij System.Data.SqlClient.SqlDataReader.get_MetaData()

         bij System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

         bij System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

         bij System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

         bij System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

         bij System.Data.SqlClient.SqlCommand.ExecuteScalar()

         bij ST.Data.SchemaInstaller.DatabaseInstaller.RunInstallScript(SqlConnection connection, String scriptText, IEnumerable`1 parameters)

         bij ST.Data.SchemaInstaller.DatabaseInstaller.ExecuteSqlScript(SqlConnection connection, SqlScriptResource scripts, IEnumerable`1 parameters)

      2013-08-22T11:37:18.4978032Z 0005 S DatabaseInstaller.cs:620|Rollback|Entering.

      ...

       

      In the 8 version I already minimised the results to 10 each but to no avail.

      I could delete the entries in the sql studio express but that could be rather error prone.

       

      Any suggestions? Thanks