Ofbiz 14.12 Multi tenant issue

[Derek Lew-2]

Hi

 

I was trying 14.12, with the multi-tenant option enabled.  After compiling,
loaded the data, and started, this is what I got.

 

2015-11-12 08:12:41,853 |OFBiz-batch-6        |DatabaseUtil
|E| Error adding foreign key: ModelEntity was null for related entity name
Tenant

2015-11-12 08:17:50,275 |main                 |GenericDelegator
|E| Failure in storeAll operation: org.ofbiz.entity.GenericEntityException:
There is no datasource (Helper) configured for the entity-group
[org.ofbiz.tenant]; was trying to find datasource (helper) for entity
[Tenant]. Rolling back transaction.

org.ofbiz.entity.GenericEntityException: There is no datasource (Helper)
configured for the entity-group [org.ofbiz.tenant]; was trying to find
datasource (helper) for entity [Tenant]

                at
org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:544)
~[ofbiz-entity.jar:?]

                at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
[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(EntityDataLoa
dContainer.java:490) [ofbiz-entityext.jar:?]

                at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContain
er.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-12 08:17:50,278 |main                 |EntitySaxReader
|E| An error occurred saving the data, rolling back transaction (true)

org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: There is no datasource (Helper)
configured for the entity-group [org.ofbiz.tenant]; was trying to find
datasource (helper) for entity [Tenant] (There is no datasource (Helper)
configured for the entity-group [org.ofbiz.tenant]; was trying to find
datasource (helper) for entity [Tenant])

                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(EntityDataLoa
dContainer.java:490) [ofbiz-entityext.jar:?]

                at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContain
er.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: There is no datasource
(Helper) configured for the entity-group [org.ofbiz.tenant]; was trying to
find datasource (helper) for entity [Tenant]

                at
org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:544)
~[ofbiz-entity.jar:?]

                at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
~[ofbiz-entity.jar:?]

                ... 10 more

2015-11-12 08:17:50,282 |main                 |EntityDataLoader
|E| [loadData]: Error loading XML Resource
"file:/E:/OfBiz14.12/framework/entity/data/TenantDemoData.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(EntityDataLoa
dContainer.java:490) [ofbiz-entityext.jar:?]

                at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContain
er.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: There is no datasource (Helper)
configured for the entity-group [org.ofbiz.tenant]; was trying to find
datasource (helper) for entity [Tenant] (There is no datasource (Helper)
configured for the entity-group [org.ofbiz.tenant]; was trying to find
datasource (helper) for entity [Tenant])

                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: There is no datasource
(Helper) configured for the entity-group [org.ofbiz.tenant]; was trying to
find datasource (helper) for entity [Tenant]

                at
org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:544)
~[ofbiz-entity.jar:?]

                at
