int-basic-pgsql - Build # 1920 - Fixed:

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


Committers since last success:

Changes for Build #1919

    David Miguelez <[email protected]> null
    [w-is] Fixed wrong boolean checks. All of them were testing the same column
and they should test the related one
        src-db/database/model/tables/M_INVENTORYSTATUS.xml
        src-db/database/model/tables/M_INVENTORYSTATUS_TRL.xml

    David Miguelez <[email protected]> null
    Fixes Issue 36078. Adds M_Reservation, M_Reservation_Stock and M_Product_AUM
tables in the Client dataset to export the information of the tables
in the ant export.sample.data task
        src-db/database/sourcedata/AD_DATASET_TABLE.xml

    David Miguelez <[email protected]> null
    [w-is] Updated Modulescript

* Removed unnecessary preference creation and check
* Updated version of core up till which it must be executed
        
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class
        
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatusData.class
        
src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java
        
src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus_data.xsql

    David Miguelez <[email protected]> null
    [w-is] Adds index to m_inventorystatus_id column in m_locator table
        src-db/database/model/tables/M_LOCATOR.xml

    David Miguelez <[email protected]> null
    [w-is] Fixes problem in Oracle in Automated Tests.
Since value property of ad_prefernce table is defined as clob
it is necessary to cast it to a char before comparing it
        src-test/src/org/openbravo/test/inventoryStatus/InventoryStatusTest.java

    David Miguelez <[email protected]> null
    [w-is] Fixes issue in M_Get_Stock_Param that was not correctly
filtering data for MRP
        src-db/database/model/functions/M_GET_STOCK_PARAM.xml

    David Miguelez <[email protected]> null
    [w-is] Fixes problem in m_inout_post

Do only check the inventory status for outgoing transactions, not for
incoming ones.
        src-db/database/model/functions/M_INOUT_POST.xml

    David Miguelez <[email protected]> null
    [w-is] Adds missing save statemente in Inventory Status Tests
while creating the Reservation Preference
        src-test/src/org/openbravo/test/inventoryStatus/InventoryStatusTest.java

    David Miguelez <[email protected]> null
    [w-is] Updated Inventory Status Tests to create Reservations preference
if it does not exist in the system
        src-test/src/org/openbravo/test/inventoryStatus/InventoryStatusTest.java

    David Miguelez <[email protected]> null
    [w-is] Extracts code into functions to improve redability in Inventory 
Status Utils
        src/org/openbravo/erpCommon/utility/InventoryStatusUtils.java

    David Miguelez <[email protected]> null
    [w-is] Updates definition of PL's to use optional parameters.
Updates license years
        src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
        src-db/database/model/functions/M_UNIQUEATTRIBUTE_RULE_PARAM.xml
        src-db/database/model/functions/M_UNIQUELOCATOR_RULE_PARAM.xml
        src-db/database/model/functions/M_WAREHOUSE_DEFAULT_RULE_PARAM.xml

    David Miguelez <[email protected]> null
    [w-is] Updates license years
        src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
        src-db/database/model/functions/M_CHECK_STOCK.xml
        src-db/database/model/functions/M_GET_STOCK.xml
        src-db/database/model/functions/M_GET_STOCK_PARAM.xml
        src-db/database/model/functions/M_INOUT_CREATE.xml
        src-db/database/model/functions/M_MOVEMENT_POST.xml
        src-db/database/model/functions/M_PRODUCTION_RUN.xml
        src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml
        src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
        src-db/database/model/triggers/M_INVENTORYSTATUS_TRG.xml
        
src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
        src/org/openbravo/costing/CostingUtils.java
        src/org/openbravo/erpCommon/ad_actionButton/ProcessGoods.java
        src/org/openbravo/materialmgmt/InventoryCountProcess.java
        src/org/openbravo/materialmgmt/ReservationUtils.java

    David Miguelez <[email protected]> null
    [w-is] Adds missing class files for moduleScript
        
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatus.class
        
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeInventoryStatusData.class

    David Miguelez <[email protected]> null
    [w-is] Adds automated tests for Inventory Status.

* Adds Test Cases
* Adds Test Cases in AllAntTasksTests Suite
* Adds needed data in QA Testing Client
        referencedata/sampledata/QA_Testing/M_RESERVATION.xml
        referencedata/sampledata/QA_Testing/M_RESERVATION_STOCK.xml
        src-test/src/org/openbravo/test/inventoryStatus/InventoryStatusTest.java
        src-test/src/org/openbravo/test/AllAntTaskTests.java

    David Miguelez <[email protected]> null
    [w-is] Add extra method in Inventory Status utils to manage Status change
        src/org/openbravo/erpCommon/utility/InventoryStatusUtils.java

    David Miguelez <[email protected]> null
    [w-is] Changes done in unqiue index for location in M_LOCATOR.

