Issue Summary

Bamboo export fails with "NullPointerException" when the "user_name" column of table "user_comment" is null.
The user_name is now filled in every comment , but this must be a legacy record from the previous versions in 2025 or 2016.

Observed in Bamboo 9.2.24, but this could be possible in new version as well.

Steps to Reproduce

1. Check whether you have atleast one recored for the following statement.

        Select * from  user_comment where user_name is null;

1. Export Bamboo data from the UI

Expected Results

Export successfully

Actual Results

The below exception is thrown in the atlassian-bamboo.log file:

2025-06-24 13:57:52,800 INFO [http-nio-8085-exec-35] [XmlMigrator] Exporting with: com.atlassian.bamboo.migration.stream.CommentRootMapper
2025-07-26 18:57:53,094 ERROR [http-nio-8085-exec-33] [CommentRootMapper$1] Could not export com.atlassian.bamboo.comment.CommentImpl@ac0001
java.lang.NullPointerException: null
	at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:447) ~[woodstox-core-asl-4.4.1.jar:?]
..................
	at com.atlassian.bamboo.comment.CommentHibernateDao$6.nextScrollableResult(CommentHibernateDao.java:134) ~[atlassian-bamboo-persistence-9.2.24.jar:?]

Workaround

Update the column "user_name" of table "user_comment" (where user_name is null) with some valid user_name and then execute export zip from Bamboo.