int-dbcons-pgsql - Build # 2256 - Failure:
Check console output at https://ci.openbravo.com/job/int-dbcons-pgsql/2256/ to
view the results.
Committers since last success:
Changes for Build #2256
David Miguelez <[email protected]> null
Fixes issue 33620: Removes UNION ALL from view and merges it into one
sentece
src-db/database/model/views/C_INVOICETAX_CASHVAT_V.xml
Last 20 lines of the console output:
[...truncated 1360 lines...]
<?xml version="1.0"?>
<database name="VIEW C_INVOICETAX_CASHVAT_V">
- <view name="C_INVOICETAX_CASHVAT_V"><![CDATA[SELECT
itcv.c_invoicetax_cashvat_id AS c_invoicetax_cashvat_v_id, itcv.ad_client_id,
itcv.ad_org_id, itcv.created, itcv.createdby, itcv.updated, itcv.updatedby,
itcv.isactive, fp.paymentdate, itcv.percentage, itcv.taxamt, itcv.taxbaseamt,
COALESCE(fpsd.iscanceled, 'N') AS iscanceled, fp.fin_payment_id,
fpd.fin_payment_detail_id, fp.isreceipt, fp.c_bpartner_id,
fp.fin_paymentmethod_id, fp.status, fp.amount, fp.c_currency_id,
itcv.c_invoicetax_id, itcv.ismanualsettlement FROM c_invoicetax_cashvat itcv
LEFT JOIN c_invoicetax it ON it.c_invoicetax_id = itcv.c_invoicetax_id LEFT
JOIN fin_payment_detail fpd ON fpd.fin_payment_detail_id =
itcv.fin_payment_detail_id LEFT JOIN fin_payment fp ON fp.fin_payment_id =
fpd.fin_payment_id LEFT JOIN fin_payment_scheduledetail fpsd ON
fpd.fin_payment_detail_id = fpsd.fin_payment_detail_id LEFT JOIN
fin_payment_schedule fpsi ON fpsi.fin_payment_schedule_id =
fpsd.fin_payment_schedule_invoice WHERE (itcv.ismanualsettlement = 'N' AND
fpsi.c_invoice_id = it.c_invoice_id) OR itcv.ismanualsettlement = 'Y']]></view>
+ <view name="C_INVOICETAX_CASHVAT_V"><![CDATA[SELECT
itcv.c_invoicetax_cashvat_id AS c_invoicetax_cashvat_v_id, itcv.ad_client_id,
itcv.ad_org_id, itcv.created, itcv.createdby, itcv.updated, itcv.updatedby,
itcv.isactive, fp.paymentdate, itcv.percentage, itcv.taxamt, itcv.taxbaseamt,
COALESCE(fpsd.iscanceled, 'N') AS iscanceled, fp.fin_payment_id,
fpd.fin_payment_detail_id, fp.isreceipt, fp.c_bpartner_id,
fp.fin_paymentmethod_id, fp.status, fp.amount, fp.c_currency_id,
itcv.c_invoicetax_id, itcv.ismanualsettlement FROM c_invoicetax_cashvat itcv
LEFT JOIN c_invoicetax it ON it.c_invoicetax_id = itcv.c_invoicetax_id LEFT
JOIN fin_payment_detail fpd ON fpd.fin_payment_detail_id =
itcv.fin_payment_detail_id LEFT JOIN fin_payment fp ON fp.fin_payment_id =
fpd.fin_payment_id LEFT JOIN fin_payment_scheduledetail fpsd ON
fpd.fin_payment_detail_id = fpsd.fin_payment_detail_id LEFT JOIN
fin_payment_schedule fpsi ON fpsi.fin_payment_schedule_id =
fpsd.fin_payment_schedule_invoice WHERE itcv.ismanualsettlement = 'N' AND
fpsi.c_invoice_id = it.c_invoice_id OR itcv.ismanualsettlement = 'Y']]></view>
</database>
reverting src-db/database/model/views/C_INVOICETAX_CASHVAT_V.xml
ERROR: found differences
* FAILURE: DBconsistency ERP
LOG:
https://ci.openbravo.com/job/int-dbcons-pgsql/2256/artifact/dbconsistency.log/*view*/
Build step 'Execute managed script' marked build as failure
Checking console output
/srv/ci/jobs/int-dbcons-pgsql/builds/2256/log:
ERROR: found differences
Email was triggered for: Failure - Any
Sending email for trigger: Failure - Any
------------------------------------------------------------------------------
_______________________________________________
Openbravo-builds mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-builds
