[ https://issues.apache.org/jira/browse/OFBIZ-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15131900#comment-15131900 ]
Jacques Le Roux commented on OFBIZ-6843: ---------------------------------------- How do I see/set it? It's not in the themes list (https://localhost:8443/catalog/control/ListVisualThemes) so I thought I had to load the data After importing {code} <Enumeration enumId="VT_STYLESHEET_LESS" description="Style Sheet Less URL" enumTypeId="VT_RES_TYPE" sequenceId="25"/> {code} I tried to import themes\rainbowstone\data\RainbowStoneThemeData.xml but got this error: {code} 2016-02-04 08:58:23,173 |http-bio-8443-exec-3 |GenericDelegator |E| Failure in create operation for entity [VisualThemeResource]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)). Rolling back transaction. 2016-02-04 08:58:23,177 |http-bio-8443-exec-3 |GenericDelegator |E| Failure in storeAll operation: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))). Rolling back transaction. org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) [ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) [ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) [ofbiz-entity.jar:?] at javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337) [javolution-5.4.3.jar:5.4.3] at javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100) [javolution-5.4.3.jar:5.4.3] at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:296) [ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248) [ofbiz-entity.jar:?] at org.ofbiz.webtools.WebToolsServices.parseEntityXmlFile(WebToolsServices.java:459) [ofbiz-webtools.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_51] at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz-service.jar:?] at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) [ofbiz-service.jar:?] at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz-service.jar:?] at org.ofbiz.webtools.WebToolsServices.entityImport(WebToolsServices.java:200) [ofbiz-webtools.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_51] at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz-service.jar:?] at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) [ofbiz-service.jar:?] at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz-service.jar:?] at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:340) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:739) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:460) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:88) [ofbiz-webapp.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) [servlet-api-3.0.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) [servlet-api-3.0.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [tomcat-7.0.65-catalina.jar:7.0.65] at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:323) [ofbiz-webapp.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_51] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_51] Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:179) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] ... 54 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] ... 54 more Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] ... 54 more Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] ... 54 more 2016-02-04 08:58:23,178 |http-bio-8443-exec-3 |EntitySaxReader |E| Error storing value org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) (org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)))) at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1347) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) [ofbiz-entity.jar:?] at javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337) [javolution-5.4.3.jar:5.4.3] at javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100) [javolution-5.4.3.jar:5.4.3] at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:296) [ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248) [ofbiz-entity.jar:?] at org.ofbiz.webtools.WebToolsServices.parseEntityXmlFile(WebToolsServices.java:459) [ofbiz-webtools.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_51] at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz-service.jar:?] at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) [ofbiz-service.jar:?] at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz-service.jar:?] at org.ofbiz.webtools.WebToolsServices.entityImport(WebToolsServices.java:200) [ofbiz-webtools.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_51] at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz-service.jar:?] at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) [ofbiz-service.jar:?] at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz-service.jar:?] at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:340) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:739) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:460) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:88) [ofbiz-webapp.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) [servlet-api-3.0.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) [servlet-api-3.0.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [tomcat-7.0.65-catalina.jar:7.0.65] at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:323) [ofbiz-webapp.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_51] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_51] Caused by: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] ... 53 more Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:179) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] ... 53 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] ... 53 more Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] ... 53 more Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] ... 53 more 2016-02-04 08:58:23,179 |http-bio-8443-exec-3 |EntitySaxReader |E| An error occurred saving the data, rolling back transaction (true) org.xml.sax.SAXException: Error storing value at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:519) ~[ofbiz-entity.jar:?] at javolution.xml.sax.XMLReaderImpl.parseAll(XMLReaderImpl.java:337) ~[javolution-5.4.3.jar:5.4.3] at javolution.xml.sax.XMLReaderImpl.parse(XMLReaderImpl.java:100) ~[javolution-5.4.3.jar:5.4.3] at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:296) [ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248) [ofbiz-entity.jar:?] at org.ofbiz.webtools.WebToolsServices.parseEntityXmlFile(WebToolsServices.java:459) [ofbiz-webtools.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_51] at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz-service.jar:?] at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) [ofbiz-service.jar:?] at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz-service.jar:?] at org.ofbiz.webtools.WebToolsServices.entityImport(WebToolsServices.java:200) [ofbiz-webtools.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_51] at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) [ofbiz-service.jar:?] at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) [ofbiz-service.jar:?] at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) [ofbiz-service.jar:?] at org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz-service.jar:?] at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:340) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:739) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:460) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) [ofbiz-webapp.jar:?] at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:88) [ofbiz-webapp.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) [servlet-api-3.0.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) [servlet-api-3.0.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [tomcat-7.0.65-catalina.jar:7.0.65] at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:323) [ofbiz-webapp.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) [tomcat-7.0.65-catalina.jar:7.0.65] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_51] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-7.0.65-tomcat-coyote.jar:7.0.65] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_51] Caused by: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) (org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)))) at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1347) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) ~[ofbiz-entity.jar:?] ... 51 more Caused by: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) ~[ofbiz-entity.jar:?] ... 51 more Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:179) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) ~[ofbiz-entity.jar:?] ... 51 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) ~[ofbiz-entity.jar:?] ... 51 more Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) ~[ofbiz-entity.jar:?] ... 51 more Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.jar:2.1] at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:879) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1312) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329) ~[ofbiz-entity.jar:?] at org.ofbiz.entity.util.EntitySaxReader.endElement(EntitySaxReader.java:504) ~[ofbiz-entity.jar:?] ... 51 more 2016-02-04 08:58:23,224 |http-bio-8443-exec-3 |ServiceDispatcher |E| Error in Service [parseEntityXmlFile]: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading data org.xml.sax.SAXException: Error storing value org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) (org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)))) 2016-02-04 08:58:23,228 |http-bio-8443-exec-3 |ServiceDispatcher |E| Error in Service [entityImport]: ERREUR : Lors de l'analyse du fichier (ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading data org.xml.sax.SAXException: Error storing value org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) (org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))))) 2016-02-04 08:58:23,229 |http-bio-8443-exec-3 |RequestHandler |E| Request entityImport caused an error with the following message: ERREUR : Lors de l'analyse du fichier (ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading data org.xml.sax.SAXException: Error storing value org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))) (org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.)) (Error while inserting: [GenericEntity:VisualThemeResource][createdStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][createdTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][lastUpdatedStamp,2016-02-04 08:58:23.171(java.sql.Timestamp)][lastUpdatedTxStamp,2016-02-04 08:58:23.126(java.sql.Timestamp)][resourceTypeEnumId,VT_CHPWD_TMPLT_LOC(java.lang.String)][resourceValue,component://rainbowstone/includes/templates/changePassword.ftl(java.lang.String)][sequenceId,01(java.lang.String)][visualThemeId,RAINBOWSTONE_SAPHIR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.VISUAL_THEME_RESOURCE (VISUAL_THEME_ID, RESOURCE_TYPE_ENUM_ID, SEQUENCE_ID, RESOURCE_VALUE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'VISUAL_THEME_RESOURCE' caused a violation of foreign key constraint 'VT_RES_TYPE_ENUM' for key (VT_CHPWD_TMPLT_LOC). The statement has been rolled back.))))) {code} I have no time to debug, what do I miss? > New theme Rainbow Stone > ----------------------- > > Key: OFBIZ-6843 > URL: https://issues.apache.org/jira/browse/OFBIZ-6843 > Project: OFBiz > Issue Type: Improvement > Components: themes > Reporter: Julien NICOLAS > Assignee: Julien NICOLAS > Priority: Minor > Labels: features, theme > Fix For: Trunk > > Attachments: patch3rainbowstone.patch, rainbowstone.tar.gz, > screenshot-1.png > > > I create a new theme based on Flat Grey. > It's the beginning but already functional, my goal is to provide a new style > for OFBiz. > This is my tastes, so don't hesitate to criticize :) -- This message was sent by Atlassian JIRA (v6.3.4#6332)