ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Derek Lew <eucalyptussoftw...@hotmail.com>
Subject RE: Ofbiz 14.12 Multi tenant issue
Date Fri, 13 Nov 2015 13:07:26 GMT
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:pierre.smits@gmail.com] 
Sent: Friday, 13 November 2015 7:22 PM
To: user@ofbiz.apache.org
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 <eucalyptussoftware@hotmail.com>
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:pierre.smits@gmail.com]
> Sent: Thursday, 12 November 2015 11:28 PM
> To: user@ofbiz.apache.org
> 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 
> <eucalyptussoftware@hotmail.com
> >
> wrote:
>
> > Hi Pierre,
> >
> > I have used ./ant create-tenant instead, but could not start it up.
> >
> > Best regards,
> >
> > Derek
> >
>

Mime
View raw message