* Created two partial indexes depending on the parent_id column
        src-db/database/model/tables/M_LOCATOR.xml

    David Miguelez <[email protected]> null
    [w-is] Adds Inventory Status Utils class with methods from other classes
grouped into the same class
        src/org/openbravo/erpCommon/utility/InventoryStatusUtils.java
        
src/org/openbravo/common/actionhandler/ChangeInventoryStatusActionHandler.java

    David Miguelez <[email protected]> null
    [w-is] Do not allow to ship Stock when it belongs to a Storage Bin
that has an Inventory Status defined as not available.
        src-db/database/model/functions/M_INOUT_POST.xml
        src-db/database/sourcedata/AD_MESSAGE.xml

    David Miguelez <[email protected]> null
    [w-is] Changed message for error while modifying Inventory Status due to an
existing Reservation Stock
        src-db/database/sourcedata/AD_MESSAGE.xml
        src-db/database/sourcedata/M_INVENTORYSTATUS.xml
        
src/org/openbravo/common/hooks/InventoryStatusValidationHookReservations.java

    David Miguelez <[email protected]> null
    [w-is] Fixes several problems

* Inventory Status field in Reservations Pick And Edit is readonly
* Sales Order Line is no longer an identifier of a reservation, because
  it should allow to have null values
* Changed Inventory Status's names
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_FIELD.xml
        src-db/database/sourcedata/M_INVENTORYSTATUS.xml

    David Miguelez <[email protected]> null
    [w-is] Adds method in reservation utils to retrieve the list
of associated Reservation Stock from a Storage Detail
        src/org/openbravo/materialmgmt/ReservationUtils.java

    David Miguelez <[email protected]> null
    [w-is] Allows to change Status from a negative Inventory Status to another 
negative
Inventory Status
        src-db/database/model/functions/M_MOVEMENT_POST.xml

    David Miguelez <[email protected]> null
    [w-is] Fixes done to Change Inventory Status button

* Not shown for virtual bins
* Not possible to change the status of a virtual bin
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_FIELD.xml
        src-db/database/sourcedata/AD_MESSAGE.xml
        
src/org/openbravo/common/actionhandler/ChangeInventoryStatusActionHandler.java

    David Miguelez <[email protected]> null
    [w-is] Fixes wrong definition of unique index
        src-db/database/model/tables/M_LOCATOR.xml

    David Miguelez <[email protected]> null
    [w-is] Fixes definition of unique index and adds new Inventory Status
        src-db/database/model/tables/M_LOCATOR.xml
        src-db/database/sourcedata/M_INVENTORYSTATUS.xml

    David Miguelez <[email protected]> null
    [w-is] Adds unique index instead of unique constraint due to possible null
values in parent_locator column
        src-db/database/model/tables/M_LOCATOR.xml

    David Miguelez <[email protected]> null
    [w-is] Allows to modify the Inventory Status of a Storage Bin through the 
drop
down list, but only when it is being created the first time, afterwards
it must be changed from the change status button.
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_FIELD.xml

    David Miguelez <[email protected]> null
    [w-is] Changed Hook in Inventory Status validation to launch it a Storage 
Detail level

* Before this hook was launched at Locator level
* Adapted hoooks to support this change
* Added Inventory Status to unicity constraint
        src-db/database/model/tables/M_LOCATOR.xml
        
src/org/openbravo/common/actionhandler/ChangeInventoryStatusActionHandler.java
        src/org/openbravo/common/hooks/InventoryStatusHookManager.java
        src/org/openbravo/common/hooks/InventoryStatusValidationHook.java
        
src/org/openbravo/common/hooks/InventoryStatusValidationHookReservations.java
        
src/org/openbravo/common/hooks/InventoryStatusValidatorHookNegativeStock.java

    David Miguelez <[email protected]> null
    [w-is] Adds Virtual Bin fields/columns in locator table.

* Adds virtual bin flag and parent locator column
* Adds indexes for columns that can be null
* This allows to automate the creation of virtual bins for changing status
        src-db/database/model/tables/M_LOCATOR.xml
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_ELEMENT.xml
        src-db/database/sourcedata/AD_FIELD.xml

    David Miguelez <[email protected]> null
    [w-is] Adds missing Message entry
        src-db/database/sourcedata/AD_MESSAGE.xml

    David Miguelez <[email protected]> null
    [w-is] Adds validation to check if there is Stock with reservations in the
Locator that is going to change it's Inventory Status.
If so, it shows a Warning to the user.
        
src/org/openbravo/common/hooks/InventoryStatusValidationHookReservations.java
        
