Errors encountered in eCommerce and Ordermgr

[rnatavio]

Here are the three errors I've encountered that I've been experiencing since rev673962 (first source i checked out), until rev677485:

_______________________________________________________________________________________
1.) Ordermgr: I created a Quote from the Request, then tried to create an Adjustment (run promotion), but this is what I got:

ERROR: Could not complete the Auto create QuoteAdjustments [file:/C:/ofbiz-trunk/applications/order/script/org/ofbiz/order/quote/QuoteServices.xml#autoCreateQuoteAdjustments] process [problem invoking the [loadCartFromQuote] service with the map named [loadCartFromQuoteInMap] containing.....

_______________________________________________________________________________________
2) ECommerce: I tried to view the Request for Quote I sent, but this is what I got: (i think this has something to do with relational mappings)

... IllegalArgumentException: Problem getting related one from entity with name CustRequest .......
_______________________________________________________________________________________
3) ECommerce: After receiving the Quote I requested, I viewed the Quote and tried to create an order out of it, but this is what I got (this issue was already posted in apache jira, but still unresolved):

Service target threw an unexpected exception ([GenericEntity.get] "accommodationMapId" is not a field of QuoteItem)


I'm currently finding a way to solve this but if anyone has a workaround for this please let me know.

Cheers!
-roy

[Jacques Le Roux]

Are you using OFBiz OOTB or have you customised (before I test) ?

Jacques

From: "rnatavio" <[hidden email]>

>
> Here are the three errors I've encountered that I've been experiencing since
> rev673962 (first source i checked out), until rev677485:
>
> _______________________________________________________________________________________
> 1.) Ordermgr: I created a Quote from the Request, then tried to create an
> Adjustment (run promotion), but this is what I got:
>
> ERROR: Could not complete the Auto create QuoteAdjustments
> [file:/C:/ofbiz-trunk/applications/order/script/org/ofbiz/order/quote/QuoteServices.xml#autoCreateQuoteAdjustments]
> process [problem invoking the [loadCartFromQuote] service with the map named
> [loadCartFromQuoteInMap] containing.....
>
> _______________________________________________________________________________________
> 2) ECommerce: I tried to view the Request for Quote I sent, but this is what
> I got: (i think this has something to do with relational mappings)
>
> ... IllegalArgumentException: Problem getting related one from entity with
> name CustRequest .......
> _______________________________________________________________________________________
> 3) ECommerce: After receiving the Quote I requested, I viewed the Quote and
> tried to create an order out of it, but this is what I got (this issue was
> already posted in apache jira, but still unresolved):
>
> Service target threw an unexpected exception ([GenericEntity.get]
> "accommodationMapId" is not a field of QuoteItem)
>
>
> I'm currently finding a way to solve this but if anyone has a workaround for
> this please let me know.
>
> Cheers!
> -roy
>
> --
> View this message in context: http://www.nabble.com/Errors-encountered-in-eCommerce-and-Ordermgr-tp18501039p18501039.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[rnatavio]

Hi Jacques,

I haven't customized anything yet. I just updated from trunk, executed ant(clean, run-install), then started the app.

Roy

jacques.le.roux wrote

Are you using OFBiz OOTB or have you customised (before I test) ?

Jacques

From: "rnatavio" <[e-mail]>
>
> Here are the three errors I've encountered that I've been experiencing since
> rev673962 (first source i checked out), until rev677485:
>
> _______________________________________________________________________________________
> 1.) Ordermgr: I created a Quote from the Request, then tried to create an
> Adjustment (run promotion), but this is what I got:
>
> ERROR: Could not complete the Auto create QuoteAdjustments
> [file:/C:/ofbiz-trunk/applications/order/script/org/ofbiz/order/quote/QuoteServices.xml#autoCreateQuoteAdjustments]
> process [problem invoking the [loadCartFromQuote] service with the map named
> [loadCartFromQuoteInMap] containing.....
>
> _______________________________________________________________________________________
> 2) ECommerce: I tried to view the Request for Quote I sent, but this is what
> I got: (i think this has something to do with relational mappings)
>
> ... IllegalArgumentException: Problem getting related one from entity with
> name CustRequest .......
> _______________________________________________________________________________________
> 3) ECommerce: After receiving the Quote I requested, I viewed the Quote and
> tried to create an order out of it, but this is what I got (this issue was
> already posted in apache jira, but still unresolved):
>
> Service target threw an unexpected exception ([GenericEntity.get]
> "accommodationMapId" is not a field of QuoteItem)
>
>
> I'm currently finding a way to solve this but if anyone has a workaround for
> this please let me know.
>
> Cheers!
> -roy
>
> --
> View this message in context: http://www.nabble.com/Errors-encountered-in-eCommerce-and-Ordermgr-tp18501039p18501039.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Bilgin Ibryam]

