org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ...... </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.))

Atlassian JIRA | Jeff Turner | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    The Microsoft JDBC driver has an astonishing number of ways of demonstrating its bugginess. Here is what happens when editing a workflow: {noformat} Cause: com.atlassian.jira.workflow.WorkflowException: com.opensymphony.workflow.FactoryException: Could not create new entity to save workflow org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> Stack Trace: hide com.atlassian.jira.workflow.WorkflowException: com.opensymphony.workflow.FactoryException: Could not create new entity to save workflow org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ....... <meta name="jira.status.id">3</meta> </step> </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.)) at com.atlassian.jira.workflow.OSWorkflowManager.createWorkflow(OSWorkflowManager.java:219) at com.atlassian.jira.workflow.OSWorkflowManager.saveWorkflow(OSWorkflowManager.java:225) at com.atlassian.jira.workflow.ConfigurableJiraWorkflow.store(ConfigurableJiraWorkflow.java:68) at com.atlassian.jira.web.action.admin.workflow.AddWorkflowTransition.doExecute(AddWorkflowTransition.java:107) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:47) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) ... at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:600) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:208) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:125) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534) Caused by: com.opensymphony.workflow.FactoryException: Could not create new entity to save workflow org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ...... </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.)) at com.atlassian.jira.workflow.JiraWorkflowFactory.saveWorkflow(JiraWorkflowFactory.java:145) at com.opensymphony.workflow.config.DefaultConfiguration.saveWorkflow(DefaultConfiguration.java:178) at com.atlassian.jira.workflow.OSWorkflowManager.createWorkflow(OSWorkflowManager.java:214) ... 36 more {noformat} For those new to the party, *please do not use the Microsoft driver* - use [the jTDS driver|http://jtds.sf.net] instead.

    Atlassian JIRA | 1 decade ago | Jeff Turner
    org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ...... </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.))
  2. 0

    The Microsoft JDBC driver has an astonishing number of ways of demonstrating its bugginess. Here is what happens when editing a workflow: {noformat} Cause: com.atlassian.jira.workflow.WorkflowException: com.opensymphony.workflow.FactoryException: Could not create new entity to save workflow org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> Stack Trace: hide com.atlassian.jira.workflow.WorkflowException: com.opensymphony.workflow.FactoryException: Could not create new entity to save workflow org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ....... <meta name="jira.status.id">3</meta> </step> </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.)) at com.atlassian.jira.workflow.OSWorkflowManager.createWorkflow(OSWorkflowManager.java:219) at com.atlassian.jira.workflow.OSWorkflowManager.saveWorkflow(OSWorkflowManager.java:225) at com.atlassian.jira.workflow.ConfigurableJiraWorkflow.store(ConfigurableJiraWorkflow.java:68) at com.atlassian.jira.web.action.admin.workflow.AddWorkflowTransition.doExecute(AddWorkflowTransition.java:107) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:47) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) ... at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:600) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:208) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:125) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534) Caused by: com.opensymphony.workflow.FactoryException: Could not create new entity to save workflow org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ...... </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.)) at com.atlassian.jira.workflow.JiraWorkflowFactory.saveWorkflow(JiraWorkflowFactory.java:145) at com.opensymphony.workflow.config.DefaultConfiguration.saveWorkflow(DefaultConfiguration.java:178) at com.atlassian.jira.workflow.OSWorkflowManager.createWorkflow(OSWorkflowManager.java:214) ... 36 more {noformat} For those new to the party, *please do not use the Microsoft driver* - use [the jTDS driver|http://jtds.sf.net] instead.

    Atlassian JIRA | 1 decade ago | Jeff Turner
    org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ...... </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.))

    Root Cause Analysis

    1. org.ofbiz.core.entity.GenericEntityException

      while updating: [GenericEntity:Workflow][creator,null][descriptor,<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd"> <workflow> ...... </steps> </workflow> ][name,Aktion-workflow][id,10011][islocked,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? ([Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.))

      at com.atlassian.jira.workflow.JiraWorkflowFactory.saveWorkflow()
    2. com.atlassian.jira
      JiraWorkflowFactory.saveWorkflow
      1. com.atlassian.jira.workflow.JiraWorkflowFactory.saveWorkflow(JiraWorkflowFactory.java:145)
      1 frame
    3. com.opensymphony.workflow
      DefaultConfiguration.saveWorkflow
      1. com.opensymphony.workflow.config.DefaultConfiguration.saveWorkflow(DefaultConfiguration.java:178)
      1 frame
    4. com.atlassian.jira
      OSWorkflowManager.createWorkflow
      1. com.atlassian.jira.workflow.OSWorkflowManager.createWorkflow(OSWorkflowManager.java:214)
      1 frame