View Issue Details

IDProjectCategoryView StatusLast Update
0000473Heureka[All Projects] Otherpublic2022-03-17 13:51
ReporterTomasLAssigned ToLinus 
Status resolvedResolutionfixed 
Product Version2.18.0 
Target Version2.18.1Fixed in Version2.18.1 
Summary0000473: Error when opening a project and attempting to update result database
Felmeddelande: Direkt efter öppnande av ett rojekt i PlanWise:
'OPTIMIZE_FOR_SEQUENTIAL_KEY' is not a recognized CREATE TABLE option.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

.Net SqlClient Data Provider

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Slu.Heureka.DomainLayer.ResultHandling.ResultDBUpgradeHandler.upgradeToVersion(String version)
   at Slu.Heureka.DomainLayer.ResultHandling.ResultDBUpgradeHandler.UpgradeResultDatabase()
   at Slu.Heureka.BaseLayer.HeurekaForms.ProgressForm.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
TagsNo tags attached.



2022-03-17 13:50

administrator   ~0000458

Removed unneeded part of script that didn't work on SQL Server 2017 and older

Issue History

Date Modified Username Field Change
2022-03-16 09:11 TomasL New Issue
2022-03-17 10:29 Linus Assigned To => Linus
2022-03-17 10:29 Linus Status new => assigned
2022-03-17 10:29 Linus Product Version => 2.18.0
2022-03-17 10:29 Linus Target Version => 2.18.1
2022-03-17 13:50 Linus Status assigned => resolved
2022-03-17 13:50 Linus Resolution open => fixed
2022-03-17 13:50 Linus Fixed in Version => 2.18.1
2022-03-17 13:50 Linus Note Added: 0000458
2022-03-17 13:51 Linus Summary Version Felmeddelande: Direkt efter öppnande av ett rojekt i PlanWise, se nedan => Error when opening a project and attempting to update result database