# SQL error - Dynamic SQL generation for the UpdateCommand

**URL:** https://discuss.workflowgen.com/t/sql-error-dynamic-sql-generation-for-the-updatecommand/859
**Category:** General WorkflowGen Discussion
**Created:** [August 26, 2017, 7:48am UTC](https://discuss.workflowgen.com/t/sql-error-dynamic-sql-generation-for-the-updatecommand/859 "2017-08-26T07:48:57Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Dexto](https://avatars.discourse-cdn.com/v4/letter/d/4491bb/32.png) [@Dexto](https://discuss.workflowgen.com/u/Dexto)
#### Post date: [August 26, 2017, 7:48am UTC](https://discuss.workflowgen.com/t/sql-error-dynamic-sql-generation-for-the-updatecommand/859/1 "2017-08-26T07:48:57Z")

</div>

Am getting the below error when i open any process on workflowgen. How can i solve it?

![image](https://canada1.discourse-cdn.com/flex030/uploads/workflowgen/original/1X/ef4cc56708b4ec69d7bfc9e8eea280c4ae467dc9.jpg)

Advantys.Workflow.Engine: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.  
System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.  
at Advantys.Workflow.Engine.WorkflowsManager.ActivityInstanceCreateContext(WorkflowUserIdentity userIdentity, Int32 processInstanceId, Int32 activityInstanceId)  
at †a.ˆa.“a(PageController )