Roy, thanks for reporting these errors.

2) is fixed in trunk r677544.
I'll check 1 and 3 before the end of this week.

Bilgin

[Amine Benkirane]

      Hi,

I'm customizing, acutally, an OFBiz ecommerce site. For my specific needs, I want to associates Categories and products with parties. Basically, I add a party like customerA (partyId = 10000) and I want that this customer can only visualize (and buy) the categories and products which are associated to him.

I saw that in the Catalog Manager Application when I browsed my categories and click on one, there is a parties menu. I thought that can do my need but when I want to associate party to category (I select customer for the type), I had this error :

   
The Following Errors Occurred:
        ERROR:
Could not complete the Add Party to Category
[file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
process [problem creating the newEntity value: Error while inserting:
[GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)][productCategoryId,snackfood_fr(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE' caused
a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
(10000,CUSTOMER). The statement has been rolled back.))]
 
Did I forgot something to do this association betwwen my categories and parties ?

Regards,

Amine




_________________________________________________________________
Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé. Créez le votre gratuitement !
http://www.windowslive.fr/hotmail/default.asp

[Jacopo Cappellato-3]

You should add to the party 10000 the role of CUSTOMER to avoid that  
error.

Jacopo

On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:

>
>      Hi,
>
> I'm customizing, acutally, an OFBiz ecommerce site. For my specific  
> needs, I want to associates Categories and products with parties.  
> Basically, I add a party like customerA (partyId = 10000) and I want  
> that this customer can only visualize (and buy) the categories and  
> products which are associated to him.
>
> I saw that in the Catalog Manager Application when I browsed my  
> categories and click on one, there is a parties menu. I thought that  
> can do my need but when I want to associate party to category (I  
> select customer for the type), I had this error :
>
>
> The Following Errors Occurred:
>        ERROR:
> Could not complete the Add Party to Category
> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/
> ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
> process [problem creating the newEntity value: Error while inserting:
> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)]
> [productCategoryId,snackfood_fr(java.lang.String)]
> [roleTypeId,CUSTOMER(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE'  
> caused
> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
> (10000,CUSTOMER). The statement has been rolled back.))]
>
> Did I forgot something to do this association betwwen my categories  
> and parties ?
>
> Regards,
>
> Amine
>
>
>
>
> _________________________________________________________________
> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé.  
> Créez le votre gratuitement !
> http://www.windowslive.fr/hotmail/default.asp

[Amine Benkirane]

Ok it works !! Thank you Jacopo !!!!

I only have a question : when a party logged in the ecommerce site, is this association generate the ecommerce browse categories with only the categories associated with the party  ?

Regards,

Amine

> From: [hidden email]
> To: [hidden email]
> Subject: Re: Categories/products and parties
> Date: Thu, 17 Jul 2008 14:32:32 +0200
>
> You should add to the party 10000 the role of CUSTOMER to avoid that  
> error.
>
> Jacopo
>
> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>
> >
> >      Hi,
> >
> > I'm customizing, acutally, an OFBiz ecommerce site. For my specific  
> > needs, I want to associates Categories and products with parties.  
> > Basically, I add a party like customerA (partyId = 10000) and I want  
> > that this customer can only visualize (and buy) the categories and  
> > products which are associated to him.
> >
> > I saw that in the Catalog Manager Application when I browsed my  
> > categories and click on one, there is a parties menu. I thought that  
> > can do my need but when I want to associate party to category (I  
> > select customer for the type), I had this error :
> >
> >
> > The Following Errors Occurred:
> >        ERROR:
> > Could not complete the Add Party to Category
> > [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/
> > ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
> > process [problem creating the newEntity value: Error while inserting:
> > [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
> > 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
> > 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
> > 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
> > 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
> > 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)]
> > [productCategoryId,snackfood_fr(java.lang.String)]
> > [roleTypeId,CUSTOMER(java.lang.String)]
> > (SQL Exception while executing the following:INSERT INTO
> > OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
> > ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
> > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE'  
> > caused
> > a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
> > (10000,CUSTOMER). The statement has been rolled back.))]
> >
> > Did I forgot something to do this association betwwen my categories  
> > and parties ?
> >
> > Regards,
> >
> > Amine
> >
> >
> >
> >
> > _________________________________________________________________
> > Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé.  
> > Créez le votre gratuitement !
> > http://www.windowslive.fr/hotmail/default.asp
>

_________________________________________________________________
Contrôlez les personnes autorisées à parler à vos enfants sur  MSN / Windows Live Messenger !
http://www.windowslive.fr/controleparental/default.asp

[rnatavio]

