Out of Sync Error when editing JIRA Dashboard
Symptoms
- The following appears in the
atlassian-jira.log
while trying to edit or made changes to the dashboard:
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
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.
Last modified on Sep 8, 2022
Powered by Confluence and Scroll Viewport.