View Issue Details

IDProjectCategoryView StatusLast Update
0000354HeurekaOtherpublic2020-08-21 10:34
ReporterPeder Assigned ToLinus  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Product Version2.16.0 
Fixed in Version2.16.1 
Summary0000354: Database error message 'DF__Treatment__Inven__03F0984C' is not a constraint'
DescriptionError message when opening an existing project created before version 2.16:

"Result database structure is invalid, check the result db connection. Reason: 'DF__Treatment__Inven__03F0984C' is not a constraint.
Could not drop constraint. See previous errors."

Source:
.Net SqlClient Data Provider

Stacktrace:
   vid System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   vid System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   vid System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   vid System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   vid System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   vid System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   vid Slu.Heureka.DomainLayer.ResultHandling.ResultDBUpgradeHandler.upgradeToVersion(String version)
   vid Slu.Heureka.DomainLayer.ResultHandling.ResultDBUpgradeHandler.UpgradeResultDatabase()
   vid Slu.Heureka.BaseLayer.HeurekaForms.ProgressForm.backgroundWorker1_DoWork(Object sender, DoWorkEventArgs e)
   vid System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   vid System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Steps To Reproduce1. Hämta och installera resultatdatabas som finns här:
https://www.dropbox.com/s/2sqqlqeqxmzcn4p/resdb_bugg354.bak?dl=0
2. Öppna eller skapa ett PlanWise-projekt
3. Anslut resultatdatabasen som installerades i steg 1

Resultat: Felmeddelandet ovan

TagsNo tags attached.
ProductPlanWise

Activities

Linus

2020-08-18 10:35

administrator   ~0000347

Fixat i senaste releasade versionen. Scriptet som försöker ta bort 'DF__Treatment__Inven__03F0984C' finns inte i 2.16.

Issue History

Date Modified Username Field Change
2020-07-22 11:07 Peder New Issue
2020-07-22 11:09 Peder Description Updated
2020-07-23 11:59 Peder Steps to Reproduce Updated
2020-07-23 11:59 Peder Priority normal => high
2020-07-23 11:59 Peder Reproducibility N/A => always
2020-08-18 09:14 Linus Assigned To => Linus
2020-08-18 09:14 Linus Status new => assigned
2020-08-18 10:35 Linus Status assigned => resolved
2020-08-18 10:35 Linus Resolution open => no change required
2020-08-18 10:35 Linus Note Added: 0000347
2020-08-18 14:46 Linus Fixed in Version => 2.16.0
2020-08-21 09:41 Peder Status resolved => closed
2020-08-21 09:41 Peder Fixed in Version 2.16.0 => 2.16.1
2020-08-21 10:34 Changeset attached => heureka trunk r20653