src/org/openbravo/common/actionhandler/ChangeInventoryStatusActionHandler.java
        src/org/openbravo/materialmgmt/ReservationUtils.java

    David Miguelez <[email protected]> null
    [w-is] Adds Inventory Status column in Manage Reservations PickAndEdit

* Supports both filtering and sorting
* Records are filtering by Inventory Status, only those ones with
  Available flag checked are shown.
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_FIELD.xml
        src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
        
src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java

    David Miguelez <[email protected]> null
    [w-is] Adds button to change Status of Locator

* Adds Hook to validate Inventory Status change
* Adds Hook implementation to valide Inventory Status change with negative stock
        
src/org/openbravo/common/actionhandler/ChangeInventoryStatusActionHandler.java
        src/org/openbravo/common/hooks/InventoryStatusHookManager.java
        src/org/openbravo/common/hooks/InventoryStatusValidationHook.java
        
src/org/openbravo/common/hooks/InventoryStatusValidatorHookNegativeStock.java
        src-db/database/model/tables/M_LOCATOR.xml
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_ELEMENT.xml
        src-db/database/sourcedata/AD_FIELD.xml
        src-db/database/sourcedata/AD_MESSAGE.xml
        src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
        src-db/database/sourcedata/OBUIAPP_PROCESS.xml

    David Miguelez <[email protected]> null
    [w-is] Deactivates allowNegativeStock flag at Client Information Level.
This functionality is now controlled through Inventory Status and
OverIssue flag.
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_FIELD.xml

    David Miguelez <[email protected]> null
    [w-is] Fixes several issues:

* Fixes missing column in group by clause in M_INOUT_CREATE
* Adds missing index in M_INVENTORYSTATUS_TRL
* Adds lines before comment in M_INVENTORYSTATUS_TRG due to problems
  while exporting in Oracle
* Fixes call to M_GET_STOCK in StockUtils.
        src-db/database/model/functions/M_INOUT_CREATE.xml
        src-db/database/model/tables/M_INVENTORYSTATUS_TRL.xml
        src-db/database/model/triggers/M_INVENTORYSTATUS_TRG.xml
        src/org/openbravo/materialmgmt/StockUtils.java
        src/org/openbravo/materialmgmt/StockUtils_data.xsql

    David Miguelez <[email protected]> null
    [w-is] Fixes problems in Oracle related to M_GET_STOCK_PARAM

* Removed M_GET_STOCK_PARAM1 function, instead, M_GET_STOCK_PARAM has
  optional parameters
* Fixed calls to M_GET_STOCK_PARAM1 to call M_GET_STOCK_PARAM instead
* Fixed problems in M_INVENTORYSTATUS_TRG in Oracle
        src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
        src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
        src-db/database/model/functions/M_GET_STOCK.xml
        src-db/database/model/functions/M_GET_STOCK_PARAM.xml
        src-db/database/model/functions/M_INOUT_CREATE.xml
        src-db/database/model/functions/M_PRODUCTION_RUN.xml
        src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml
        src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
        src-db/database/model/triggers/M_INVENTORYSTATUS_TRG.xml
        src-db/database/model/functions/M_GET_STOCK_PARAM1.xml

    David Miguelez <[email protected]> null
    [w-is] Support for OverIssue flag.

Instead of using allowNegativeStock flag present in AD_Client_Info table
it looks into the overIssue flag of the Inventory Status of the Locator.
        src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
        src-db/database/model/functions/M_CHECK_STOCK.xml
        src-db/database/model/functions/M_GET_STOCK_PARAM1.xml
        src-db/database/model/functions/M_INOUT_CREATE.xml
        src-db/database/model/functions/M_PRODUCTION_RUN.xml
        src-db/database/sourcedata/AD_TAB.xml
        src/org/openbravo/costing/CostingUtils.java
        src/org/openbravo/erpCommon/ad_actionButton/ProcessGoods.java
        src/org/openbravo/materialmgmt/InventoryCountProcess.java

    David Miguelez <[email protected]> null
    [w-is] Fixes wrong check in Inventory Status.
When the Client Info flag is not enabled, the Status must be one
that does not have the OverIssue flag enabled.
        
src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java

    David Miguelez <[email protected]> null
    [w-is] Fixed wrong parameter name in M_GET_STOCK_PARAM1 and also
rearranged parameters in that function.
        src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
        src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
        src-db/database/model/functions/M_GET_STOCK.xml
        src-db/database/model/functions/M_GET_STOCK_PARAM.xml
        src-db/database/model/functions/M_GET_STOCK_PARAM1.xml
        src-db/database/model/functions/M_INOUT_CREATE.xml
        src-db/database/model/functions/M_PRODUCTION_RUN.xml
        src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml
        src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml

    David Miguelez <[email protected]> null
    [w-is] Modified M_GET_STOCK_PARARM1 to correctly retrieve Inventory Status
