You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Ivan Drinks Sr <iv...@reality-technology.com> on 2024/04/30 02:45:53 UTC
Creating a new tenant errors for version 22.01
Trying to create a new tenant produces the following error:
Detail: Key (group_id)=(SUPER) is not present in table "security_group".))). Rolling back transaction.
org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.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 (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp"
Detail: Key (group_id)=(SUPER) is not present in table "security_group".)) (Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.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 (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp"
Detail: Key (group_id)=(SUPER) is not present in table "security_group".)))
at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:921) ~[main/:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1357) ~[main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:314) ~[main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:284) ~[main/:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261) ~[main/:?]
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:267) ~[main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:432) ~[main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) ~[main/:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115) ~[main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:140) ~[main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:104) ~[main/:?]
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:74) ~[main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) ~[main/:?]
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) ~[main/:?]
at org.apache.ofbiz.base.start.Start.main(Start.java:89) ~[main/:?]
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.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 (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp"
Re: Creating a new tenant errors for version 22.01
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Ivan,
Your message has been moderated, else it would not have reached this Mailing List.
Please subscribe to the user ML for such questions and then use your email client.
See why here http://ofbiz.apache.org/mailing-lists.html.
You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.
Also it's more work for moderators who have to accept your messages as long as you have not subscribed.
I'll personally no longer accept them (other moderators still could).
This said, I suggest that you create at Jira issue where you give us more information.
Notably what you exactly did, including detailed steps to reproduce. Also the OFBiz version you used.
To create a Jira please follow https://s.apache.org/yp9d0
Before doing that, did you load the demo data using "gradlew loadAll"?
For more information you may refer to
https://nightlies.apache.org/ofbiz/trunk/readme/html5/README.html
Thanks
Jacques
Le 30/04/2024 à 04:45, Ivan Drinks Sr a écrit :
> Trying to create a new tenant produces the following error:
>
> Detail: Key (group_id)=(SUPER) is not present in table "security_group".))). Rolling back transaction.
> org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.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 (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp"
> Detail: Key (group_id)=(SUPER) is not present in table "security_group".)) (Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.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 (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp"
> Detail: Key (group_id)=(SUPER) is not present in table "security_group".)))
> at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:921) ~[main/:?]
> at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1357) ~[main/:?]
> at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:314) ~[main/:?]
> at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:284) ~[main/:?]
> at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:261) ~[main/:?]
> at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:267) ~[main/:?]
> at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:432) ~[main/:?]
> at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) ~[main/:?]
> at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:115) ~[main/:?]
> at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:140) ~[main/:?]
> at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:104) ~[main/:?]
> at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:74) ~[main/:?]
> at org.apache.ofbiz.base.start.StartupControlPanel.loadContainers(StartupControlPanel.java:146) ~[main/:?]
> at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:70) ~[main/:?]
> at org.apache.ofbiz.base.start.Start.main(Start.java:89) ~[main/:?]
> Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:UserLoginSecurityGroup][createdStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][createdTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][fromDate,2001-01-01 12:00:00.0(java.sql.Timestamp)][groupId,SUPER(java.lang.String)][lastUpdatedStamp,2024-04-30 02:20:48.57(java.sql.Timestamp)][lastUpdatedTxStamp,2024-04-30 02:20:48.562(java.sql.Timestamp)][userLoginId,rti-admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.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 (?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "user_login_security_group" violates foreign key constraint "user_secgrp_grp"
>
>
>