SQL Server "unspecified error" saving workflow

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Obsolete
    • None
    • Component/s: None

      The Microsoft JDBC driver has an astonishing number of ways of demonstrating its bugginess. Here is what happens when editing a workflow:

      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
      

      For those new to the party, please do not use the Microsoft driver - use the jTDS driver instead.

            Assignee:
            Unassigned
            Reporter:
            Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: