Details
-
Suggestion
-
Resolution: Obsolete
-
None
-
None
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.
