Error when creating order.
Locked
 
|
Hi. I get following error when finalizing an order. I am using an MSSQL
database as engine. The end of the error looks like there could be a problem with this: (Error converting data type nvarchar to decimal.). Does anybody have experiences with this. I would like to know where to look. A database error, or if it is something I setup wrong in the system. B.R Christoffer ---------------------- ERROR DUMP -------------------------------- Problem occurred in tax service (Could not commit transaction for service [calcTax] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) (Could not commit transaction for service [calcTax] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) |
|
|
Can you specify which SVN (Trunk or Ver4.0) and the version.
it would help track down the error. Since all numbers are VarChar, there must be something that is not converting properly. Christoffer Munck sent the following on 4/14/2008 10:26 PM: > Hi. I get following error when finalizing an order. I am using an MSSQL > database as engine. The end of the error looks like there could be a problem > with this: (Error converting data type nvarchar to decimal.). > > Does anybody have experiences with this. I would like to know where to look. > A database error, or if it is something I setup wrong in the system. > > B.R > > Christoffer > > > ---------------------- ERROR DUMP -------------------------------- > Problem occurred in tax service (Could not commit transaction for service > [calcTax] call: Roll back error, could not commit transaction, was rolled > back instead because of: Failure in findByCondition operation for entity > [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL > Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). > Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL > Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) (SQL > Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > (Could not commit transaction for service [calcTax] call: Roll back error, > could not commit transaction, was rolled back instead because of: Failure in > findByCondition operation for entity [TaxAuthorityRateProduct]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing > the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, > TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, > PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, > TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP > FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR > PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = > ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND > (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? )) > AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS > NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, > FROM_DATE ASC (Error converting data type nvarchar to decimal.). Rolling > back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception > while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) (SQL > Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > |
|
|
Hi'
I am really sorry about the late response time. Did not see the response. I am using ver 4.0 from the release library. Rev: 629279 B.R Christoffer On Tue, Apr 15, 2008 at 3:36 PM, BJ Freeman <[hidden email]> wrote: > Can you specify which SVN (Trunk or Ver4.0) and the version. > it would help track down the error. > Since all numbers are VarChar, there must be something that is not > converting properly. > > > > > Christoffer Munck sent the following on 4/14/2008 10:26 PM: > > Hi. I get following error when finalizing an order. I am using an MSSQL > > database as engine. The end of the error looks like there could be a > problem > > with this: (Error converting data type nvarchar to decimal.). > > > > Does anybody have experiences with this. I would like to know where to > look. > > A database error, or if it is something I setup wrong in the system. > > > > B.R > > > > Christoffer > > > > > > ---------------------- ERROR DUMP -------------------------------- > > Problem occurred in tax service (Could not commit transaction for > service > > [calcTax] call: Roll back error, could not commit transaction, was > rolled > > back instead because of: Failure in findByCondition operation for entity > > [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). > > Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) > (SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > > (Could not commit transaction for service [calcTax] call: Roll back > error, > > could not commit transaction, was rolled back instead because of: > Failure in > > findByCondition operation for entity [TaxAuthorityRateProduct]: > > org.ofbiz.entity.GenericDataSourceException: SQL Exception while > executing > > the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, > > TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, > > PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, > MIN_PURCHASE, > > TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP > > FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR > > PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND > > (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? > )) > > AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS > > NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, > > FROM_DATE ASC (Error converting data type nvarchar to decimal.). Rolling > > back transaction.org.ofbiz.entity.GenericDataSourceException: SQL > Exception > > while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) > (SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > > > > -- Best regards Christoffer Munck 2proceed.com, Parner, CTO Contact info: MSN: [hidden email] Google Talk: [hidden email] Skype: christoffer_munck |
|
|
In reply to this post by Christoffer
I suggest you to do something on your database:
Go in the table an make a select* from order_header. If you have some table with order_type_id null you have to delete these table making : Delete from order_header where order_type_id is null Thanks
|
|
|
Hello, thank you for you reply. There are no rows where order_type_id is
null. There is however one order where the CURRENCY_UOM and PRODUCT_STORE_ID is null. I deleted this item, but still same error... On Mon, Apr 21, 2008 at 4:07 PM, ladroge <[hidden email]> wrote: > > I suggest you to do something on your database: > Go in the table an make a select* from order_header. > If you have some table with order_type_id null you have to delete these > table making : > Delete from order_header where order_type_id is null > > Thanks > > > Christoffer Munck wrote: > > > > Hi. I get following error when finalizing an order. I am using an MSSQL > > database as engine. The end of the error looks like there could be a > > problem > > with this: (Error converting data type nvarchar to decimal.). > > > > Does anybody have experiences with this. I would like to know where to > > look. > > A database error, or if it is something I setup wrong in the system. > > > > B.R > > > > Christoffer > > > > > > ---------------------- ERROR DUMP -------------------------------- > > Problem occurred in tax service (Could not commit transaction for > service > > [calcTax] call: Roll back error, could not commit transaction, was > rolled > > back instead because of: Failure in findByCondition operation for entity > > [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: > > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.). > > Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: > SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) > (SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > > (Could not commit transaction for service [calcTax] call: Roll back > error, > > could not commit transaction, was rolled back instead because of: > Failure > > in > > findByCondition operation for entity [TaxAuthorityRateProduct]: > > org.ofbiz.entity.GenericDataSourceException: SQL Exception while > executing > > the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, > > TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, > > PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, > MIN_PURCHASE, > > TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, THRU_DATE, DESCRIPTION, > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP > > FROM dbo.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR > > PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND > > (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, ?, ?, ? > )) > > AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS > > NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > ASC, > > FROM_DATE ASC (Error converting data type nvarchar to decimal.). Rolling > > back transaction.org.ofbiz.entity.GenericDataSourceException: SQL > > Exception > > while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.) > (SQL > > Exception while executing the following:SELECT > TAX_AUTHORITY_RATE_SEQ_ID, > > TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, > > PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, > > MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, FROM_DATE, > > THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP FROM dbo.TAX_AUTHORITY_RATE_PRODUCT > WHERE > > ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND > > ((TAX_AUTH_PARTY_ID > > = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND > TAX_AUTH_GEO_ID > > = > > ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN ( ?, ?, > ?, > > ?, > > ? )) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND > (MIN_PURCHASE > > IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE > > ASC, FROM_DATE ASC (Error converting data type nvarchar to decimal.))) > > > > > > -- > View this message in context: > http://www.nabble.com/Error-when-creating-order.-tp16695345p16807936.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- Best regards Christoffer Munck 2proceed.com, Parner, CTO Contact info: MSN: [hidden email] Google Talk: [hidden email] Skype: christoffer_munck |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |