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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] Google Talk: [EMAIL PROTECTED] Skype: christoffer_munck