com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))

Atlassian JIRA | Daniel Zahn | 7 years ago
  1. 0

    copied from / also see https://support.atlassian.com/browse/JSP-47192 When a user goes to "Manage Dashboard" and adds a new dashboard, the form field "description" allows a user to input a lot of text. On save it is not validated how many chars are in that field. If there are more than 255 chars in it, JIRA throws a System Error, because the according database field seems to be text(255). INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) the error is: "Data too long for column 'DESCRIPTION' at row 1" after: INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT)... The table portalpage looks like this: {code} mysql> describe portalpage; +-------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+-------+ | ID | decimal(18,0) | NO | PRI | | | | USERNAME | varchar(255) | YES | | NULL | | | PAGENAME | varchar(255) | YES | | NULL | | | DESCRIPTION | varchar(255) | YES | | NULL | | | SEQUENCE | decimal(18,0) | YES | | NULL | | | FAV_COUNT | decimal(18,0) | YES | | NULL | | +-------------+---------------+------+-----+---------+-------+ {code} so, "DESCRIPTION" is varchar(255). (max. 255 chars) I can confirm inserting 254 chars into the description field does not cause the error, while 256 chars does. The problem is just that the formfield does not check if the user inserts more characters. We dont even need a workaround, see it just as a bug report, so you can fix it in a future version It would be better if either the database field would allow more than 255 chars (if possible), or the form would be validated and tell the user something like "your description text is too long" instead. This is more for your information than expecting a work-around right now, i have already informed our user to use only up to 254 chars to avoid this. ---- System Error A system error has occurred. Please try submitting this problem via the Support Request Page Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem 2. cut & paste the error and system information found below 3. attach the application server log file ( /home/jira/atlassian-jira.log ) Cause: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) Stack Trace: [hide] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:333) at com.atlassian.jira.portal.OfBizPortalPageStore.create(OfBizPortalPageStore.java:199) at com.atlassian.jira.portal.CachingPortalPageStore.create(CachingPortalPageStore.java:208) at com.atlassian.jira.portal.DefaultPortalPageManager.create(DefaultPortalPageManager.java:195) at com.atlassian.jira.bc.portal.AbstractPortalPageService.createPortalPage(AbstractPortalPageService.java:214) at com.atlassian.jira.web.action.user.AddPortalPage.createBlankPortalPage(AddPortalPage.java:332) at com.atlassian.jira.web.action.user.AddPortalPage.doExecute(AddPortalPage.java:146) 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:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:75) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:480) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:460) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:329) ... 66 more Referer URL: http://jira.ligatus.local/jira/secure/AddPortalPage!default.jspa

    Atlassian JIRA | 7 years ago | Daniel Zahn
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))
  2. 0

    copied from / also see https://support.atlassian.com/browse/JSP-47192 When a user goes to "Manage Dashboard" and adds a new dashboard, the form field "description" allows a user to input a lot of text. On save it is not validated how many chars are in that field. If there are more than 255 chars in it, JIRA throws a System Error, because the according database field seems to be text(255). INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) the error is: "Data too long for column 'DESCRIPTION' at row 1" after: INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT)... The table portalpage looks like this: {code} mysql> describe portalpage; +-------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+-------+ | ID | decimal(18,0) | NO | PRI | | | | USERNAME | varchar(255) | YES | | NULL | | | PAGENAME | varchar(255) | YES | | NULL | | | DESCRIPTION | varchar(255) | YES | | NULL | | | SEQUENCE | decimal(18,0) | YES | | NULL | | | FAV_COUNT | decimal(18,0) | YES | | NULL | | +-------------+---------------+------+-----+---------+-------+ {code} so, "DESCRIPTION" is varchar(255). (max. 255 chars) I can confirm inserting 254 chars into the description field does not cause the error, while 256 chars does. The problem is just that the formfield does not check if the user inserts more characters. We dont even need a workaround, see it just as a bug report, so you can fix it in a future version It would be better if either the database field would allow more than 255 chars (if possible), or the form would be validated and tell the user something like "your description text is too long" instead. This is more for your information than expecting a work-around right now, i have already informed our user to use only up to 254 chars to avoid this. ---- System Error A system error has occurred. Please try submitting this problem via the Support Request Page Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem 2. cut & paste the error and system information found below 3. attach the application server log file ( /home/jira/atlassian-jira.log ) Cause: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) Stack Trace: [hide] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:333) at com.atlassian.jira.portal.OfBizPortalPageStore.create(OfBizPortalPageStore.java:199) at com.atlassian.jira.portal.CachingPortalPageStore.create(CachingPortalPageStore.java:208) at com.atlassian.jira.portal.DefaultPortalPageManager.create(DefaultPortalPageManager.java:195) at com.atlassian.jira.bc.portal.AbstractPortalPageService.createPortalPage(AbstractPortalPageService.java:214) at com.atlassian.jira.web.action.user.AddPortalPage.createBlankPortalPage(AddPortalPage.java:332) at com.atlassian.jira.web.action.user.AddPortalPage.doExecute(AddPortalPage.java:146) 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:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:75) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:480) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:460) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:329) ... 66 more Referer URL: http://jira.ligatus.local/jira/secure/AddPortalPage!default.jspa

    Atlassian JIRA | 7 years ago | Daniel Zahn
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))
  3. 0

    Trusted apps were originally created but failed (silently as always), because the URLs did not match the base URLs of the applications. After fixing the base URLs, the next synchronization attempt results in this error: {noformat} 2008-08-29 02:24:58,436 TP-Processor13 ERROR [atlassian.applinks.trusted.JiraTrustedApplicationsSynchroniser] Exception occured during create of trustedApplication: http://HOST.jira.com/wiki com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:TrustedApplication][created,2008-08-29 02:24:58.435][urlMatch,null][timeout,5000][updatedBy,admin][applicationId,confluence:3794233][publicKey,<OMITTED>][createdBy,admin][ipMatch,null][name,http://HOST.jira.com/wiki][updated,2008-08-29 02:24:58.435][id,10021] (SQL Exception while executing the following:INSERT INTO public.trustedapp (ID, APPLICATION_ID, NAME, PUBLIC_KEY, IP_MATCH, URL_MATCH, TIMEOUT, CREATED, CREATED_BY, UPDATED, UPDATED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint "trustedapp_id")) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:313) at com.atlassian.jira.security.auth.trustedapps.DefaultTrustedApplicationStore.store(DefaultTrustedApplicationStore.java:52) at com.atlassian.jira.security.auth.trustedapps.CachingTrustedApplicationStore.store(CachingTrustedApplicationStore.java:54) at com.atlassian.jira.security.auth.trustedapps.DefaultTrustedApplicationManager.store(DefaultTrustedApplicationManager.java:95) at com.atlassian.jira.security.auth.trustedapps.CachingTrustedApplicationManager.store(CachingTrustedApplicationManager.java:54) at com.atlassian.applinks.trusted.JiraTrustedApplicationsSynchroniser.add(JiraTrustedApplicationsSynchroniser.java:55) at com.atlassian.applinks.trusted.TrustedApplicationsResourceHandler.establishTrustedApplicationLink(TrustedApplicationsResourceHandler.java:74) at com.atlassian.applinks.trusted.TrustedApplicationsResourceHandler.doPut(TrustedApplicationsResourceHandler.java:54) at com.atlassian.applinks.servlet.RestServlet.doPut(RestServlet.java:101) at javax.servlet.http.HttpServlet.service(HttpServlet.java:713) at com.atlassian.applinks.servlet.RestServlet.access$001(RestServlet.java:24) at com.atlassian.applinks.servlet.RestServlet$2.doInTransaction(RestServlet.java:68) at com.atlassian.sal.core.transaction.NoOpTransactionTemplate.execute(NoOpTransactionTemplate.java:14) at com.atlassian.applinks.servlet.RestServlet.service(RestServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at com.atlassian.plugin.descriptors.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:48) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at com.atlassian.plugin.descriptors.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:38) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 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:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) 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.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686) at java.lang.Thread.run(Thread.java:595) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:TrustedApplication][created,2008-08-29 02:24:58.435][urlMatch,null][timeout,5000][updatedBy,admin][applicationId,confluence:3794233][publicKey,<OMITTED>][createdBy,admin][ipMatch,null][name,http://HOST.jira.com/wiki][updated,2008-08-29 02:24:58.435][id,10021] (SQL Exception while executing the following:INSERT INTO public.trustedapp (ID, APPLICATION_ID, NAME, PUBLIC_KEY, IP_MATCH, URL_MATCH, TIMEOUT, CREATED, CREATED_BY, UPDATED, UPDATED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint "trustedapp_id")) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:480) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:460) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:309) ... 70 more {noformat}

    Ecosystem JIRA | 8 years ago | Jeff Turner
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:TrustedApplication][created,2008-08-29 02:24:58.435][urlMatch,null][timeout,5000][updatedBy,admin][applicationId,confluence:3794233][publicKey,<OMITTED>][createdBy,admin][ipMatch,null][name,http://HOST.jira.com/wiki][updated,2008-08-29 02:24:58.435][id,10021] (SQL Exception while executing the following:INSERT INTO public.trustedapp (ID, APPLICATION_ID, NAME, PUBLIC_KEY, IP_MATCH, URL_MATCH, TIMEOUT, CREATED, CREATED_BY, UPDATED, UPDATED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint "trustedapp_id"))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    This error appears when upgrading to 3.2 Enterprise by pointing JIRA to the existing 2.5.3 Professional database 2005-05-16 13:00:05,375 ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: null java.lang.NullPointerException at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build83.doUpgrade(UpgradeTask_Build83.java:72) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:669) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:565) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doEditionUpgrade(UpgradeManagerImpl.java:508) at com.atlassian.jira.web.action.admin.SetupLicense.doExecute(SetupLicense.java:103) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:46) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:177) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534) On restart: 2005-05-16 13:02:26,312 ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')])) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')])) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:153) at com.atlassian.jira.issue.fields.screen.DefaultFieldScreenStore.createFieldScreen(DefaultFieldScreenStore.java:65) at com.atlassian.jira.issue.fields.screen.CachingFieldScreenStore.createFieldScreen(CachingFieldScreenStore.java:41) at com.atlassian.jira.issue.fields.screen.DefaultFieldScreenManager.createFieldScreen(DefaultFieldScreenManager.java:59) at com.atlassian.jira.issue.fields.screen.FieldScreenImpl.store(FieldScreenImpl.java:185) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build83.doUpgrade(UpgradeTask_Build83.java:68) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:669) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:565) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:393) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:341) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:301) at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:65) at com.caucho.server.http.Application.init(Application.java:1843) at com.caucho.server.http.VirtualHost.init(VirtualHost.java:728) at com.caucho.server.http.ServletServer.initHosts(ServletServer.java:874) at com.caucho.server.http.ServletServer.initInternal(ServletServer.java:719) at com.caucho.server.http.ServletServer.init(ServletServer.java:530) at com.caucho.server.http.ResinServer.init(ResinServer.java:393) at com.caucho.server.http.ResinServer.main(ResinServer.java:1154) at com.caucho.server.http.HttpServer.main(HttpServer.java:103) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')])) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:149) ... 19 more

    Atlassian JIRA | 1 decade ago | Brian Nguyen (HipChat)
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldScreen][description,Allows to update all system fields.][name,Default Screen][id,1] (SQL Exception while executing the following:INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (?, ?, ?) (Violation of unique index: PK_FIELDSCREEN in statement [INSERT INTO fieldscreen (ID, NAME, DESCRIPTION) VALUES (1, 'Default Screen', 'Allows to update all system fields.')]))
  6. 0

    Steps to recreate: 1) add a custom field with a long (> 255 characters) description 2) attempt to hid the field. You get exceptions as shown below. Workaround: - change the custom field description to be less than 255 characters long. 2005-02-09 10:39:51,011 ERROR [fields.layout.field.DefaultFieldLayoutManager] org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldLayoutItem][fieldidentifier,customfield_10020][fieldlayout,10000][description,Used to represent a t entative assignment of an issue to a person without actually assigning the issue to that person. This allows for project managers to toy with various possible assignments without actually committing to those assignments. The "Export Issues to MS Project Report " uses this field. ][verticalposition,16][ishidden,true][isrequired,false][id,10367] (SQL Exception while executing the following: INSERT INTO public.fieldlayoutitem (ID, FIELDLAYOUT, FIELDIDENTIFIER, DESCRIPTION, VERTICALPOSITION, ISHIDDEN, ISREQUIRED) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255) )) org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldLayoutItem][fieldidentifier,customfield_10020][ fieldlayout,10000][description,Used to represent a tentative assignment of an issue to a person without actually assigning the iss ue to that person. This allows for project managers to toy with various possible assignments without actually committing to those assignments. The "Export Issues to MS Project Report" uses this field. ][verticalposition,16][ishidden,true][isrequired,false][id, 10367] (SQL Exception while executing the following:INSERT INTO public.fieldlayoutitem (ID, FIELDLAYOUT, FIELDIDENTIFIER, DESCRIPT ION, VERTICALPOSITION, ISHIDDEN, ISREQUIRED) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255) )) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.storeEditableFieldLayout(DefaultFieldLayoutManag er.java:152) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.storeEditableDefaultFieldLayout(DefaultFieldLayo utManager.java:109) at com.atlassian.jira.web.action.admin.issuefields.ViewIssueFields.store(ViewIssueFields.java:42) at com.atlassian.jira.web.action.admin.issuefields.AbstractEditFieldLayout.doHide(AbstractEditFieldLayout.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:415) at webwork.action.ActionSupport.execute(ActionSupport.java:144) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:46) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.fieldlayoutitem ( ID, FIELDLAYOUT, FIELDIDENTIFIER, DESCRIPTION, VERTICALPOSITION, ISHIDDEN, ISREQUIRED) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255) ) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:341) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.storeEditableFieldLayout(DefaultFieldLayoutManag er.java:152) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.storeEditableDefaultFieldLayout(DefaultFieldLayo utManager.java:109) at com.atlassian.jira.web.action.admin.issuefields.ViewIssueFields.store(ViewIssueFields.java:42) at com.atlassian.jira.web.action.admin.issuefields.AbstractEditFieldLayout.doHide(AbstractEditFieldLayout.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:415) at webwork.action.ActionSupport.execute(ActionSupport.java:144) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:46) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) java.sql.SQLException: ERROR: value too long for type character varying(255) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:339) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77) at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.storeEditableFieldLayout(DefaultFieldLayoutManag er.java:152) at com.atlassian.jira.issue.fields.layout.field.DefaultFieldLayoutManager.storeEditableDefaultFieldLayout(DefaultFieldLayo utManager.java:109) at com.atlassian.jira.web.action.admin.issuefields.ViewIssueFields.store(ViewIssueFields.java:42) at com.atlassian.jira.web.action.admin.issuefields.AbstractEditFieldLayout.doHide(AbstractEditFieldLayout.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:415) at webwork.action.ActionSupport.execute(ActionSupport.java:144) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:46) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534)

    Atlassian JIRA | 1 decade ago | Mick Hollins
    org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:FieldLayoutItem][fieldidentifier,customfield_10020][ fieldlayout,10000][description,Used to represent a tentative assignment of an issue to a person without actually assigning the iss ue to that person. This allows for project managers to toy with various possible assignments without actually committing to those assignments. The "Export Issues to MS Project Report" uses this field. ][verticalposition,16][ishidden,true][isrequired,false][id, 10367] (SQL Exception while executing the following:INSERT INTO public.fieldlayoutitem (ID, FIELDLAYOUT, FIELDIDENTIFIER, DESCRIPT ION, VERTICALPOSITION, ISHIDDEN, ISREQUIRED) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(255) ))

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.ofbiz.core.entity.GenericEntityException

      while inserting: [GenericEntity:PortalPage][favCount,0][id,10988][username,zahn_d][description,Hier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiertHier wird hinterlegt, welche Kampagnen sich in Einzel-Optimierung befinden. Der Prozess sieht derzeit (Stand 6.11.09) so aus, das analysiert wird, auf welchen Partnern eine Kampagne gut performt um im Anschluss die übrigen Partner weitgehend zu exkludiert][pagename,test] (SQL Exception while executing the following:INSERT INTO portalpage (ID, USERNAME, PAGENAME, DESCRIPTION, SEQUENCE, FAV_COUNT) VALUES (?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'DESCRIPTION' at row 1))

      at org.ofbiz.core.entity.GenericDAO.singleInsert()
    2. org.ofbiz.core
      GenericValue.create
      1. org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:123)
      2. org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
      3. org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
      4. org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:480)
      5. org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:460)
      6. org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
      6 frames
    3. com.atlassian.core
      EntityUtils.createValue
      1. com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
      1 frame
    4. com.atlassian.jira
      AddPortalPage.doExecute
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:329)
      2. com.atlassian.jira.portal.OfBizPortalPageStore.create(OfBizPortalPageStore.java:199)
      3. com.atlassian.jira.portal.CachingPortalPageStore.create(CachingPortalPageStore.java:208)
      4. com.atlassian.jira.portal.DefaultPortalPageManager.create(DefaultPortalPageManager.java:195)
      5. com.atlassian.jira.bc.portal.AbstractPortalPageService.createPortalPage(AbstractPortalPageService.java:214)
      6. com.atlassian.jira.web.action.user.AddPortalPage.createBlankPortalPage(AddPortalPage.java:332)
      7. com.atlassian.jira.web.action.user.AddPortalPage.doExecute(AddPortalPage.java:146)
      7 frames
    5. webwork.action
      ActionSupport.execute
      1. webwork.action.ActionSupport.execute(ActionSupport.java:153)
      1 frame
    6. com.atlassian.jira
      JiraActionSupport.execute
      1. com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54)
      1 frame
    7. webwork.dispatcher
      GenericDispatcher.executeAction
      1. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
      1 frame
    8. com.atlassian.jira
      JiraServletDispatcher.service
      1. com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178)
      1 frame
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      1 frame
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    11. com.atlassian.jira
      AccessLogFilter.doFilter
      1. com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73)
      1 frame
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    13. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
      2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
      2 frames
    14. com.atlassian.jira
      SitemeshExcludePathFilter.doFilter
      1. com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
      1 frame
    15. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    16. com.atlassian.seraph
      SecurityFilter.doFilter
      1. com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192)
      1 frame
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    18. com.atlassian.seraph
      TrustedApplicationsFilter.doFilter
      1. com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120)
      1 frame
    19. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    20. com.atlassian.seraph
      BaseLoginFilter.doFilter
      1. com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125)
      1 frame
    21. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    22. com.atlassian.util
      ProfilingFilter.doFilter
      1. com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      1 frame
    23. com.atlassian.jira
      JIRAProfilingFilter.doFilter
      1. com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
      1 frame
    24. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    25. com.atlassian.jira
      ActionCleanupDelayFilter.doFilter
      1. com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43)
      1 frame
    26. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    27. com.atlassian.jira
      RequestCleanupFilter.doFilter
      1. com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50)
      1 frame
    28. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    29. com.atlassian.johnson
      AbstractJohnsonFilter.doFilter
      1. com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
      1 frame
    30. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    31. UrlRewriteFilter
      UrlRewriteFilter.doFilter
      1. org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
      1 frame
    32. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    33. com.atlassian.gzipfilter
      GzipFilter.doFilter
      1. com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:75)
      2. com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
      2 frames
    34. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    35. com.atlassian.core
      AbstractEncodingFilter.doFilter
      1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
      1 frame
    36. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    37. com.atlassian.jira
      DatabaseCompatibilityEnforcerFilter.doFilter
      1. com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39)
      1 frame
    38. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
      8 frames
    39. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      3 frames
    40. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame