Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-8443

SQL Server "unspecified error" saving workflow

    XMLWordPrintable

    Details

    • Feedback Policy:
      We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: