Hi,
I have gotten these errors.
2015-11-13 20:59:43,130 |OFBiz-batch-2 |DatabaseUtil
|I| Error getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
2015-11-13 20:59:43,130 |OFBiz-batch-1 |DatabaseUtil
|I| Error getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
2015-11-13 20:59:43,146 |OFBiz-batch-2 |DatabaseUtil
|I| Searching in 6 tables for primary key fields ...
2015-11-13 20:59:43,159 |OFBiz-batch-1 |DatabaseUtil
|I| Searching in 5 tables for primary key fields ...
2015-11-13 20:59:43,179 |OFBiz-batch-3 |DatabaseUtil
|I| Getting Column Info From Database
2015-11-13 20:59:43,196 |OFBiz-batch-2 |DatabaseUtil
|I| Reviewed 8 primary key fields from database.
2015-11-13 20:59:43,199 |OFBiz-batch-1 |DatabaseUtil
|I| Reviewed 7 primary key fields from database.
2015-11-13 20:59:43,907 |OFBiz-batch-3 |DatabaseUtil
|I| Error getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
2015-11-13 20:59:43,918 |OFBiz-batch-3 |DatabaseUtil
|I| Searching in 861 tables for primary key fields ...
2015-11-13 20:59:44,805 |OFBiz-batch-3 |GenericDelegator
|I| Can't access entity of entityGroup = org.ofbiz.tenant using tenant
delegator default#demo1, use base delegator instead
2015-11-13 20:59:44,805 |OFBiz-batch-3 |GenericDelegator
|I| Delegator "default#demo1" NOT initializing helper for entity group
"org.ofbiz.tenant" because the group is not associated to this delegator.
2015-11-13 21:00:01,197 |OFBiz-batch-4 |DatabaseUtil
|I| Getting Table Info From Database
2015-11-13 21:00:01,270 |OFBiz-batch-4 |DatabaseUtil
|I| Getting Column Info From Database
2015-11-13 21:00:01,835 |OFBiz-batch-4 |DatabaseUtil
|I| Error getting primary key info from database with null tableName, will try
other means: java.sql.SQLException: Table name can not be null
2015-11-13 21:00:01,868 |OFBiz-batch-4 |DatabaseUtil
|I| Searching in 861 tables for primary key fields ...
2015-11-13 21:00:26,823 |main |EntityDataLoadContainer
|I| =-=-=-=-=-=-= Doing a data load using delegator 'default#demo1' with the
following files:
2015-11-13 21:00:26,823 |main |EntityDataLoadContainer
|I| file:/E:/OfBiz14.12/runtime/tmp/tmpUserLogin.xml
2015-11-13 21:00:26,823 |main |EntityDataLoadContainer
|I| =-=-=-=-=-=-= Starting the data load...
2015-11-13 21:00:26,829 |main |EntitySaxReader
|I| Beginning import from URL: file:/E:/OfBiz14.12/runtime/tmp/tmpUserLogin.xml
2015-11-13 21:00:26,857 |main |EntitySaxReader
|I| Transaction Timeout set to 2 hours (7200 seconds)
2015-11-13 21:00:26,960 |main |GenericDelegator
|E| Failure in create operation for entity [UserLoginSecurityGroup]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)). Rolling back transaction.
2015-11-13 21:00:26,961 |main |TransactionUtil
|W| Calling transaction setRollbackOnly; this stack trace shows where this is
happening:
java.lang.Exception: Failure in create operation for entity
[UserLoginSecurityGroup]: org.ofbiz.entity.GenericEntityException: Error while
inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)). Rolling back transaction.
at
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:360)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:301)
[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:925)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:490)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:245)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:237)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:343)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:369) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:136) [ofbiz.jar:?]
2015-11-13 21:00:26,964 |main |GenericDelegator
|E| Failure in storeAll operation: org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.))). Rolling back transaction.
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)))
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:926)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:490)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:245)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:237)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:343)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:369) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:136) [ofbiz.jar:?]
Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.))
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:179)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
... 11 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:INSERT INTO OFBIZ.USER_LOGIN_SECURITY_GROUP
(USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP' caused a violation of
foreign key constraint 'USER_SECGRP_GRP' for key (SUPER). The statement has
been rolled back.)
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
... 11 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table
'USER_LOGIN_SECURITY_GROUP' caused a violation of foreign key constraint
'USER_SECGRP_GRP' for key (SUPER). The statement has been rolled back.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
~[derby-10.11.1.1.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
... 11 more
Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table
'USER_LOGIN_SECURITY_GROUP' caused a violation of foreign key constraint
'USER_SECGRP_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
~[derby-10.11.1.1.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
... 11 more
2015-11-13 21:00:26,965 |main |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2015-11-13 21:00:26,965 |main |EntitySaxReader
|E| An error occurred saving the data, rolling back transaction (true)
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)))
(org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.))))
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1482)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:490)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:245)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:237)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:343)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:369) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:136) [ofbiz.jar:?]
Caused by: org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)))
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:926)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
... 10 more
Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.))
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:179)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
... 10 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:INSERT INTO OFBIZ.USER_LOGIN_SECURITY_GROUP
(USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP' caused a violation of
foreign key constraint 'USER_SECGRP_GRP' for key (SUPER). The statement has
been rolled back.)
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
... 10 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table
'USER_LOGIN_SECURITY_GROUP' caused a violation of foreign key constraint
'USER_SECGRP_GRP' for key (SUPER). The statement has been rolled back.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
~[derby-10.11.1.1.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
... 10 more
Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table
'USER_LOGIN_SECURITY_GROUP' caused a violation of foreign key constraint
'USER_SECGRP_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
~[derby-10.11.1.1.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
... 10 more
2015-11-13 21:00:26,971 |main |TransactionUtil
|I| Transaction rolled back
2015-11-13 21:00:26,971 |main |EntityDataLoader
|E| [loadData]: Error loading XML Resource
"file:/E:/OfBiz14.12/runtime/tmp/tmpUserLogin.xml"; Error was: A transaction
error occurred reading data
org.xml.sax.SAXException: A transaction error occurred reading data
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:311)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:248)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:257)
[ofbiz-entity.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:490)
[ofbiz-entityext.jar:?]
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:245)
[ofbiz-entityext.jar:?]
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:237)
[ofbiz-base.jar:?]
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:343)
[ofbiz.jar:?]
at org.ofbiz.base.start.Start.start(Start.java:369) [ofbiz.jar:?]
at org.ofbiz.base.start.Start.main(Start.java:136) [ofbiz.jar:?]
Caused by: org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)))
(org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.))))
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1482)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
~[ofbiz-entity.jar:?]
... 8 more
Caused by: org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)) (Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.)))
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:926)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
~[ofbiz-entity.jar:?]
... 8 more
Caused by: org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:UserLoginSecurityGroup][createdStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][createdTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][fromDate,2001-01-01
12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2015-11-13
21:00:26.947(java.sql.Timestamp)][lastUpdatedTxStamp,2015-11-13
21:00:26.857(java.sql.Timestamp)][userLoginId,demo1-admin(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.USER_LOGIN_SECURITY_GROUP (USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP'
caused a violation of foreign key constraint 'USER_SECGRP_GRP' for key (SUPER).
The statement has been rolled back.))
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:179)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
~[ofbiz-entity.jar:?]
... 8 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:INSERT INTO OFBIZ.USER_LOGIN_SECURITY_GROUP
(USER_LOGIN_ID, GROUP_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?) (INSERT on table 'USER_LOGIN_SECURITY_GROUP' caused a violation of
foreign key constraint 'USER_SECGRP_GRP' for key (SUPER). The statement has
been rolled back.)
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
~[ofbiz-entity.jar:?]
... 8 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT on table
'USER_LOGIN_SECURITY_GROUP' caused a violation of foreign key constraint
'USER_SECGRP_GRP' for key (SUPER). The statement has been rolled back.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
~[derby-10.11.1.1.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
~[ofbiz-entity.jar:?]
... 8 more
Caused by: org.apache.derby.iapi.error.StandardException: INSERT on table
'USER_LOGIN_SECURITY_GROUP' caused a violation of foreign key constraint
'USER_SECGRP_GRP' for key (SUPER). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.11.1.1.jar:?]
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
~[derby-10.11.1.1.jar:?]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:174)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:116)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:902)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1447)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:329)
~[ofbiz-entity.jar:?]
at
org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299)
~[ofbiz-entity.jar:?]
... 8 more
2015-11-13 21:00:26,972 |main |EntityDataLoadContainer
|I| =-=-=-=-=-=-= Here is a summary of the data load:
2015-11-13 21:00:26,972 |main |EntityDataLoadContainer
|I| 00000 of 00000 from file:/E:/OfBiz14.12/runtime/tmp/tmpUserLogin.xml
2015-11-13 21:00:26,972 |main |EntityDataLoadContainer
|I| The following errors occurred in the data load:
2015-11-13 21:00:26,972 |main |EntityDataLoadContainer
|I| [loadData]: Error loading XML Resource
"file:/E:/OfBiz14.12/runtime/tmp/tmpUserLogin.xml"; Error was: A transaction
error occurred reading data
2015-11-13 21:00:26,972 |main |EntityDataLoadContainer
|I| =-=-=-=-=-=-= Finished the data load with 0 rows changed.
-----Original Message-----
From: Pierre Smits [mailto:[email protected]]
Sent: Friday, 13 November 2015 7:22 PM
To: [email protected]
Subject: Re: Ofbiz 14.12 Multi tenant issue
Hi Derek,
I used localhost there. Some systems don't use 127.0.0.1, but have variations
thereon.
Best regards,
Pierre Smits
*OFBiz Extensions Marketplace*
http://oem.ofbizci.net/oci-2/
On Fri, Nov 13, 2015 at 12:00 PM, Derek Lew <[email protected]>
wrote:
> Pierre,
>
> Steps 1 to 3, I am ok.
>
> Step 4:
> a) Enter Id for the tenant: demo1
> b) Enter name for the tenant: demo1
> c) Enter domain name for tenant (Optional): (skip)
> d) Enter data to install: demo
> e) Select your default database platform: D
> f) Enter IP address of the database server (you may add a port number):
> 127.0.0.1
> g) Enter userID of database user: ofbiz
> h) Enter password of database user: ofbiz
>
> I think step 4f) is the mistake.
>
> Please advice.
>
> Best regards,
>
> Derek Lew
>
>
> -----Original Message-----
> From: Pierre Smits [mailto:[email protected]]
> Sent: Thursday, 12 November 2015 11:28 PM
> To: [email protected]
> Subject: Re: Ofbiz 14.12 Multi tenant issue
>
> Derek,
>
> In a fresh check-out of OFBiz R14.12 I performed following actions:
>
> 1. ./ant clean-all - to get rid of any unwanted bagage
> 2. ./ant build
> 3. ./ant load-demo - ensure that all demo data loads perfectly and be
> able to test the master environment
> 4. ./ant create-tenant - defining the tenant and the adminId for the
> tenant, I only selected
> 5. adjust the 'multitenant=N' setting in the general.properties file to
> 'multitenant=Y' to enable login into a tenant
> 6. ./ant start
>
> Subsequently I started up a new browser session and used
> https://localhost:8443/webtools/control/entitymaint
> I saw the 3 fields of the login form and provided my details:
>
> userid: t01-admin
>
> password: ofbiz
>
> tenantId: t01
>
> This went well, as I was presented with a 'change password' form,
> where I provided the existing (ofbiz) and new passwords in order to continue.
>
> This all performed without issue.
>
> Maybe you should outline the steps you undertook, so that the
> community can help you better?
>
> Best regards,
>
>
> Pierre Smits
>
> *OFBiz Extensions Marketplace*
> http://oem.ofbizci.net/oci-2/
>
> On Thu, Nov 12, 2015 at 2:07 PM, Derek Lew
> <[email protected]
> >
> wrote:
>
> > Hi Pierre,
> >
> > I have used ./ant create-tenant instead, but could not start it up.
> >
> > Best regards,
> >
> > Derek
> >
>
