opentravel issues

[Warren Goddard]

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)][billOfMaterialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][comments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lang.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.lang.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)][billOfMaterialLevel,0(java.lang.Integer)][chargeShipping,N(java.lang.String)][comments,TestRoom(java.lang.String)][createdByUserLogin,flexadmin(java.lang.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.lang.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