Out of Sync Error when editing JIRA Dashboard

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

  1. 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


Last modified on Sep 8, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.