REST update tree field, error ORA-00907

Create issue
Issue #24 closed
venam777 created an issue

While updating custom field value via REST request error occures: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

  • REST request: {"update":{"customfield_11690":[{"set":[{"name":"Some tree node value"}]}]}}
  • Error: Server error 500, cause: ORA-00907: missing right parenthesis

  • Stacktrace: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database:

    • name:Oracle
    • version:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
    • minor version:2 Driver:
    • name:Oracle JDBC driver
    • version:12.1.0.1.0 java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:142) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:296) ... 2 filtered at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) at com.sun.proxy.$Proxy4059.find(Unknown Source) at ru.slie.jira.tree.admin.service.TreeOptionService.getByName(TreeOptionService.java:79) at ru.slie.jira.tree.manager.TreeSchemaManagerImpl.getOptionByName(TreeSchemaManagerImpl.java:115) at ru.slie.jira.tree.customfield.rest.TreeMultiCustomFieldOperationsHandler.getOptionIdForValue(TreeMultiCustomFieldOperationsHandler.java:123) at ru.slie.jira.tree.customfield.rest.TreeMultiCustomFieldOperationsHandler.handleSetOperation(TreeMultiCustomFieldOperationsHandler.java:81) at ru.slie.jira.tree.customfield.rest.TreeMultiCustomFieldOperationsHandler.handleSetOperation(TreeMultiCustomFieldOperationsHandler.java:24) at com.atlassian.jira.issue.customfields.impl.rest.AbstractCustomFieldOperationsHandler.updateIssueInputParameters(AbstractCustomFieldOperationsHandler.java:89) at com.atlassian.jira.rest.v2.issue.IssueInputParametersAssembler$IssueInputParametersBuilder.finalizeIssueInputParams(IssueInputParametersAssembler.java:428) at com.atlassian.jira.rest.v2.issue.IssueInputParametersAssembler$IssueInputParametersBuilder.buildForEdit(IssueInputParametersAssembler.java:230) at com.atlassian.jira.rest.v2.issue.IssueInputParametersAssembler.makeUpdateAssembler(IssueInputParametersAssembler.java:119) at com.atlassian.jira.rest.v2.issue.UpdateIssueResource.editIssue(UpdateIssueResource.java:58) at com.atlassian.jira.rest.v2.issue.IssueResource.editIssue(IssueResource.java:752)

Comments (2)

  1. Log in to comment