LDAP synchronisation failed due to the Adaptavist ScriptRunner bug on Microsoft SQL Server

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

要約

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.

Other Notes

  • This issue may also affect other Atlassian products




最終更新日 2020 年 1 月 29 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.