OFBiz › OFBiz - User

Error doing entity-auto operation for entity Agreement in service createAgreement:

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

12 messages Options

Donhu Vy

Error doing entity-auto operation for entity Agreement in service createAgreement:

I use module Agreements. I face this error:

https://gist.githubusercontent.com/donhuvy/70c84a153251fc11124bc9a5eb00134b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log

Screenshot: https://user-images.githubusercontent.com/1328316/27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg

How to avoid this error?

thangnguyen.Olbius

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Hi Vy,

You can see: .. (accountant_group, MAIN_ROLE) is not present in table
"party_role" in your log (file error.log or ofbiz.log). It's mean party
accountant_group not has role MAIN_ROLE. You must add new record to table
PartyRole like that: <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
:)

On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]> wrote:

> I use module Agreements. I face this error:
>
> https://gist.githubusercontent.com/donhuvy/70c84a153251fc11124bc9a5eb0013
> 4b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log
>
> Screenshot: https://user-images.githubusercontent.com/1328316/
> 27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg
>
>
> How to avoid this error?
>
>
>

--
*THANG NGUYEN (Mr)*

*OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
1674636641

*OLBIUS., JSC*
*Tel:* (+84) 9 88 99 3333
*Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
*Website:* http://olbius.com

Donhu Vy

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Thank you,

How to add a new record to table PartyRole from GUI?

________________________________
From: Trà Đá Một Mình <[hidden email]>
Sent: Thursday, June 22, 2017 9:48:02 AM
To: [hidden email]
Subject: Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Hi Vy,

You can see: .. (accountant_group, MAIN_ROLE) is not present in table
"party_role" in your log (file error.log or ofbiz.log). It's mean party
accountant_group not has role MAIN_ROLE. You must add new record to table
PartyRole like that: <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
:)

On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]> wrote:

thangnguyen.Olbius

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Go to: https://localhost:8443/webtools/control/EntityImport with user
admin. We can import entity data by xml format. Put <entity-engine-xml> <Party
partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
</entity-engine-xml> in to Import Text field.

On Thu, Jun 22, 2017 at 10:07 AM, Donhu Vy <[hidden email]> wrote:

> Thank you,
>
>
> How to add a new record to table PartyRole from GUI?
>
>
> ________________________________
> From: Trà Đá Một Mình <[hidden email]>
> Sent: Thursday, June 22, 2017 9:48:02 AM
> To: [hidden email]
> Subject: Re: Error doing entity-auto operation for entity Agreement in
> service createAgreement:
>
> Hi Vy,
>
> You can see: .. (accountant_group, MAIN_ROLE) is not present in table
> "party_role" in your log (file error.log or ofbiz.log). It's mean party
> accountant_group not has role MAIN_ROLE. You must add new record to table
> PartyRole like that: <Party partyId="accountant_group"
> roleTypeId="MAIN_ROLE"/>
> :)
>
> On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]> wrote:
>
> > I use module Agreements. I face this error:
> >
> > https://gist.githubusercontent.com/donhuvy/
> 70c84a153251fc11124bc9a5eb0013
> > 4b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log
> >
> > Screenshot: https://user-images.githubusercontent.com/1328316/
> > 27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg
> >
> >
> > How to avoid this error?
> >
> >
> >
>
>
> --
> *THANG NGUYEN (Mr)*
>
> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> 1674636641
>
> *OLBIUS., JSC*
> *Tel:* (+84) 9 88 99 3333
> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> *Website:* http://olbius.com
>

Donhu Vy

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

After follow your instruction, I create a new item like early stage. I have been already import XML content

<entity-engine-xml>
<Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
</entity-engine-xml>

Error:

https://gist.githubusercontent.com/donhuvy/089810cec3f2be35ab546a5fd14d31a9/raw/5910cad1e473d874e7416c86d491022c897391f1/error.log

https://user-images.githubusercontent.com/1328316/27416038-24f6f6c8-5735-11e7-8f4b-8da39de11ae8.jpg

How to fix it?