org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
~[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

 

Best regards.
 
Derek Lew 刘绍雄

 

[Jacques Le Roux]

Hi,

By loading the data what do you mean exactly? Did you follow recent Pierre Smit's advices on this? I mean like using ./ant create-tenant and checking
other related tenant ant targets with ant -p ?

Jacques

Le 12/11/2015 02:26, Derek Lew a écrit :

> Hi
>
>  
>
> I was trying 14.12, with the multi-tenant option enabled.  After compiling,
> loaded the data, and started, this is what I got.
>
>  
>
> 2015-11-12 08:12:41,853 |OFBiz-batch-6        |DatabaseUtil
> |E| Error adding foreign key: ModelEntity was null for related entity name
> Tenant
>
> 2015-11-12 08:17:50,275 |main                 |GenericDelegator
> |E| Failure in storeAll operation: org.ofbiz.entity.GenericEntityException:
> There is no datasource (Helper) configured for the entity-group
> [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
> [Tenant]. Rolling back transaction.
>
> org.ofbiz.entity.GenericEntityException: There is no datasource (Helper)
> configured for the entity-group [org.ofbiz.tenant]; was trying to find
> datasource (helper) for entity [Tenant]
>
>                  at
> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:544)
> ~[ofbiz-entity.jar:?]
>
>                  at
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> [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(EntityDataLoa
> dContainer.java:490) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContain
> er.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-12 08:17:50,278 |main                 |EntitySaxReader
> |E| An error occurred saving the data, rolling back transaction (true)
>
> org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException: There is no datasource (Helper)
> configured for the entity-group [org.ofbiz.tenant]; was trying to find
> datasource (helper) for entity [Tenant] (There is no datasource (Helper)
> configured for the entity-group [org.ofbiz.tenant]; was trying to find
> datasource (helper) for entity [Tenant])
>
>                  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(EntityDataLoa
> dContainer.java:490) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContain
> er.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: There is no datasource
> (Helper) configured for the entity-group [org.ofbiz.tenant]; was trying to
> find datasource (helper) for entity [Tenant]
>
>                  at
> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:544)
> ~[ofbiz-entity.jar:?]
>
>                  at
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> ~[ofbiz-entity.jar:?]
>
>                  ... 10 more
>
> 2015-11-12 08:17:50,282 |main                 |EntityDataLoader
> |E| [loadData]: Error loading XML Resource
> "file:/E:/OfBiz14.12/framework/entity/data/TenantDemoData.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(EntityDataLoa
> dContainer.java:490) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContain
> er.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: There is no datasource (Helper)
> configured for the entity-group [org.ofbiz.tenant]; was trying to find
> datasource (helper) for entity [Tenant] (There is no datasource (Helper)
> configured for the entity-group [org.ofbiz.tenant]; was trying to find
> datasource (helper) for entity [Tenant])
>
>                  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: There is no datasource
> (Helper) configured for the entity-group [org.ofbiz.tenant]; was trying to
> find datasource (helper) for entity [Tenant]
>
>                  at
> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.java:544)
> ~[ofbiz-entity.jar:?]
>
>                  at
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> ~[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
>
>  
>
> Best regards.
>    
> Derek Lew 刘绍雄
>
>  
>
>

[Derek Lew-2]

In Eclipse, click on Ant Clean All, Ant Build, Ant Load Demo Multitenant.

-----Original Message-----
From: Jacques Le Roux [mailto:[hidden email]]
Sent: Thursday, 12 November 2015 3:18 PM
To: [hidden email]
Subject: Re: Ofbiz 14.12 Multi tenant issue

Hi,

By loading the data what do you mean exactly? Did you follow recent Pierre Smit's advices on this? I mean like using ./ant create-tenant and checking other related tenant ant targets with ant -p ?

Jacques

Le 12/11/2015 02:26, Derek Lew a écrit :

> Hi
>
>  
>
> I was trying 14.12, with the multi-tenant option enabled.  After
> compiling, loaded the data, and started, this is what I got.
>
>  
>
> 2015-11-12 08:12:41,853 |OFBiz-batch-6        |DatabaseUtil
> |E| Error adding foreign key: ModelEntity was null for related entity
> |E| name
> Tenant
>
> 2015-11-12 08:17:50,275 |main                 |GenericDelegator
> |E| Failure in storeAll operation: org.ofbiz.entity.GenericEntityException:
> There is no datasource (Helper) configured for the entity-group
> [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
> [Tenant]. Rolling back transaction.
>
> org.ofbiz.entity.GenericEntityException: There is no datasource
> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> trying to find datasource (helper) for entity [Tenant]
>
>                  at
> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
> a:544)
> ~[ofbiz-entity.jar:?]
>
>                  at
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> [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(EntityD
> ataLoa
> dContainer.java:490) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
> ontain
> er.java:245) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
> 7)
> [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-12 08:17:50,278 |main                 |EntitySaxReader
> |E| An error occurred saving the data, rolling back transaction (true)
>
> org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException: There is no datasource
> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> trying to find datasource (helper) for entity [Tenant] (There is no
> datasource (Helper) configured for the entity-group
> [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
> [Tenant])
>
>                  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(EntityD
> ataLoa
> dContainer.java:490) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
> ontain
> er.java:245) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
> 7)
> [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: There is no
> datasource
> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> trying to find datasource (helper) for entity [Tenant]
>
>                  at
> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
> a:544)
> ~[ofbiz-entity.jar:?]
>
>                  at
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> ~[ofbiz-entity.jar:?]
>
>                  ... 10 more
>
> 2015-11-12 08:17:50,282 |main                 |EntityDataLoader
> |E| [loadData]: Error loading XML Resource
> "file:/E:/OfBiz14.12/framework/entity/data/TenantDemoData.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(EntityD
> ataLoa
> dContainer.java:490) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
> ontain
> er.java:245) [ofbiz-entityext.jar:?]
>
>                  at
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
> 7)
> [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: There is no datasource
> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> trying to find datasource (helper) for entity [Tenant] (There is no
> datasource (Helper) configured for the entity-group
> [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
> [Tenant])
>
>                  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: There is no
> datasource
> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> trying to find datasource (helper) for entity [Tenant]
>
>                  at
> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
> a:544)
> ~[ofbiz-entity.jar:?]
>
>                  at
> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> ~[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
>
>  
>
> Best regards.
>    
> Derek Lew 刘绍雄
>
>  
>
>

[Pierre Smits]

Derek,

Don't use ./ant load-demo-multi-tenant. Go with the ./ant create-tenant in
stead.

See https://issues.apache.org/jira/browse/OFBIZ-5757

Best regards,

Pierre Smits

*OFBiz Extensions Marketplace*
http://oem.ofbizci.net/oci-2/

On Thu, Nov 12, 2015 at 9:25 AM, Derek Lew <[hidden email]>
wrote:

> In Eclipse, click on Ant Clean All, Ant Build, Ant Load Demo Multitenant.
>
> -----Original Message-----
> From: Jacques Le Roux [mailto:[hidden email]]
> Sent: Thursday, 12 November 2015 3:18 PM
> To: [hidden email]
> Subject: Re: Ofbiz 14.12 Multi tenant issue
>
> Hi,
>
> By loading the data what do you mean exactly? Did you follow recent Pierre
> Smit's advices on this? I mean like using ./ant create-tenant and checking
> other related tenant ant targets with ant -p ?
>
> Jacques
>
> Le 12/11/2015 02:26, Derek Lew a écrit :
> > Hi
> >
> >
> >
> > I was trying 14.12, with the multi-tenant option enabled.  After
> > compiling, loaded the data, and started, this is what I got.
> >
> >
> >
> > 2015-11-12 08:12:41,853 |OFBiz-batch-6        |DatabaseUtil
> > |E| Error adding foreign key: ModelEntity was null for related entity
> > |E| name
> > Tenant
> >
> > 2015-11-12 08:17:50,275 |main                 |GenericDelegator
> > |E| Failure in storeAll operation:
> org.ofbiz.entity.GenericEntityException:
> > There is no datasource (Helper) configured for the entity-group
> > [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
> > [Tenant]. Rolling back transaction.
> >
> > org.ofbiz.entity.GenericEntityException: There is no datasource
> > (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> > trying to find datasource (helper) for entity [Tenant]
> >
> >                  at
> > org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
> > a:544)
> > ~[ofbiz-entity.jar:?]
> >
> >                  at
> > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> > [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(EntityD
> > ataLoa
> > dContainer.java:490) [ofbiz-entityext.jar:?]
> >
> >                  at
> > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
> > ontain
> > er.java:245) [ofbiz-entityext.jar:?]
> >
> >                  at
> > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
> > 7)
> > [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-12 08:17:50,278 |main                 |EntitySaxReader
> > |E| An error occurred saving the data, rolling back transaction (true)
> >
> > org.ofbiz.entity.GenericEntityException:
> > org.ofbiz.entity.GenericEntityException: There is no datasource
> > (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> > trying to find datasource (helper) for entity [Tenant] (There is no
> > datasource (Helper) configured for the entity-group
> > [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
> > [Tenant])
> >
> >                  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(EntityD
> > ataLoa
> > dContainer.java:490) [ofbiz-entityext.jar:?]
> >
> >                  at
> > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
> > ontain
> > er.java:245) [ofbiz-entityext.jar:?]
> >
> >                  at
> > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
> > 7)
> > [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: There is no
> > datasource
> > (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> > trying to find datasource (helper) for entity [Tenant]
> >
> >                  at
> > org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
> > a:544)
> > ~[ofbiz-entity.jar:?]
> >
> >                  at
> > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> > ~[ofbiz-entity.jar:?]
> >
> >                  ... 10 more
> >
> > 2015-11-12 08:17:50,282 |main                 |EntityDataLoader
> > |E| [loadData]: Error loading XML Resource
> > "file:/E:/OfBiz14.12/framework/entity/data/TenantDemoData.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(EntityD
> > ataLoa
> > dContainer.java:490) [ofbiz-entityext.jar:?]
> >
> >                  at
> > org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
> > ontain
> > er.java:245) [ofbiz-entityext.jar:?]
> >
> >                  at
> > org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
> > 7)
> > [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: There is no datasource
> > (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> > trying to find datasource (helper) for entity [Tenant] (There is no
> > datasource (Helper) configured for the entity-group
> > [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
> > [Tenant])
> >
> >                  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: There is no
> > datasource
> > (Helper) configured for the entity-group [org.ofbiz.tenant]; was
> > trying to find datasource (helper) for entity [Tenant]
> >
> >                  at
> > org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
> > a:544)
> > ~[ofbiz-entity.jar:?]
> >
> >                  at
> > org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
> > ~[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
> >
> >
> >
> > Best regards.
> >
> > Derek Lew 刘绍雄
> >
> >
> >
> >
>

[Jacques Le Roux]

Thanks Pierre, I will complete OFBIZ-5757 !

Jacques

Le 12/11/2015 10:03, Pierre Smits a écrit :

> Derek,
>
> Don't use ./ant load-demo-multi-tenant. Go with the ./ant create-tenant in
> stead.
>
> See https://issues.apache.org/jira/browse/OFBIZ-5757
>
> Best regards,
>
> Pierre Smits
>
> *OFBiz Extensions Marketplace*
> http://oem.ofbizci.net/oci-2/
>
> On Thu, Nov 12, 2015 at 9:25 AM, Derek Lew <[hidden email]>
> wrote:
>
>> In Eclipse, click on Ant Clean All, Ant Build, Ant Load Demo Multitenant.
>>
>> -----Original Message-----
>> From: Jacques Le Roux [mailto:[hidden email]]
>> Sent: Thursday, 12 November 2015 3:18 PM
>> To: [hidden email]
>> Subject: Re: Ofbiz 14.12 Multi tenant issue
>>
>> Hi,
>>
>> By loading the data what do you mean exactly? Did you follow recent Pierre
>> Smit's advices on this? I mean like using ./ant create-tenant and checking
>> other related tenant ant targets with ant -p ?
>>
>> Jacques
>>
>> Le 12/11/2015 02:26, Derek Lew a écrit :
>>> Hi
>>>
>>>
>>>
>>> I was trying 14.12, with the multi-tenant option enabled.  After
>>> compiling, loaded the data, and started, this is what I got.
>>>
>>>
>>>
>>> 2015-11-12 08:12:41,853 |OFBiz-batch-6        |DatabaseUtil
>>> |E| Error adding foreign key: ModelEntity was null for related entity
>>> |E| name
>>> Tenant
>>>
>>> 2015-11-12 08:17:50,275 |main                 |GenericDelegator
>>> |E| Failure in storeAll operation:
>> org.ofbiz.entity.GenericEntityException:
>>> There is no datasource (Helper) configured for the entity-group
>>> [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
>>> [Tenant]. Rolling back transaction.
>>>
>>> org.ofbiz.entity.GenericEntityException: There is no datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
>>> a:544)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
>>> [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(EntityD
>>> ataLoa
>>> dContainer.java:490) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
>>> ontain
>>> er.java:245) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
>>> 7)
>>> [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-12 08:17:50,278 |main                 |EntitySaxReader
>>> |E| An error occurred saving the data, rolling back transaction (true)
>>>
>>> org.ofbiz.entity.GenericEntityException:
>>> org.ofbiz.entity.GenericEntityException: There is no datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant] (There is no
>>> datasource (Helper) configured for the entity-group
>>> [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
>>> [Tenant])
>>>
>>>                   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(EntityD
>>> ataLoa
>>> dContainer.java:490) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
>>> ontain
>>> er.java:245) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
>>> 7)
>>> [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: There is no
>>> datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
>>> a:544)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   ... 10 more
>>>
>>> 2015-11-12 08:17:50,282 |main                 |EntityDataLoader
>>> |E| [loadData]: Error loading XML Resource
>>> "file:/E:/OfBiz14.12/framework/entity/data/TenantDemoData.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(EntityD
>>> ataLoa
>>> dContainer.java:490) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadC
>>> ontain
>>> er.java:245) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:23
>>> 7)
>>> [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: There is no datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant] (There is no
>>> datasource (Helper) configured for the entity-group
>>> [org.ofbiz.tenant]; was trying to find datasource (helper) for entity
>>> [Tenant])
>>>
>>>                   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: There is no
>>> datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.jav
>>> a:544)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1429)
>>> ~[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
>>>
>>>
>>>
>>> Best regards.
>>>
>>> Derek Lew 刘绍雄
>>>
>>>
>>>
>>>

[Derek Lew-2]

Hi Pierre,

I have used ./ant create-tenant instead, but could not start it up.

Best regards,

Derek

-----Original Message-----
From: Jacques Le Roux [mailto:[hidden email]]
Sent: Thursday, 12 November 2015 5:44 PM
To: [hidden email]
Subject: Re: Ofbiz 14.12 Multi tenant issue

Thanks Pierre, I will complete OFBIZ-5757 !

Jacques

Le 12/11/2015 10:03, Pierre Smits a écrit :

> Derek,
>
> Don't use ./ant load-demo-multi-tenant. Go with the ./ant
> create-tenant in stead.
>
> See https://issues.apache.org/jira/browse/OFBIZ-5757
>
> Best regards,
>
> Pierre Smits
>
> *OFBiz Extensions Marketplace*
> http://oem.ofbizci.net/oci-2/
>
> On Thu, Nov 12, 2015 at 9:25 AM, Derek Lew
> <[hidden email]>
> wrote:
>
>> In Eclipse, click on Ant Clean All, Ant Build, Ant Load Demo Multitenant.
>>
>> -----Original Message-----
>> From: Jacques Le Roux [mailto:[hidden email]]
>> Sent: Thursday, 12 November 2015 3:18 PM
>> To: [hidden email]
>> Subject: Re: Ofbiz 14.12 Multi tenant issue
>>
>> Hi,
>>
>> By loading the data what do you mean exactly? Did you follow recent
>> Pierre Smit's advices on this? I mean like using ./ant create-tenant
>> and checking other related tenant ant targets with ant -p ?
>>
>> Jacques
>>
>> Le 12/11/2015 02:26, Derek Lew a écrit :
>>> Hi
>>>
>>>
>>>
>>> I was trying 14.12, with the multi-tenant option enabled.  After
>>> compiling, loaded the data, and started, this is what I got.
>>>
>>>
>>>
>>> 2015-11-12 08:12:41,853 |OFBiz-batch-6        |DatabaseUtil
>>> |E| Error adding foreign key: ModelEntity was null for related
>>> |E| entity name
>>> Tenant
>>>
>>> 2015-11-12 08:17:50,275 |main                 |GenericDelegator
>>> |E| Failure in storeAll operation:
>> org.ofbiz.entity.GenericEntityException:
>>> There is no datasource (Helper) configured for the entity-group
>>> [org.ofbiz.tenant]; was trying to find datasource (helper) for
>>> entity [Tenant]. Rolling back transaction.
>>>
>>> org.ofbiz.entity.GenericEntityException: There is no datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.j
>>> av
>>> a:544)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:142
>>> 9)
>>> [ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.ja
>>> va
>>> :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(Entit
>>> yD
>>> ataLoa
>>> dContainer.java:490) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa
>>> dC
>>> ontain
>>> er.java:245) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:
>>> 23
>>> 7)
>>> [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-12 08:17:50,278 |main                 |EntitySaxReader
>>> |E| An error occurred saving the data, rolling back transaction
>>> |E| (true)
>>>
>>> org.ofbiz.entity.GenericEntityException:
>>> org.ofbiz.entity.GenericEntityException: There is no datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant] (There is no
>>> datasource (Helper) configured for the entity-group
>>> [org.ofbiz.tenant]; was trying to find datasource (helper) for
>>> entity
>>> [Tenant])
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:148
>>> 2)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.ja
>>> va
>>> :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(Entit
>>> yD
>>> ataLoa
>>> dContainer.java:490) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa
>>> dC
>>> ontain
>>> er.java:245) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:
>>> 23
>>> 7)
>>> [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: There is no
>>> datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.j
>>> av
>>> a:544)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:142
>>> 9)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   ... 10 more
>>>
>>> 2015-11-12 08:17:50,282 |main                 |EntityDataLoader
>>> |E| [loadData]: Error loading XML Resource
>>> "file:/E:/OfBiz14.12/framework/entity/data/TenantDemoData.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(Entit
>>> yD
>>> ataLoa
>>> dContainer.java:490) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoa
>>> dC
>>> ontain
>>> er.java:245) [ofbiz-entityext.jar:?]
>>>
>>>                   at
>>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:
>>> 23
>>> 7)
>>> [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: There is no datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant] (There is no
>>> datasource (Helper) configured for the entity-group
>>> [org.ofbiz.tenant]; was trying to find datasource (helper) for
>>> entity
>>> [Tenant])
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:148
>>> 2)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.ja
>>> va
>>> :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: There is no
>>> datasource
>>> (Helper) configured for the entity-group [org.ofbiz.tenant]; was
>>> trying to find datasource (helper) for entity [Tenant]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.getEntityHelper(GenericDelegator.j
>>> av
>>> a:544)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:142
>>> 9)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.ja
>>> va
>>> :329)
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   at
>>> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:299
>>> )
>>> ~[ofbiz-entity.jar:?]
>>>
>>>                   ... 8 more
>>>
>>>
>>>
>>> Best regards.
>>>
>>> Derek Lew 刘绍雄
>>>
>>>
>>>
>>>

[Pierre Smits]

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 <[hidden email]>
wrote:

> Hi Pierre,
>
> I have used ./ant create-tenant instead, but could not start it up.
>
> Best regards,
>
> Derek
>

[Derek Lew-2]

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:[hidden email]]
Sent: Thursday, 12 November 2015 11:28 PM
To: [hidden email]
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 <[hidden email]>
wrote:

> Hi Pierre,
>
> I have used ./ant create-tenant instead, but could not start it up.
>
> Best regards,
>
> Derek
>

[Pierre Smits]

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 <[hidden email]>
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:[hidden email]]
> Sent: Thursday, 12 November 2015 11:28 PM
> To: [hidden email]
> 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 <[hidden email]
> >
> wrote:
>
> > Hi Pierre,
> >
> > I have used ./ant create-tenant instead, but could not start it up.
> >
> > Best regards,
> >
> > Derek
> >
>

[Derek Lew-2]

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:[hidden email]]
Sent: Friday, 13 November 2015 7:22 PM
To: [hidden email]
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 <[hidden email]>
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:[hidden email]]
> Sent: Thursday, 12 November 2015 11:28 PM
> To: [hidden email]
> 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
> <[hidden email]
> >
> wrote:
>
> > Hi Pierre,
> >
> > I have used ./ant create-tenant instead, but could not start it up.
> >
> > Best regards,
> >
> > Derek
> >
>