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
