int-upgrade-pgsql - Build # 1325 - Fixed:

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


Committers since last success:

Changes for Build #1324

    Carlos Aristu <[email protected]> null
    fixes issue 32039: Add generic mechanism to have multiple cached preferences

The new CachedPreference class can be used to keep the value of a preference 
defined at system level. The value of the 'Allow Unpaged Datasource Manual 
Request' preference is already handled by this class. So the 
UnpagedRequestCachedPreference is not needed anymore.
        
modules/org.openbravo.client.application/src/org/openbravo/client/application/CachedPreference.java
        
modules/org.openbravo.client.application/src/org/openbravo/client/application/event/PreferenceEventHandler.java
        
modules/org.openbravo.service.json/src/org/openbravo/service/json/DefaultJsonDataService.java
        
modules/org.openbravo.service.json/src/org/openbravo/service/json/UnpagedRequestCachedPreference.java

    Carlos Aristu <[email protected]> null
    fixes issue 31180: openDirectTab action now works if the tab is already 
opened

When the opening tab was already opened, the openDirectTab method was not 
waiting properly to the new tab be refreshed/opened. This was caused because 
the callout of OB.Utilities.openDirectTab method was invoked after the line 
that checks if the action needs to wait.
Now if the tab is already opened the action is called again with a delay of 
100ms, giving OB.Utilities.openDirectTab enough time to execute its callout.
        
modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-utilities-action-def.js

    Carlos Aristu <[email protected]> null
    related to issue 31180: backed out changeset
        
modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-utilities-action-def.js

    Nono Carballo <[email protected]> null
    Fixes Issue 31936: The SQL query of M_INVENTORY_LISTCREATE store procedure 
was
tuned to take care about null values.

The SQL query to retrieve the products that will be part of the lines was tuned
to take care about null values in aset.isoneattrsetvalrequired field.
The line AND aset.isoneattrsetvalrequired = 'Y' was replaced with
AND COALESCE(aset.isoneattrsetvalrequired, '-') = 'Y'
        src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml

Changes for Build #1325

    Augusto Mauch <[email protected]> null
    Fixes issue 32011: Trigger can be recreated with triggers to follow list 
(ORA)

Now it is possible to recreate an existing trigger, specifying a list of 
triggers of the same type that should be invoked before it. This development 
only affects Oracle database
s, as in postgres the trigger execution order is given by the trigger's name.

The Oracle8Builder has been updated to include a follows clause if the trigger 
being created must be executed before it. For instance, to create a trigger 
named TEST_TRIGGER_SECO
ND that must be executed after a trigger called TEST_TRIGGER_FIRST, the builder 
constructs the following statement:

CREATE TRIGGER TEST_TRIGGER_FIRST
AFTER INSERT OR UPDATE
ON TEST FOR EACH ROW
FOLLOWS TEST_TRIGGER_SECOND
DECLARE
BEGIN
END TEST_TRIGGER_FIRST
;
        src-db/database/lib/dbsourcemanager.jar

    Augusto Mauch <[email protected]> null
    Fixes issue 31712: Foreign keys and constraints can be disabled per table

Before this change the Platform class only offered methods to disable all the 
constraints and foreign keys of the whole database. Now it is possible to do it 
also on a table to table basis.

Changes done:
- Platform.java: Added public methods disableAllFkForTable, 
enableAllFkForTable, disableCheckConstraintsForTable, 
enableCheckConstraintsForTable
- PlatformImplBase.java: Provides a functional default implementation for 
disableCheckConstraintsForTable and enableCheckConstraintsForTable, possible 
because the .disableAllChecks(table) was already implemented. Also provides an 
implementation for disableAllFkForTable and enableAllFkForTable that just 
returns throw new DatabaseOperationException("Error: Operation not supported"), 
because it needs to be implemented in each specific platform.
- Oracle8Platform and PostgreSqlPlatform: Implementations for 
disableAllFkForTable and enableAllFkForTable.

Some tests have been added to check that the foreign keys and constraints can 
be disabled and enabled for the whole database and also for a specific table.
        src-db/database/lib/dbsourcemanager.jar




Last 20 lines of the console output:

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

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

executing script 'Check log'
[int-upgrade-pgsql] $ /bin/bash /tmp/build_step_template5625703372424119211.sh 
ENABLE
DEBUG: Check log called with parameters: ENABLED=ENABLE
Check log: openbravo log (artifact: int-upgrade-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
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Openbravo-builds mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-builds

Reply via email to