Error - couldn't load items

[Lisa Beattie]

This error comes up when I try to filter my list by category. 

Related errors: 

1. I cannot create a Filter based on category

2. I can't sort the category column from Filters page 

Attempting to fix this: 

1. I've tried refreshing - this error has been occurring for over 1 week

2. I've removed special characters from the Category drop list

2. It's nothing to do with my connection, everything else appears to be working fine 

Anyone had a similar issue and been able to resolve it?

Thank you 

[Steven Lam · Accepted solution]

It seems to be some sort of AD sync / auth issue.

To resolve this I had to go into the database and modify 3 tables

cwd_user, cwd_membership, cwd_user_attributes

and change directory_id from 10000 (LDAP/AD authentication) to 1 (JIRA internal auth) referencing user ID

restart then change it back from 1 to 10000 and restart and this would resolve the issue.

Out of the hundreds of users we have, this has occured 3 times.

[Deleted user]

Do you have an internal directory? perhaps there is a duplicate ID, perhaps thats failing an auth check. Also, check your filters, are they 'exotic' or simplistic. Validate assumptions for lookup etc with ldap browsers like jXplorer or my favorite apache directory studio.