int-modules-pgsql - Build # 2319 - Fixed:

Check console output at https://ci.openbravo.com/job/int-modules-pgsql/2319/ to 
view the results.


Committers since last success:

Changes for Build #2318

    Alvaro Ferraz <[email protected]> null
    Related to issue 36736: Revert changes in reports launched after creating a 
document
(post document, print document, etc.)
        
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_reports/ReportReconciliation.java
        src/org/openbravo/erpCommon/ad_reports/ReportBudgetExportExcel.java
        src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
        
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalDetail.java
        src/org/openbravo/erpReports/ReportRegisterLineJR.jrxml
        src/org/openbravo/erpReports/ReportTaxPaymentJR.java
        src/org/openbravo/erpReports/ReportVatRegisterJR.java
        src/org/openbravo/erpReports/RptC_Bpartner.java
        src/org/openbravo/erpReports/RptMA_CCP_Group.java
        src/org/openbravo/erpReports/RptMA_CCP_Measures.java
        src/org/openbravo/erpReports/RptMA_ProcessPlan.java
        src/org/openbravo/erpReports/RptM_Requisition.java

    Alvaro Ferraz <[email protected]> null
    Related to issue 36736: Use read only pool also in Aging reports
        
src/org/openbravo/common/actionhandler/AgingBalanceReportActionHandler.java

    Atul Gaware <[email protected]> null
    Fixes issue 36736: Adapt read only pool connection provider in ob reports
        
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_reports/ReportReconciliation.java
        
modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReport.java
        
modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
        
modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.java
        
src/org/openbravo/common/actionhandler/CashflowForecastReportActionHandler.java
        src/org/openbravo/erpCommon/ad_reports/AgingDao.java
        src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java
        src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.java
        src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.java
        
src/org/openbravo/erpCommon/ad_reports/ReportAssetDepreciationSchedule.java
        src/org/openbravo/erpCommon/ad_reports/ReportBudgetExportExcel.java
        src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.java
        src/org/openbravo/erpCommon/ad_reports/ReportExpense.java
        src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
        src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
        
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalDetail.java
        src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.java
        
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.java
        
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.java
        
src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR.java
        
src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionEditionJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportNotPosted.java
        src/org/openbravo/erpCommon/ad_reports/ReportOffer.java
        src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java
        src/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.java
        src/org/openbravo/erpCommon/ad_reports/ReportPricelist.java
        src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
        src/org/openbravo/erpCommon/ad_reports/ReportProductionCost.java
        src/org/openbravo/erpCommon/ad_reports/ReportProductionJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportProductionRunJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportProjectProgress.java
        
src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR.java
        
src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java
        
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.java
        src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.java
        
src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportShipmentEditionJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportShipper.java
        src/org/openbravo/erpCommon/ad_reports/ReportStandardCostJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
        src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
        src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl.java
        src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.java
        src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.java
        src/org/openbravo/erpReports/ReportRegisterLineJR.jrxml
        src/org/openbravo/erpReports/ReportTaxPaymentJR.java
        src/org/openbravo/erpReports/ReportVatRegisterJR.java
        src/org/openbravo/erpReports/RptC_Bpartner.java
        src/org/openbravo/erpReports/RptMA_CCP_Group.java
        src/org/openbravo/erpReports/RptMA_CCP_Measures.java
        src/org/openbravo/erpReports/RptMA_ProcessPlan.java
        src/org/openbravo/erpReports/RptM_Requisition.java

    Asier LostalĂ© <[email protected]> null
    fixes 36741: generate xml report for individual test execution with run.test

  XML report will be generated in src directory with named like the executed 
test.
        src-test/build.xml

    Carlos Aristu <[email protected]> null
    fixes bug 36728: Can't use fields based on some properties in selector 
picklist

With the fix for issue #36268 the selector fields based on derived properties 
that are shown in the picklist are sent as 'extra properties' in order to 
calculate them properly.

The problem is that the fix was not complete when the derived properties were 
not primitive. In that case the DataToJsonConverter class was not calculating 
properly the referenced property.

Now that kind of properties are calculated properly.
        
modules/org.openbravo.service.json/src/org/openbravo/service/json/DataToJsonConverter.java

Changes for Build #2319

    Alvaro Ferraz <[email protected]> null
    Related to issue 36675: Fix some logs
        src/org/openbravo/costing/CostingMigrationProcess.java

    Mark <[email protected]> null
    Fixes issue 36675: Transaction Cost not created for closing inventory lines

After cost was assigned to closing inventory lines transactions,
when calling to insertTrxCosts() from calculateCosts() method (second call),
CostingUtilsData.countTrxCosts(conn) was getting 0 in countTrx.
It was caused because closing inventory lines cost calculation
was done by OBDal connection, and methods invoked in CostingUtilsData are done
using different connection provided by SQLC, and the transactions are not 
available
at this moment. See: 
http://wiki.openbravo.com/wiki/Data_Access_Layer#Transaction_and_Session

To find the best solution for this issue and don't affect the performance (see 
issue 35959),
different solutions were tested to always use DAL and make process use the same 
connection.

1.- Doing a single insert-select query with limits is not supported in DAL. We 
tried it in two different ways (see attached TestCosting_v1.diff):
- Use setMaxResults(). It only works for selects but not for inserts/updates.
- Use setMaxResults() in select query and append it to insert query using 
getQueryString(). It appends the select without any limit.

2.- Another option could be to refactor insertTrxCosts() method to do a 
multiple insert query:
We can create the select query with limits using setMaxResults(), iterate it 
using an scroll
and create and save in each iteration a new TransactionCost. Flush won't be 
done in every iteration.
When flush is done, it raises every insert in multiple single-row inserts 
instead of only one multiple-row insert.
Single-row inserts performs worst than multiple-row insert, at least with not 
many rows (see attached TestCosting_v2.diff).

3.- Finally, we have refactor the process to avoid insertTrxCosts() method:
Our solution makes an insertion in M_Transaction_Cost table each
time we make the updation of related transaction cost in M_Transaction table.
We will do single-row inserts in two methods: updateTrxLegacyCosts() and 
calculateCosts(),
and multiple-row insert in one method: updateWithZeroCostRemainingTrx().
Thus, we split the number of TransactionCost records to be created in three 
different steps.
        src/org/openbravo/costing/CostingMigrationProcess.java
        src/org/openbravo/costing/CostingUtils_data.xsql




Last 20 lines of the console output:

[...truncated 1885 lines...]
  [ "$(jps | grep Bootstrap || true)" = "" ] && break
  sleep 5
done
[ "$(jps | grep Bootstrap || true)" != "" ] && echo "Tomcat has fail to stop" 
&& exit 1 || true
[ "$i" != "0" ] && secs=$(echo "$i * 5" | bc) && echo "Waiting for $secs secs 
for tomcat to stop"

echo
fi

[int-modules-pgsql] $ /bin/bash -xe /tmp/hudson8567175752616998609.sh
++ jps
++ grep Bootstrap
++ true
+ '[' '' '!=' '' ']'
POST BUILD TASK : SUCCESS
END OF POST BUILD TASK : 0
Email was triggered for: Fixed
Trigger Success was overridden by another trigger and will not send an email.
Sending email for trigger: Fixed
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-builds mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-builds

Reply via email to