________________________________
From: Trà Đá Một Mình <[hidden email]>
Sent: Thursday, June 22, 2017 10:16:52 AM
To: [hidden email]
Subject: Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Go to: https://localhost:8443/webtools/control/EntityImport with user
admin. We can import entity data by xml format. Put <entity-engine-xml> <Party
partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
</entity-engine-xml> in to Import Text field.

On Thu, Jun 22, 2017 at 10:07 AM, Donhu Vy <[hidden email]> wrote:

thangnguyen.Olbius

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Check table PartyRole in your database. Are you sure has new record has
been imported ?

On Thu, Jun 22, 2017 at 10:26 AM, Donhu Vy <[hidden email]> wrote:

> After follow your instruction, I create a new item like early stage. I
> have been already import XML content
>
> <entity-engine-xml>
> <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> </entity-engine-xml>
>
>
> Error:
>
>
> https://gist.githubusercontent.com/donhuvy/089810cec3f2be35ab546a5fd14d31
> a9/raw/5910cad1e473d874e7416c86d491022c897391f1/error.log
>
> https://user-images.githubusercontent.com/1328316/
> 27416038-24f6f6c8-5735-11e7-8f4b-8da39de11ae8.jpg
>
>
> How to fix it?
>
>
>
> ________________________________
> From: Trà Đá Một Mình <[hidden email]>
> Sent: Thursday, June 22, 2017 10:16:52 AM
> To: [hidden email]
> Subject: Re: Error doing entity-auto operation for entity Agreement in
> service createAgreement:
>
> Go to: https://localhost:8443/webtools/control/EntityImport with user
> admin. We can import entity data by xml format. Put <entity-engine-xml>
> <Party
> partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> </entity-engine-xml> in to Import Text field.
>
> On Thu, Jun 22, 2017 at 10:07 AM, Donhu Vy <[hidden email]> wrote:
>
> > Thank you,
> >
> >
> > How to add a new record to table PartyRole from GUI?
> >
> >
> > ________________________________
> > From: Trà Đá Một Mình <[hidden email]>
> > Sent: Thursday, June 22, 2017 9:48:02 AM
> > To: [hidden email]
> > Subject: Re: Error doing entity-auto operation for entity Agreement in
> > service createAgreement:
> >
> > Hi Vy,
> >
> > You can see: .. (accountant_group, MAIN_ROLE) is not present in table
> > "party_role" in your log (file error.log or ofbiz.log). It's mean party
> > accountant_group not has role MAIN_ROLE. You must add new record to table
> > PartyRole like that: <Party partyId="accountant_group"
> > roleTypeId="MAIN_ROLE"/>
> > :)
> >
> > On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]> wrote:
> >
> > > I use module Agreements. I face this error:
> > >
> > > https://gist.githubusercontent.com/donhuvy/
> > 70c84a153251fc11124bc9a5eb0013
> > > 4b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log
> > >
> > > Screenshot: https://user-images.githubusercontent.com/1328316/
> > > 27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg
> > >
> > >
> > > How to avoid this error?
> > >
> > >
> > >
> >
> >
> > --
> > *THANG NGUYEN (Mr)*
> >
> > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> > 1674636641
> >
> > *OLBIUS., JSC*
> > *Tel:* (+84) 9 88 99 3333
> > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> > *Website:* http://olbius.com
> >
>
>
>
> --
> *THANG NGUYEN (Mr)*
>
> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> 1674636641
>
> *OLBIUS., JSC*
> *Tel:* (+84) 9 88 99 3333
> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> *Website:* http://olbius.com
>

Donhu Vy

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

On web GUI, After import XML content, I see message:

"Got 1 entities to write to the datasource.".

I use PostgreSQL 9.6.3 . When check database by running query:

select count(*) from party_role where party_id = 'accountant_group' and role_type_id = 'MAIN_ROLE';

Result is 0.

________________________________
From: Trà Đá Một Mình <[hidden email]>
Sent: Thursday, June 22, 2017 10:32:51 AM
To: [hidden email]
Subject: Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Check table PartyRole in your database. Are you sure has new record has
been imported ?

On Thu, Jun 22, 2017 at 10:26 AM, Donhu Vy <[hidden email]> wrote:

