Uploaded image for project: 'Xporter for Jira'
  1. Xporter for Jira
  2. XPORTER-230

There was a SQL exception thrown by the Active Objects library(POSTGRES)

    XporterXMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Release 3.1.1, Release 3.1.2
    • Fix Version/s: Release 3.1.3
    • Component/s: None
    • Labels:
      None
    • Requirement Status:

      Release 3.1.3 - UNCOVERED

      Description

      Email from Customer:

      Hi Guys,

      I just upgraded from JIRA 6.2 to JIRA 6.3.8 and Xporter is throwing an exception when attempting to manage the templates. The Manage templates screen is blank ( I have 5 templates in the server ), bulk filter templates are blank and the Xporter options in the issue screen do not appear. If I attempt to add a new template from the Manage Templates screen a red error dialog is displayed. Permissions are displayed, global settings are displayed and license details are displayed.

      I tested the upgrade a few weeks ago on my test system and Xporter was fine after the upgrade.

      It looks like I was using Xporter 3.1.0 on my test system and on PROD, I picked up the newer 3.1.2 release.

      Here's the stack from my JIRA log:

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

      • name:PostgreSQL
      • version:9.1.14
      • minor version:1
      • major version:9
        Driver:
      • name:PostgreSQL Native Driver
      • version:PostgreSQL 9.0 JDBC4 (build 801)

      org.postgresql.util.PSQLException: ERROR: syntax error at or near ""ASC""
      Position: 167
      at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:179)
      at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:93)
      at sun.reflect.GeneratedMethodAccessor338.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
      at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
      at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at com.sun.proxy.$Proxy3779.find(Unknown Source)
      at com.xpandit.jiraxporter.ao.service.XporterTemplateAOServiceImpl.getAll(Unknown Source)
      at com.xpandit.jiraxporter.utils.m.a(Unknown Source)
      at com.xpandit.jiraxporter.action.BulkExport.getTemplateFiles(Unknown Source)
      at com.xpandit.jiraxporter.action.BulkExport.getEmptyTemplates(Unknown Source)
      ... 211 more

      Please let me know if you need any additional info. I have the Xporter plug-in disabled now.

        Attachments

          Activity

            People

            • Assignee:
              rmbr Rui Rodrigues
              Reporter:
              rmbr Rui Rodrigues
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: