[jira] Created: (OFBIZ-2140) Failure in create operation for entity [PartyRole]

[Nicolas Malin (Jira)]

Failure in create operation for entity [PartyRole]
--------------------------------------------------

                 Key: OFBIZ-2140
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2140
             Project: OFBiz
          Issue Type: Bug
          Components: party
    Affects Versions: SVN trunk
         Environment: Linux Debian, OFBiz trunk 737660, PostgresQL 8.1
            Reporter: Eric DE MAULDE
            Priority: Blocker


When I load an "ANT run-install" with or not "seed" or "extseed" for the first time
There is an error in PartyRole entity
and I can't login "admin" with password "ofbiz" in backend

*** Error :

---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:INSERT INTO public.PARTY_ROLE (PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table � party_role � viole la contrainte de cl�
�trang�re � party_rle_role �
  Detail: La cl� (role_type_id)=(CONTENT_GUEST) n'est pas pr�sente dans la table � role_type �.)

--
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-2140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667236#action_12667236 ]

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

Hi Eric,

I just tried and it works well using XP Sp3, r737638, PostGres 8.3. Are you doing something specific (Im' not sure to understand what you mean by <<with or not "seed" or "extseed" for the first time>> ?

> Failure in create operation for entity [PartyRole]
> --------------------------------------------------
>
>                 Key: OFBIZ-2140
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2140
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: SVN trunk
>         Environment: Linux Debian, OFBiz trunk 737660, PostgresQL 8.1
>            Reporter: Eric DE MAULDE
>            Priority: Blocker
>
> When I load an "ANT run-install" with or not "seed" or "extseed" for the first time
> There is an error in PartyRole entity
> and I can't login "admin" with password "ofbiz" in backend
> *** Error :
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO public.PARTY_ROLE (PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table � party_role � viole la contrainte de cl�
> �trang�re � party_rle_role �
>   Detail: La cl� (role_type_id)=(CONTENT_GUEST) n'est pas pr�sente dans la table � role_type �.)

--
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-2140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667238#action_12667238 ]

Eric DE MAULDE commented on OFBIZ-2140:
---------------------------------------

The error : my own changes

Sorry

> Failure in create operation for entity [PartyRole]
> --------------------------------------------------
>
>                 Key: OFBIZ-2140
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2140
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: SVN trunk
>         Environment: Linux Debian, OFBiz trunk 737660, PostgresQL 8.1
>            Reporter: Eric DE MAULDE
>            Priority: Blocker
>
> When I load an "ANT run-install" with or not "seed" or "extseed" for the first time
> There is an error in PartyRole entity
> and I can't login "admin" with password "ofbiz" in backend
> *** Error :
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO public.PARTY_ROLE (PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table � party_role � viole la contrainte de cl�
> �trang�re � party_rle_role �
>   Detail: La cl� (role_type_id)=(CONTENT_GUEST) n'est pas pr�sente dans la table � role_type �.)

--
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-2140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eric DE MAULDE closed OFBIZ-2140.
---------------------------------

       Resolution: Fixed
    Fix Version/s: SVN trunk

the error comes from my own changes

> Failure in create operation for entity [PartyRole]
> --------------------------------------------------
>
>                 Key: OFBIZ-2140
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2140
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: SVN trunk
>         Environment: Linux Debian, OFBiz trunk 737660, PostgresQL 8.1
>            Reporter: Eric DE MAULDE
>            Priority: Blocker
>             Fix For: SVN trunk
>
>
> When I load an "ANT run-install" with or not "seed" or "extseed" for the first time
> There is an error in PartyRole entity
> and I can't login "admin" with password "ofbiz" in backend
> *** Error :
> ---- cause ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO public.PARTY_ROLE (PARTY_ID, ROLE_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou update sur la table � party_role � viole la contrainte de cl�
> �trang�re � party_rle_role �
>   Detail: La cl� (role_type_id)=(CONTENT_GUEST) n'est pas pr�sente dans la table � role_type �.)

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