Deepak Dixit-3

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Hi Donhu,

>> <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
This is incorrect data.

You need to create party and then assign role to it.

<Party partyId="accountant_group" partyTypeId ="PERSON"/>
//partyTypeId can be PERSON or GROUP
//Create Person or PartyGroup data based on partyTypeId
<PartyRole partyId="accountant_group" roleTypeId="MAIN_ROLE"/>

Please read data model for more understanding
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books

Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co

On Thu, Jun 22, 2017 at 9:13 AM, Donhu Vy <[hidden email]> wrote:

> On web GUI, After import XML content, I see message:
>
> "Got 1 entities to write to the datasource.".
>
>
> I use PostgreSQL 9.6.3 . When check database by running query:
>
> select count(*) from party_role where party_id = 'accountant_group' and
> role_type_id = 'MAIN_ROLE';
>
>
> Result is 0.
>
> ________________________________
> From: Trà Đá Một Mình <[hidden email]>
> Sent: Thursday, June 22, 2017 10:32:51 AM
> To: [hidden email]
> Subject: Re: Error doing entity-auto operation for entity Agreement in
> service createAgreement:
>
> Check table PartyRole in your database. Are you sure has new record has
> been imported ?
>
> On Thu, Jun 22, 2017 at 10:26 AM, Donhu Vy <[hidden email]> wrote:
>
> > After follow your instruction, I create a new item like early stage. I
> > have been already import XML content
> >
> > <entity-engine-xml>
> > <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> > </entity-engine-xml>
> >
> >
> > Error:
> >
> >
> > https://gist.githubusercontent.com/donhuvy/
> 089810cec3f2be35ab546a5fd14d31
> > a9/raw/5910cad1e473d874e7416c86d491022c897391f1/error.log
> >
> > https://user-images.githubusercontent.com/1328316/
> > 27416038-24f6f6c8-5735-11e7-8f4b-8da39de11ae8.jpg
> >
> >
> > How to fix it?
> >
> >
> >
> > ________________________________
> > From: Trà Đá Một Mình <[hidden email]>
> > Sent: Thursday, June 22, 2017 10:16:52 AM
> > To: [hidden email]
> > Subject: Re: Error doing entity-auto operation for entity Agreement in
> > service createAgreement:
> >
> > Go to: https://localhost:8443/webtools/control/EntityImport with user
> > admin. We can import entity data by xml format. Put <entity-engine-xml>
> > <Party
> > partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> > </entity-engine-xml> in to Import Text field.
> >
> > On Thu, Jun 22, 2017 at 10:07 AM, Donhu Vy <[hidden email]> wrote:
> >
> > > Thank you,
> > >
> > >
> > > How to add a new record to table PartyRole from GUI?
> > >
> > >
> > > ________________________________
> > > From: Trà Đá Một Mình <[hidden email]>
> > > Sent: Thursday, June 22, 2017 9:48:02 AM
> > > To: [hidden email]
> > > Subject: Re: Error doing entity-auto operation for entity Agreement in
> > > service createAgreement:
> > >
> > > Hi Vy,
> > >
> > > You can see: .. (accountant_group, MAIN_ROLE) is not present in table
> > > "party_role" in your log (file error.log or ofbiz.log). It's mean party
> > > accountant_group not has role MAIN_ROLE. You must add new record to
> table
> > > PartyRole like that: <Party partyId="accountant_group"
> > > roleTypeId="MAIN_ROLE"/>
> > > :)
> > >
> > > On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]> wrote:
> > >
> > > > I use module Agreements. I face this error:
> > > >
> > > > https://gist.githubusercontent.com/donhuvy/
> > > 70c84a153251fc11124bc9a5eb0013
> > > > 4b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log
> > > >
> > > > Screenshot: https://user-images.githubusercontent.com/1328316/
> > > > 27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg
> > > >
> > > >
> > > > How to avoid this error?
> > > >
> > > >
> > > >
> > >
> > >
> > > --
> > > *THANG NGUYEN (Mr)*
> > >
> > > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> > > 1674636641
> > >
> > > *OLBIUS., JSC*
> > > *Tel:* (+84) 9 88 99 3333
> > > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> > > *Website:* http://olbius.com
> > >
> >
> >
> >
> > --
> > *THANG NGUYEN (Mr)*
> >
> > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> > 1674636641
> >
> > *OLBIUS., JSC*
> > *Tel:* (+84) 9 88 99 3333
> > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> > *Website:* http://olbius.com
> >
>
>
>
> --
> *THANG NGUYEN (Mr)*
>
> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> 1674636641
>
> *OLBIUS., JSC*
> *Tel:* (+84) 9 88 99 3333
> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> *Website:* http://olbius.com
>

