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.)))