User default Page Size set to '0'
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
After upgrading JIRA many users are reporting their default 'Page Size' is now set to 0.
Diagnosis
Run this query to find the global setting for number of Issues displayed per Issue Navigator page
1
2
select propertyvalue from propertystring where id = (select id from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'jira.properties');
You can check the value against the user's preferences, substituting xxx with the username.
1
select propertyvalue from propertynumber where id = (select id from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'ApplicationUser' and entity_id = (select id from cwd_user where lower_user_name = 'xxx'));Cause
Currently, the cause is unknown but observed upgrading from JIRA 5.2.5 to 7.9.1
Solution
Workaround
Workarounds are ways to temporally circumvent a problem, although it still exists in the application.
⚠️Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Please do not run the following steps without backing up your database first!
1. Backup database
2. Shutdown Jira
3. Run the following statements:
1
2
3
delete from propertynumber where id = (select id from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'ApplicationUser');
delete from propertyentry where property_key = 'user.issues.per.page' and entity_name = 'ApplicationUser';4. Start Jira
5. Configure the 'Number of Issues displayed per Issue Navigator page' in the Jira administration >> System >> Default user preferences
Was this helpful?