thangnguyen.Olbius

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

In reply to this post by Donhu Vy

Oh, Sorry, I'm wrong, exactly we need import: <PartyRole
partyId="accountant_group" roleTypeId="MAIN_ROLE"/>

On Thu, Jun 22, 2017 at 10:43 AM, Donhu Vy <[hidden email]> wrote:

thangnguyen.Olbius

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Hi Deepak,
I think in this case, party accountant_group already existed, we don't need
to add <Party partyId="accountant_group" partyTypeId ="PERSON"/> any more.

On Thu, Jun 22, 2017 at 10:52 AM, Trà Đá Một Mình <[hidden email]
> wrote:

> Oh, Sorry, I'm wrong, exactly we need import: <PartyRole
> partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
>
> On Thu, Jun 22, 2017 at 10:43 AM, Donhu Vy <[hidden email]> wrote:
>
>> On web GUI, After import XML content, I see message:
>>
>> "Got 1 entities to write to the datasource.".
>>
>>
>> I use PostgreSQL 9.6.3 . When check database by running query:
>>
>> select count(*) from party_role where party_id = 'accountant_group' and
>> role_type_id = 'MAIN_ROLE';
>>
>>
>> Result is 0.
>>
>> ________________________________
>> From: Trà Đá Một Mình <[hidden email]>
>> Sent: Thursday, June 22, 2017 10:32:51 AM
>> To: [hidden email]
>> Subject: Re: Error doing entity-auto operation for entity Agreement in
>> service createAgreement:
>>
>> Check table PartyRole in your database. Are you sure has new record has
>> been imported ?
>>
>> On Thu, Jun 22, 2017 at 10:26 AM, Donhu Vy <[hidden email]> wrote:
>>
>> > After follow your instruction, I create a new item like early stage. I
>> > have been already import XML content
>> >
>> > <entity-engine-xml>
>> > <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
>> > </entity-engine-xml>
>> >
>> >
>> > Error:
>> >
>> >
>> > https://gist.githubusercontent.com/donhuvy/089810cec3f2be35a
>> b546a5fd14d31
>> > a9/raw/5910cad1e473d874e7416c86d491022c897391f1/error.log
>> >
>> > https://user-images.githubusercontent.com/1328316/
>> > 27416038-24f6f6c8-5735-11e7-8f4b-8da39de11ae8.jpg
>> >
>> >
>> > How to fix it?
>> >
>> >
>> >
>> > ________________________________
>> > From: Trà Đá Một Mình <[hidden email]>
>> > Sent: Thursday, June 22, 2017 10:16:52 AM
>> > To: [hidden email]
>> > Subject: Re: Error doing entity-auto operation for entity Agreement in
>> > service createAgreement:
>> >
>> > Go to: https://localhost:8443/webtools/control/EntityImport with user
>> > admin. We can import entity data by xml format. Put <entity-engine-xml>
>> > <Party
>> > partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
>> > </entity-engine-xml> in to Import Text field.
>> >
>> > On Thu, Jun 22, 2017 at 10:07 AM, Donhu Vy <[hidden email]> wrote:
>> >
>> > > Thank you,
>> > >
>> > >
>> > > How to add a new record to table PartyRole from GUI?
>> > >
>> > >
>> > > ________________________________
>> > > From: Trà Đá Một Mình <[hidden email]>
>> > > Sent: Thursday, June 22, 2017 9:48:02 AM
>> > > To: [hidden email]
>> > > Subject: Re: Error doing entity-auto operation for entity Agreement in
>> > > service createAgreement:
>> > >
>> > > Hi Vy,
>> > >
>> > > You can see: .. (accountant_group, MAIN_ROLE) is not present in table
>> > > "party_role" in your log (file error.log or ofbiz.log). It's mean
>> party
>> > > accountant_group not has role MAIN_ROLE. You must add new record to
>> table
>> > > PartyRole like that: <Party partyId="accountant_group"
>> > > roleTypeId="MAIN_ROLE"/>
>> > > :)
>> > >
>> > > On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]>
>> wrote:
>> > >
>> > > > I use module Agreements. I face this error:
>> > > >
>> > > > https://gist.githubusercontent.com/donhuvy/
>> > > 70c84a153251fc11124bc9a5eb0013
>> > > > 4b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log
>> > > >
>> > > > Screenshot: https://user-images.githubusercontent.com/1328316/
>> > > > 27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg
>> > > >
>> > > >
>> > > > How to avoid this error?
>> > > >
>> > > >
>> > > >
>> > >
>> > >
>> > > --
>> > > *THANG NGUYEN (Mr)*
>> > >
>> > > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
>> > > 1674636641
>> > >
>> > > *OLBIUS., JSC*
>> > > *Tel:* (+84) 9 88 99 3333
>> > > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
>> > > *Website:* http://olbius.com
>> > >
>> >
>> >
>> >
>> > --
>> > *THANG NGUYEN (Mr)*
>> >
>> > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
>> > 1674636641
>> >
>> > *OLBIUS., JSC*
>> > *Tel:* (+84) 9 88 99 3333
>> > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
>> > *Website:* http://olbius.com
>> >
>>
>>
>>
>> --
>> *THANG NGUYEN (Mr)*
>>
>> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
>> 1674636641
>>
>> *OLBIUS., JSC*
>> *Tel:* (+84) 9 88 99 3333
>> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
>> *Website:* http://olbius.com
>>
>
>
>
> --
> *THANG NGUYEN (Mr)*
>
> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> 1674636641
>
> *OLBIUS., JSC*
> *Tel:* (+84) 9 88 99 3333
> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> *Website:* http://olbius.com
>

