Re: Invoice PDF Error

[David E. Jones]

-David


On Mar 23, 2007, at 11:21 AM, Brettonwoods wrote:

This is an interesting error and brings up a lower level issue. When there is an IN operator and an empty set passed to it, what should we do? I would say this should always result in a "false". Should we change the entity engine to somehow always represent this as a FALSE? I'm looking at doing this right now to avoid this problem, but if anyone has any opinions please let me know...

Hi All,

Got this error when trying to create a PDF file for an Invoice.

it's failing on some iteration but I can't nail it down.

Thanks for any help.

Tom

org.ofbiz.base.util.GeneralException: Error rendering screen
[component://accounting/widget/AccountingPrintForms.xml#InvoicePDF]:

org.ofbiz.base.util.GeneralException: Error running BSH script at

line [89]: Sourced file:

: Method Invocation invoice.getRelated : at Line: 89 : in file:

: invoice .getRelated ( "InvoiceTerm" )


The current transaction is marked for rollback, not beginning a new

Failure in findByCondition operation for entity [InvoiceItem]:

PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG,
QUANTITY, AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID,
TAX_AUTHORITY_RATE_SEQ_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,

Exception while executing the following:SELECT INVOICE_ID,
INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID,
INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, PARENT_INVOICE_ID,
PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG, QUANTITY, AMOUNT,

PARENT_INVOICE_ID, PARENT_INVOICE_ITEM_SEQ_ID, UOM_ID, TAXABLE_FLAG,
QUANTITY, AMOUNT, DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID,
TAX_AUTHORITY_RATE_SEQ_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,

(Sourced file:

: Method Invocation invoice.getRelated) (Error running BSH script at

line [89]: Sourced file:

: Method Invocation invoice.getRelated : at Line: 89 : in file:

: invoice .getRelated ( "InvoiceTerm" )

--

Target exception:... is repeated four times in the actual error, seems like org.ofbiz.base.util.GeneralException: Error running BSH script at location [component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh]: [component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh], component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh Target exception: org.ofbiz.entity.transaction.GenericTransactionException: transaction and aborting current operation; the rollbackOnly was caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, CREATED_STAMP, CREATED_TX_STAMP FROM public.INVOICE_ITEM WHERE (INVOICE_ID = ? AND INVOICE_ITEM_TYPE_ID IN ()) (ERROR: syntax error at or near ")"). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL DESCRIPTION, TAX_AUTH_PARTY_ID, TAX_AUTH_GEO_ID, TAX_AUTHORITY_RATE_SEQ_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM public.INVOICE_ITEM WHERE (INVOICE_ID = ? AND INVOICE_ITEM_TYPE_ID IN ()) (ERROR: syntax error at or near ")") (SQL Exception while executing the following:SELECT INVOICE_ID, INVOICE_ITEM_SEQ_ID, INVOICE_ITEM_TYPE_ID, OVERRIDE_GL_ACCOUNT_ID, INVENTORY_ITEM_ID, PRODUCT_ID, PRODUCT_FEATURE_ID, CREATED_STAMP, CREATED_TX_STAMP FROM public.INVOICE_ITEM WHERE (INVOICE_ID = ? AND INVOICE_ITEM_TYPE_ID IN ()) (ERROR: syntax error at or near ")")) component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh [component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh], component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh component://accounting/webapp/accounting/WEB-INF/actions/invoice/ editInvoice.bsh View this message in context: http://www.nabble.com/Invoice-PDF- Error-tf3455217.html#a9639466

Sent from the OFBiz - User mailing list archive at Nabble.com.

smime.p7s
Description: S/MIME cryptographic signature