Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Done
-
Release 6.2.1
-
None
Description
Xporter is not working properly with Service Desk when a user creates an issue from Service Desk Customer Portal.
Steps to reproduce the error:
- Create a new user which only have access to Customer Portal
- Create a new issue from the customer portal
- The user will get the error attached to the issue
- After that, the issue is available on Jira. However, if you try to access through Customer Portal you will face the error also attached to this issue
*Error on log file: *
org.postgresql.util.PSQLException: ERROR: syntax error at or near "OR"
Position: 424
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:302)
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:208)
at com.sun.proxy.$Proxy4508.find(Unknown Source)
at com.xpandit.jiraxporter.ao.service.XporterRepositoryImpl.get(XporterRepositoryImpl.java:131)
at com.xpandit.jiraxporter.manager.impl.XporterTemplateServiceImpl.getAdminAndMineAndShared(XporterTemplateServiceImpl.java:1133)
at com.xpandit.jiraxporter.manager.impl.PermissionSchemeServiceImpl.getTemplates(PermissionSchemeServiceImpl.java:572)
at com.xpandit.jiraxporter.manager.impl.PermissionSchemeServiceImpl.getTemplates(PermissionSchemeServiceImpl.java:552)
at com.xpandit.jiraxporter.condition.JsdAccessCondition.shouldDisplay(JsdAccessCondition.java:132)
at com.atlassian.plugin.web.DefaultWebInterfaceManager.filterFragmentsByCondition(DefaultWebInterface
Note: This error occurs on an environment with database Postgres
