org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Derek MacKie, 1 year ago
SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))
via Atlassian JIRA by Derek MacKie, 1 year ago
SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))
via Atlassian JIRA by Derek MacKie, 3 weeks ago
SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))
via Atlassian JIRA by fukan, 1 year ago
SQL Exception while executing the following:UPDATE issuetype SET SEQUENCE=?, pname=?, pstyle=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (Data truncation: Data too long for column 'pname' at row 1)
via Atlassian JIRA by fukan, 1 year ago
SQL Exception while executing the following:UPDATE issuetype SET SEQUENCE=?, pname=?, pstyle=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (Data truncation: Data too long for column 'pname' at row 1)
via Atlassian JIRA by Nick Mason, 1 year ago
SQL Exception while executing the following:INSERT INTO public.MOVED_ISSUE_KEY (ID, OLD_ISSUE_KEY, ISSUE_ID) VALUES (?, ?, ?) (ERROR: duplicate key value violates unique constraint "idx_old_issue_key")
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:375)
at org.ofbiz.core.entity.GenericDAO.singleUpdate(GenericDAO.java:214)
at org.ofbiz.core.entity.GenericDAO.customUpdate(GenericDAO.java:164)
at org.ofbiz.core.entity.GenericDAO.update(GenericDAO.java:157)
at org.ofbiz.core.entity.GenericHelperDAO.store(GenericHelperDAO.java:207)
at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1406)
at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1386)
at org.ofbiz.core.entity.GenericValue.store(GenericValue.java:81)
at com.atlassian.jira.web.action.admin.constants.AbstractEditConstant.doExecute(AbstractEditConstant.java:53)
at webwork.action.ActionSupport.execute(ActionSupport.java:153)
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at java.lang.Thread.run(Thread.java:619)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.