View Issue Details

IDProjectCategoryView StatusLast Update
0000751HeurekaGeneralpublic2025-01-24 14:52
Reporteradmin Assigned Toosskyn  
PrioritynormalSeverityminorReproducibilityN/A
Status assignedResolutionopen 
Summary0000751: Run Strategic TPG produces Sql exception
DescriptionEmail from: Bugtracker Heureka <bugtracker.heureka@slu.se>

Originally sent by: Magnus Persson<magnus.persson@skogforsk.se>

Hej,

jag har fått följande felmeddelande när jag kör "Run Strategic TPG". Jag kan alltså inte ens får fram en TPG-lösning. Jag använder senaste Heureka-versionen. Jag använder ett beståndsregister.


Source:
.Net SqlClient Data Provider

Stacktrace:
   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.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
   at Slu.Heureka.DomainLayer.ResultHandling.ResultDb.SaveSimulationData(Simulation simulation, ResultData[] results, DataTable tUnitTable, DataTable siteDataTable, DataTable standObjectDataTable, DataTable treatmentUnitExternalDataTable, DataTable optimizationTable, DataTable simulationTreatments)
   at Slu.Heureka.DomainLayer.ResultHandling.Simulation.Save()
   at Slu.Heureka.DomainLayer.TreatmentProgramGenerator.TreatmentProgramManager.GenerateTreatmentPrograms()
   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)



--- Exception ---
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'RESULT_PK'. Cannot insert duplicate key in object 'dbo.RESULT'. The duplicate key value is (1090206332132).
The statement has been terminated.

--- Stack Trace ---
   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.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
   at Slu.Heureka.DomainLayer.ResultHandling.ResultDb.SaveSimulationData(Simulation simulation, ResultData[] results, DataTable tUnitTable, DataTable siteDataTable, DataTable standObjectDataTable, DataTable treatmentUnitExternalDataTable, DataTable optimizationTable, DataTable simulationTreatments)
   at Slu.Heureka.DomainLayer.ResultHandling.Simulation.Save()
   at Slu.Heureka.DomainLayer.TreatmentProgramGenerator.TreatmentProgramManager.GenerateTreatmentPrograms()
   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.
ProductGeneral

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-01-13 11:30 admin New Issue
2025-01-14 10:34 osskyn Summary User Submitted Report => Run Strategic TPG produces Sql exception
2025-01-14 10:34 osskyn Description Updated
2025-01-24 14:52 osskyn Assigned To => osskyn
2025-01-24 14:52 osskyn Status new => assigned