View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000165 | Heureka | TPG | public | 2017-12-07 18:14 | 2018-01-19 13:43 |
| Reporter | Peder | Assigned To | Linus | ||
| Priority | normal | Severity | major | Reproducibility | unable to reproduce |
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 2.9.3 | ||||
| Target Version | 2.10.0 | Fixed in Version | 2.10.0 | ||
| Summary | 0000165: Timeout when running tactical TPG | ||||
| Description | Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source: .Net SqlClient Data Provider Inner Exception: The wait operation timed out 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Slu.Heureka.DomainLayer.ResultHandling.ResultDb.GetYearAtPeriod1(IOptimization optimization) at Slu.Heureka.DomainLayer.TreatmentProgramGenerator.UI.GenerateTacticalTreatmentProgramCommand.Do() | ||||
| Steps To Reproduce | 1. Hämta projektfiler och databasfiler här: \\storage-ume.slu.se\common$\srh\heureka\Buggrapportdata\Bugg165 2. Gör restore på databas-filerna fordb_hexagoner.2bak och resdb.hexagoner.bak. Kommer från Sql Server professional ver 2012. Funkar inte med SqlExpress, resultatdatabasen är för stor. 3. Importera projektet 4. Under områdesnoden med 50000 hexagoner ska knapp 5000 var valda. Kontrollera i Ingående tillstånd att det stämmer. Om så inte är fallet finns en fil som heter standlist.txt som kan användas för att uppdatera valet. 5. Kör taktisk TPG där stategisk plan nr 3-1 används som startläge. Resultat: Inget händer, tills Timeout visas efter ca 30 sek. Förväntat resultat: Wait-cursor borde visas, och Timeout borde inte uppstå. | ||||
| Tags | No tags attached. | ||||
| Product | PlanWise | ||||
|
|
After changing to a new result database, and rerunning the simulations, the timeout problem disappeared. But it took very long time to start the tactical TPG, the status message said "Evaluating forest domains..." för 20 minutes before the actual TPG started. |
|
|
Gjorde ändringar i december som verkar ha åtgärdat felet. Kan ej återskapa nu. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-12-07 18:14 | Peder | New Issue | |
| 2017-12-07 18:22 | Peder | Steps to Reproduce Updated | |
| 2017-12-08 10:23 | Peder | Note Added: 0000171 | |
| 2017-12-08 13:24 | Peder | Steps to Reproduce Updated | |
| 2017-12-08 13:24 | Peder | Assigned To | => Linus |
| 2017-12-08 13:24 | Peder | Status | new => assigned |
| 2017-12-08 13:24 | Peder | Product Version | => 2.9.3 |
| 2017-12-08 13:24 | Peder | Steps to Reproduce Updated | |
| 2017-12-08 13:31 | Peder | Steps to Reproduce Updated | |
| 2018-01-11 14:48 | Linus | Status | assigned => resolved |
| 2018-01-11 14:48 | Linus | Resolution | open => fixed |
| 2018-01-11 14:48 | Linus | Note Added: 0000181 | |
| 2018-01-19 13:14 | Peder | Status | resolved => closed |
| 2018-01-19 13:14 | Peder | Fixed in Version | => 2.10.0 |
| 2018-01-19 13:43 | Peder | Reproducibility | always => unable to reproduce |
| 2018-01-19 13:43 | Peder | Resolution | fixed => unable to reproduce |
