JIRA Directory synchronisation fails due to invalid XML character

お困りですか?

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

コミュニティに質問


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

課題

Your Bitbucket Server is configured to use JIRA as a User Directory but suddenly stopped working. In the logs you can find an error like that:

ERROR log
ERROR [Caesium-1-4]  c.a.c.d.DbCachingDirectoryPoller Error occurred while refreshing the cache for directory [ 123456 ].
com.atlassian.crowd.exception.OperationFailedException: javax.xml.bind.UnmarshalException
 - with linked exception:
[org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1432; An invalid XML character (Unicode: 0x1a) was found in the value of attribute "name" and element is "user".]


ソリューション

There are two ways of determining which name causes the issue:

Option 1:

  1. Query the cwd_user table for any data containing character put in brackets. In our example, it's (Unicode: 0x1a).

The query depends on the database type, as the Unicode character might be represented differently in different databases. 

If you wish to follow this path, please build a SELECT statement querying the JIRA CWD_USER table for the Unicode character mentioned in the log.

Option 2:

Save the output of:

SELECT * FROM CWD_USER;

to cwd_user.txt file

and search for the invalid characters manually:

grep --color='auto' --line-number --perl-regexp "[^\x00-\x7F]" cwd_user.txt

Once you find the faulty credentials, please correct them in JIRA (manually removing it and adding again should be enough), and start the synchronization again.



説明JIRA Directory synchronisation fails due to invalid XML character
製品Bitbucket Server



最終更新日 2019 年 7 月 2 日

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

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