Thanks Bilgin for the info. I'll update my source right away and keep everyone posted on errors/bugs I encounter, and how I managed to solve it (if ever I can solve some of 'em).

Cheers and Regards
Roy

Bilgin Ibryam wrote

Roy, thanks for reporting these errors.

2) is fixed in trunk r677544.
I'll check 1 and 3 before the end of this week.

Bilgin

[Ashish Vijaywargiya]

Jacopo,

I remembered that somewhere in Ofbiz a functionality exists to first check
the associated role based record, if it doesn't exists then first it creates
that record and then
create the Record in the calling entity that check for foreign key
constraint.
I think we should avoid this kind of error as far as User Point of View is
concerned.

Does this scenario applies to here as well ?
If yes please let me know I will work on it as soon as I will get a chance.

Please let me know your thoughts on this.

On Thu, Jul 17, 2008 at 6:02 PM, Jacopo Cappellato <
[hidden email]> wrote:

> You should add to the party 10000 the role of CUSTOMER to avoid that error.
>
> Jacopo
>
>
> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>
>
>>     Hi,
>>
>> I'm customizing, acutally, an OFBiz ecommerce site. For my specific needs,
>> I want to associates Categories and products with parties. Basically, I add
>> a party like customerA (partyId = 10000) and I want that this customer can
>> only visualize (and buy) the categories and products which are associated to
>> him.
>>
>> I saw that in the Catalog Manager Application when I browsed my categories
>> and click on one, there is a parties menu. I thought that can do my need but
>> when I want to associate party to category (I select customer for the type),
>> I had this error :
>>
>>
>> The Following Errors Occurred:
>>       ERROR:
>> Could not complete the Add Party to Category
>>
>> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
>> process [problem creating the newEntity value: Error while inserting:
>> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
>> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
>> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
>>
>> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)][productCategoryId,snackfood_fr(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)]
>> (SQL Exception while executing the following:INSERT INTO
>> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
>> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
>> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE' caused
>> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
>> (10000,CUSTOMER). The statement has been rolled back.))]
>>
>> Did I forgot something to do this association betwwen my categories and
>> parties ?
>>
>> Regards,
>>
>> Amine
>>
>>
>>
>>
>> _________________________________________________________________
>> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé. Créez le
>> votre gratuitement !
>> http://www.windowslive.fr/hotmail/default.asp
>>
>
>

--
Ashish Vijaywargiya
Indore, India
http://en.wikipedia.org/wiki/Indore

[Jacopo Cappellato-3]

Hi Ashish,

I don't like too much the idea of adding behind the lines the role to  
the party: in fact, if the user selects a wrong partyId (for example a  
supplier) and the system will make it a customer...
The best solution would be, IMO, to enhance the UI (maybe with some  
Ajax magic) so that, when the user selects a role, then only the  
parties with that role are shown.

Jacopo

On Jul 18, 2008, at 9:59 AM, Ashish Vijaywargiya wrote:

> Jacopo,
>
> I remembered that somewhere in Ofbiz a functionality exists to first  
> check
> the associated role based record, if it doesn't exists then first it  
> creates
> that record and then
> create the Record in the calling entity that check for foreign key
> constraint.
> I think we should avoid this kind of error as far as User Point of  
> View is
> concerned.
>
> Does this scenario applies to here as well ?
> If yes please let me know I will work on it as soon as I will get a  
> chance.
>
> Please let me know your thoughts on this.
>
> On Thu, Jul 17, 2008 at 6:02 PM, Jacopo Cappellato <
> [hidden email]> wrote:
>
>> You should add to the party 10000 the role of CUSTOMER to avoid  
>> that error.
>>
>> Jacopo
>>
>>
>> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>>
>>
>>>    Hi,
>>>
>>> I'm customizing, acutally, an OFBiz ecommerce site. For my  
>>> specific needs,
>>> I want to associates Categories and products with parties.  
>>> Basically, I add
>>> a party like customerA (partyId = 10000) and I want that this  
>>> customer can
>>> only visualize (and buy) the categories and products which are  
>>> associated to
>>> him.
>>>
>>> I saw that in the Catalog Manager Application when I browsed my  
>>> categories
>>> and click on one, there is a parties menu. I thought that can do  
>>> my need but
>>> when I want to associate party to category (I select customer for  
>>> the type),
>>> I had this error :
>>>
>>>
>>> The Following Errors Occurred:
>>>      ERROR:
>>> Could not complete the Add Party to Category
>>>
>>> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/
>>> org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
>>> process [problem creating the newEntity value: Error while  
>>> inserting:
>>> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
>>> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
>>> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
>>>
>>> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)]
>>> [productCategoryId,snackfood_fr(java.lang.String)]
>>> [roleTypeId,CUSTOMER(java.lang.String)]
>>> (SQL Exception while executing the following:INSERT INTO
>>> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
>>> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES  
>>> (?, ?,
>>> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE'  
>>> caused
>>> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
>>> (10000,CUSTOMER). The statement has been rolled back.))]
>>>
>>> Did I forgot something to do this association betwwen my  
>>> categories and
>>> parties ?
>>>
>>> Regards,
>>>
>>> Amine
>>>
>>>
>>>
>>>
>>> _________________________________________________________________
>>> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé.  
>>> Créez le
>>> votre gratuitement !
>>> http://www.windowslive.fr/hotmail/default.asp
>>>
>>
>>
>
>
> --
> Ashish Vijaywargiya
> Indore, India
> http://en.wikipedia.org/wiki/Indore

