Out of Sync Error when editing JIRA Dashboard
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
Symptoms
The following appears in the
atlassian-jira.logwhile trying to edit or made changes to the dashboard:
1
2
3
4
5
6
7
8
2013-07-05 13:47:29,923 http-bio-8080-exec-23 ERROR moritz 827x16956x1 8rx9va 192.168.0.198 /rest/dashboards/1.0/10211/layout [common.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service
com.atlassian.gadgets.dashboard.spi.DashboardStateStoreException: Error updating dashboard state with id '10211'.
at com.atlassian.jira.dashboard.JiraDashboardStateStoreManager.update(JiraDashboardStateStoreManager.java:162)
at sun.reflect.GeneratedMethodAccessor1645.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)2. The following window will prompt when trying to edit or made changes to the dashboard
Cause
1
Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE dbo.portletconfiguration SET positionseq = ? , PORTALPAGE = ? , COLUMN_NUMBER = ? WHERE id = ? (Invalid column name 'id'.)The error shows that it has problem related to the encoding and/or collation type being configured incorrectly.
JIRA must use case-insensitive collation type, for example '
SQL_Latin1_General_CP437_CI_AI' (CI stand for case-insensitive and CS stands for case sensitive)
Resolution
Configure JIRA to use case-insensitive collation type('
SQL_Latin1_General_CP437_CI_AI' ) as suggested in Connect Jira applications to a database.
Was this helpful?