帮看一个ofbiz错误

yhsniaw 2011-11-01
在运行OFBIZ9.0.4示例程序时,在ORDERMGR应用中处理订单,点击快速运送整个订单出现下面的错误。那位能帮助解决下。谢谢


发生了下面的错误:

调用事件时出错: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [quickShipEntireOrder] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in findOne operation for entity [SalesInvoiceItemFact]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ORDER_ID, INVOICE_DATE_DIM_ID, PRODUCT_DIM_ID,
BILL_TO_CUSTOMER_DIM_ID, ORIG_CURRENCY_DIM_ID, QUANTITY, EXT_GROSS_AMOUNT, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT, EXT_TAX_AMOUNT, EXT_MAN_FIXED_COST, EXT_MAN_VAR_COST, EXT_STORAGE_COST, EXT_DISTRIBUTION_COST, CONTRIBUTION_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SALES_INVOICE_ITEM_FACT WHERE INVOICE_ID=? AND INVOICE_ITEM_SEQ_ID=? (Table 'ofbiz_9.sales_invoice_item_fact' doesn't exist). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ORDER_ID, INVOICE_DATE_DIM_ID, PRODUCT_DIM_ID, BILL_TO_CUSTOMER_DIM_ID, ORIG_CURRENCY_DIM_ID, QUANTITY, EXT_GROSS_AMOUNT, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT, EXT_TAX_AMOUNT, EXT_MAN_FIXED_COST, EXT_MAN_VAR_COST, EXT_STORAGE_COST, EXT_DISTRIBUTION_COST, CONTRIBUTION_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SALES_INVOICE_ITEM_FACT WHERE INVOICE_ID=? AND INVOICE_ITEM_SEQ_ID=? (Table 'ofbiz_9.sales_invoice_item_fact' doesn't exist) (SQL Exception while executing the following:SELECT ORDER_ID, INVOICE_DATE_DIM_ID, PRODUCT_DIM_ID, BILL_TO_CUSTOMER_DIM_ID, ORIG_CURRENCY_DIM_ID, QUANTITY, EXT_GROSS_AMOUNT, EXT_DISCOUNT_AMOUNT, EXT_NET_AMOUNT, EXT_TAX_AMOUNT, EXT_MAN_FIXED_COST, EXT_MAN_VAR_COST, EXT_STORAGE_COST, EXT_DISTRIBUTION_COST, CONTRIBUTION_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SALES_INVOICE_ITEM_FACT WHERE INVOICE_ID=? AND INVOICE_ITEM_SEQ_ID=? (Table 'ofbiz_9.sales_invoice_item_fact' doesn't exist)))
jum 2011-11-03
Table 'ofbiz_9.sales_invoice_item_fact' doesn't exist) 很明显了
jiasudu1649 2011-11-03
webtools 查看这个表sales_invoice_item_fact 是否存在
Global site tag (gtag.js) - Google Analytics