View Issue Details

IDProjectCategoryView StatusLast Update
0000579HeurekaOtherpublic2023-03-21 10:57
ReporterPeder Assigned ToLinus  
PrioritynormalSeveritycrashReproducibilityalways
Status resolvedResolutionfixed 
Product Version2.20.0 
Target Version2.21.0Fixed in Version2.21.0 
Summary0000579: Fel vid beräkning av klickar och avverkningskluster
Description"The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information."

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.SqlDataReader.TryConsumeMetaData()
   vid System.Data.SqlClient.SqlDataReader.get_MetaData()
   vid System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   vid 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)
   vid 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)
   vid System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   vid System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   vid Slu.Heureka.DomainLayer.GIS.SpatialRelations.CliquesAndClustersCommand.dbResultsExist(Boolean& _adjacenciesDataFound, Boolean& _cliquesAndClustersDataFound)
   vid Slu.Heureka.DomainLayer.GIS.SpatialRelations.CliquesAndClustersCommand.Do()

Steps To ReproduceJag kan tillhandahålla skogsdatabasen med importerade polygoner
TagsNo tags attached.
ProductPlanWise

Activities

Linus

2023-03-21 10:56

administrator   ~0000554

Now checks previous clique and clusters in chunks of 100 treatment units to avoid too complex queries

Issue History

Date Modified Username Field Change
2023-03-16 13:52 Peder New Issue
2023-03-21 10:54 Changeset attached => heureka trunk r21846
2023-03-21 10:56 Linus Assigned To => Linus
2023-03-21 10:56 Linus Status new => resolved
2023-03-21 10:56 Linus Resolution open => fixed
2023-03-21 10:56 Linus Fixed in Version => 2.21.0
2023-03-21 10:56 Linus Note Added: 0000554
2023-03-21 10:57 Linus Target Version => 2.21.0