WorkflowEngine.NET icon indicating copy to clipboard operation
WorkflowEngine.NET copied to clipboard
verified publisher icon optimajet

PersistenceProvider.GetProcessInstancesAsync SQL Error

Open LiubomyrSkalskyi opened this issue 3 years ago • 9 comments

System.AggregateException: 'One or more errors occurred. (An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.)'

LiubomyrSkalskyi avatar May 02 '22 14:05 LiubomyrSkalskyi

Can you send us a full stack trace of this exception?

betine avatar May 02 '22 14:05 betine

at OptimaJet.Workflow.DbPersistence.DbObject1.<SelectAsync>d__19.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1.ConfiguredTaskAwaiter.GetResult() at OptimaJet.Workflow.DbPersistence.DbObject1.<SelectAllWithPagingAsync>d__10.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1.ConfiguredTaskAwaiter.GetResult() at OptimaJet.Workflow.DbPersistence.MSSQLProvider.<GetProcessInstancesAsync>d__22.MoveNext()

LiubomyrSkalskyi avatar May 02 '22 14:05 LiubomyrSkalskyi

Here is Inner Exception stack trace: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, Boolean isInternal, String endMethod) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderAsync(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at OptimaJet.Workflow.DbPersistence.DbObject1.<SelectInternalAsync>d__26.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1.ConfiguredTaskAwaiter.GetResult() at OptimaJet.Workflow.DbPersistence.DbObject`1.<SelectAsync>d__19.MoveNext()

LiubomyrSkalskyi avatar May 02 '22 14:05 LiubomyrSkalskyi

Can you please describe the case when this exception occurs? It is not obvious from this stack trace.

betine avatar May 02 '22 15:05 betine

I'm just testing the package functionality to be sure it fits with my current project. I'm calling WorkflowInit.Runtime.PersistenceProvider.GetProcessInstancesAsync() to load the processes It is the Console app like in the How to Integrate article, running .Net Core 3.1 connected with MSSQL Server

LiubomyrSkalskyi avatar May 02 '22 15:05 LiubomyrSkalskyi

image

LiubomyrSkalskyi avatar May 02 '22 15:05 LiubomyrSkalskyi

Does it make sense? Because I didn't find any documentation on that method

LiubomyrSkalskyi avatar May 02 '22 15:05 LiubomyrSkalskyi

Now it is clear, this bug will be fixed soon. Thank you for the report.

betine avatar May 03 '22 16:05 betine

Hello, I took this bug to work.

Please, send:

  1. Full code that causes this exception.
  2. Version of dotnet, Workflow Engine and SqlServer used.

rylee-soll avatar May 13 '22 12:05 rylee-soll