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:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 2:10 PM To: [email protected] 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 <[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 > > > > > >
