OFBiz › OFBiz - User

opentravel issues

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 5 messages Options
Warren Goddard
Reply | Threaded
Open this post in threaded view
♦
♦
|

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

 

 
cjhowe
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: opentravel issues

cjhowe
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 <[hidden email]> 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
>
>  
>
>  
>
>

Jacopo Cappellato
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: opentravel issues

Jacopo Cappellato
In reply to this post by Warren Goddard
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

Warren Goddard
Reply | Threaded
Open this post in threaded view
♦
♦
|

RE: opentravel issues

Warren Goddard
In reply to this post by cjhowe
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:[hidden email]]
Sent: Thursday, September 07, 2006 2:10 PM
To: [hidden email]
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 <[hidden email]> 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
>
>  
>
>  
>
>

David E Jones-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: opentravel issues

David E Jones-2

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

Free forum by Nabble Edit this page