Community
Products
Jira
Questions
java.sql.SQLExcetion: invalid object name 'AO_08F1AF_SYNC_EVENT' error after plugin upgrade

java.sql.SQLExcetion: invalid object name 'AO_08F1AF_SYNC_EVENT' error after plugin upgrade

Hi,

After upgrading the new version, this error is seen and the sync is blocked

java.sql.SQLExcetion: invalid object name 'AO_08F1AF_SYNC_EVENT'

What should I do to solve this problem?

Regards

2 answers

0 votes

Hi @GG ,

I am Dhiren, one of the Solutions Engineers working at Exalate.

May I please ask you to raise a request with our Support Team for this issue and I am sure we would be able to help resolve this issue.

If you can even provide me the ticket number, I can have my eyes over it for a quicker resolution.

Thank you very much, Dhiren

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Dhiren,

Thank you so much for your response. My ticket number in Exalate Support Portal is:

EASE-31829.

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

It looks like the AO_08F1AF_SYNC_EVENT table is related to the Exalate plugin. Is that the plugin that you upgraded? If so, what version of the plugin did you upgrade to?

According to the marketplace listing, there are some versions that are only compatible with Jira Server 8.0 and higher (they typically have a j7 or j8 extension). I would double-check your plugins to make sure that your version of the plugin is compatible with the version of Jira that you're running.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks for your response Matt.

The Jira version is 7.3.6 and the plugin version is 5.4.0-j

After updating the plugin, the "Invalid object name error" is displayed in the two tables below in the log:

AO_08F1AF_SYNC_EVENT
AO_08F1AF_SYNC_REQUEST

I dropped all indexes on both tables and reinstalled Exalate app. But there are still errors and the sync is blocked.
What do you think the problem could be?

[2024-03-25 15:06:12,244] <out.EventProcessorService > Error detected when processing sync events

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

Database:

- name:Microsoft SQL Server

- version:15.00.2000

- minor version:0

- major version:15

Driver:

- name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase

- version:1.3.1

java.sql.SQLException: Invalid object name 'AO_08F1AF_SYNC_EVENT'.

at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.findWithSQL(EntityManagedActiveObjects.java:158)

at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.findWithSQL(TenantAwareActiveObjects.java:306)

at sun.reflect.GeneratedMethodAccessor570.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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.$Proxy3614.findWithSQL(Unknown Source)

at com.exalate.persistence.event.SyncEventRepository.findSyncEventsToProcessPrioritized(SyncEventRepository.java:462)

at com.exalate.replication.out.EventProcessorService.findNextSyncEventForProcessing(EventProcessorService.java:384)

at com.exalate.replication.out.EventProcessorService.processEventsWithPriorities(EventProcessorService.java:356)

at com.exalate.replication.out.EventProcessorService.processSyncEvents(EventProcessorService.java:146)

at com.exalate.replication.out.EventWorker.runProcessing(EventWorker.java:51)

at com.exalate.replication.ReplicationWorker.lambda$run$0(ReplicationWorker.java:85)

at com.exalate.node.util.concurrent.ClusteredSensitiveExecutorService.lambda$executeHandlingLocks$0(ClusteredSensitiveExecutorService.java:31)

at com.exalate.node.util.concurrent.ClusteredSensitiveExecutorService.executeHandlingLocks(ClusteredSensitiveExecutorService.java:52)

at com.exalate.node.util.concurrent.ClusteredSensitiveExecutorService.executeHandlingLocks(ClusteredSensitiveExecutorService.java:29)

at com.exalate.replication.ReplicationWorker.run(ReplicationWorker.java:78)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.SQLException: Invalid object name 'AO_08F1AF_SYNC_EVENT'.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)

at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)

at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)

at net.java.ao.EntityManager.findWithSQL(EntityManager.java:736)

at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.findWithSQL(EntityManagedActiveObjects.java:156)

... 38 more

[2024-03-25 15:06:12,255] <in.RequestProcessorService > Error detected when processing sync requests

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

Database:

- name:Microsoft SQL Server

- version:15.00.2000

- minor version:0

- major version:15

Driver:

- name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase

- version:1.3.1

java.sql.SQLException: Invalid object name 'AO_08F1AF_SYNC_REQUEST'.