--
*THANG NGUYEN (Mr)*

*OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84) 96
955 0905

*OLBIUS., JSC*
*Tel:* (+84) 9 88 99 3333
*Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
*Website:* http://olbius.com

Deepak Dixit-3

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Thanks Thang Nguyen.
Yes, its part of demo data.

Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co

On Thu, Jun 22, 2017 at 9:28 AM, Trà Đá Một Mình <[hidden email]>
wrote:

> Hi Deepak,
> I think in this case, party accountant_group already existed, we don't need
> to add <Party partyId="accountant_group" partyTypeId ="PERSON"/> any
> more.
>
> On Thu, Jun 22, 2017 at 10:52 AM, Trà Đá Một Mình <
> [hidden email]
> > wrote:
>
> > Oh, Sorry, I'm wrong, exactly we need import: <PartyRole
> > partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> >
> > On Thu, Jun 22, 2017 at 10:43 AM, Donhu Vy <[hidden email]> wrote:
> >
> >> On web GUI, After import XML content, I see message:
> >>
> >> "Got 1 entities to write to the datasource.".
> >>
> >>
> >> I use PostgreSQL 9.6.3 . When check database by running query:
> >>
> >> select count(*) from party_role where party_id = 'accountant_group' and
> >> role_type_id = 'MAIN_ROLE';
> >>
> >>
> >> Result is 0.
> >>
> >> ________________________________
> >> From: Trà Đá Một Mình <[hidden email]>
> >> Sent: Thursday, June 22, 2017 10:32:51 AM
> >> To: [hidden email]
> >> Subject: Re: Error doing entity-auto operation for entity Agreement in
> >> service createAgreement:
> >>
> >> Check table PartyRole in your database. Are you sure has new record has
> >> been imported ?
> >>
> >> On Thu, Jun 22, 2017 at 10:26 AM, Donhu Vy <[hidden email]> wrote:
> >>
> >> > After follow your instruction, I create a new item like early stage. I
> >> > have been already import XML content
> >> >
> >> > <entity-engine-xml>
> >> > <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> >> > </entity-engine-xml>
> >> >
> >> >
> >> > Error:
> >> >
> >> >
> >> > https://gist.githubusercontent.com/donhuvy/089810cec3f2be35a
> >> b546a5fd14d31
> >> > a9/raw/5910cad1e473d874e7416c86d491022c897391f1/error.log
> >> >
> >> > https://user-images.githubusercontent.com/1328316/
> >> > 27416038-24f6f6c8-5735-11e7-8f4b-8da39de11ae8.jpg
> >> >
> >> >
> >> > How to fix it?
> >> >
> >> >
> >> >
> >> > ________________________________
> >> > From: Trà Đá Một Mình <[hidden email]>
> >> > Sent: Thursday, June 22, 2017 10:16:52 AM
> >> > To: [hidden email]
> >> > Subject: Re: Error doing entity-auto operation for entity Agreement in
> >> > service createAgreement:
> >> >
> >> > Go to: https://localhost:8443/webtools/control/EntityImport with user
> >> > admin. We can import entity data by xml format. Put
> <entity-engine-xml>
> >> > <Party
> >> > partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> >> > </entity-engine-xml> in to Import Text field.
> >> >
> >> > On Thu, Jun 22, 2017 at 10:07 AM, Donhu Vy <[hidden email]>
> wrote:
> >> >
> >> > > Thank you,
> >> > >
> >> > >
> >> > > How to add a new record to table PartyRole from GUI?
> >> > >
> >> > >
> >> > > ________________________________
> >> > > From: Trà Đá Một Mình <[hidden email]>
> >> > > Sent: Thursday, June 22, 2017 9:48:02 AM
> >> > > To: [hidden email]
> >> > > Subject: Re: Error doing entity-auto operation for entity Agreement
> in
> >> > > service createAgreement:
> >> > >
> >> > > Hi Vy,
> >> > >
> >> > > You can see: .. (accountant_group, MAIN_ROLE) is not present in
> table
> >> > > "party_role" in your log (file error.log or ofbiz.log). It's mean
> >> party
> >> > > accountant_group not has role MAIN_ROLE. You must add new record to
> >> table
> >> > > PartyRole like that: <Party partyId="accountant_group"
> >> > > roleTypeId="MAIN_ROLE"/>
> >> > > :)
> >> > >
> >> > > On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]>
> >> wrote:
> >> > >
> >> > > > I use module Agreements. I face this error:
> >> > > >
> >> > > > https://gist.githubusercontent.com/donhuvy/
> >> > > 70c84a153251fc11124bc9a5eb0013
> >> > > > 4b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log
> >> > > >
> >> > > > Screenshot: https://user-images.githubusercontent.com/1328316/
> >> > > > 27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg
> >> > > >
> >> > > >
> >> > > > How to avoid this error?
> >> > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> > > --
> >> > > *THANG NGUYEN (Mr)*
> >> > >
> >> > > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:*
> (+84)
> >> > > 1674636641
> >> > >
> >> > > *OLBIUS., JSC*
> >> > > *Tel:* (+84) 9 88 99 3333
> >> > > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City,
> VietNam
> >> > > *Website:* http://olbius.com
> >> > >
> >> >
> >> >
> >> >
> >> > --
> >> > *THANG NGUYEN (Mr)*
> >> >
> >> > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> >> > 1674636641
> >> >
> >> > *OLBIUS., JSC*
> >> > *Tel:* (+84) 9 88 99 3333
> >> > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> >> > *Website:* http://olbius.com
> >> >
> >>
> >>
> >>
> >> --
> >> *THANG NGUYEN (Mr)*
> >>
> >> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> >> 1674636641
> >>
> >> *OLBIUS., JSC*
> >> *Tel:* (+84) 9 88 99 3333
> >> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> >> *Website:* http://olbius.com
> >>
> >
> >
> >
> > --
> > *THANG NGUYEN (Mr)*
> >
> > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> > 1674636641
> >
> > *OLBIUS., JSC*
> > *Tel:* (+84) 9 88 99 3333
> > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> > *Website:* http://olbius.com
> >
>
>
>
> --
> *THANG NGUYEN (Mr)*
>
> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84) 96
> 955 0905
>
> *OLBIUS., JSC*
> *Tel:* (+84) 9 88 99 3333
> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> *Website:* http://olbius.com
>

