I'm trying to figure out how I can better debug my workflow.  I've got a custom query that pulls invoices from our oracle database and populates the metadata in laserfiche.  This workflow has actually worked on thousands and thousands of invoices, except 2 in the past couple of months.  I'm getting a specified cast is not valid when the query executes.  

The query is very simple:

SELECT * FROM apx_invoices_v
WHERE rtrim(ltrim(INVOICE_NUM))=&x
AND  rtrim(ltrim(VENDOR_NAME))=&y

The email returns:

The query returns the record just fine in Toad and when I do the test scenario in the custom query window in laserfiche workflow designer.

Thanks,

Glenn