You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Warren Goddard <wa...@failsafecanada.com> on 2006/09/07 20:05:23 UTC
opentravel issues
First of all sorry for the long message/post.
I am getting no where fast and with no assistance. I installed Opentaps
with the opentravel component using the 124mb download available on the
OpenTravelSystems website. After much trial and error with other db's I
am now using the embedded derby db. The 'specialized' folder is loading
2nd last(before the website) in the component-load.xml file. I can
purchase a hat...I cannot, however book a room. The error I get when I
submit the order is 'Problem with order change; see error above' 2
things, firstly I am not changing an order...I am creating a new one.
Secondly there is no 'error above'. As well the room does in fact show
as being allocated in the Fixed_Asset calendar and when you cancel the
reservation, an email confirming the cancellation is sent and received
As well, I am getting pk/fk errors when I try to add or edit an existing
product. I am logged in using the built-in Admin account. By using the
embedded derby db I felt I was removing any permissions issues that may
have been plaguing my install. But I have the same errors when I'm using
SQL Server, PostGres and Derby.
This is the error I get when trying to edit an existing product's
Comments field:
In set-nonpk-fields a value was not found with the specified valueAcsr:
lookedUpValue, not setting fields
This is the error I get when I try to create a new product(everything is
filled except for the Tax Vat Code, Tax Category, Tax Duty Codes...if
these fields are required there should be a dropdown with the options):
* ERROR: Could not complete the Create an Product
[file:/C:/opentaps/applications/product/script/org/ofbiz/product/product
/ProductServices.xml#createProduct] process [problem creating the
newEntity value: Exception while inserting the following entity:
[GenericEntity:Product][autoCreateKeywords,N(java.lang.String)][billOfMa
terialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][co
mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lan
g.String)][createdDate,2006-09-06
17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][description,TestRoom(java.lang.String)]
[includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom(java
.lang.String)][introductionDate,2006-09-06
17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)][isVirtual
,N(java.lang.String)][lastModifiedByUserLogin,flexadmin(java.lang.String
)][lastModifiedDate,2006-09-06
17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin(java.lan
g.String)][productId,10020(java.lang.String)][productTypeId,ASSET_USAGE(
java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null()][
taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)]
(while inserting:
[GenericEntity:Product][autoCreateKeywords,N(java.lang.String)][billOfMa
terialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][co
mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lan
g.String)][createdDate,2006-09-06
17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][description,TestRoom(java.lang.String)]
[includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom(java
.lang.String)][introductionDate,2006-09-06
17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)][isVirtual
,N(java.lang.String)][lastModifiedByUserLogin,flexadmin(java.lang.String
)][lastModifiedDate,2006-09-06
17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin(java.lan
g.String)][productId,10020(java.lang.String)][productTypeId,ASSET_USAGE(
java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null()][
taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO OFBIZ.PRODUCT
(PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID,
MANUFACTURER_PARTY_ID, FACILITY_ID, INTRODUCTION_DATE,
SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE,
SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, COMMENTS,
PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION, SMALL_IMAGE_URL,
MEDIUM_IMAGE_URL, LARGE_IMAGE_URL, DETAIL_IMAGE_URL, DETAIL_SCREEN,
INVENTORY_MESSAGE, REQUIRE_INVENTORY, QUANTITY_UOM_ID,
QUANTITY_INCLUDED, PIECES_INCLUDED, REQUIRE_AMOUNT, FIXED_AMOUNT,
AMOUNT_UOM_TYPE_ID, WEIGHT_UOM_ID, WEIGHT, HEIGHT_UOM_ID,
PRODUCT_HEIGHT, SHIPPING_HEIGHT, WIDTH_UOM_ID, PRODUCT_WIDTH,
SHIPPING_WIDTH, DEPTH_UOM_ID, PRODUCT_DEPTH, SHIPPING_DEPTH,
PRODUCT_RATING, RATING_TYPE_ENUM, RETURNABLE, TAXABLE, TAX_CATEGORY,
TAX_VAT_CODE, TAX_DUTY_CODE, CHARGE_SHIPPING, AUTO_CREATE_KEYWORDS,
INCLUDE_IN_PROMOTIONS, IS_VIRTUAL, IS_VARIANT,
REQUIREMENT_METHOD_ENUM_ID, BILL_OF_MATERIAL_LEVEL, RESERV_MAX_PERSONS,
RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC, CREATED_DATE,
CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?) (INSERT on table 'PRODUCT' caused a violation of foreign key
constraint 'PROD_PRIMARY_CAT' for key (admin). The statement has been
rolled back.)))] calling service createProductOfbiz in createProduct
Currently this is running on a Windows 2003 server utilizing the
embedded db, embedded app server. Java 1.4.2_12 sdk, though I will be
reverting back to an Sql Server db as the error messages encountered are
the same with either db.
Thanks in advance
Regards,
Warren Goddard
Failsafe Canada Inc.
Office: 403.313.6789
Fax: 403.313.6792
Cellular: 403.708.9270
Intelligent Business Solutions Using Innovative Technology
Re: opentravel issues
Posted by Jacopo Cappellato <ti...@sastau.it>.
Hi Warren,
> ?) (INSERT on table 'PRODUCT' caused a violation of foreign key
> constraint 'PROD_PRIMARY_CAT' for key (admin). The statement has been
> rolled back.)))] calling service createProductOfbiz in createProduct
just don't fill the product's primaryCategory and you should succesfully
create your product.
Jacopo
Re: opentravel issues
Posted by David E Jones <jo...@undersunconsulting.com>.
Yes, even the core OFBiz is somewhat buggy. When you get outside of
that the user and developer groups are even smaller and so things get
a bit trickier. I think Hans has done a great job with the
opentravelsystem stuff, but I don't know how much he has invested in
it recently and I have no idea if it is even really complete, let
alone production hardened.
-David
On Sep 8, 2006, at 2:49 PM, Warren Goddard wrote:
> I found out that reason I was getting the error 'Problem with
> order' was because when I used the complete 124mb download of
> Opentaps with open travel the GLAccount tables were not getting
> populated. Once I installed Opentaps without opentravel the tables
> were created with demo data. Then I rebuilt with the specialized/
> opentravelsystems folder added and I can book rooms. However for
> whatever reason I cannot use CAN as the currency or it will throw
> an error. I can use USD and EUR though. This is the first time
> using an opensource application and I must say it sure can be bug
> ridden.
>
> Regards,
> Warren Goddard
> Failsafe Canada Inc.
> Office: 403.313.6789
> Fax: 403.313.6792
> Cellular: 403.708.9270
>
> Intelligent Business Solutions Using Innovative Technology
>
> -----Original Message-----
> From: Chris Howe [mailto:cjhowe76013@yahoo.com]
> Sent: Thursday, September 07, 2006 2:10 PM
> To: ofbiz-user@incubator.apache.org
> Subject: Re: opentravel issues
>
> I'd have to look further into your first issue baout the
> lookedUpValue. but the second issue is that you are trying to set
> (either you entering or opentravel
> entering) the primaryProductCategoryId for the new product to
> "admin" when you there is not a category with categoryId = "admin"
>
> --- Warren Goddard <wa...@failsafecanada.com> wrote:
>
>>
>>
>> First of all sorry for the long message/post.
>>
>>
>>
>> I am getting no where fast and with no assistance. I installed
>> Opentaps with the opentravel component using the 124mb download
>> available on the OpenTravelSystems website. After much trial and
>> error
>> with other db's I am now using the embedded derby db. The
>> 'specialized' folder is loading 2nd last(before the website) in the
>> component-load.xml file. I can purchase a hat...I cannot, however
>> book
>> a room. The error I get when I submit the order is 'Problem with
>> order
>> change; see error above' 2 things, firstly I am not changing an
>> order...I am creating a new one.
>> Secondly there is no 'error above'. As well the room does in fact
>> show
>> as being allocated in the Fixed_Asset calendar and when you cancel
>> the
>> reservation, an email confirming the cancellation is sent and
>> received
>>
>> As well, I am getting pk/fk errors when I try to add or edit an
>> existing product. I am logged in using the built-in Admin account. By
>> using the embedded derby db I felt I was removing any permissions
>> issues that may have been plaguing my install. But I have the same
>> errors when I'm using SQL Server, PostGres and Derby.
>>
>> This is the error I get when trying to edit an existing product's
>> Comments field:
>>
>> In set-nonpk-fields a value was not found with the specified
>> valueAcsr:
>> lookedUpValue, not setting fields
>>
>> This is the error I get when I try to create a new product(everything
>> is filled except for the Tax Vat Code, Tax Category, Tax Duty
>> Codes...if these fields are required there should be a dropdown with
>> the options):
>>
>> * ERROR: Could not complete the Create an
>> Product
>>
> [file:/C:/opentaps/applications/product/script/org/ofbiz/product/
> product
>> /ProductServices.xml#createProduct] process [problem creating the
>> newEntity value: Exception while inserting the following entity:
>>
> [GenericEntity:Product][autoCreateKeywords,N(java.lang.String)]
> [billOfMa
>>
> terialLevel,0(java.lang.Integer)][chargeShipping,N
> (java.lang.String)][co
>>
> mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin
> (java.lan
>> g.String)][createdDate,2006-09-06
>>
> 17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][description,TestRoom
> (java.lang.String)]
>>
> [includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom
> (java
>> .lang.String)][introductionDate,2006-09-06
>>
> 17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)]
> [isVirtual
>>
> ,N(java.lang.String)][lastModifiedByUserLogin,flexadmin
> (java.lang.String
>> )][lastModifiedDate,2006-09-06
>>
> 17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin
> (java.lan
>>
> g.String)][productId,10020(java.lang.String)]
> [productTypeId,ASSET_USAGE(
>>
> java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null
> ()][
>>
> taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)]
>> (while inserting:
>>
> [GenericEntity:Product][autoCreateKeywords,N(java.lang.String)]
> [billOfMa
>>
> terialLevel,0(java.lang.Integer)][chargeShipping,N
> (java.lang.String)][co
>>
> mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin
> (java.lan
>> g.String)][createdDate,2006-09-06
>>
> 17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][description,TestRoom
> (java.lang.String)]
>>
> [includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom
> (java
>> .lang.String)][introductionDate,2006-09-06
>>
> 17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)]
> [isVirtual
>>
> ,N(java.lang.String)][lastModifiedByUserLogin,flexadmin
> (java.lang.String
>> )][lastModifiedDate,2006-09-06
>>
> 17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
>>
> 17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin
> (java.lan
>>
> g.String)][productId,10020(java.lang.String)]
> [productTypeId,ASSET_USAGE(
>>
> java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null
> ()][
>>
> taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)]
>> (SQL
>> Exception while executing the following:INSERT INTO OFBIZ.PRODUCT
>> (PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID,
>> MANUFACTURER_PARTY_ID, FACILITY_ID, INTRODUCTION_DATE,
>> SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE,
>> SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, COMMENTS,
>> PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION, SMALL_IMAGE_URL,
>> MEDIUM_IMAGE_URL, LARGE_IMAGE_URL, DETAIL_IMAGE_URL, DETAIL_SCREEN,
>> INVENTORY_MESSAGE, REQUIRE_INVENTORY, QUANTITY_UOM_ID,
>> QUANTITY_INCLUDED, PIECES_INCLUDED, REQUIRE_AMOUNT, FIXED_AMOUNT,
>> AMOUNT_UOM_TYPE_ID, WEIGHT_UOM_ID, WEIGHT, HEIGHT_UOM_ID,
>> PRODUCT_HEIGHT, SHIPPING_HEIGHT, WIDTH_UOM_ID, PRODUCT_WIDTH,
>> SHIPPING_WIDTH, DEPTH_UOM_ID, PRODUCT_DEPTH, SHIPPING_DEPTH,
>> PRODUCT_RATING, RATING_TYPE_ENUM, RETURNABLE, TAXABLE, TAX_CATEGORY,
>> TAX_VAT_CODE, TAX_DUTY_CODE, CHARGE_SHIPPING, AUTO_CREATE_KEYWORDS,
>> INCLUDE_IN_PROMOTIONS, IS_VIRTUAL, IS_VARIANT,
>> REQUIREMENT_METHOD_ENUM_ID, BILL_OF_MATERIAL_LEVEL,
>> RESERV_MAX_PERSONS, RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC,
>> CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
>> LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP,
>> LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>> CREATED_TX_STAMP) VALUES
>> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
>> ?, ?,
>> ?) (INSERT on table 'PRODUCT' caused a violation of foreign key
>> constraint 'PROD_PRIMARY_CAT' for key (admin). The statement has been
>> rolled back.)))] calling service createProductOfbiz in createProduct
>>
>>
>>
>> Currently this is running on a Windows 2003 server utilizing the
>> embedded db, embedded app server. Java 1.4.2_12 sdk, though I will be
>> reverting back to an Sql Server db as the error messages encountered
>> are the same with either db.
>>
>> Thanks in advance
>>
>>
>>
>> Regards,
>>
>> Warren Goddard
>>
>> Failsafe Canada Inc.
>>
>> Office: 403.313.6789
>>
>> Fax: 403.313.6792
>>
>> Cellular: 403.708.9270
>>
>>
>>
>> Intelligent Business Solutions Using Innovative Technology
>>
>>
>>
>>
>>
>>
>
RE: opentravel issues
Posted by Warren Goddard <wa...@failsafecanada.com>.
I found out that reason I was getting the error 'Problem with order' was because when I used the complete 124mb download of Opentaps with open travel the GLAccount tables were not getting populated. Once I installed Opentaps without opentravel the tables were created with demo data. Then I rebuilt with the specialized/opentravelsystems folder added and I can book rooms. However for whatever reason I cannot use CAN as the currency or it will throw an error. I can use USD and EUR though. This is the first time using an opensource application and I must say it sure can be bug ridden.
Regards,
Warren Goddard
Failsafe Canada Inc.
Office: 403.313.6789
Fax: 403.313.6792
Cellular: 403.708.9270
Intelligent Business Solutions Using Innovative Technology
-----Original Message-----
From: Chris Howe [mailto:cjhowe76013@yahoo.com]
Sent: Thursday, September 07, 2006 2:10 PM
To: ofbiz-user@incubator.apache.org
Subject: Re: opentravel issues
I'd have to look further into your first issue baout the lookedUpValue. but the second issue is that you are trying to set (either you entering or opentravel
entering) the primaryProductCategoryId for the new product to "admin" when you there is not a category with categoryId = "admin"
--- Warren Goddard <wa...@failsafecanada.com> wrote:
>
>
> First of all sorry for the long message/post.
>
>
>
> I am getting no where fast and with no assistance. I installed
> Opentaps with the opentravel component using the 124mb download
> available on the OpenTravelSystems website. After much trial and error
> with other db's I am now using the embedded derby db. The
> 'specialized' folder is loading 2nd last(before the website) in the
> component-load.xml file. I can purchase a hat...I cannot, however book
> a room. The error I get when I submit the order is 'Problem with order
> change; see error above' 2 things, firstly I am not changing an
> order...I am creating a new one.
> Secondly there is no 'error above'. As well the room does in fact show
> as being allocated in the Fixed_Asset calendar and when you cancel the
> reservation, an email confirming the cancellation is sent and received
>
> As well, I am getting pk/fk errors when I try to add or edit an
> existing product. I am logged in using the built-in Admin account. By
> using the embedded derby db I felt I was removing any permissions
> issues that may have been plaguing my install. But I have the same
> errors when I'm using SQL Server, PostGres and Derby.
>
> This is the error I get when trying to edit an existing product's
> Comments field:
>
> In set-nonpk-fields a value was not found with the specified
> valueAcsr:
> lookedUpValue, not setting fields
>
> This is the error I get when I try to create a new product(everything
> is filled except for the Tax Vat Code, Tax Category, Tax Duty
> Codes...if these fields are required there should be a dropdown with
> the options):
>
> * ERROR: Could not complete the Create an
> Product
>
[file:/C:/opentaps/applications/product/script/org/ofbiz/product/product
> /ProductServices.xml#createProduct] process [problem creating the
> newEntity value: Exception while inserting the following entity:
>
[GenericEntity:Product][autoCreateKeywords,N(java.lang.String)][billOfMa
>
terialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][co
>
mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lan
> g.String)][createdDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][description,TestRoom(java.lang.String)]
>
[includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom(java
> .lang.String)][introductionDate,2006-09-06
>
17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)][isVirtual
>
,N(java.lang.String)][lastModifiedByUserLogin,flexadmin(java.lang.String
> )][lastModifiedDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin(java.lan
>
g.String)][productId,10020(java.lang.String)][productTypeId,ASSET_USAGE(
>
java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null()][
>
taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)]
> (while inserting:
>
[GenericEntity:Product][autoCreateKeywords,N(java.lang.String)][billOfMa
>
terialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][co
>
mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lan
> g.String)][createdDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][description,TestRoom(java.lang.String)]
>
[includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom(java
> .lang.String)][introductionDate,2006-09-06
>
17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)][isVirtual
>
,N(java.lang.String)][lastModifiedByUserLogin,flexadmin(java.lang.String
> )][lastModifiedDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin(java.lan
>
g.String)][productId,10020(java.lang.String)][productTypeId,ASSET_USAGE(
>
java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null()][
>
taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)]
> (SQL
> Exception while executing the following:INSERT INTO OFBIZ.PRODUCT
> (PRODUCT_ID, PRODUCT_TYPE_ID, PRIMARY_PRODUCT_CATEGORY_ID,
> MANUFACTURER_PARTY_ID, FACILITY_ID, INTRODUCTION_DATE,
> SUPPORT_DISCONTINUATION_DATE, SALES_DISCONTINUATION_DATE,
> SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME, BRAND_NAME, COMMENTS,
> PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION, SMALL_IMAGE_URL,
> MEDIUM_IMAGE_URL, LARGE_IMAGE_URL, DETAIL_IMAGE_URL, DETAIL_SCREEN,
> INVENTORY_MESSAGE, REQUIRE_INVENTORY, QUANTITY_UOM_ID,
> QUANTITY_INCLUDED, PIECES_INCLUDED, REQUIRE_AMOUNT, FIXED_AMOUNT,
> AMOUNT_UOM_TYPE_ID, WEIGHT_UOM_ID, WEIGHT, HEIGHT_UOM_ID,
> PRODUCT_HEIGHT, SHIPPING_HEIGHT, WIDTH_UOM_ID, PRODUCT_WIDTH,
> SHIPPING_WIDTH, DEPTH_UOM_ID, PRODUCT_DEPTH, SHIPPING_DEPTH,
> PRODUCT_RATING, RATING_TYPE_ENUM, RETURNABLE, TAXABLE, TAX_CATEGORY,
> TAX_VAT_CODE, TAX_DUTY_CODE, CHARGE_SHIPPING, AUTO_CREATE_KEYWORDS,
> INCLUDE_IN_PROMOTIONS, IS_VIRTUAL, IS_VARIANT,
> REQUIREMENT_METHOD_ENUM_ID, BILL_OF_MATERIAL_LEVEL,
> RESERV_MAX_PERSONS, RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC,
> CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
> LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?,
> ?) (INSERT on table 'PRODUCT' caused a violation of foreign key
> constraint 'PROD_PRIMARY_CAT' for key (admin). The statement has been
> rolled back.)))] calling service createProductOfbiz in createProduct
>
>
>
> Currently this is running on a Windows 2003 server utilizing the
> embedded db, embedded app server. Java 1.4.2_12 sdk, though I will be
> reverting back to an Sql Server db as the error messages encountered
> are the same with either db.
>
> Thanks in advance
>
>
>
> Regards,
>
> Warren Goddard
>
> Failsafe Canada Inc.
>
> Office: 403.313.6789
>
> Fax: 403.313.6792
>
> Cellular: 403.708.9270
>
>
>
> Intelligent Business Solutions Using Innovative Technology
>
>
>
>
>
>
Re: opentravel issues
Posted by Chris Howe <cj...@yahoo.com>.
I'd have to look further into your first issue baout
the lookedUpValue. but the second issue is that you
are trying to set (either you entering or opentravel
entering) the primaryProductCategoryId for the new
product to "admin" when you there is not a category
with categoryId = "admin"
--- Warren Goddard <wa...@failsafecanada.com> wrote:
>
>
> First of all sorry for the long message/post.
>
>
>
> I am getting no where fast and with no assistance. I
> installed Opentaps
> with the opentravel component using the 124mb
> download available on the
> OpenTravelSystems website. After much trial and
> error with other db's I
> am now using the embedded derby db. The
> 'specialized' folder is loading
> 2nd last(before the website) in the
> component-load.xml file. I can
> purchase a hat...I cannot, however book a room. The
> error I get when I
> submit the order is 'Problem with order change; see
> error above' 2
> things, firstly I am not changing an order...I am
> creating a new one.
> Secondly there is no 'error above'. As well the room
> does in fact show
> as being allocated in the Fixed_Asset calendar and
> when you cancel the
> reservation, an email confirming the cancellation is
> sent and received
>
> As well, I am getting pk/fk errors when I try to add
> or edit an existing
> product. I am logged in using the built-in Admin
> account. By using the
> embedded derby db I felt I was removing any
> permissions issues that may
> have been plaguing my install. But I have the same
> errors when I'm using
> SQL Server, PostGres and Derby.
>
> This is the error I get when trying to edit an
> existing product's
> Comments field:
>
> In set-nonpk-fields a value was not found with the
> specified valueAcsr:
> lookedUpValue, not setting fields
>
> This is the error I get when I try to create a new
> product(everything is
> filled except for the Tax Vat Code, Tax Category,
> Tax Duty Codes...if
> these fields are required there should be a dropdown
> with the options):
>
> * ERROR: Could not complete the Create an
> Product
>
[file:/C:/opentaps/applications/product/script/org/ofbiz/product/product
> /ProductServices.xml#createProduct] process [problem
> creating the
> newEntity value: Exception while inserting the
> following entity:
>
[GenericEntity:Product][autoCreateKeywords,N(java.lang.String)][billOfMa
>
terialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][co
>
mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lan
> g.String)][createdDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][description,TestRoom(java.lang.String)]
>
[includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom(java
> .lang.String)][introductionDate,2006-09-06
>
17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)][isVirtual
>
,N(java.lang.String)][lastModifiedByUserLogin,flexadmin(java.lang.String
> )][lastModifiedDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin(java.lan
>
g.String)][productId,10020(java.lang.String)][productTypeId,ASSET_USAGE(
>
java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null()][
>
taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)]
> (while inserting:
>
[GenericEntity:Product][autoCreateKeywords,N(java.lang.String)][billOfMa
>
terialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][co
>
mments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lan
> g.String)][createdDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][createdStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][createdTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][description,TestRoom(java.lang.String)]
>
[includeInPromotions,N(java.lang.String)][internalName,HDS-TestRoom(java
> .lang.String)][introductionDate,2006-09-06
>
17:56:16.3(java.sql.Timestamp)][isVariant,N(java.lang.String)][isVirtual
>
,N(java.lang.String)][lastModifiedByUserLogin,flexadmin(java.lang.String
> )][lastModifiedDate,2006-09-06
>
17:57:03.615(java.sql.Timestamp)][lastUpdatedStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][lastUpdatedTxStamp,2006-09-06
>
17:57:03.63(java.sql.Timestamp)][primaryProductCategoryId,admin(java.lan
>
g.String)][productId,10020(java.lang.String)][productTypeId,ASSET_USAGE(
>
java.lang.String)][salesDiscontinuationDate,null()][taxCategory,null()][
>
taxDutyCode,null()][taxVatCode,null()][taxable,Y(java.lang.String)]
> (SQL
> Exception while executing the following:INSERT INTO
> OFBIZ.PRODUCT
> (PRODUCT_ID, PRODUCT_TYPE_ID,
> PRIMARY_PRODUCT_CATEGORY_ID,
> MANUFACTURER_PARTY_ID, FACILITY_ID,
> INTRODUCTION_DATE,
> SUPPORT_DISCONTINUATION_DATE,
> SALES_DISCONTINUATION_DATE,
> SALES_DISC_WHEN_NOT_AVAIL, INTERNAL_NAME,
> BRAND_NAME, COMMENTS,
> PRODUCT_NAME, DESCRIPTION, LONG_DESCRIPTION,
> SMALL_IMAGE_URL,
> MEDIUM_IMAGE_URL, LARGE_IMAGE_URL, DETAIL_IMAGE_URL,
> DETAIL_SCREEN,
> INVENTORY_MESSAGE, REQUIRE_INVENTORY,
> QUANTITY_UOM_ID,
> QUANTITY_INCLUDED, PIECES_INCLUDED, REQUIRE_AMOUNT,
> FIXED_AMOUNT,
> AMOUNT_UOM_TYPE_ID, WEIGHT_UOM_ID, WEIGHT,
> HEIGHT_UOM_ID,
> PRODUCT_HEIGHT, SHIPPING_HEIGHT, WIDTH_UOM_ID,
> PRODUCT_WIDTH,
> SHIPPING_WIDTH, DEPTH_UOM_ID, PRODUCT_DEPTH,
> SHIPPING_DEPTH,
> PRODUCT_RATING, RATING_TYPE_ENUM, RETURNABLE,
> TAXABLE, TAX_CATEGORY,
> TAX_VAT_CODE, TAX_DUTY_CODE, CHARGE_SHIPPING,
> AUTO_CREATE_KEYWORDS,
> INCLUDE_IN_PROMOTIONS, IS_VIRTUAL, IS_VARIANT,
> REQUIREMENT_METHOD_ENUM_ID, BILL_OF_MATERIAL_LEVEL,
> RESERV_MAX_PERSONS,
> RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC,
> CREATED_DATE,
> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE,
> LAST_MODIFIED_BY_USER_LOGIN,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP,
> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?,
> ?) (INSERT on table 'PRODUCT' caused a violation of
> foreign key
> constraint 'PROD_PRIMARY_CAT' for key (admin). The
> statement has been
> rolled back.)))] calling service createProductOfbiz
> in createProduct
>
>
>
> Currently this is running on a Windows 2003 server
> utilizing the
> embedded db, embedded app server. Java 1.4.2_12 sdk,
> though I will be
> reverting back to an Sql Server db as the error
> messages encountered are
> the same with either db.
>
> Thanks in advance
>
>
>
> Regards,
>
> Warren Goddard
>
> Failsafe Canada Inc.
>
> Office: 403.313.6789
>
> Fax: 403.313.6792
>
> Cellular: 403.708.9270
>
>
>
> Intelligent Business Solutions Using Innovative
> Technology
>
>
>
>
>
>