[
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)
