erp_devel_pi-pgsql-db-inc-consistency-test - Build # 1026 - Failure:
Check console output at
http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-inc-consistency-test/1026/ to view the results.
Committers since last success:
Changes for Build #1026
Last 20 lines of the console output:
[...truncated 138 lines...]
diff -r 18e1d305fcd1 src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml
--- a/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml Wed Apr 21 18:18:55 2010 +0200
+++ b/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml Wed Apr 21 19:16:24 2010 +0200
@@ -1,8 +1,8 @@
<?xml version="1.0"?>
<database name="VIEW FIN_PAYMENT_DETAIL_V">
- <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate,
gli.name as glitemname
+ <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_sched_inv_v_id, pso.fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.expected, pso.expected) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate,
gli.name AS glitemname
FROM fin_payment p, fin_payment_detail pd
-INNER JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id
+JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id
LEFT JOIN fin_payment_sched_inv_v psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_sched_inv_v_id
LEFT JOIN c_invoice i ON psi.c_invoice_id = i.c_invoice_id
LEFT JOIN fin_payment_sched_ord_v pso ON psd.fin_payment_schedule_order = pso.fin_payment_sched_ord_v_id
reverting src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml
[locks-and-latches] Releasing all the locks
[locks-and-latches] All the locks released
Email was triggered for: Failure
Sending email for trigger: Failure
------------------------------------------------------------------------------
_______________________________________________
Openbravo-builds mailing list
Openbrav...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-builds
--
You received this message because you are subscribed to the Google Groups "openbravo-builds" group.
To post to this group, send email to
openbrav...@googlegroups.com.
To unsubscribe from this group, send email to
openbravo-buil...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/openbravo-builds?hl=en.