Confluence User List throws NullPointerException

Kathy Taylor

One of our smaller Confluence servers is throwing these issues when trying to access the User list as admin.  It is running 6.12.2 and is using Postgresql 9.6.  

https://confluence.atlassian.com/confkb/confluence-triggers-npe-when-a-user-tries-to-open-view-all-users-802597745.html?utm_medium=logScan&utm_source=STP

and

https://confluence.atlassian.com/confkb/user-list-throws-nullpointerexception-879799322.html?utm_medium=logScan&utm_source=STP

Following the resolution in the second article and running the query, I find that I have 6 offending users in the database.  

If I try to do the INSERT INTO commands at the end of the article, it works for one, but this article is written from the perspective of 1 user offending.   I have no idea what values to use for user_mapping values when you are looking at multiple users.  Does anyone know what the best way to approach this is?  Thanks.

INSERT INTO user_mapping values ('2c9681954172cf560000000000000001', 'dummyuser01', 'dummyuser01');
INSERT INTO content ("contentid", "contenttype", "version", "content_status", "username") VALUES (9999999, 'USERINFO', 1, 'current', '2c9681954172cf560000000000000001')<br>

 

Daniel Eads

Hi Kathy,

For multiple users you're going to want to do separate inserts. As indicated in the article you're going to want to swap out dummyuser01 with the actual offending username. Both statements have unique keys (that long string) that will need to be updated too.

So for your first insert, you'll do what you've got already (swapping out dummyuser01)

<span>INSERT</span> <span>INTO</span> user_mapping <span>values</span> (<span>'2c9681954172cf560000000000000001'</span>, <span>'dummyuser01'</span>, <span>'dummyuser01'</span>);
<span>INSERT</span> <span>INTO</span> <span>content</span> (<span>"contentid"</span>, <span>"contenttype"</span>, <span>"version"</span>, <span>"content_status"</span>, <span>"username"</span>) <span>VALUES</span> (<span>9999999</span>, <span>'USERINFO'</span>, <span>1</span>, <span>'current'</span>, <span>'2c9681954172cf560000000000000001'</span>)

But then the next insert you'll need to swap out dummyuser02 and the unique key. I've incremented the key for you in this statement to show what it would be like:

<span>INSERT</span> <span>INTO</span> user_mapping <span>values</span> (<span>'2c9681954172cf560000000000000002'</span>, <span>'dummyuser02'</span>, <span>'dummyuser02'</span>);
<span>INSERT</span> <span>INTO</span> <span>content</span> (<span>"contentid"</span>, <span>"contenttype"</span>, <span>"version"</span>, <span>"content_status"</span>, <span>"username"</span>) <span>VALUES</span> (<span>9999999</span>, <span>'USERINFO'</span>, <span>1</span>, <span>'current'</span>, <span>'2c9681954172cf560000000000000002'</span>)

For the remaining users, the unique key just needs to be incremented. The second one would be ....02, then the third ...03, etc: 

<span>2c9681954172cf560000000000000002</span>

 Let me know if you've got more questions!

Cheers,
Daniel | Atlassian Support