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