[Ashish Vijaywargiya]

Jacopo,

I like your idea.
Will put my efforts soon on this.

On Fri, Jul 18, 2008 at 3:08 PM, Jacopo Cappellato <
[hidden email]> wrote:

> Hi Ashish,
>
> I don't like too much the idea of adding behind the lines the role to the
> party: in fact, if the user selects a wrong partyId (for example a supplier)
> and the system will make it a customer...
> The best solution would be, IMO, to enhance the UI (maybe with some Ajax
> magic) so that, when the user selects a role, then only the parties with
> that role are shown.
>
> Jacopo
>
>
> On Jul 18, 2008, at 9:59 AM, Ashish Vijaywargiya wrote:
>
>  Jacopo,
>>
>> I remembered that somewhere in Ofbiz a functionality exists to first check
>> the associated role based record, if it doesn't exists then first it
>> creates
>> that record and then
>> create the Record in the calling entity that check for foreign key
>> constraint.
>> I think we should avoid this kind of error as far as User Point of View is
>> concerned.
>>
>> Does this scenario applies to here as well ?
>> If yes please let me know I will work on it as soon as I will get a
>> chance.
>>
>> Please let me know your thoughts on this.
>>
>> On Thu, Jul 17, 2008 at 6:02 PM, Jacopo Cappellato <
>> [hidden email]> wrote:
>>
>>  You should add to the party 10000 the role of CUSTOMER to avoid that
>>> error.
>>>
>>> Jacopo
>>>
>>>
>>> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>>>
>>>
>>>    Hi,
>>>>
>>>> I'm customizing, acutally, an OFBiz ecommerce site. For my specific
>>>> needs,
>>>> I want to associates Categories and products with parties. Basically, I
>>>> add
>>>> a party like customerA (partyId = 10000) and I want that this customer
>>>> can
>>>> only visualize (and buy) the categories and products which are
>>>> associated to
>>>> him.
>>>>
>>>> I saw that in the Catalog Manager Application when I browsed my
>>>> categories
>>>> and click on one, there is a parties menu. I thought that can do my need
>>>> but
>>>> when I want to associate party to category (I select customer for the
>>>> type),
>>>> I had this error :
>>>>
>>>>
>>>> The Following Errors Occurred:
>>>>     ERROR:
>>>> Could not complete the Add Party to Category
>>>>
>>>>
>>>> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
>>>> process [problem creating the newEntity value: Error while inserting:
>>>> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
>>>> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
>>>> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
>>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
>>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
>>>>
>>>>
>>>> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)][productCategoryId,snackfood_fr(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)]
>>>> (SQL Exception while executing the following:INSERT INTO
>>>> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
>>>> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
>>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
>>>> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE' caused
>>>> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
>>>> (10000,CUSTOMER). The statement has been rolled back.))]
>>>>
>>>> Did I forgot something to do this association betwwen my categories and
>>>> parties ?
>>>>
>>>> Regards,
>>>>
>>>> Amine
>>>>
>>>>
>>>>
>>>>
>>>> _________________________________________________________________
>>>> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé. Créez le
>>>> votre gratuitement !
>>>> http://www.windowslive.fr/hotmail/default.asp
>>>>
>>>>
>>>
>>>
>>
>> --
>> Ashish Vijaywargiya
>> Indore, India
>> http://en.wikipedia.org/wiki/Indore
>>
>
>

--
Ashish Vijaywargiya
Indore, India
http://en.wikipedia.org/wiki/Indore

[pmacdee]

I am experiencing the same error as #3 reported above.  Was this ever resolved? I am upgrading from r593355 to r699005.  It would seem to me that I need to have
the accommodationMapID field added to the QuoteItem table.  If this is the case, how do I do it?

Bilgin Ibryam wrote

Roy, thanks for reporting these errors.

2) is fixed in trunk r677544.
I'll check 1 and 3 before the end of this week.

Bilgin