from M_Locator table.
        src-db/database/model/functions/M_GET_STOCK_PARAM1.xml
        src-db/database/sourcedata/M_INVENTORYSTATUS.xml

    David Miguelez <[email protected]> null
    [w-is] Adapt flows to use Available and Nettable flags.

* Created new function m_get_stock_param1 that has this flags as parameters
* Modified m_get_stock and m_get_stock_param to call this function
* Modified calls to m_get_stock_param to use new function instead
        src-db/database/model/functions/M_GET_STOCK_PARAM1.xml
        src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
        src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
        src-db/database/model/functions/M_GET_STOCK.xml
        src-db/database/model/functions/M_GET_STOCK_PARAM.xml
        src-db/database/model/functions/M_INOUT_CREATE.xml
        src-db/database/model/functions/M_PRODUCTION_RUN.xml
        src-db/database/model/functions/M_RESERVATION_REALLOCATE.xml
        src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
        src-db/database/model/functions/M_UNIQUEATTRIBUTE_RULE_PARAM.xml
        src-db/database/model/functions/M_UNIQUELOCATOR_RULE_PARAM.xml
        src-db/database/model/functions/M_WAREHOUSE_DEFAULT_RULE_PARAM.xml
        src/org/openbravo/materialmgmt/StockUtils.java
        src/org/openbravo/materialmgmt/StockUtils_data.xsql

    David Miguelez <[email protected]> null
    [w-is] Adds ModuleScript to set the correct Inventory Status for each Client
depending on the Client Information configuration.
        
src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus.java
        
src-util/modulescript/src/org/openbravo/modulescript/InitializeInventoryStatus_data.xsql
        src-db/database/sourcedata/AD_FIELD.xml
        src-db/database/sourcedata/M_INVENTORYSTATUS.xml

    Víctor Martínez Romanos <[email protected]> null
    [w-is] Useful code extracted from initial project

Defined tables M_INVENTORYSTATUS and M_INVENTORYSTATUS_TRL at System level.
        src-db/database/model/tables/M_INVENTORYSTATUS.xml
        src-db/database/model/tables/M_INVENTORYSTATUS_TRL.xml
        src-db/database/model/triggers/M_INVENTORYSTATUS_TRG.xml
        src-db/database/sourcedata/M_INVENTORYSTATUS.xml
        src-db/database/model/tables/M_LOCATOR.xml
        src-db/database/sourcedata/AD_AUXILIARINPUT.xml
        src-db/database/sourcedata/AD_COLUMN.xml
        src-db/database/sourcedata/AD_DATASET_TABLE.xml
        src-db/database/sourcedata/AD_ELEMENT.xml
        src-db/database/sourcedata/AD_FIELD.xml
        src-db/database/sourcedata/AD_MENU.xml
        src-db/database/sourcedata/AD_MESSAGE.xml
        src-db/database/sourcedata/AD_REFERENCE.xml
        src-db/database/sourcedata/AD_TAB.xml
        src-db/database/sourcedata/AD_TABLE.xml
        src-db/database/sourcedata/AD_TREENODE.xml
        src-db/database/sourcedata/AD_WINDOW.xml
        src-db/database/sourcedata/OBUISEL_SELECTOR.xml
        src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml

    Asier Lostalé <[email protected]> null
    fixed bug 36074: inconsistent ad_process generates invalid web.xml

  Some invalid defintions of ad_process generated invalid web.xml because 
mapping
  was included referencing to a class that was filtered out, causing Tomcat to
  refuse to start.

  It has been fixed by adding to the query that retrieves mappings the same 
restrictions
  already added to the query looking for classes, so mappings will be obtained
  only if class is present.
        src-wad/src/org/openbravo/wad/Wad_data.xsql

Changes for Build #1920

    Carlos Aristu <[email protected]> null
    related to bug 35956: added missing javadoc info for the getWhereClause 
method
        
modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java




Last 20 lines of the console output:

[...truncated 2015 lines...]
Total time: 2 seconds

executing script 'Tomcat stop'
[int-basic-pgsql] $ /bin/bash /tmp/build_step_template6058004203553484309.sh 
ENABLE
DEBUG: Tomcat stop called with parameters: ENABLED=ENABLE
 * Stopping Tomcat servlet engine for Openbravo tomcat
   ...done.

executing script 'Check openbravo log'
[int-basic-pgsql] $ /bin/bash /tmp/build_step_template2970558593289934260.sh 
ENABLE
DEBUG: Check openbravo log called with parameters: ENABLED=ENABLE
Check log: openbravo log (artifact: int-basic-pgsql.log) is clean

Recording test results
Archiving artifacts
Checking \] ERROR|\] WARN
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