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 <[EMAIL PROTECTED]> 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 > > > > > >
