[jira] Created: (OFBIZ-3908) ofbiz setup conflict.

[Nicolas Malin (Jira)]

ofbiz setup conflict.
---------------------

                 Key: OFBIZ-3908
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3908
             Project: OFBiz
          Issue Type: Bug
          Components: commonext/setup
    Affects Versions: SVN trunk
            Reporter: BJ Freeman
            Priority: Minor
             Fix For: SVN trunk


this is seed only install
used the ant to create a login
then created a party for the login and linked them through the webtools.
while creating the party I also create a postal and email contactmech.
this created contactMechId 10001 and 10002
then I went to setup to create the organization.
on the save I got a error message:
Error: ERROR: Could not complete the Create Contact Mechanism [file:/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechId,10002(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)]
cut

 (SQL Exception while executing the following:INSERT INTO public.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_contact_mech"))]  calling service createPartyPostalAddress in createOrganization

have not dug into it yet.
no one responded to email so put it here



--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12903828#action_12903828 ]

BJ Freeman commented on OFBIZ-3908:
-----------------------------------

my proposed way to fix this is add and SECA triggered by the login that checks for a party of that is linked to the login. this will work since all future logins will have a party created first.
if no partyID found then is sent to the setup for a new person for the login then goes directly to the organization setup.

> ofbiz setup conflict.
> ---------------------
>
>                 Key: OFBIZ-3908
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3908
>             Project: OFBiz
>          Issue Type: Bug
>          Components: commonext/setup
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> this is seed only install
> used the ant to create a login
> then created a party for the login and linked them through the webtools.
> while creating the party I also create a postal and email contactmech.
> this created contactMechId 10001 and 10002
> then I went to setup to create the organization.
> on the save I got a error message:
> Error: ERROR: Could not complete the Create Contact Mechanism [file:/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechId,10002(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)]
> cut
>  (SQL Exception while executing the following:INSERT INTO public.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_contact_mech"))]  calling service createPartyPostalAddress in createOrganization
> have not dug into it yet.
> no one responded to email so put it here

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12903945#action_12903945 ]

Jacques Le Roux commented on OFBIZ-3908:
----------------------------------------

Hi BJ,

Is it safe to mix ant and the Setup UI? I'd have thought that users using UI are not seasoned and would not use ant. Maybe I miss something though, do you *need* to use ant before, and is that the reason? Anyway should we not try to separate things and have it all in Setup (ie add there if it's missing)

Thanks

> ofbiz setup conflict.
> ---------------------
>
>                 Key: OFBIZ-3908
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3908
>             Project: OFBiz
>          Issue Type: Bug
>          Components: commonext/setup
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> this is seed only install
> used the ant to create a login
> then created a party for the login and linked them through the webtools.
> while creating the party I also create a postal and email contactmech.
> this created contactMechId 10001 and 10002
> then I went to setup to create the organization.
> on the save I got a error message:
> Error: ERROR: Could not complete the Create Contact Mechanism [file:/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechId,10002(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)]
> cut
>  (SQL Exception while executing the following:INSERT INTO public.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_contact_mech"))]  calling service createPartyPostalAddress in createOrganization
> have not dug into it yet.
> no one responded to email so put it here

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12903979#action_12903979 ]

BJ Freeman commented on OFBIZ-3908:
-----------------------------------

concept is the ant should be mostly technical stuff and a Setup should be mostly user stuff.
I am not sure what you mean mixing Ant and Setup.

My goal is to move way from loading ext data for setting up a Business as a norm.
but have interactive screens that this data is entered.

I am thinking in terms of a multi-tenat type operation, where once the base system is setup, someone would purchase from the Host a package in the ecommerce that would setup their db and seed data on the fly. then send them to a Setup pages to do the setup for their company.

However for the first setup of the host and  in this instance of adding Admin if someone wants to extend Ant to add a partyid  and Partypreference and the associated roles and security so that MyPortal and Themes works  That would seem correct to use Ant

> ofbiz setup conflict.
> ---------------------
>
>                 Key: OFBIZ-3908
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3908
>             Project: OFBiz
>          Issue Type: Bug
>          Components: commonext/setup
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> this is seed only install
> used the ant to create a login
> then created a party for the login and linked them through the webtools.
> while creating the party I also create a postal and email contactmech.
> this created contactMechId 10001 and 10002
> then I went to setup to create the organization.
> on the save I got a error message:
> Error: ERROR: Could not complete the Create Contact Mechanism [file:/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechId,10002(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)]
> cut
>  (SQL Exception while executing the following:INSERT INTO public.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_contact_mech"))]  calling service createPartyPostalAddress in createOrganization
> have not dug into it yet.
> no one responded to email so put it here

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12903992#action_12903992 ]

Jacques Le Roux commented on OFBIZ-3908:
----------------------------------------

OK, I think I have to see more to have an opinion

Thanks for the explanation

> ofbiz setup conflict.
> ---------------------
>
>                 Key: OFBIZ-3908
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3908
>             Project: OFBiz
>          Issue Type: Bug
>          Components: commonext/setup
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> this is seed only install
> used the ant to create a login
> then created a party for the login and linked them through the webtools.
> while creating the party I also create a postal and email contactmech.
> this created contactMechId 10001 and 10002
> then I went to setup to create the organization.
> on the save I got a error message:
> Error: ERROR: Could not complete the Create Contact Mechanism [file:/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechId,10002(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)]
> cut
>  (SQL Exception while executing the following:INSERT INTO public.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_contact_mech"))]  calling service createPartyPostalAddress in createOrganization
> have not dug into it yet.
> no one responded to email so put it here

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12922560#action_12922560 ]

BJ Freeman commented on OFBIZ-3908:
-----------------------------------

the simplest would be to assign numbers below 10000 range.
what do you think

> ofbiz setup conflict.
> ---------------------
>
>                 Key: OFBIZ-3908
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3908
>             Project: OFBiz
>          Issue Type: Bug
>          Components: commonext/setup
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> this is seed only install
> used the ant to create a login
> then created a party for the login and linked them through the webtools.
> while creating the party I also create a postal and email contactmech.
> this created contactMechId 10001 and 10002
> then I went to setup to create the organization.
> on the save I got a error message:
> Error: ERROR: Could not complete the Create Contact Mechanism [file:/applications/party/script/org/ofbiz/party/contact/ContactMechServices.xml#createContactMech] process [problem creating the newValue value: Error while inserting: [GenericEntity:ContactMech][contactMechId,10002(java.lang.String)][contactMechTypeId,POSTAL_ADDRESS(java.lang.String)]
> cut
>  (SQL Exception while executing the following:INSERT INTO public.CONTACT_MECH (CONTACT_MECH_ID, CONTACT_MECH_TYPE_ID, INFO_STRING, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_contact_mech"))]  calling service createPartyPostalAddress in createOrganization
> have not dug into it yet.
> no one responded to email so put it here

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.