View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000751 | Heureka | General | public | 2025-01-13 11:30 | 2025-01-24 14:52 |
Reporter | admin | Assigned To | osskyn | ||
Priority | normal | Severity | minor | Reproducibility | N/A |
Status | assigned | Resolution | open | ||
Summary | 0000751: Run Strategic TPG produces Sql exception | ||||
Description | Email 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) | ||||
Tags | No tags attached. | ||||
Product | General | ||||
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 |