rendered paste body122758 [http-8080-Processor24] DEBUG org.openbravo.erpReports.RptC_Invoice - creating the format factory: dd-MM-yyyy
122776 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1346261054: created for RptC_Invoice
123118 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1346261054: filling report
123120 [http-8080-Processor24] DEBUG org.openbravo.erpReports.RptCInvoiceHeaderData - Field does not exist: REGION
123120 [http-8080-Processor24] DEBUG org.openbravo.erpReports.RptCInvoiceHeaderData - Field does not exist: COUNTRY
123120 [http-8080-Processor24] DEBUG org.openbravo.erpReports.RptCInvoiceHeaderData - Field does not exist: PHONE
123120 [http-8080-Processor24] DEBUG org.openbravo.erpReports.RptCInvoiceHeaderData - Field does not exist: FAX
123133 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1346261054: adding page 1
123134 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1346261054: C_INVOICE_ID header
123268 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1346261054: detail
123396 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: creating subreport filler
123398 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1054162645: created for RptC_Invoice_Lines
123443 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: creating subreport filler
123444 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 252579598: created for RptC_Invoice_TaxLines
123445 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: starting 1054162645
123446 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: starting thread Thread[RptC_Invoice_Lines subreport filler,5,main]
123446 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: waiting for fill result
123446 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1054162645: filling report
123446 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRFillDataset - Fill 1054162645: Creating sql query executer
123452 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.query.JRJdbcQueryExecuter - SQL query string: SELECT C_INVOICE.C_INVOICE_ID, COALESCE(M_PRODUCT.NAME, C_INVOICELINE.DESCRIPTION) AS NAME_PRODUCT, C_INVOICELINE.QTYINVOICED, C_UOM.NAME AS UOMNAME, C_INVOICELINE.DESCRIPTION,
C_INVOICELINE.LINENETAMT, C_INVOICELINE.PRICEACTUAL,
M_INOUT.DOCUMENTNO AS INOUTNO, C_ORDER.DOCUMENTNO AS ORDERNO
FROM C_INVOICELINE left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID
left join M_INOUTLINE on M_INOUTLINE.M_INOUTLINE_ID = C_INVOICELINE.M_INOUTLINE_ID
left join M_INOUT on M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID
left join C_ORDERLINE on C_ORDERLINE.C_ORDERLINE_ID = C_INVOICELINE.C_ORDERLINE_ID
left join C_ORDER on C_ORDERLINE.C_ORDER_ID = C_ORDER.C_ORDER_ID,
C_INVOICE
WHERE C_INVOICELINE.C_INVOICE_ID = C_INVOICE.C_INVOICE_ID
AND C_INVOICE.C_INVOICE_ID = ?
ORDER BY C_INVOICELINE.LINE
123455 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.query.JRJdbcQueryExecuter - Parameter #1 (C_INVOICE_ID of type java.math.BigDecimal): 1000001
123474 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1054162645: C_INVOICE_ID header
123494 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1054162645: detail
......... (Some more lines like this)
124154 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1054162645: suspeding subreport runner
124154 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: notifying on suspend
124154 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: waiting to continue
124154 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: notified of fill result
124155 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: subreport 1054162645 to continue
124156 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1346261054: page footer
124168 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1346261054: adding page 2
124168 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: resuming 1054162645
124168 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: notifying to continue
124168 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: waiting for fill result
124190 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: notified to continue
124195 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1054162645: detail
124199 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1054162645: detail
124203 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1054162645: detail
124208 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1054162645: detail
124212 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1054162645: C_INVOICE_ID footer
124218 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1054162645: ended
124218 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRFillDataset - Fill 1054162645: closing query executer
124218 [RptC_Invoice_Lines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: notifying of completion
124219 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 1054162645: notified of fill result
124219 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: subreport 1054162645 finished
124219 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: starting 252579598
124219 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 252579598: starting thread Thread[RptC_Invoice_TaxLines subreport filler,5,main]
124219 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 252579598: waiting for fill result
124229 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 252579598: filling report
124230 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRFillDataset - Fill 252579598: Creating sql query executer
124230 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.query.JRJdbcQueryExecuter - SQL query string: SELECT C_INVOICE_ID, C_TAX.NAME, C_INVOICETAX.TAXBASEAMT, C_INVOICETAX.TAXAMT
FROM C_INVOICETAX, C_TAX
WHERE C_INVOICETAX.C_TAX_ID = C_TAX.C_TAX_ID
AND C_TAX.ISPRINTTAX = 'Y'
AND C_INVOICETAX.C_INVOICE_ID = ?
ORDER BY C_INVOICETAX.LINE, C_TAX.RATE
124231 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.query.JRJdbcQueryExecuter - Parameter #1 (C_INVOICE_ID of type java.math.BigDecimal): 1000001
124236 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 252579598: detail
124239 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 252579598: C_INVOICE_ID footer
124239 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 252579598: ended
124239 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRFillDataset - Fill 252579598: closing query executer
124239 [RptC_Invoice_TaxLines subreport filler] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 252579598: notifying of completion
124243 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRThreadSubreportRunner - Fill 252579598: notified of fill result
124243 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1346261054: subreport 252579598 finished
124243 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1346261054: C_INVOICE_ID footer
124245 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRVerticalFiller - Fill 1346261054: page footer
124252 [http-8080-Processor24] DEBUG net.sf.jasperreports.engine.fill.JRBaseFiller - Fill 1346261054: ended
128890 [http-8080-Processor23] DEBUG org.apache.catalina.core.StandardWrapper - Returning non-STM instance
128891 [http-8080-Processor23] DEBUG org.openbravo.base.secureApp.VariablesHistory - Session attribute: reqHistory.current:...91
128891 [http-8080-Processor23] DEBUG org.openbravo.base.secureApp.VariablesHistory - Session attribute: #AD_Role_ID:...1000005
128891 [http-8080-Processor23] DEBUG org.openbravo.base.secureApp.VariablesHistory - Session attribute: #AD_Language:...pt_PT
128891 [http-8080-Processor23] DEBUG org.openbravo.base.secureApp.VariablesHistory - Session attribute: #AD_Session_ID:...1000051
128891 [http-8080-Processor23] DEBUG org.openbravo.base.secureApp.VariablesHistory - Session attribute: #Theme:...Default
128891 [http-8080-Processor23] DEBUG org.openbravo.erpCommon.utility.VerticalMenu - Servlet request for class info: /utility/VerticalMenu.html