View Issue Details

IDProjectCategoryView StatusLast Update
0000402HeurekaGeneralpublic2022-08-18 15:40
Reporteradmin Assigned Tojonare  
Status resolvedResolutionfixed 
Fixed in Version2.19.0 
Summary0000402: User Submitted Report - Incorrect Syntax
DescriptionEmail from: Bugtracker Heureka <>

Originally sent by: Teresa<>

I get an error message "Incorrect syntax near "," when trying to solve the model

--- Exception ---
System.Data.SqlClient.SqlException: Incorrect syntax near ','.

--- 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Slu.Heureka.DomainLayer.GIS.SpatialRelations.CircumferenceCommand.insertData()
   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.



2022-08-15 11:54

administrator   ~0000499

In a few cases, when using circumference in optimizations, the generated SQL-query would have incorrect syntax.

Issue History

Date Modified Username Field Change
2020-11-17 16:30 admin New Issue
2020-11-19 07:27 Linus Summary User Submitted Report => User Submitted Report - Incorrect Syntax
2020-11-19 07:27 Linus Description Updated
2022-08-15 11:52 jonare Changeset attached => heureka trunk r21461
2022-08-15 11:54 jonare Assigned To => jonare
2022-08-15 11:54 jonare Status new => resolved
2022-08-15 11:54 jonare Resolution open => fixed
2022-08-15 11:54 jonare Fixed in Version => 2.19.0
2022-08-15 11:54 jonare Product General => PlanWise
2022-08-15 11:54 jonare Note Added: 0000499
2022-08-18 15:40 jonare Changeset attached => heureka trunk r21466