You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Mathieu Lirzin (Jira)" <ji...@apache.org> on 2019/11/08 23:57:00 UTC
[jira] [Reopened] (OFBIZ-11275) bug in depends-on in
ofbiz-component.xml
[ https://issues.apache.org/jira/browse/OFBIZ-11275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mathieu Lirzin reopened OFBIZ-11275:
------------------------------------
Here is the error I got when doing {{gradlew cleanAll loadAll}} after applying [^0003-Fixed-Remove-dependency-management-from-ComponentCon.patch] I am reverting the corresponding commit
{code}
2019-11-09 00:47:42,695 |main |EntityDataLoadContainer |I| =-=-=-=-=-=-= Starting the data load...
2019-11-09 00:47:42,698 |main |EntitySaxReader |I| Beginning import from URL: file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtTypeData.xml
2019-11-09 00:47:42,705 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds)
2019-11-09 00:47:42,755 |main |EntitySaxReader |I| Finished 12 values from file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtTypeData.xml
2019-11-09 00:47:42,755 |main |EntitySaxReader |I| Beginning import from URL: file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml
2019-11-09 00:47:42,757 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds)
2019-11-09 00:47:42,775 |main |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: rollback called in Entity Engine SQLProcessor
at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358) [main/:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185) [main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112) [main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) [main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) [main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304) [main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258) [main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228) [main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) [main/:?]
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:433) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:143) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:107) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:75) [main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:160) [main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71) [main/:?]
at org.apache.ofbiz.base.start.Start.main(Start.java:90) [main/:?]
2019-11-09 00:47:42,782 |main |GenericDelegator |E| Failure in create operation for entity [SecurityGroupPermission]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)). Rolling back transaction.
2019-11-09 00:47:42,782 |main |TransactionUtil |I| Transaction rollback only not set, rollback only is already set.
2019-11-09 00:47:42,782 |main |GenericDelegator |E| Failure in storeAll operation: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))). Rolling back transaction.
org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)))
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304) [main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258) [main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228) [main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) [main/:?]
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:433) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:143) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:107) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:75) [main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:160) [main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71) [main/:?]
at org.apache.ofbiz.base.start.Start.main(Start.java:90) [main/:?]
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
... 14 more
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
... 14 more
Caused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
... 14 more
Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
... 14 more
2019-11-09 00:47:42,783 |main |TransactionUtil |I| Transaction rollback only not set, rollback only is already set.
2019-11-09 00:47:42,784 |main |EntitySaxReader |E| An error occurred saving the data, rolling back transaction (true)
org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))))
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1339) ~[main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258) ~[main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228) [main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) [main/:?]
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:433) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) [main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:143) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:107) [main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:75) [main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:160) [main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71) [main/:?]
at org.apache.ofbiz.base.start.Start.main(Start.java:90) [main/:?]
Caused by: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)))
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304) ~[main/:?]
... 13 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304) ~[main/:?]
... 13 more
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304) ~[main/:?]
... 13 more
Caused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304) ~[main/:?]
... 13 more
Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.14.2.0.jar:?]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110) ~[main/:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304) ~[main/:?]
... 13 more
2019-11-09 00:47:42,799 |main |TransactionUtil |I| Transaction rolled back
org.apache.ofbiz.base.start.StartupException: Cannot init() dataload-container (org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Resource "file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data) ([loadData]: Error loading XML Resource "file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data)))
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:145)
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:107)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:75)
at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:160)
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
at org.apache.ofbiz.base.start.Start.main(Start.java:90)
Caused by: org.apache.ofbiz.base.container.ContainerException: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Resource "file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data) ([loadData]: Error loading XML Resource "file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data))
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:441)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115)
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:143)
... 5 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Resource "file:/home/mthl/src/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data)
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:275)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:433)
... 8 more
Caused by: org.xml.sax.SAXException: A transaction error occurred reading data
org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))))
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:240)
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268)
... 9 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))))
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1339)
at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
... 11 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)) (Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)))
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1304)
... 13 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:SecurityGroupPermission][createdStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][createdTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][fromDate,2001-05-13 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2019-11-09 00:47:42.768(java.sql.Timestamp)][lastUpdatedTxStamp,2019-11-09 00:47:42.757(java.sql.Timestamp)][permissionId,ENTITY_SYNC_ADMIN(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.))
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172)
at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110)
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:67)
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:855)
... 14 more
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OFBIZ.SECURITY_GROUP_PERMISSION (GROUP_ID, PERMISSION_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435)
at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167)
... 17 more
Caused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431)
... 18 more
Caused by: ERROR 23503: INSERT on table 'SECURITY_GROUP_PERMISSION' caused a violation of foreign key constraint 'SEC_GRP_PERM_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 25 more
> Task :ofbiz --load-data FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':ofbiz --load-data'.
> Process 'command '/gnu/store/k77pzd0ha33kv604zkn658sazsr5jxlw-openjdk-12.33-jdk/bin/java'' finished with non-zero exit value 1
* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.
* Get more help at https://help.gradle.org
BUILD FAILED in 3m 19s
19 actionable tasks: 15 executed, 4 up-to-date
{code}
> bug in depends-on in ofbiz-component.xml
> ----------------------------------------
>
> Key: OFBIZ-11275
> URL: https://issues.apache.org/jira/browse/OFBIZ-11275
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Trunk, 18.12.01
> Reporter: Samuel Trégouët
> Assignee: Mathieu Lirzin
> Priority: Major
> Fix For: Trunk
>
> Attachments: 0001-Implemented-Show-dependency-resolution-algorithm-pro.patch, 0002-Implemented-Add-a-generic-directed-graph-utilitary-c.patch, 0003-Fixed-Remove-dependency-management-from-ComponentCon.patch
>
>
> when using `depends-on` tag in obfiz-component.xml one should expect ofbiz to load component (and in particular container listed in ofbiz-component.xml) in particular order.
> I mean if component `accounting` has this line in its ofbiz-component.xml
> {noformat}
> <depends-on component="order" />{noformat}
> ofbiz should load order component first and then accounting. This is not the case. Only classpath is modified according to depends-on declaration (and this is not really a usefull/used feature but we'll see this in another issue ;) )
> So here are patches to fix this issue. First one is only a test (which is skipped to allow ./gradlew test to be ok, so if one need to be convinced one should comment Ignore annotation) to illustrate issue, the two others are actual fixes
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)