Issue Details (XML | Word | Printable)

Key: JRA-8443
Type: Third-party issue Third-party issue
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Jeff Turner [Atlassian]
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
JIRA

SQL Server "unspecified error" saving workflow

Created: 07/Nov/05 11:40 PM   Updated: 07/Nov/05 11:40 PM
Component/s: None
Affects Version/s: 3.3.1
Fix Version/s: None

Time Tracking:
Not Specified

Participants: Jeff Turner [Atlassian]
Since last comment: 2 years, 47 weeks, 6 days ago
Labels:


 Description  « Hide
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.



 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.