LDAP synchronisation failed due to the Adaptavist ScriptRunner bug on Microsoft SQL Server
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
要約
There is a known bug for Adaptavist ScriptRunner plugin and Microsoft SQL server that one of the plugin libraries insert the table 'AO_XXXXXX_SR_USER_PROP' which may block the synchronization from an external directory. In the Confluence application log, we can observe the following trace:
2020-01-22 13:31:25,646 ERROR [Caesium-1-2] [atlassian.crowd.directory.DbCachingDirectoryPoller] pollChanges Error occurred while refreshing the cache for directory [ 4358145 ].
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:873)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:710)
at sun.reflect.GeneratedMethodAccessor77.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:343)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
at com.sun.proxy.$Proxy75.commit(Unknown Source)
...
2020-01-22 13:31:24,895 WARN [Caesium-1-2] [user.properties.service.UserPropertiesServiceImpl] userRenamedHandler Failed to transfer user properties on user rename
2020-01-22 13:31:25,122 WARN [Caesium-1-2] [user.properties.service.UserPropertiesServiceImpl] userRenamedHandler Failed to transfer user properties on user rename
...環境
- Microsoft SQL Server
- Adaptavist ScriptRunner version earlier than 5.6.10
- External directory (e.g. LDAP, JIRA)
診断
Enable SQL logging in Confluence then perform the sync, we will see the below trace:
SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'null.AO_XXXXXX_SR_USER_PROP'原因
ソリューション
Upgrading Adaptavist ScriptRunner plugin server or data center to the latest version.
その他
- This issue may also affect other Atlassian products