7/08/22 1:46 PM (SetupUtil) 
7/08/22 1:46 PM (SetupUtil) Clarity Home Directory [/app/patch16.0.2.1] : 
7/08/22 1:46 PM (SetupUtil) -----------------------------------------
7/08/22 1:46 PM (SetupUtil) You chose the following:
7/08/22 1:46 PM (SetupUtil) 
7/08/22 1:46 PM (SetupUtil) install.dir = /app/clarity
7/08/22 1:46 PM (SetupUtil) -----------------------------------------
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (ReleaseUtilityTask) Current version: 16.0.2.861
7/08/22 1:46 PM (ReleaseUtilityTask) Patching  to:    16.0.2.1.44
7/08/22 1:46 PM (Project) Trying to override old definition of task java
7/08/22 1:46 PM (Target) Target "init" started.
7/08/22 1:46 PM (Target) Target "init" finished.
7/08/22 1:46 PM (Target) Target "_dbBackupCheck" started.
7/08/22 1:46 PM (Echo)   CA PPM upgrade from 16.0.2 to 16.0.2.1 detected.
7/08/22 1:46 PM (Echo)     
7/08/22 1:46 PM (Target) Target "_dbBackupCheck" finished.
7/08/22 1:46 PM (Project) Trying to override old definition of task java
7/08/22 1:46 PM (Target) Target "_upgrade" started.
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (Echo)             
7/08/22 1:46 PM (Echo) -------------------------------------------------------------
7/08/22 1:46 PM (Echo) ATTENTION:
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (Echo) This program will patch your existing installation to 16.0.2.1.44:
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (Echo) Before proceeding, please make sure to do the following:
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (Echo) - For upgrades or patch: Read the upgrade section in the
7/08/22 1:46 PM (Echo)   installation guide thoroughly.
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (Echo) - Review your process for restoring any of your
7/08/22 1:46 PM (Echo)   customizations.
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (Echo) - Make sure to perform this upgrade or patch first on a test
7/08/22 1:46 PM (Echo)   environment with a replication of your production
7/08/22 1:46 PM (Echo)   data and customizations.
7/08/22 1:46 PM (Echo)         
7/08/22 1:46 PM (Echo)           
7/08/22 1:46 PM (Echo) 
7/08/22 1:46 PM (Echo)             
7/08/22 1:46 PM (Echo) -------------------------------------------------------------
7/08/22 1:46 PM (Echo)          
7/08/22 1:46 PM (Echo)           
7/08/22 1:46 PM (ReadLine) 
7/08/22 1:46 PM (ReadLine) Type 'y' to proceed : 
7/08/22 1:49 PM (SetupUtil) 
7/08/22 1:49 PM (SetupUtil) Clarity Home Directory [/app/clarity] : 
7/08/22 1:49 PM (SetupUtil) -----------------------------------------
7/08/22 1:49 PM (SetupUtil) You chose the following:
7/08/22 1:49 PM (SetupUtil) 
7/08/22 1:49 PM (SetupUtil) install.dir = /app/clarity
7/08/22 1:49 PM (SetupUtil) -----------------------------------------
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (ReleaseUtilityTask) Current version: 16.0.2.861
7/08/22 1:49 PM (ReleaseUtilityTask) Patching  to:    16.0.2.1.44
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "_dbBackupCheck" started.
7/08/22 1:49 PM (Echo)   CA PPM upgrade from 16.0.2 to 16.0.2.1 detected.
7/08/22 1:49 PM (Echo)     
7/08/22 1:49 PM (Target) Target "_dbBackupCheck" finished.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "_upgrade" started.
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo)             
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo) ATTENTION:
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo) This program will patch your existing installation to 16.0.2.1.44:
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo) Before proceeding, please make sure to do the following:
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo) - For upgrades or patch: Read the upgrade section in the
7/08/22 1:49 PM (Echo)   installation guide thoroughly.
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo) - Review your process for restoring any of your
7/08/22 1:49 PM (Echo)   customizations.
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo) - Make sure to perform this upgrade or patch first on a test
7/08/22 1:49 PM (Echo)   environment with a replication of your production
7/08/22 1:49 PM (Echo)   data and customizations.
7/08/22 1:49 PM (Echo)         
7/08/22 1:49 PM (Echo)           
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo)             
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo)          
7/08/22 1:49 PM (Echo)           
7/08/22 1:49 PM (ReadLine) 
7/08/22 1:49 PM (ReadLine) Type 'y' to proceed : 
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "_proceed-upgrade" started.
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo)       
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo) Release List for patch: 16.0.2.1
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo)     
7/08/22 1:49 PM (Echo)     
7/08/22 1:49 PM (CallTarget) Task "antcall" started.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "_process-release-setup-props" started.
7/08/22 1:49 PM (Target) Target "_process-release-setup-props" finished.
7/08/22 1:49 PM (CallTarget) Task "antcall" finished.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "_preprocess-upgrade" started.
7/08/22 1:49 PM (Target) Target "_preprocess-upgrade" finished.
7/08/22 1:49 PM (CallTarget) Task "antcall" started.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "_process-release" started.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "_install-release" started.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "_version_prep" started.
7/08/22 1:49 PM (Target) Target "_version_prep" finished.
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo)         
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo) Processing release: 16.0.2.1
7/08/22 1:49 PM (Echo) Package install path: /app/patch16.0.2.1/install-packages/16.0.2.1
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo)  
7/08/22 1:49 PM (Echo)       
7/08/22 1:49 PM (Echo) 
7/08/22 1:49 PM (Echo)         
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo) The following properties are used in the new install or upgrade invocation:
7/08/22 1:49 PM (Echo) interactive:         false
7/08/22 1:49 PM (Echo) skip.completed:      false
7/08/22 1:49 PM (Echo) appPoolId:           
7/08/22 1:49 PM (Echo) tenantId:            clarity
7/08/22 1:49 PM (Echo) qa.build:            
7/08/22 1:49 PM (Echo) qa.build.reimport:   false
7/08/22 1:49 PM (Echo) db.apply:            true
7/08/22 1:49 PM (Echo) xdm.apply:           true
7/08/22 1:49 PM (Echo) content.apply:       true
7/08/22 1:49 PM (Echo) legacy.upgrade:      false
7/08/22 1:49 PM (Echo) legacy.deploy:       false
7/08/22 1:49 PM (Echo) move.install.folder: false
7/08/22 1:49 PM (Echo) extract.package:     true
7/08/22 1:49 PM (Echo) reports.apply:       false
7/08/22 1:49 PM (Echo) install.target.dir:  /app/clarity
7/08/22 1:49 PM (Echo) install.dir          /app/clarity
7/08/22 1:49 PM (Echo) fail.on.errors:      true
7/08/22 1:49 PM (Echo) java_home:           /app/java
7/08/22 1:49 PM (Echo) j2ee.home:           
7/08/22 1:49 PM (Echo) maintenance.release: true
7/08/22 1:49 PM (Echo) standalone:          false
7/08/22 1:49 PM (Echo) stop.at.dbinstall:   false
7/08/22 1:49 PM (Echo) -------------------------------------------------------------
7/08/22 1:49 PM (Echo)        
7/08/22 1:49 PM (Echo)       
7/08/22 1:49 PM (Project) Trying to override old definition of task versionCompare
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "install" started.
7/08/22 1:49 PM (SetupUtil) -----------------------------------------
7/08/22 1:49 PM (SetupUtil) You chose the following:
7/08/22 1:49 PM (SetupUtil) 
7/08/22 1:49 PM (SetupUtil) install.dir = /app/clarity
7/08/22 1:49 PM (SetupUtil) -----------------------------------------
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "_upgrade" started.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "_install" started.
7/08/22 1:49 PM (SetupUtil) -----------------------------------------
7/08/22 1:49 PM (SetupUtil) You chose the following:
7/08/22 1:49 PM (SetupUtil) 
7/08/22 1:49 PM (SetupUtil) java_home             = /app/java
7/08/22 1:49 PM (SetupUtil) nsa.multicast.address = 230.0.0.1
7/08/22 1:49 PM (SetupUtil) nsa.multicast.port    = 9090
7/08/22 1:49 PM (SetupUtil) nsa.client.port       = 9091
7/08/22 1:49 PM (SetupUtil) use.command.prefix    = no
7/08/22 1:49 PM (SetupUtil) root.user             = root
7/08/22 1:49 PM (SetupUtil) nsa.install           = true
7/08/22 1:49 PM (SetupUtil) j2ee.home             = /app/tomcat
7/08/22 1:49 PM (SetupUtil) nsa.web.port          = 8090
7/08/22 1:49 PM (SetupUtil) -----------------------------------------
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "preextract" started.
7/08/22 1:49 PM (CallList) 
7/08/22 1:49 PM (CallList) preextract::upgrade --> start
7/08/22 1:49 PM (Target) Target "upgrade" started.
7/08/22 1:49 PM (Echo) toReleaseDir = /app/patch16.0.2.1/install-packages/16.0.2.1
7/08/22 1:49 PM (Target) Target "upgrade" finished.
7/08/22 1:49 PM (CallList) preextract::upgrade --> 0.0 seconds
7/08/22 1:49 PM (Target) Target "preextract" finished.
7/08/22 1:49 PM (Copy) Copying 480 files to /app/clarity
7/08/22 1:49 PM (Chmod) Applied chmod to 6 files and 0 directories.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "postextract" started.
7/08/22 1:49 PM (CallList) 
7/08/22 1:49 PM (CallList) postextract::upgrade --> start
7/08/22 1:49 PM (Target) Target "upgrade" started.
7/08/22 1:49 PM (Target) Target "upgrade" finished.
7/08/22 1:49 PM (CallList) postextract::upgrade --> 0.0 seconds
7/08/22 1:49 PM (Target) Target "postextract" finished.
7/08/22 1:49 PM (Copy) Copying 1 file to /app/clarity/bin
7/08/22 1:49 PM (Java) Updated properties.xml
7/08/22 1:49 PM (Java) Updated hosts.xml
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "preupgrade" started.
7/08/22 1:49 PM (Target) Target "preupgrade" finished.
7/08/22 1:49 PM (Project) Trying to override old definition of task java
7/08/22 1:49 PM (Target) Target "init" started.
7/08/22 1:49 PM (Target) Target "init" finished.
7/08/22 1:49 PM (Target) Target "installsteps" started.
7/08/22 1:49 PM (ExecTask) Executing upgrade process from maintenance directory.
7/08/22 1:49 PM (ExecTask) upgrade.phase = maintenance
7/08/22 1:49 PM (ExecTask) install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:49 PM (ExecTask) maintenance.release = true
7/08/22 1:49 PM (ExecTask) upgrade:phase = maintenance
7/08/22 1:49 PM (ExecTask) init_upgrade - HeapSize Max = 2048m
7/08/22 1:49 PM (ExecTask) core-upgrade:skip.db.upgrade = false
7/08/22 1:49 PM (ExecTask) core-upgrade:install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:49 PM (ExecTask) Installing schema file: /app/clarity/maintenance/infrastructure/schema/function/IS_CUSTOMER_DB.xml...
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) DBTools Log - Fri Jul 08 13:49:25 UTC 2022
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Command: install database schema file
7/08/22 1:49 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:49 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:49 PM (ExecTask) For vendor: postgres
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Process: /app/clarity/maintenance/infrastructure/schema/function/IS_CUSTOMER_DB.xml
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:49 PM (ExecTask) Installing schema file: /app/clarity/maintenance/infrastructure/schema/table/CMN_USAGE_ANALYTICS_DATA.xml...
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) DBTools Log - Fri Jul 08 13:49:29 UTC 2022
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Command: install database schema file
7/08/22 1:49 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:49 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:49 PM (ExecTask) For vendor: postgres
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Process: /app/clarity/maintenance/infrastructure/schema/table/CMN_USAGE_ANALYTICS_DATA.xml
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:49 PM (ExecTask) Created table CMN_USAGE_ANALYTICS_DATA
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) DBTools Log - Fri Jul 08 13:49:32 UTC 2022
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Command: extract row count
7/08/22 1:49 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:49 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:49 PM (ExecTask) For vendor: postgres
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Total time: 0H:0M:12S
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) -----------------------------------------------------
7/08/22 1:49 PM (ExecTask) 2022-07-08 13:49:30: Updating database
7/08/22 1:49 PM (ExecTask) -----------------------------------------------------
7/08/22 1:49 PM (ExecTask)         
7/08/22 1:49 PM (ExecTask) Executing upgrade process from maintenance directory.
7/08/22 1:49 PM (ExecTask) upgrade.phase = maintenance
7/08/22 1:49 PM (ExecTask) install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:49 PM (ExecTask) maintenance.release = true
7/08/22 1:49 PM (ExecTask) upgrade:phase = maintenance
7/08/22 1:49 PM (ExecTask) init_upgrade - HeapSize Max = 2048m
7/08/22 1:49 PM (ExecTask) Preupgrade
7/08/22 1:49 PM (ExecTask) Checking for resources to apply for database...
7/08/22 1:49 PM (ExecTask) Checking for resources to apply for infrastructure...
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) DBTools Log - Fri Jul 08 13:49:48 UTC 2022
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:49 PM (ExecTask) core-upgrade
7/08/22 1:49 PM (ExecTask) found /app/clarity/maintenance/componentList.xml
7/08/22 1:49 PM (ExecTask) Schema pre-upgrade
7/08/22 1:49 PM (ExecTask) Pre-upgrade schema for component = database
7/08/22 1:49 PM (ExecTask) Installing database schema...
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) DBTools Log - Fri Jul 08 13:49:52 UTC 2022
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:49 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:49 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:49 PM (ExecTask) For vendor: postgres
7/08/22 1:49 PM (ExecTask) Option: filtering on type "^pre-upgrade$"
7/08/22 1:49 PM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session.
7/08/22 1:49 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/database/schema/driver.xml
7/08/22 1:49 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/database/schema/driver.xml
7/08/22 1:49 PM (ExecTask) Current database version is database_post_20220426_2349
7/08/22 1:49 PM (ExecTask) DBDriver for database_20220623_1558
7/08/22 1:49 PM (ExecTask) Start installation of DBDriver ...
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:49 PM (ExecTask) Pre-upgrade schema for component = infrastructure
7/08/22 1:49 PM (ExecTask) Installing database schema...
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) DBTools Log - Fri Jul 08 13:49:55 UTC 2022
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:49 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:49 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:49 PM (ExecTask) For vendor: postgres
7/08/22 1:49 PM (ExecTask) Option: filtering on type "^pre-upgrade$"
7/08/22 1:49 PM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session.
7/08/22 1:49 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/schema/driver.xml
7/08/22 1:49 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/schema/driver.xml
7/08/22 1:49 PM (ExecTask) Current database version is infrastructure_20220426_2349
7/08/22 1:49 PM (ExecTask) DBDriver for infrastructure_20220623_1558
7/08/22 1:49 PM (ExecTask) Start installation of DBDriver ...
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:49 PM (ExecTask) Schema core upgrade
7/08/22 1:49 PM (ExecTask) Updating schema for component = database
7/08/22 1:49 PM (ExecTask) Installing database schema...
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) DBTools Log - Fri Jul 08 13:49:59 UTC 2022
7/08/22 1:49 PM (ExecTask) ==========================================
7/08/22 1:49 PM (ExecTask) 
7/08/22 1:49 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:49 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:49 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:49 PM (ExecTask) For vendor: postgres
7/08/22 1:49 PM (ExecTask) Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$"
7/08/22 1:49 PM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session.
7/08/22 1:49 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/database/schema/driver.xml
7/08/22 1:49 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/database/schema/driver.xml
7/08/22 1:50 PM (ExecTask) Current database version is database_20220623_1558
7/08/22 1:50 PM (ExecTask) DBDriver for database_20220623_1558
7/08/22 1:50 PM (ExecTask) Resume installation of DBDriver ...
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Current database version is database_post_20220426_2349
7/08/22 1:50 PM (ExecTask) Note: Triggers have been disabled
7/08/22 1:50 PM (ExecTask) Process - function: NK_SUM_JULIAN_FCT.xml
7/08/22 1:50 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:50 PM (ExecTask) Updating schema for component = infrastructure
7/08/22 1:50 PM (ExecTask) Installing database schema...
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:02 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:50 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:50 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:50 PM (ExecTask) For vendor: postgres
7/08/22 1:50 PM (ExecTask) Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$"
7/08/22 1:50 PM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session.
7/08/22 1:50 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/schema/driver.xml
7/08/22 1:50 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/schema/driver.xml
7/08/22 1:50 PM (ExecTask) Current database version is infrastructure_20220623_1558
7/08/22 1:50 PM (ExecTask) DBDriver for infrastructure_20220623_1558
7/08/22 1:50 PM (ExecTask) Resume installation of DBDriver ...
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Current database version is infrastructure_20220426_2349
7/08/22 1:50 PM (ExecTask) Re-creating the index
7/08/22 1:50 PM (ExecTask) Existing index (drop) : CMN_USAGE_ANALYTICS_DATA_U1( user_id )
7/08/22 1:50 PM (ExecTask)  New Index (create):  CMN_USAGE_ANALYTICS_DATA_U1 ( USER_ID ) 
7/08/22 1:50 PM (ExecTask) Note: Triggers have been disabled
7/08/22 1:50 PM (ExecTask) Process - table: CMN_USAGE_ANALYTICS_DATA.xml
7/08/22 1:50 PM (ExecTask) Process - function: IS_CUSTOMER_DB.xml
7/08/22 1:50 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:2S
7/08/22 1:50 PM (ExecTask) Updating xogseeddata for component = database
7/08/22 1:50 PM (ExecTask) Updating xogseeddata for component = infrastructure
7/08/22 1:50 PM (ExecTask) Created dir: /app/clarity/logs/xog-seeddata/out/infrastructure
7/08/22 1:50 PM (ExecTask) 	Applying PPM_INVALID_USER.xml
7/08/22 1:50 PM (ExecTask) Post-upgrade schema for component = database
7/08/22 1:50 PM (ExecTask) Installing database schema...
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:17 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:50 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:50 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:50 PM (ExecTask) For vendor: postgres
7/08/22 1:50 PM (ExecTask) Option: filtering on type "^post-upgrade$"
7/08/22 1:50 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/database/schema/driver.xml
7/08/22 1:50 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/database/schema/driver.xml
7/08/22 1:50 PM (ExecTask) Current database version is database_20220623_1558
7/08/22 1:50 PM (ExecTask) DBDriver for database_20220623_1558
7/08/22 1:50 PM (ExecTask) Resume installation of DBDriver ...
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Current database version is database_post_20220426_2349
7/08/22 1:50 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:50 PM (ExecTask) Post-upgrade schema for component = infrastructure
7/08/22 1:50 PM (ExecTask) Installing database schema...
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:20 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:50 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:50 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:50 PM (ExecTask) For vendor: postgres
7/08/22 1:50 PM (ExecTask) Option: filtering on type "^post-upgrade$"
7/08/22 1:50 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/schema/driver.xml
7/08/22 1:50 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/schema/driver.xml
7/08/22 1:50 PM (ExecTask) Current database version is infrastructure_20220623_1558
7/08/22 1:50 PM (ExecTask) DBDriver for infrastructure_20220623_1558
7/08/22 1:50 PM (ExecTask) Resume installation of DBDriver ...
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Current database version is infrastructure_20220426_2349
7/08/22 1:50 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:50 PM (ExecTask) Adjust stock seeddata IDs...
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:23 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Command: bump ids 
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:50 PM (ExecTask) Generate sequences...
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:26 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Command: install database schema file
7/08/22 1:50 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:50 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:50 PM (ExecTask) For vendor: postgres
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Process: /app/clarity/database/sql/GENERATE_CMN_SEQ_TABLES.xml
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:50 PM (ExecTask) Applying post-bootstrap xog-seeddata for component = database
7/08/22 1:50 PM (ExecTask) Installing post-install DB Driver file /app/clarity/maintenance/database/postinstall/driver.xml
7/08/22 1:50 PM (ExecTask) Applying post-bootstrap xog-seeddata for component = infrastructure
7/08/22 1:50 PM (ExecTask) Installing post-install DB Driver file /app/clarity/maintenance/infrastructure/postinstall/driver.xml
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:30 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:50 PM (ExecTask) Executing upgrade process from maintenance directory.
7/08/22 1:50 PM (ExecTask) upgrade.phase = maintenance
7/08/22 1:50 PM (ExecTask) install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:50 PM (ExecTask) maintenance.release = true
7/08/22 1:50 PM (ExecTask) upgrade:phase = maintenance
7/08/22 1:50 PM (ExecTask) init_upgrade - HeapSize Max = 2048m
7/08/22 1:50 PM (ExecTask) Postupgrade
7/08/22 1:50 PM (ExecTask) HeapSize Max = 2048m
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:33 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) Executing Ant script: /app/clarity/maintenance/16.0.2.1/infrastructure/postupgrade/osf.xml
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:36 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:40 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:43 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Command: extract row count
7/08/22 1:50 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:50 PM (ExecTask) As user: ppm_1602_ga
7/08/22 1:50 PM (ExecTask) For vendor: postgres
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:11S
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) -----------------------------------------------------
7/08/22 1:50 PM (ExecTask) 2022-07-08 13:50:55: Finished updating database
7/08/22 1:50 PM (ExecTask) -----------------------------------------------------
7/08/22 1:50 PM (ExecTask)         
7/08/22 1:50 PM (ExecTask) upgrade.phase = maintenance
7/08/22 1:50 PM (ExecTask) install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:50 PM (ExecTask) maintenance.release = true
7/08/22 1:50 PM (ExecTask) Installing schema file: /app/clarity/maintenance/infrastructure/dwhschema/function/IS_DWH_CUSTOMER_DB.xml...
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) DBTools Log - Fri Jul 08 13:50:58 UTC 2022
7/08/22 1:50 PM (ExecTask) ==========================================
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Command: install database schema file
7/08/22 1:50 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/dwh_1602_ga
7/08/22 1:50 PM (ExecTask) As user: dwh_1602_ga
7/08/22 1:50 PM (ExecTask) For vendor: postgres
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Process: /app/clarity/maintenance/infrastructure/dwhschema/function/IS_DWH_CUSTOMER_DB.xml
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) Total time: 0H:0M:0S
7/08/22 1:50 PM (ExecTask) INFO: Data Warehouse last Installed  version 16.0.2.861
7/08/22 1:50 PM (ExecTask) Executing upgrade process from maintenance directory.
7/08/22 1:50 PM (ExecTask) upgrade.phase = maintenance
7/08/22 1:50 PM (ExecTask) install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:50 PM (ExecTask) maintenance.release = true
7/08/22 1:50 PM (ExecTask) upgrade:phase = maintenance
7/08/22 1:50 PM (ExecTask) init_upgrade - HeapSize Max = 2048m
7/08/22 1:50 PM (ExecTask) dwh-core-upgrade:skip.db.upgrade = false
7/08/22 1:50 PM (ExecTask) dwh-core-upgrade:install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask) -----------------------------------------------------
7/08/22 1:50 PM (ExecTask) 2022-07-08 13:50:59: Updating Data warehouse database
7/08/22 1:50 PM (ExecTask) -----------------------------------------------------
7/08/22 1:50 PM (ExecTask)    
7/08/22 1:50 PM (ExecTask) The dblink PPMDBLINK will be recreated after upgrading.
7/08/22 1:50 PM (ExecTask) Preparing to drop DBLink...
7/08/22 1:50 PM (ExecTask) Dropping PostgreSQL DBLink...
7/08/22 1:50 PM (ExecTask) 
7/08/22 1:50 PM (ExecTask)         %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
7/08/22 1:50 PM (ExecTask)         Dropping PostgreSQL foreign server:
7/08/22 1:50 PM (ExecTask)         dblinkname: PPMDBLINK
7/08/22 1:50 PM (ExecTask)         url:        jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/dwh_1602_ga
7/08/22 1:50 PM (ExecTask)         username:   dwh_1602_ga
7/08/22 1:50 PM (ExecTask)         password:   *****
7/08/22 1:50 PM (ExecTask)         %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
7/08/22 1:50 PM (ExecTask)       
7/08/22 1:50 PM (ExecTask)  
7/08/22 1:50 PM (ExecTask) DROP SERVER IF EXISTS PPMDBLINK CASCADE;
7/08/22 1:50 PM (ExecTask)  
7/08/22 1:51 PM (ExecTask) 1 of 1 SQL statements executed successfully
7/08/22 1:51 PM (ExecTask) DBLink operation complete
7/08/22 1:51 PM (ExecTask) upgrade.phase = maintenance
7/08/22 1:51 PM (ExecTask) install.upgrade.dir = /app/clarity/maintenance
7/08/22 1:51 PM (ExecTask) maintenance.release = true
7/08/22 1:51 PM (ExecTask) upgrade:phase = maintenance
7/08/22 1:51 PM (ExecTask) init_upgrade - HeapSize Max = 2048m
7/08/22 1:51 PM (ExecTask) Datawarehouse Preupgrade Script Before Upgrade for Component:infrastructure
7/08/22 1:51 PM (ExecTask) Schema pre-upgrade for Datawarehouse schema
7/08/22 1:51 PM (ExecTask) Pre-upgrade schema for component = infrastructure and database schema=Datawarehouse
7/08/22 1:51 PM (ExecTask) Installing database schema...
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) DBTools Log - Fri Jul 08 13:51:04 UTC 2022
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:51 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/dwh_1602_ga
7/08/22 1:51 PM (ExecTask) As user: dwh_1602_ga
7/08/22 1:51 PM (ExecTask) For vendor: postgres
7/08/22 1:51 PM (ExecTask) Option: filtering on type "^pre-upgrade$"
7/08/22 1:51 PM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session.
7/08/22 1:51 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/dwhschema/driver.xml
7/08/22 1:51 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/dwhschema/driver.xml
7/08/22 1:51 PM (ExecTask) Current database version is infrastructure_20220426_2349
7/08/22 1:51 PM (ExecTask) DBDriver for infrastructure_20220623_1558
7/08/22 1:51 PM (ExecTask) Start installation of DBDriver ...
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:51 PM (ExecTask) Schema core upgrade for Datawarehouse schema
7/08/22 1:51 PM (ExecTask) Updating schema for component = infrastructure and database schema=Datawarehouse
7/08/22 1:51 PM (ExecTask) Installing database schema...
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) DBTools Log - Fri Jul 08 13:51:08 UTC 2022
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:51 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/dwh_1602_ga
7/08/22 1:51 PM (ExecTask) As user: dwh_1602_ga
7/08/22 1:51 PM (ExecTask) For vendor: postgres
7/08/22 1:51 PM (ExecTask) Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$"
7/08/22 1:51 PM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session.
7/08/22 1:51 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/dwhschema/driver.xml
7/08/22 1:51 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/dwhschema/driver.xml
7/08/22 1:51 PM (ExecTask) Current database version is infrastructure_20220623_1558
7/08/22 1:51 PM (ExecTask) DBDriver for infrastructure_20220623_1558
7/08/22 1:51 PM (ExecTask) Resume installation of DBDriver ...
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Note: Triggers have been disabled
7/08/22 1:51 PM (ExecTask) Process - function: IS_DWH_CUSTOMER_DB.xml
7/08/22 1:51 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:51 PM (ExecTask) Schema post-upgrade for Datawarehouse schema
7/08/22 1:51 PM (ExecTask) Post-upgrade schema for component = infrastructure and database schema=Datawarehouse
7/08/22 1:51 PM (ExecTask) Installing database schema...
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) DBTools Log - Fri Jul 08 13:51:11 UTC 2022
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Command: install database schema from driver file
7/08/22 1:51 PM (ExecTask) To URL: jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/dwh_1602_ga
7/08/22 1:51 PM (ExecTask) As user: dwh_1602_ga
7/08/22 1:51 PM (ExecTask) For vendor: postgres
7/08/22 1:51 PM (ExecTask) Option: filtering on type "^post-upgrade$"
7/08/22 1:51 PM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session.
7/08/22 1:51 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/dwhschema/driver.xml
7/08/22 1:51 PM (ExecTask) Loading DBDriver file: /app/clarity/maintenance/infrastructure/dwhschema/driver.xml
7/08/22 1:51 PM (ExecTask) Current database version is infrastructure_20220623_1558
7/08/22 1:51 PM (ExecTask) DBDriver for infrastructure_20220623_1558
7/08/22 1:51 PM (ExecTask) Resume installation of DBDriver ...
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Note: Triggers have been enabled
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) DBDriver successfully installed!
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:51 PM (ExecTask) Configuring DBLink...
7/08/22 1:51 PM (ExecTask) Recreating PostgreSQL DBLink...
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask)                 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
7/08/22 1:51 PM (ExecTask)                 Creating foreign data wrapper
7/08/22 1:51 PM (ExecTask)                 for user dwh_1602_ga:
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask)                 url:         jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/dwh_1602_ga
7/08/22 1:51 PM (ExecTask)                 user:        dwh_1602_ga
7/08/22 1:51 PM (ExecTask)                 target url:  jdbc:postgresql://lvnprod006395.bpc.broadcom.net:5432/ppm_1602_ga
7/08/22 1:51 PM (ExecTask)                 target user: ppm_1602_ga
7/08/22 1:51 PM (ExecTask)                 target db:   ppm_1602_ga
7/08/22 1:51 PM (ExecTask)                 schema:      dwh_1602_ga
7/08/22 1:51 PM (ExecTask)                 extension:   postgres_fdw
7/08/22 1:51 PM (ExecTask)                 fdw:         postgres_fdw
7/08/22 1:51 PM (ExecTask)                 name:        PPMDBLINK
7/08/22 1:51 PM (ExecTask)                 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
7/08/22 1:51 PM (ExecTask)       
7/08/22 1:51 PM (ExecTask) DBLink operation complete
7/08/22 1:51 PM (ExecTask) Executing update-dwh-install-history from #3 for Datawarehouse 
7/08/22 1:51 PM (ExecTask) Inside  update-dwh-install-history  install.type=package install.id=dwhdatabase::16.0.2.1.44
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) DBTools Log - Fri Jul 08 13:51:17 UTC 2022
7/08/22 1:51 PM (ExecTask) ==========================================
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask) Total time: 0H:0M:1S
7/08/22 1:51 PM (ExecTask) 
7/08/22 1:51 PM (ExecTask)          --------------------------------------------------------------
7/08/22 1:51 PM (ExecTask)          2022-07-08 13:51:19: Finished updating Data warehouse database
7/08/22 1:51 PM (ExecTask)          --------------------------------------------------------------
7/08/22 1:51 PM (ExecTask)                  
7/08/22 1:51 PM (ExecTask)     
7/08/22 1:51 PM (Java) Uploaded properties.xml
7/08/22 1:51 PM (Target) Target "installsteps" finished.
7/08/22 1:51 PM (Project) Trying to override old definition of task java
7/08/22 1:51 PM (Target) Target "init" started.
7/08/22 1:51 PM (Target) Target "init" finished.
7/08/22 1:51 PM (Target) Target "postupgrade" started.
7/08/22 1:51 PM (Target) Target "postupgrade" finished.
7/08/22 1:51 PM (Echo) Installation Successful - 08-July-2022 13:51:22
7/08/22 1:51 PM (Target) Target "_install" finished.
7/08/22 1:51 PM (Target) Target "_upgrade" finished.
7/08/22 1:51 PM (Target) Target "install" finished.
7/08/22 1:51 PM (Target) Target "_install-release" finished.
7/08/22 1:51 PM (Target) Target "_process-release" finished.
7/08/22 1:51 PM (CallTarget) Task "antcall" finished.
7/08/22 1:51 PM (Project) Trying to override old definition of task java
7/08/22 1:51 PM (Target) Target "_postprocess-upgrade" started.
7/08/22 1:51 PM (Target) Target "_postprocess-upgrade" finished.
7/08/22 1:51 PM (Target) Target "_proceed-upgrade" finished.
7/08/22 1:51 PM (Target) Target "_upgrade" finished.
7/08/22 1:51 PM (Target) Target "install" finished.