Rishi Solanki

Re: Error doing entity-auto operation for entity Agreement in service createAgreement:

Alternatively, you may like use the ensurePartyRole service to create party
roles before using them. You can find many occurrences of the service in
OFBiz work flows.

Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com

On Thu, Jun 22, 2017 at 9:32 AM, Deepak Dixit <
[hidden email]> wrote:

> Thanks Thang Nguyen.
> Yes, its part of demo data.
>
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Thu, Jun 22, 2017 at 9:28 AM, Trà Đá Một Mình <
> [hidden email]>
> wrote:
>
> > Hi Deepak,
> > I think in this case, party accountant_group already existed, we don't
> need
> > to add <Party partyId="accountant_group" partyTypeId ="PERSON"/> any
> > more.
> >
> > On Thu, Jun 22, 2017 at 10:52 AM, Trà Đá Một Mình <
> > [hidden email]
> > > wrote:
> >
> > > Oh, Sorry, I'm wrong, exactly we need import: <PartyRole
> > > partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> > >
> > > On Thu, Jun 22, 2017 at 10:43 AM, Donhu Vy <[hidden email]>
> wrote:
> > >
> > >> On web GUI, After import XML content, I see message:
> > >>
> > >> "Got 1 entities to write to the datasource.".
> > >>
> > >>
> > >> I use PostgreSQL 9.6.3 . When check database by running query:
> > >>
> > >> select count(*) from party_role where party_id = 'accountant_group'
> and
> > >> role_type_id = 'MAIN_ROLE';
> > >>
> > >>
> > >> Result is 0.
> > >>
> > >> ________________________________
> > >> From: Trà Đá Một Mình <[hidden email]>
> > >> Sent: Thursday, June 22, 2017 10:32:51 AM
> > >> To: [hidden email]
> > >> Subject: Re: Error doing entity-auto operation for entity Agreement in
> > >> service createAgreement:
> > >>
> > >> Check table PartyRole in your database. Are you sure has new record
> has
> > >> been imported ?
> > >>
> > >> On Thu, Jun 22, 2017 at 10:26 AM, Donhu Vy <[hidden email]>
> wrote:
> > >>
> > >> > After follow your instruction, I create a new item like early
> stage. I
> > >> > have been already import XML content
> > >> >
> > >> > <entity-engine-xml>
> > >> > <Party partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> > >> > </entity-engine-xml>
> > >> >
> > >> >
> > >> > Error:
> > >> >
> > >> >
> > >> > https://gist.githubusercontent.com/donhuvy/089810cec3f2be35a
> > >> b546a5fd14d31
> > >> > a9/raw/5910cad1e473d874e7416c86d491022c897391f1/error.log
> > >> >
> > >> > https://user-images.githubusercontent.com/1328316/
> > >> > 27416038-24f6f6c8-5735-11e7-8f4b-8da39de11ae8.jpg
> > >> >
> > >> >
> > >> > How to fix it?
> > >> >
> > >> >
> > >> >
> > >> > ________________________________
> > >> > From: Trà Đá Một Mình <[hidden email]>
> > >> > Sent: Thursday, June 22, 2017 10:16:52 AM
> > >> > To: [hidden email]
> > >> > Subject: Re: Error doing entity-auto operation for entity Agreement
> in
> > >> > service createAgreement:
> > >> >
> > >> > Go to: https://localhost:8443/webtools/control/EntityImport with
> user
> > >> > admin. We can import entity data by xml format. Put
> > <entity-engine-xml>
> > >> > <Party
> > >> > partyId="accountant_group" roleTypeId="MAIN_ROLE"/>
> > >> > </entity-engine-xml> in to Import Text field.
> > >> >
> > >> > On Thu, Jun 22, 2017 at 10:07 AM, Donhu Vy <[hidden email]>
> > wrote:
> > >> >
> > >> > > Thank you,
> > >> > >
> > >> > >
> > >> > > How to add a new record to table PartyRole from GUI?
> > >> > >
> > >> > >
> > >> > > ________________________________
> > >> > > From: Trà Đá Một Mình <[hidden email]>
> > >> > > Sent: Thursday, June 22, 2017 9:48:02 AM
> > >> > > To: [hidden email]
> > >> > > Subject: Re: Error doing entity-auto operation for entity
> Agreement
> > in
> > >> > > service createAgreement:
> > >> > >
> > >> > > Hi Vy,
> > >> > >
> > >> > > You can see: .. (accountant_group, MAIN_ROLE) is not present in
> > table
> > >> > > "party_role" in your log (file error.log or ofbiz.log). It's mean
> > >> party
> > >> > > accountant_group not has role MAIN_ROLE. You must add new record
> to
> > >> table
> > >> > > PartyRole like that: <Party partyId="accountant_group"
> > >> > > roleTypeId="MAIN_ROLE"/>
> > >> > > :)
> > >> > >
> > >> > > On Thu, Jun 22, 2017 at 9:40 AM, Donhu Vy <[hidden email]>
> > >> wrote:
> > >> > >
> > >> > > > I use module Agreements. I face this error:
> > >> > > >
> > >> > > > https://gist.githubusercontent.com/donhuvy/
> > >> > > 70c84a153251fc11124bc9a5eb0013
> > >> > > > 4b/raw/14de23e5f8622115e98521e50eceecc834603260/bug.log
> > >> > > >
> > >> > > > Screenshot: https://user-images.githubusercontent.com/1328316/
> > >> > > > 27414977-b5edf106-572e-11e7-9073-1473dd2521ee.jpg
> > >> > > >
> > >> > > >
> > >> > > > How to avoid this error?
> > >> > > >
> > >> > > >
> > >> > > >
> > >> > >
> > >> > >
> > >> > > --
> > >> > > *THANG NGUYEN (Mr)*
> > >> > >
> > >> > > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:*
> > (+84)
> > >> > > 1674636641
> > >> > >
> > >> > > *OLBIUS., JSC*
> > >> > > *Tel:* (+84) 9 88 99 3333
> > >> > > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City,
> > VietNam
> > >> > > *Website:* http://olbius.com
> > >> > >
> > >> >
> > >> >
> > >> >
> > >> > --
> > >> > *THANG NGUYEN (Mr)*
> > >> >
> > >> > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:*
> (+84)
> > >> > 1674636641
> > >> >
> > >> > *OLBIUS., JSC*
> > >> > *Tel:* (+84) 9 88 99 3333
> > >> > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City,
> VietNam
> > >> > *Website:* http://olbius.com
> > >> >
> > >>
> > >>
> > >>
> > >> --
> > >> *THANG NGUYEN (Mr)*
> > >>
> > >> *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> > >> 1674636641
> > >>
> > >> *OLBIUS., JSC*
> > >> *Tel:* (+84) 9 88 99 3333
> > >> *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> > >> *Website:* http://olbius.com
> > >>
> > >
> > >
> > >
> > > --
> > > *THANG NGUYEN (Mr)*
> > >
> > > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84)
> > > 1674636641
> > >
> > > *OLBIUS., JSC*
> > > *Tel:* (+84) 9 88 99 3333
> > > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> > > *Website:* http://olbius.com
> > >
> >
> >
> >
> > --
> > *THANG NGUYEN (Mr)*
> >
> > *OLBIUS DEVELOPER**Email:* [hidden email]| *Mobile:* (+84) 96
> > 955 0905
> >
> > *OLBIUS., JSC*
> > *Tel:* (+84) 9 88 99 3333
> > *Address: *25th Fl., No 91, Nguyen Chi Thanh St., Ha Noi City, VietNam
> > *Website:* http://olbius.com
> >
>