Buildfile: /home/clar/15.7/15.7/install_files/install-packages/15.6.0/upgrade-repack.15.6.0.320tpexcludes/gateway.xml gateway: Trying to override old definition of task java init: install: ----------------------------------------- You chose the following: install.dir = /home/clar/clarity ----------------------------------------- Trying to override old definition of task java _upgrade: Trying to override old definition of task java init: _install: ----------------------------------------- You chose the following: java_home = /usr/java/jdk_11.0.4_11 nsa.multicast.address = 239.255.1.17 nsa.multicast.port = 9091 nsa.client.port = 9094 use.command.prefix = no root.user = claritybnl nsa.install = false j2ee.home = /home/clar/apache-tomcat-8.5.45 ----------------------------------------- Trying to override old definition of task java init: preextract: preextract::reporting --> start upgrade: Deleting jaspersoft content upgrade zip files... preextract::reporting --> 0.0 seconds preextract::xdm --> start upgrade: backing up xdm descriptor file... Copying 1 file to /home/clar/clarity/META-INF/xdm/config preextract::xdm --> 0.0 seconds preextract::release-override.15.6.0 --> start upgrade: Executing incremental release-override infrastructure/preextract scripts preextract::release-override.15.6.0 --> 0.0 seconds preextract::release-override.15.6.0 --> start upgrade: Executing incremental release-override component/preextract scripts preextract::release-override.15.6.0 --> 0.0 seconds Trying to override old definition of task java _process-install-dir: Moving 23173 files to /home/clar/clarity_15.5.1.240 Created dir: /home/clar/clarity Expanding: /home/clar/15.7/15.7/install_files/install-packages/15.6.0/upgrade-repack.15.6.0.320tpexcludes/package.jar into /home/clar/clarity Applied chmod to 4 files and 0 directories. Copying 63 files to /home/clar/clarity Trying to override old definition of task java init: postextract: postextract::osf --> start upgrade: Created dir: /home/clar/clarity/resource/previousRelease Copying 887 files to /home/clar/clarity/resource/previousRelease postextract::osf --> 0.0 seconds postextract::xdm --> start upgrade: Restoring xdm ... Copying 1 file to /home/clar/clarity/META-INF/xdm/config Created dir: /home/clar/clarity/xdm-temp Copying 151 files to /home/clar/clarity/xdm-temp Copied 15 empty directories to 3 empty directories under /home/clar/clarity/xdm-temp Copying 281 files to /home/clar/clarity Copied 23 empty directories to 3 empty directories under /home/clar/clarity Copying 151 files to /home/clar/clarity Deleting directory /home/clar/clarity/xdm-temp postextract::xdm --> 0.0 seconds postextract::upgrade --> start upgrade: upgrade: upgrade: Checking for Custom External deploy scripts in /home/clar/clarity_15.5.1.240/.setup/scripts/custom postextract::upgrade --> 0.0 seconds postextract::release-override.15.6.0 --> start upgrade: Updating installation directory with release override files... Expanding: /home/clar/15.7/15.7/install_files/install-packages/15.6.0/upgrade-repack.15.6.0.320tpexcludes/upgrade/15.6.0/release-override.jar into /home/clar/clarity Copying 1 file to /home/clar/clarity/.setup Copying 1 file to /home/clar/clarity/upgrade/15.6.0/infrastructure/preupgrade Created dir: /home/clar/clarity/upgrade/15.6.0/component/preupgrade Copying 1 file to /home/clar/clarity/upgrade/15.6.0/component/preupgrade Copying 1 file to /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade Copying 1 file to /home/clar/clarity/upgrade/15.6.0/component/postupgrade Executing incremental release-override postextract scripts postextract::release-override.15.6.0 --> 0.0 seconds postextract::release-override.15.6.0 --> start upgrade: Executing incremental release-override component/postextract scripts postextract::release-override.15.6.0 --> 0.0 seconds Copying 1 file to /home/clar/clarity/bin Updated properties.xml Updated hosts.xml Trying to override old definition of task java init: preupgrade: Trying to override old definition of task java init: installsteps: Executing upgrade process from upgrade directory. upgrade.phase = upgrade install.upgrade.dir = /home/clar/clarity/upgrade maintenance.release = false upgrade:phase = upgrade init_upgrade - HeapSize Max = 4096m core-upgrade:skip.db.upgrade = false core-upgrade:install.upgrade.dir = /home/clar/clarity/upgrade Installing schema file: /home/clar/clarity/upgrade/infrastructure/schema/function/IS_CUSTOMER_DB.xml... ========================================== DBTools Log - Mon Apr 06 08:35:10 CEST 2020 ========================================== Command: install database schema file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Process: /home/clar/clarity/upgrade/infrastructure/schema/function/IS_CUSTOMER_DB.xml Total time: 0H:0M:0S ========================================== DBTools Log - Mon Apr 06 08:35:13 CEST 2020 ========================================== Command: extract row count To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Total time: 0H:10M:11S ----------------------------------------------------- 2020-04-06 08:35:11: Updating database ----------------------------------------------------- Executing upgrade process from upgrade directory. upgrade.phase = upgrade install.upgrade.dir = /home/clar/clarity/upgrade maintenance.release = false upgrade:phase = upgrade init_upgrade - HeapSize Max = 4096m Preupgrade HeapSize Max = 4096m ========================================== DBTools Log - Mon Apr 06 08:45:26 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/preupgrade/database.xml ========================================== DBTools Log - Mon Apr 06 08:45:28 CEST 2020 ========================================== Command: install database schema file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Process: /home/clar/clarity/upgrade/15.6.0/infrastructure/preupgrade/CMN_ENABLE_DISABLE_SP.xml Total time: 0H:0M:0S Total time: 0H:0M:2S HeapSize Max = 4096m ========================================== DBTools Log - Mon Apr 06 08:45:30 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/preupgrade/release-override.15.6.0.xml Executing incremental release-override infrastructure/preupgrade scripts Total time: 0H:0M:0S Checking for resources to apply for database... Checking for resources to apply for infrastructure... Checking for resources to apply for union... Checking for resources to apply for nmc... Checking for resources to apply for revmgr... Checking for resources to apply for projmgr... Checking for resources to apply for content... Checking for resources to apply for cms... Checking for resources to apply for osf... HeapSize Max = 4096m ========================================== DBTools Log - Mon Apr 06 08:45:33 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/component/preupgrade/release-override.15.6.0.xml Executing incremental release-override component/preupgrade scripts Total time: 0H:0M:0S ========================================== DBTools Log - Mon Apr 06 08:45:35 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:1S core-upgrade found /home/clar/clarity/upgrade/componentList.xml Schema pre-upgrade Pre-upgrade schema for component = database Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:45:38 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/database/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/database/schema/driver.xml Current database version is database_20181116_0028 DBDriver for database_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Process - pre-upgrade: PREUPGRADE_CORS_FEATURE_ENABLE.xml Process - pre-upgrade: PREUPGRADE_INVESTMENT_TASK_MANAGEMENT_PERM_SEEDDATA.xml Process - pre-upgrade: PREUPGRADE_TOKEN_FEATURE_ENABLE.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:2S Pre-upgrade schema for component = infrastructure Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:45:42 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/schema/driver.xml Current database version is infrastructure_20181116_0028 DBDriver for infrastructure_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Pre-upgrade schema for component = union Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:45:45 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/union/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/union/schema/driver.xml Current database version is union_20160401_0111 DBDriver for union_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Pre-upgrade schema for component = nmc Pre-upgrade schema for component = revmgr Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:45:48 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/revmgr/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/revmgr/schema/driver.xml Current database version is revmgr_20180517_2038 DBDriver for revmgr_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Pre-upgrade schema for component = projmgr Pre-upgrade schema for component = content Pre-upgrade schema for component = cms Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:45:52 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/cms/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/cms/schema/driver.xml Current database version is cms_20160401_0111 DBDriver for cms_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Pre-upgrade schema for component = osf Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:45:55 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/osf/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/osf/schema/driver.xml Current database version is osf_20170223_0001 DBDriver for osf_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Schema core upgrade Updating schema for component = database Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:45:58 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/database/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/database/schema/driver.xml Current database version is database_20190222_0436 DBDriver for database_20190222_0436 Resume installation of DBDriver ... Current database version is database_20181116_0028 Note: Foreign Keys have been disabled Note: Triggers have been disabled Process - table: BIZ_COM_PERIODS.xml Process - table: CMN_SEC_ACCESS_TOKENS.xml Process - table: CMN_TELEMETRY_OPTIONS.xml Process - table: CMN_TELEMETRY_OPTION_VALUES.xml Process - table: CMN_TELEMETRY_REQ_STATUS.xml Process - table: DWH_CFG_OBJECT_TYPE.xml Process - table: DWH_TMP_FIN_TRANSACTION.xml Process - table: INV_INVESTMENTS.xml Process - table: ODF_CA_PROJECT.xml Process - table: ODF_GLOBAL_PICKLIST_DEFS.xml Process - table: ODF_ITEM_POSITIONS.xml Process - table: ODF_ITEM_VALUES.xml Process - table: ODF_PICKLIST_CANDIDATES.xml Process - table: ODF_PICKLIST_CONTEXTS_TBL.xml Process - table: ODF_PICKLIST_DEFS.xml Process - table: ODF_PICKLIST_DEF_OBJECTS.xml Process - table: ODF_PICKLIST_ITEM_MAPPINGS.xml Process - table: ODF_TL_ITEM_POSITIONS.xml Process - table: ODF_UI_LIST_COLS.xml Process - table: ODF_UI_SETTINGS_METADATA.xml Process - table: ODF_UI_SETTING_POSITIONS.xml Process - table: ODF_UI_VIEWS.xml Process - table: PRNOTE.xml Process - table: SRM_RESOURCES.xml Process - view: DWH_FIN_I_TRANSACTION_V.xml Process - view: DWH_FIN_TRANSACTION_DP_V.xml Process - view: DWH_FIN_TRANSACTION_V.xml Process - view: DWH_INV_OBS_MAPPING_V.xml Process - view: DWH_INV_SEC_GBL_PERMS_V.xml Process - view: DWH_INV_SEC_INST_PERMS_V.xml Process - view: DWH_SEC_GLOBAL_RIGHT_V.xml Process - view: DWH_X_INV_I_SUM_FACTS_V.xml Process - view: DWH_X_INV_SUM_FACTS_V.xml Process - sequence: CMN_TELEMETRY_OPTIONS_S1.xml Process - sequence: CMN_TELEMETRY_OPTION_VALUES_S1.xml Process - sequence: CMN_TELEMETRY_REQ_STATUS_S1.xml Process - sequence: ODF_PICKLIST_CONTEXTS_S1.xml Process - sequence: ODF_PICKLIST_DEFS_S1.xml Process - sequence: ODF_PICKLIST_DEF_OBJECTS_S1.xml Process - procedure: CMN_LOOKUPS_UPD_SP.xml Process - procedure: NBI_PROJ_RATES_AND_COSTS_SP.xml Process - procedure: PAC_PURGE_FINANCIAL_SP.xml Note: Triggers have been disabled Process - seeddata: DWH_FIN_TRANS_META_COLUMN_SEED.xml Process - seeddata: SEED_SETTINGS_METADATA.xml Process - seeddata: SEED_SETTINGS_METADATA_POSITIONS.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:39S Updating schema for component = infrastructure Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:46:39 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/schema/driver.xml Current database version is infrastructure_20190222_0436 DBDriver for infrastructure_20190222_0436 Resume installation of DBDriver ... Current database version is infrastructure_20181116_0028 Note: Foreign Keys have been disabled Note: Triggers have been disabled Process - function: IS_CUSTOMER_DB.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Updating schema for component = union Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:46:42 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/union/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/union/schema/driver.xml Current database version is union_20190222_0436 DBDriver for union_20190222_0436 Resume installation of DBDriver ... Current database version is union_20160401_0111 Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Updating schema for component = nmc Updating schema for component = revmgr Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:46:45 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/revmgr/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/revmgr/schema/driver.xml Current database version is revmgr_20190222_0436 DBDriver for revmgr_20190222_0436 Resume installation of DBDriver ... Current database version is revmgr_20180517_2038 Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Updating schema for component = projmgr Updating schema for component = content Updating schema for component = cms Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:46:48 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/cms/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/cms/schema/driver.xml Current database version is cms_20190222_0436 DBDriver for cms_20190222_0436 Resume installation of DBDriver ... Current database version is cms_20160401_0111 Note: Foreign Keys have been disabled Note: Triggers have been disabled Process - function: CMS_GET_CONTENT_ITEM_CODE_FCT.xml Process - function: CMS_GET_CONTENT_ITEM_NAME_FCT.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Updating schema for component = osf Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:46:51 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/osf/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/osf/schema/driver.xml Current database version is osf_20190222_0436 DBDriver for osf_20190222_0436 Resume installation of DBDriver ... Current database version is osf_20170223_0001 Note: Foreign Keys have been disabled Note: Triggers have been disabled Process - table: ODF_UI_VIEW_SETTINGS.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Updating xogseeddata for component = database Created dir: /home/clar/clarity/logs/xog-seeddata/out/database log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Applying API_CLIENTS_LOOKUP.xml Applying API_TOKEN_ACCESS_TYPE.xml Applying Black_and_White_UI_Theme.xml Applying Blue_UI_Theme.xml Applying DE45969_LOOKUP_FILTER.xml Applying DECIMAL_PRECISION_DISPLAY.xml Applying High_Contrast_UI_Theme.xml Applying LOOKUP_LOOKUP_FOR_CUST_ATTR_LIST.xml Applying Mobile_Enter_Time_Navigate_Right.xml Applying Navy_Blue_UI_Theme.xml Applying OBS_BROWSE_FLT_RDM_ROADMAP.xml Applying ODF_PICKLIST_PURGE.xml Applying PHOENIX_UI_THEME.xml Applying RDM_ITEMS_SYNC.xml Applying Red_UI_Theme.xml Applying SIMPLE_PERIOD_TYPE.xml Applying Studio_Access_Rights.xml Applying Teal_and_Grey_UI_Theme.xml Applying telemetry.xml Updating xogseeddata for component = infrastructure Created dir: /home/clar/clarity/logs/xog-seeddata/out/infrastructure log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Applying PPM_INVALID_USER.xml ------------------------------------------------------------------- GMS: address=gdcletsaplv01d-11186, cluster=CLRTY, physical address=10.247.XXX.XXX:51769 ------------------------------------------------------------------- Updating xogseeddata for component = union Updating xogseeddata for component = nmc Created dir: /home/clar/clarity/logs/xog-seeddata/out/nmc log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Applying CMN_TELEMETRY_NOTIFICATION_TEMPLATE.xml ------------------------------------------------------------------- GMS: address=gdcletsaplv01d-12155, cluster=CLRTY, physical address=10.247.XXX.XXX:41648 ------------------------------------------------------------------- Updating xogseeddata for component = revmgr Updating xogseeddata for component = projmgr Created dir: /home/clar/clarity/logs/xog-seeddata/out/projmgr log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Applying IDEA_MANAGEMENT_NAVIGATE_ACCESS.xml Updating xogseeddata for component = content Created dir: /home/clar/clarity/logs/xog-seeddata/out/content log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Applying update_lookup_names_de45767.xml Updating xogseeddata for component = cms Updating xogseeddata for component = osf Created dir: /home/clar/clarity/logs/xog-seeddata/out/osf log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Applying LOOKUP_UI_SETTINGS_MD_XOG_SEEDDATA.xml Post-upgrade schema for component = database Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:47:51 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Loading DBDriver file: /home/clar/clarity/upgrade/database/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/database/schema/driver.xml Current database version is database_20190222_0436 DBDriver for database_20190222_0436 Resume installation of DBDriver ... Current database version is database_20181116_0028 Note: Foreign Keys have been disabled Process - post-upgrade: POSTUPGRADE_API_KEY_SETTINGS.xml Process - post-upgrade: POSTUPGRADE_CORS_SETTINGS.xml Process - post-upgrade: POSTUPGRADE_CSV_EXPORT_FEATURE_TOGGLE_SEEDDATA.xml Process - post-upgrade: POSTUPGRADE_CUSTOM_INVESTMENT_TASKS_TOGGLE.xml Process - post-upgrade: POSTUPGRADE_CUST_INV_OBJ_NULLIFY_API_AIAS.xml Process - post-upgrade: POSTUPGRADE_DEL_IMPORTPROJS_TOGGLE.xml Process - post-upgrade: POSTUPGRADE_DEL_RMITEMSGRID_TOGGLE.xml Process - post-upgrade: POSTUPGRADE_DEL_SYNCPROJS_TOGGLE.xml Process - post-upgrade: POSTUPGRADE_FIN_TRANS_SEEDDATA.xml Process - post-upgrade: POSTUPGRADE_GROUP_BY_TOGGLE.xml Process - post-upgrade: POSTUPGRADE_IDEA_F19501_FEATURE_TOGGLE_SEEDDATA.xml Process - post-upgrade: POSTUPGRADE_INVESTMENT_BOARD_FEATURE_TOGGLE_SEEDDATA.xml Process - post-upgrade: POSTUPGRADE_MULTI_TAB_FEATURE_TOGGLE.xml Process - post-upgrade: POSTUPGRADE_POPULATE_ODF_UI_VIEW_SETTINGS_MD_ID.xml Process - post-upgrade: POSTUPGRADE_PPM_NEW_UX_THEME_F19162_FEATURE_TOGGLE_SEEDDATA.xml Process - post-upgrade: POSTUPGRADE_REMOVE_PENDO_DOMAIN_VALUES.xml Process - post-upgrade: POSTUPGRADE_REMOVE_PENDO_FEATURE_TOGGLE.xml Process - post-upgrade: POSTUPGRADE_REMOVE_PENDO_TELEMETRY_OPTIONS.xml Process - post-upgrade: POSTUPGRADE_RIGHTS_CORRECTION.xml Process - post-upgrade: POSTUPGRADE_SEED_STANDARD_API_CLIENTS_VIEW.xml Process - post-upgrade: POSTUPGRADE_SEED_STANDARD_API_TOKEN_ADMIN_VIEW.xml Process - post-upgrade: POSTUPGRADE_SEED_STANDARD_API_TOKEN_USER_VIEW.xml Process - post-upgrade: POSTUPGRADE_TELEMETRY_F19253_FEATURE_TOGGLE_SEEDDATA.xml Process - post-upgrade: POSTUPGRADE_TELEMETRY_SEEDDATA.xml Process - post-upgrade: POSTUPGRADE_TOKEN_FEATURE_DISABLE.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:3S Post-upgrade schema for component = infrastructure Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:47:56 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/schema/driver.xml Current database version is infrastructure_20190222_0436 DBDriver for infrastructure_20190222_0436 Resume installation of DBDriver ... Current database version is infrastructure_20181116_0028 Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Post-upgrade schema for component = union Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:47:59 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Loading DBDriver file: /home/clar/clarity/upgrade/union/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/union/schema/driver.xml Current database version is union_20190222_0436 DBDriver for union_20190222_0436 Resume installation of DBDriver ... Current database version is union_20160401_0111 Note: Foreign Keys have been disabled Process - post-upgrade: POSTUPGRADE_LOGIN_COOKIE_SAMESITE_OPTIONS.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Post-upgrade schema for component = nmc Post-upgrade schema for component = revmgr Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:48:03 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Loading DBDriver file: /home/clar/clarity/upgrade/revmgr/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/revmgr/schema/driver.xml Current database version is revmgr_20190222_0436 DBDriver for revmgr_20190222_0436 Resume installation of DBDriver ... Current database version is revmgr_20180517_2038 Note: Foreign Keys have been disabled Process - post-upgrade: POSTUPGRADE_REMOVE_TOGGLE_SUBMIT_BUDGET.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Post-upgrade schema for component = projmgr Post-upgrade schema for component = content Post-upgrade schema for component = cms Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:48:06 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Loading DBDriver file: /home/clar/clarity/upgrade/cms/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/cms/schema/driver.xml Current database version is cms_20190222_0436 DBDriver for cms_20190222_0436 Resume installation of DBDriver ... Current database version is cms_20160401_0111 Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Post-upgrade schema for component = osf Installing database schema... ========================================== DBTools Log - Mon Apr 06 08:48:09 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Loading DBDriver file: /home/clar/clarity/upgrade/osf/schema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/osf/schema/driver.xml Current database version is osf_20190222_0436 DBDriver for osf_20190222_0436 Resume installation of DBDriver ... Current database version is osf_20170223_0001 Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:0M:1S Adjust stock seeddata IDs... ========================================== DBTools Log - Mon Apr 06 08:48:12 CEST 2020 ========================================== Command: bump ids Total time: 0H:0M:0S Generate sequences... ========================================== DBTools Log - Mon Apr 06 08:48:14 CEST 2020 ========================================== Command: install database schema file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Process: /home/clar/clarity/database/sql/GENERATE_CMN_SEQ_TABLES.xml Total time: 0H:0M:0S Bootstrapping ODF... Heap Size: 4096m log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Capturing metrics in: /home/clar/clarity/logs/bootstrap.xml Loading registered objects for custom attribute bootstrap... Loading registered objects for object mappings bootstrap... Loading registered objects to bootstrap... Loading registered objects for view bootstrap... Loading registered objects for object action bootstrap... Loading registered objects for data warehouse attributes bootstrap... Loading registered objects for building blocks bootstrap... Total bootstrap time: 0H:13M:18.728S Bootstrap time breakdown: Compiling database objects... ========================================== DBTools Log - Mon Apr 06 09:01:36 CEST 2020 ========================================== Command: compile Compiling the database.... Following object(s) are invalid: COP_SUM_WBS_MATRIX_FCT GET_VARIANCE GET_VARIANCE1 GET_VARIANCE_OLD_1 MISSING_ASSIGNMENTS ODF_ORGANIZERTASK_V ODF_ORGANIZERTASK_V2 PRC_BDE_DEBUGG PRC_POPULATE_NOP_TIME_INFO_1 ZNOP_PA_EXPENDITURE_TYPES ZNOP_PA_PROJECTS_ALL ZNOP_PA_TASKS ZNOP_PA_TRANSACTION_CONTROLS ZNOP_PER_ALL_PEOPLE_F Z_PKG_NIKU_TO_AUTOPROME oracle/jpub/runtime/MutableArray oracle/jpub/runtime/MutableStruct oracle/jpub/runtime/Util oracle/sql/ARRAY oracle/sql/ArrayDescriptor oracle/sql/BFILE oracle/sql/BLOB oracle/sql/BfileDBAccess oracle/sql/BlobDBAccess oracle/sql/CHAR oracle/sql/CLOB oracle/sql/ClobDBAccess oracle/sql/DatumWithConnection oracle/sql/JAVA_STRUCT oracle/sql/LobDBAccessImpl oracle/sql/LobPlsqlUtil oracle/sql/OPAQUE oracle/sql/OpaqueDescriptor oracle/sql/OracleJdbc2SQLInput oracle/sql/OracleSQLOutput oracle/sql/RAW oracle/sql/REF oracle/sql/SQLName oracle/sql/SQLUtil oracle/sql/STRUCT oracle/sql/StructDescriptor oracle/sql/TypeDescriptor org/apache/log4j/jmx/Agent Total time: 9H:20M:58S Applying post-bootstrap xog-seeddata for component = database Applying post-bootstrap xog-seeddata for component = infrastructure Applying post-bootstrap xog-seeddata for component = union Applying post-bootstrap xog-seeddata for component = nmc Applying post-bootstrap xog-seeddata for component = revmgr Applying post-bootstrap xog-seeddata for component = projmgr Applying post-bootstrap xog-seeddata for component = content Applying post-bootstrap xog-seeddata for component = cms Applying post-bootstrap xog-seeddata for component = osf Installation properties for System: PPM content ID: clarityContent reports.apply=false package.addin.release=15.6.0 package.addin.version=15.6.0.320 force=false Content Pack clarityContent version 7.5.2.3495 has been deployed Installing content... clarityContent Installing content items that do not already exist or have the force option set to true Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Applying menus/Active_Job_Monitor.xml ------------------------------------------------------------------- GMS: address=gdcletsaplv01d-42291, cluster=CLRTY, physical address=10.247.XXX.XXX:46451 ------------------------------------------------------------------- Content Pack Installation Complete log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Total execution time: 0H:0M:0.565S ========================================== DBTools Log - Mon Apr 06 23:03:21 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:0S System: PPM content installation was successful and is complete. Check the install.log for errors that might not have been handled. Content Installation Complete ========================================== DBTools Log - Mon Apr 06 23:03:24 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:0S _invoke-install-xdm - HeapSize Max = 4096m Checking for xdm Copying 1 file to /home/clar/clarity/.setup/scripts install-xdm - HeapSize Max = 4096m Generating Resource Bundle Property File for activitiesMetaData.xml ...... Generating Resource Bundle Property File for activitiesMetaData.xml ...... Deleting: /home/clar/clarity/xdm/xdmGlossary_en.properties Deleting: /home/clar/clarity/xdm/xdm.properties Deleting: /home/clar/clarity/xdm/xdmActGlossary.txt Generating VXSL File(s) for activitiesMetaData.xml ...... Extraction view...... log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Extracting localizable text from View file(s) XDM is a deprecated component. Extraction of strings will not occur. Extraction nls...... NlsExtractor log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Extracting nls from ODF file(s) XDM is a deprecated component. Extraction of strings will not occur. No source files exist--nothing to append No language file found for ca, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for zh_TW, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_zh.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_ko.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for tr, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for pl, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for hu, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for ru, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for no, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_sv.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_ja.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for fi, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles No language file found for da, using defaults. Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_en.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_fr.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_de.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_es.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_ja.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_nl.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_pt.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_it.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_cs.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Found language file: /home/clar/clarity/xdm/xdmGlossary_sv.properties Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. XDM.validation_successful: Validation succeeded. Generating XQL(s) for activitiesMetaData_4xql.xml ...... Generating View MetaData File(s) for activitiesMetaData.xml ...... Generating VXSL File(s) for activitiesMetaData.xml ...... Generating Binding Files for activitiesMetaData.xml ...... Generating Web MetaData File for activitiesMetaData.xml ...... Generating Persistent MetaData File for activitiesMetaData.xml ...... Generating Master XSL for activitiesMetaData.xml ...... Generating XSL File(s) for activitiesMetaData.xml ...... Generating XDM_TaskActivitiesView XSL File(s) for activitiesMetaData.xml ...... Generating Web MetaData File(s) for activitiesMetaData.xml ...... Generating Web MetaData File(s) for activitiesMetaData.xml ...... Generating Web MetaData File(s) for activitiesMetaData.xml ...... Generating Web MetaData File(s) for activitiesMetaData.xml ...... Copying 4 files to /home/clar/clarity/webroot/WEB-INF/xdm/config Generating Forms OMD for activitiesMetaData.xml ...... Running nls-extraction on OMD of XDM NlsExtractor log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Extracting nls from ODF file(s) XDM is a deprecated component. Extraction of strings will not occur. Copying 5 files to /home/clar/clarity/webroot/WEB-INF/xdm/xsl Generating Stored Proc DML file for activitiesMetaData.xml ...... Generating schema file in XML for activitiesMetaData.xml ...... Applying $ DB Schema by using DTG tools ... ========================================== DBTools Log - Mon Apr 06 23:04:11 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Loading DBDriver file: /home/clar/clarity/webroot/WEB-INF/xdm/sql_generated/driver_ACT.xml Start installation of DBDriver ... Note: Foreign Keys and Triggers have been disabled Process - table: XDM_ACT_RES_RESUME.xml Process - sequence: XDM_ACT_RES_RESUME_S1.xml Process - procedure: XDM_ACT_RES_RESUME_INS_SP.xml Process - procedure: XDM_ACT_RES_RESUME_DEL_SP.xml Process - procedure: XDM_ACT_RES_RESUME_UPD_SP.xml Note: Foreign Keys and Triggers have been enabled Total time: 0H:1M:39S ========================================== DBTools Log - Mon Apr 06 23:05:51 CEST 2020 ========================================== Command: install database schema file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Process: /home/clar/clarity/database/sql/GENERATE_CMN_SEQ_TABLES.xml Total time: 0H:0M:0S Bootstrapping ODF... Heap Size: 4096m log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Capturing metrics in: /home/clar/clarity/logs/bootstrap.xml Loading registered objects for custom attribute bootstrap... Loading registered objects for object mappings bootstrap... Loading registered objects to bootstrap... Loading registered objects for view bootstrap... Loading registered objects for object action bootstrap... Loading registered objects for data warehouse attributes bootstrap... Loading registered objects for building blocks bootstrap... Total bootstrap time: 0H:3M:38.820S Bootstrap time breakdown: Compiling database objects... ========================================== DBTools Log - Mon Apr 06 23:09:38 CEST 2020 ========================================== Command: compile Compiling the database.... Following object(s) are invalid: COP_SUM_WBS_MATRIX_FCT GET_VARIANCE GET_VARIANCE1 GET_VARIANCE_OLD_1 MISSING_ASSIGNMENTS ODF_ORGANIZERTASK_V ODF_ORGANIZERTASK_V2 PRC_BDE_DEBUGG PRC_POPULATE_NOP_TIME_INFO_1 ZNOP_PA_EXPENDITURE_TYPES ZNOP_PA_PROJECTS_ALL ZNOP_PA_TASKS ZNOP_PA_TRANSACTION_CONTROLS ZNOP_PER_ALL_PEOPLE_F Z_PKG_NIKU_TO_AUTOPROME oracle/jpub/runtime/MutableArray oracle/jpub/runtime/MutableStruct oracle/jpub/runtime/Util oracle/sql/ARRAY oracle/sql/ArrayDescriptor oracle/sql/BFILE oracle/sql/BLOB oracle/sql/BfileDBAccess oracle/sql/BlobDBAccess oracle/sql/CHAR oracle/sql/CLOB oracle/sql/ClobDBAccess oracle/sql/DatumWithConnection oracle/sql/JAVA_STRUCT oracle/sql/LobDBAccessImpl oracle/sql/LobPlsqlUtil oracle/sql/OPAQUE oracle/sql/OpaqueDescriptor oracle/sql/OracleJdbc2SQLInput oracle/sql/OracleSQLOutput oracle/sql/RAW oracle/sql/REF oracle/sql/SQLName oracle/sql/SQLUtil oracle/sql/STRUCT oracle/sql/StructDescriptor oracle/sql/TypeDescriptor org/apache/log4j/jmx/Agent Total time: 4H:39M:55S XDM Install... ========================================== DBTools Log - Tue Apr 07 03:49:36 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:0S Installation Complete Executing upgrade process from upgrade directory. upgrade.phase = upgrade install.upgrade.dir = /home/clar/clarity/upgrade maintenance.release = false upgrade:phase = upgrade init_upgrade - HeapSize Max = 4096m Postupgrade HeapSize Max = 4096m ========================================== DBTools Log - Tue Apr 07 03:49:38 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/database.xml ========================================== DBTools Log - Tue Apr 07 03:49:41 CEST 2020 ========================================== Command: install database schema file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Process: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/POSTUPGRADE_SET_PPM_INVALID_USER_ID.xml Total time: 0H:0M:0S Total time: 0H:0M:3S HeapSize Max = 4096m ========================================== DBTools Log - Tue Apr 07 03:49:43 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/osf.xml log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total execution time: 0H:0M:6.494S Total time: 0H:0M:9S HeapSize Max = 4096m ========================================== DBTools Log - Tue Apr 07 03:49:53 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/webdev.xml Total time: 0H:0M:0S HeapSize Max = 4096m ========================================== DBTools Log - Tue Apr 07 03:49:55 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/release-override.15.6.0.xml Executing incremental release-override infrastucture/postupgrade scripts Total time: 0H:0M:0S HeapSize Max = 4096m ========================================== DBTools Log - Tue Apr 07 03:49:57 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/component/postupgrade/database.xml ========================================== DBTools Log - Tue Apr 07 03:49:59 CEST 2020 ========================================== Command: install database schema file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Process: /home/clar/clarity/upgrade/15.6.0/component/postupgrade/POSTUPGRADE_SEED_STANDARD_IDEA_VIEW.xml Total time: 0H:0M:0S Encrypting and storing the telemetry API keys log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Total execution time: 0H:0M:0.703S Initiating the Telemetry job schedule log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total execution time: 0H:0M:1.211S Total time: 0H:0M:7S HeapSize Max = 4096m ========================================== DBTools Log - Tue Apr 07 03:50:07 CEST 2020 ========================================== Executing Ant script: /home/clar/clarity/upgrade/15.6.0/component/postupgrade/release-override.15.6.0.xml Executing incremental release-override component/postupgrade scripts Total time: 0H:0M:0S ========================================== DBTools Log - Tue Apr 07 03:50:09 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:0S ========================================== DBTools Log - Tue Apr 07 03:50:11 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:0S ========================================== DBTools Log - Tue Apr 07 03:50:13 CEST 2020 ========================================== Command: extract row count To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: niku For vendor: oracle Total time: 0H:4M:56S ----------------------------------------------------- 2020-04-07 03:55:10: Finished updating database ----------------------------------------------------- upgrade.phase = upgrade install.upgrade.dir = /home/clar/clarity/upgrade maintenance.release = false Installing schema file: /home/clar/clarity/upgrade/infrastructure/dwhschema/function/IS_DWH_CUSTOMER_DB.xml... ========================================== DBTools Log - Tue Apr 07 03:55:12 CEST 2020 ========================================== Command: install database schema file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: PPM_DWH For vendor: oracle Process: /home/clar/clarity/upgrade/infrastructure/dwhschema/function/IS_DWH_CUSTOMER_DB.xml Total time: 0H:0M:0S INFO: Data Warehouse last Installed version 15.5.1.240 Executing upgrade process from upgrade directory. upgrade.phase = upgrade install.upgrade.dir = /home/clar/clarity/upgrade maintenance.release = false upgrade:phase = upgrade init_upgrade - HeapSize Max = 4096m dwh-core-upgrade:skip.db.upgrade = false dwh-core-upgrade:install.upgrade.dir = /home/clar/clarity/upgrade ----------------------------------------------------- 2020-04-07 03:55:13: Updating Data warehouse database ----------------------------------------------------- upgrade.phase = upgrade install.upgrade.dir = /home/clar/clarity/upgrade maintenance.release = false upgrade:phase = upgrade init_upgrade - HeapSize Max = 4096m Datawarehouse Preupgrade Script Before Upgrade for Component:infrastructure upgrade.phase = upgrade install.upgrade.dir = /home/clar/clarity/upgrade maintenance.release = false upgrade:phase = upgrade init_upgrade - HeapSize Max = 4096m Datawarehouse Preupgrade Script Before Upgrade for Component:datamart Schema pre-upgrade for Datawarehouse schema Pre-upgrade schema for component = infrastructure and database schema=Datawarehouse Installing database schema... ========================================== DBTools Log - Tue Apr 07 03:55:15 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: PPM_DWH For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml Current database version is infrastructure_20181116_0028 DBDriver for infrastructure_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:8M:59S Pre-upgrade schema for component = datamart and database schema=Datawarehouse Installing database schema... ========================================== DBTools Log - Tue Apr 07 04:04:15 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: PPM_DWH For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^pre-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml Current database version is datamart_20181116_0028 DBDriver for datamart_20190222_0436 Start installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:8M:46S Schema core upgrade for Datawarehouse schema Updating schema for component = infrastructure and database schema=Datawarehouse Installing database schema... ========================================== DBTools Log - Tue Apr 07 04:13:03 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: PPM_DWH For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml Current database version is infrastructure_20190222_0436 DBDriver for infrastructure_20190222_0436 Resume installation of DBDriver ... Note: Foreign Keys have been disabled Note: Triggers have been disabled Process - function: IS_DWH_CUSTOMER_DB.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:8M:36S Updating schema for component = datamart and database schema=Datawarehouse Installing database schema... ========================================== DBTools Log - Tue Apr 07 04:21:41 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: PPM_DWH For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml Current database version is datamart_20190222_0436 DBDriver for datamart_20190222_0436 Resume installation of DBDriver ... Note: Foreign Keys have been disabled Re-creating the index Existing index (drop) : DWH_FIN_TRANSACTION_N1( RESOURCE_KEY ) New Index (create): DWH_FIN_TRANSACTION_N1 ( RESOURCE_KEY ) Re-creating the index Existing index (drop) : DWH_FIN_TRANSACTION_N2( INVESTMENT_KEY ) New Index (create): DWH_FIN_TRANSACTION_N2 ( INVESTMENT_KEY ) Re-creating the index Existing index (drop) : DWH_FIN_TRANSACTION_N4( DW_UPDATED_DATE ) New Index (create): DWH_FIN_TRANSACTION_N4 ( DW_UPDATED_DATE ) Re-creating the index Existing index (drop) : DWH_FIN_TRANSACTION_PK( TRANSACTION_KEY ) New Index (create): DWH_FIN_TRANSACTION_PK ( TRANSACTION_KEY ) Re-creating the index Existing index (drop) : DWH_FIN_TRANSACTION_U3( CLARITY_TRANSACTION_KEY ) New Index (create): DWH_FIN_TRANSACTION_U3 ( CLARITY_TRANSACTION_KEY ) Note: Triggers have been disabled Process - table: DWH_CFG_OBJECT_TYPE.xml Process - table: DWH_FIN_TRANSACTION.xml Process - view: DWH_INV_SECURITY.xml Process - view: DWH_INV_SECURITY_V.xml Process - view: DWH_SEC_INV_INST_SECURITY_V.xml Process - view: DWH_SEC_INV_OBS_ENTITIES_MV.xml Process - view: DWH_SEC_INV_OBS_ENTITIES_V.xml Process - view: DWH_SEC_INV_OBS_PARTIAL_MV.xml Process - view: DWH_TMP_FIN_ACT_PER_FACTS_V.xml Process - view: DWH_TRD_SUM_TREND_BY_PER_MV.xml Process - view: DWH_X_PLAN_ACT_I_PER_FACTS_V.xml Process - view: DWH_X_PLAN_ACT_PER_FACTS_V.xml Process - view: DWH_X_PLAN_PER_ACT_FACTS_MV.xml Process - view: DWH_X_RES_AVAIL_PER_FACTS_MV.xml Process - mview: DWH_TRD_SUM_TREND_BY_PER_MV.xml Process - procedure: DWH_FIN_PLAN_PER_FACTS_LOAD.xml Process - procedure: DWH_FIN_PLAN_SUM_FACTS_LOAD.xml Process - procedure: DWH_FIN_TRANSACTION_DIM_LOAD.xml Process - procedure: DWH_INV_ASSIGN_PER_FACTS_LOAD.xml Process - procedure: DWH_INV_PER_FACTS_LOAD.xml Process - procedure: DWH_INV_SUM_FACTS_LOAD.xml Process - procedure: DWH_INV_TEAM_PERIOD_FACTS_LOAD.xml Process - procedure: DWH_RES_PERIOD_FACTS_LOAD.xml Process - procedure: DWH_SEC_ASSIGN_PERM_LOAD.xml Process - procedure: DWH_SEC_RIGHT_LOAD.xml Process - procedure: DWH_TMP_RECORD_KEYS_LOAD.xml Process - procedure: DWH_X_INV_SUM_FACTS_LOAD.xml Process - procedure: DWH_X_PLAN_ACT_PER_FACTS_LOAD.xml Process - procedure: DWH_X_RES_AVAIL_PER_FACTS_LOAD.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:16M:17S Schema post-upgrade for Datawarehouse schema Post-upgrade schema for component = infrastructure and database schema=Datawarehouse Installing database schema... ========================================== DBTools Log - Tue Apr 07 04:38:01 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: PPM_DWH For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml Current database version is infrastructure_20190222_0436 DBDriver for infrastructure_20190222_0436 Resume installation of DBDriver ... Note: Foreign Keys have been disabled Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:17M:5S Post-upgrade schema for component = datamart and database schema=Datawarehouse Installing database schema... ========================================== DBTools Log - Tue Apr 07 04:55:07 CEST 2020 ========================================== Command: install database schema from driver file To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true As user: PPM_DWH For vendor: oracle Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema Option: filtering on type "^post-upgrade$" Option: -updateHistory=false - update history will not be recorded for this session. Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml Current database version is datamart_20190222_0436 DBDriver for datamart_20190222_0436 Resume installation of DBDriver ... Note: Foreign Keys have been disabled Process - post-upgrade: DWH_POSTUPG_MVIEW_INDEXES.xml Note: Foreign Keys and Triggers have been enabled DBDriver successfully installed! Total time: 0H:8M:49S Executing update-dwh-install-history from #4 for Datawarehouse Inside update-dwh-install-history install.type=dwh_release_marker install.id=dwh_release_version ========================================== DBTools Log - Tue Apr 07 05:03:58 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:0S Inside update-dwh-install-history install.type=install install.id=dwhdatabase ========================================== DBTools Log - Tue Apr 07 05:04:00 CEST 2020 ========================================== Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl Total time: 0H:0M:0S -------------------------------------------------------------- 2020-04-07 05:04:01: Finished updating Data warehouse database -------------------------------------------------------------- Uploaded properties.xml Trying to override old definition of task java init: postupgrade: Installation Successful - 07-April-2020 05:04:03 BUILD SUCCESSFUL Total time: 1229 minutes 21 seconds activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Deleting: /home/clar/clarity/xdm/xdmGlossary_en.properties 4/06/20 11:03 PM (ExecTask) Deleting: /home/clar/clarity/xdm/xdm.properties 4/06/20 11:03 PM (ExecTask) Deleting: /home/clar/clarity/xdm/xdmActGlossary.txt 4/06/20 11:03 PM (ExecTask) Generating VXSL File(s) for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Extraction view...... 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) Extracting localizable text from View file(s) 4/06/20 11:03 PM (ExecTask) XDM is a deprecated component. Extraction of strings will not occur. 4/06/20 11:03 PM (ExecTask) Extraction nls...... 4/06/20 11:03 PM (ExecTask) NlsExtractor 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) Extracting nls from ODF file(s) 4/06/20 11:03 PM (ExecTask) XDM is a deprecated component. Extraction of strings will not occur. 4/06/20 11:03 PM (ExecTask) No source files exist--nothing to append 4/06/20 11:03 PM (ExecTask) No language file found for ca, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for zh_TW, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_zh.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_ko.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for tr, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for pl, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for hu, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for ru, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for no, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_sv.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_ja.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for fi, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) No language file found for da, using defaults. 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_en.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_fr.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_de.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_es.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_ja.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_nl.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_pt.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_it.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_cs.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Found language file: /home/clar/clarity/xdm/xdmGlossary_sv.properties 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) Copying 1 file to /home/clar/clarity/webroot/WEB-INF/runtime/resourcebundles 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:03 PM (ExecTask) XDM.validation_successful: Validation succeeded. 4/06/20 11:03 PM (ExecTask) Generating XQL(s) for activitiesMetaData_4xql.xml ...... 4/06/20 11:03 PM (ExecTask) Generating View MetaData File(s) for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating VXSL File(s) for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating Binding Files for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating Web MetaData File for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating Persistent MetaData File for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating Master XSL for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating XSL File(s) for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating XDM_TaskActivitiesView XSL File(s) for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating Web MetaData File(s) for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating Web MetaData File(s) for activitiesMetaData.xml ...... 4/06/20 11:03 PM (ExecTask) Generating Web MetaData File(s) for activitiesMetaData.xml ...... 4/06/20 11:04 PM (ExecTask) Generating Web MetaData File(s) for activitiesMetaData.xml ...... 4/06/20 11:04 PM (ExecTask) Copying 4 files to /home/clar/clarity/webroot/WEB-INF/xdm/config 4/06/20 11:04 PM (ExecTask) Generating Forms OMD for activitiesMetaData.xml ...... 4/06/20 11:04 PM (ExecTask) Running nls-extraction on OMD of XDM 4/06/20 11:04 PM (ExecTask) NlsExtractor 4/06/20 11:04 PM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:04 PM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:04 PM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:04 PM (ExecTask) Extracting nls from ODF file(s) 4/06/20 11:04 PM (ExecTask) XDM is a deprecated component. Extraction of strings will not occur. 4/06/20 11:04 PM (ExecTask) Copying 5 files to /home/clar/clarity/webroot/WEB-INF/xdm/xsl 4/06/20 11:04 PM (ExecTask) Generating Stored Proc DML file for activitiesMetaData.xml ...... 4/06/20 11:04 PM (ExecTask) Generating schema file in XML for activitiesMetaData.xml ...... 4/06/20 11:04 PM (ExecTask) Applying $ DB Schema by using DTG tools ... 4/06/20 11:04 PM (ExecTask) ========================================== 4/06/20 11:04 PM (ExecTask) DBTools Log - Mon Apr 06 23:04:11 CEST 2020 4/06/20 11:04 PM (ExecTask) ========================================== 4/06/20 11:04 PM (ExecTask) 4/06/20 11:04 PM (ExecTask) Command: install database schema from driver file 4/06/20 11:04 PM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/06/20 11:04 PM (ExecTask) As user: niku 4/06/20 11:04 PM (ExecTask) For vendor: oracle 4/06/20 11:04 PM (ExecTask) Loading DBDriver file: /home/clar/clarity/webroot/WEB-INF/xdm/sql_generated/driver_ACT.xml 4/06/20 11:04 PM (ExecTask) Start installation of DBDriver ... 4/06/20 11:04 PM (ExecTask) 4/06/20 11:05 PM (ExecTask) Note: Foreign Keys and Triggers have been disabled 4/06/20 11:05 PM (ExecTask) Process - table: XDM_ACT_RES_RESUME.xml 4/06/20 11:05 PM (ExecTask) Process - sequence: XDM_ACT_RES_RESUME_S1.xml 4/06/20 11:05 PM (ExecTask) Process - procedure: XDM_ACT_RES_RESUME_INS_SP.xml 4/06/20 11:05 PM (ExecTask) Process - procedure: XDM_ACT_RES_RESUME_DEL_SP.xml 4/06/20 11:05 PM (ExecTask) Process - procedure: XDM_ACT_RES_RESUME_UPD_SP.xml 4/06/20 11:05 PM (ExecTask) Note: Foreign Keys and Triggers have been enabled 4/06/20 11:05 PM (ExecTask) 4/06/20 11:05 PM (ExecTask) Total time: 0H:1M:39S 4/06/20 11:05 PM (ExecTask) ========================================== 4/06/20 11:05 PM (ExecTask) DBTools Log - Mon Apr 06 23:05:51 CEST 2020 4/06/20 11:05 PM (ExecTask) ========================================== 4/06/20 11:05 PM (ExecTask) 4/06/20 11:05 PM (ExecTask) Command: install database schema file 4/06/20 11:05 PM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/06/20 11:05 PM (ExecTask) As user: niku 4/06/20 11:05 PM (ExecTask) For vendor: oracle 4/06/20 11:05 PM (ExecTask) 4/06/20 11:05 PM (ExecTask) Process: /home/clar/clarity/database/sql/GENERATE_CMN_SEQ_TABLES.xml 4/06/20 11:05 PM (ExecTask) 4/06/20 11:05 PM (ExecTask) Total time: 0H:0M:0S 4/06/20 11:05 PM (ExecTask) Bootstrapping ODF... 4/06/20 11:05 PM (ExecTask) Heap Size: 4096m 4/06/20 11:05 PM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:05 PM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:05 PM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/06/20 11:05 PM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/06/20 11:06 PM (ExecTask) Capturing metrics in: /home/clar/clarity/logs/bootstrap.xml 4/06/20 11:06 PM (ExecTask) Loading registered objects for custom attribute bootstrap... 4/06/20 11:06 PM (ExecTask) Loading registered objects for object mappings bootstrap... 4/06/20 11:06 PM (ExecTask) Loading registered objects to bootstrap... 4/06/20 11:06 PM (ExecTask) Loading registered objects for view bootstrap... 4/06/20 11:06 PM (ExecTask) Loading registered objects for object action bootstrap... 4/06/20 11:06 PM (ExecTask) Loading registered objects for data warehouse attributes bootstrap... 4/06/20 11:07 PM (ExecTask) Loading registered objects for building blocks bootstrap... 4/06/20 11:09 PM (ExecTask) Total bootstrap time: 0H:3M:38.820S 4/06/20 11:09 PM (ExecTask) Bootstrap time breakdown: 4/06/20 11:09 PM (ExecTask) Compiling database objects... 4/06/20 11:09 PM (ExecTask) ========================================== 4/06/20 11:09 PM (ExecTask) DBTools Log - Mon Apr 06 23:09:38 CEST 2020 4/06/20 11:09 PM (ExecTask) ========================================== 4/06/20 11:09 PM (ExecTask) 4/06/20 11:09 PM (ExecTask) Command: compile 4/06/20 11:09 PM (ExecTask) Compiling the database.... 4/07/20 3:49 AM (ExecTask) Following object(s) are invalid: 4/07/20 3:49 AM (ExecTask) COP_SUM_WBS_MATRIX_FCT 4/07/20 3:49 AM (ExecTask) GET_VARIANCE 4/07/20 3:49 AM (ExecTask) GET_VARIANCE1 4/07/20 3:49 AM (ExecTask) GET_VARIANCE_OLD_1 4/07/20 3:49 AM (ExecTask) MISSING_ASSIGNMENTS 4/07/20 3:49 AM (ExecTask) ODF_ORGANIZERTASK_V 4/07/20 3:49 AM (ExecTask) ODF_ORGANIZERTASK_V2 4/07/20 3:49 AM (ExecTask) PRC_BDE_DEBUGG 4/07/20 3:49 AM (ExecTask) PRC_POPULATE_NOP_TIME_INFO_1 4/07/20 3:49 AM (ExecTask) ZNOP_PA_EXPENDITURE_TYPES 4/07/20 3:49 AM (ExecTask) ZNOP_PA_PROJECTS_ALL 4/07/20 3:49 AM (ExecTask) ZNOP_PA_TASKS 4/07/20 3:49 AM (ExecTask) ZNOP_PA_TRANSACTION_CONTROLS 4/07/20 3:49 AM (ExecTask) ZNOP_PER_ALL_PEOPLE_F 4/07/20 3:49 AM (ExecTask) Z_PKG_NIKU_TO_AUTOPROME 4/07/20 3:49 AM (ExecTask) oracle/jpub/runtime/MutableArray 4/07/20 3:49 AM (ExecTask) oracle/jpub/runtime/MutableStruct 4/07/20 3:49 AM (ExecTask) oracle/jpub/runtime/Util 4/07/20 3:49 AM (ExecTask) oracle/sql/ARRAY 4/07/20 3:49 AM (ExecTask) oracle/sql/ArrayDescriptor 4/07/20 3:49 AM (ExecTask) oracle/sql/BFILE 4/07/20 3:49 AM (ExecTask) oracle/sql/BLOB 4/07/20 3:49 AM (ExecTask) oracle/sql/BfileDBAccess 4/07/20 3:49 AM (ExecTask) oracle/sql/BlobDBAccess 4/07/20 3:49 AM (ExecTask) oracle/sql/CHAR 4/07/20 3:49 AM (ExecTask) oracle/sql/CLOB 4/07/20 3:49 AM (ExecTask) oracle/sql/ClobDBAccess 4/07/20 3:49 AM (ExecTask) oracle/sql/DatumWithConnection 4/07/20 3:49 AM (ExecTask) oracle/sql/JAVA_STRUCT 4/07/20 3:49 AM (ExecTask) oracle/sql/LobDBAccessImpl 4/07/20 3:49 AM (ExecTask) oracle/sql/LobPlsqlUtil 4/07/20 3:49 AM (ExecTask) oracle/sql/OPAQUE 4/07/20 3:49 AM (ExecTask) oracle/sql/OpaqueDescriptor 4/07/20 3:49 AM (ExecTask) oracle/sql/OracleJdbc2SQLInput 4/07/20 3:49 AM (ExecTask) oracle/sql/OracleSQLOutput 4/07/20 3:49 AM (ExecTask) oracle/sql/RAW 4/07/20 3:49 AM (ExecTask) oracle/sql/REF 4/07/20 3:49 AM (ExecTask) oracle/sql/SQLName 4/07/20 3:49 AM (ExecTask) oracle/sql/SQLUtil 4/07/20 3:49 AM (ExecTask) oracle/sql/STRUCT 4/07/20 3:49 AM (ExecTask) oracle/sql/StructDescriptor 4/07/20 3:49 AM (ExecTask) oracle/sql/TypeDescriptor 4/07/20 3:49 AM (ExecTask) org/apache/log4j/jmx/Agent 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Total time: 4H:39M:55S 4/07/20 3:49 AM (ExecTask) XDM Install... 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:36 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:49 AM (ExecTask) Installation Complete 4/07/20 3:49 AM (ExecTask) Executing upgrade process from upgrade directory. 4/07/20 3:49 AM (ExecTask) upgrade.phase = upgrade 4/07/20 3:49 AM (ExecTask) install.upgrade.dir = /home/clar/clarity/upgrade 4/07/20 3:49 AM (ExecTask) maintenance.release = false 4/07/20 3:49 AM (ExecTask) upgrade:phase = upgrade 4/07/20 3:49 AM (ExecTask) init_upgrade - HeapSize Max = 4096m 4/07/20 3:49 AM (ExecTask) Postupgrade 4/07/20 3:49 AM (ExecTask) HeapSize Max = 4096m 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:38 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/database.xml 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:41 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Command: install database schema file 4/07/20 3:49 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 3:49 AM (ExecTask) As user: niku 4/07/20 3:49 AM (ExecTask) For vendor: oracle 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Process: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/POSTUPGRADE_SET_PPM_INVALID_USER_ID.xml 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Total time: 0H:0M:3S 4/07/20 3:49 AM (ExecTask) HeapSize Max = 4096m 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:43 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/osf.xml 4/07/20 3:49 AM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:49 AM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:49 AM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:49 AM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/07/20 3:49 AM (ExecTask) Total execution time: 0H:0M:6.494S 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Total time: 0H:0M:9S 4/07/20 3:49 AM (ExecTask) HeapSize Max = 4096m 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:53 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/webdev.xml 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:49 AM (ExecTask) HeapSize Max = 4096m 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:55 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) Executing Ant script: /home/clar/clarity/upgrade/15.6.0/infrastructure/postupgrade/release-override.15.6.0.xml 4/07/20 3:49 AM (ExecTask) Executing incremental release-override infrastucture/postupgrade scripts 4/07/20 3:49 AM (ExecTask) 4/07/20 3:49 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:49 AM (ExecTask) HeapSize Max = 4096m 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:57 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) Executing Ant script: /home/clar/clarity/upgrade/15.6.0/component/postupgrade/database.xml 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:49 AM (ExecTask) DBTools Log - Tue Apr 07 03:49:59 CEST 2020 4/07/20 3:49 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Command: install database schema file 4/07/20 3:50 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 3:50 AM (ExecTask) As user: niku 4/07/20 3:50 AM (ExecTask) For vendor: oracle 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Process: /home/clar/clarity/upgrade/15.6.0/component/postupgrade/POSTUPGRADE_SEED_STANDARD_IDEA_VIEW.xml 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:50 AM (ExecTask) Encrypting and storing the telemetry API keys 4/07/20 3:50 AM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:50 AM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:50 AM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:50 AM (ExecTask) Total execution time: 0H:0M:0.703S 4/07/20 3:50 AM (ExecTask) Initiating the Telemetry job schedule 4/07/20 3:50 AM (ExecTask) log4j:WARN No such property [maxFileSize] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:50 AM (ExecTask) log4j:WARN No such property [maxBackupIndex] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:50 AM (ExecTask) log4j:WARN No such property [append] in org.apache.log4j.net.SyslogAppender. 4/07/20 3:50 AM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/07/20 3:50 AM (ExecTask) Total execution time: 0H:0M:1.211S 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Total time: 0H:0M:7S 4/07/20 3:50 AM (ExecTask) HeapSize Max = 4096m 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) DBTools Log - Tue Apr 07 03:50:07 CEST 2020 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) Executing Ant script: /home/clar/clarity/upgrade/15.6.0/component/postupgrade/release-override.15.6.0.xml 4/07/20 3:50 AM (ExecTask) Executing incremental release-override component/postupgrade scripts 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) DBTools Log - Tue Apr 07 03:50:09 CEST 2020 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) DBTools Log - Tue Apr 07 03:50:11 CEST 2020 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) DBTools Log - Tue Apr 07 03:50:13 CEST 2020 4/07/20 3:50 AM (ExecTask) ========================================== 4/07/20 3:50 AM (ExecTask) 4/07/20 3:50 AM (ExecTask) Command: extract row count 4/07/20 3:50 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 3:50 AM (ExecTask) As user: niku 4/07/20 3:50 AM (ExecTask) For vendor: oracle 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) Total time: 0H:4M:56S 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) ----------------------------------------------------- 4/07/20 3:55 AM (ExecTask) 2020-04-07 03:55:10: Finished updating database 4/07/20 3:55 AM (ExecTask) ----------------------------------------------------- 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) upgrade.phase = upgrade 4/07/20 3:55 AM (ExecTask) install.upgrade.dir = /home/clar/clarity/upgrade 4/07/20 3:55 AM (ExecTask) maintenance.release = false 4/07/20 3:55 AM (ExecTask) Installing schema file: /home/clar/clarity/upgrade/infrastructure/dwhschema/function/IS_DWH_CUSTOMER_DB.xml... 4/07/20 3:55 AM (ExecTask) ========================================== 4/07/20 3:55 AM (ExecTask) DBTools Log - Tue Apr 07 03:55:12 CEST 2020 4/07/20 3:55 AM (ExecTask) ========================================== 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) Command: install database schema file 4/07/20 3:55 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 3:55 AM (ExecTask) As user: PPM_DWH 4/07/20 3:55 AM (ExecTask) For vendor: oracle 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) Process: /home/clar/clarity/upgrade/infrastructure/dwhschema/function/IS_DWH_CUSTOMER_DB.xml 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 3:55 AM (ExecTask) INFO: Data Warehouse last Installed version 15.5.1.240 4/07/20 3:55 AM (ExecTask) Executing upgrade process from upgrade directory. 4/07/20 3:55 AM (ExecTask) upgrade.phase = upgrade 4/07/20 3:55 AM (ExecTask) install.upgrade.dir = /home/clar/clarity/upgrade 4/07/20 3:55 AM (ExecTask) maintenance.release = false 4/07/20 3:55 AM (ExecTask) upgrade:phase = upgrade 4/07/20 3:55 AM (ExecTask) init_upgrade - HeapSize Max = 4096m 4/07/20 3:55 AM (ExecTask) dwh-core-upgrade:skip.db.upgrade = false 4/07/20 3:55 AM (ExecTask) dwh-core-upgrade:install.upgrade.dir = /home/clar/clarity/upgrade 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) ----------------------------------------------------- 4/07/20 3:55 AM (ExecTask) 2020-04-07 03:55:13: Updating Data warehouse database 4/07/20 3:55 AM (ExecTask) ----------------------------------------------------- 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) upgrade.phase = upgrade 4/07/20 3:55 AM (ExecTask) install.upgrade.dir = /home/clar/clarity/upgrade 4/07/20 3:55 AM (ExecTask) maintenance.release = false 4/07/20 3:55 AM (ExecTask) upgrade:phase = upgrade 4/07/20 3:55 AM (ExecTask) init_upgrade - HeapSize Max = 4096m 4/07/20 3:55 AM (ExecTask) Datawarehouse Preupgrade Script Before Upgrade for Component:infrastructure 4/07/20 3:55 AM (ExecTask) upgrade.phase = upgrade 4/07/20 3:55 AM (ExecTask) install.upgrade.dir = /home/clar/clarity/upgrade 4/07/20 3:55 AM (ExecTask) maintenance.release = false 4/07/20 3:55 AM (ExecTask) upgrade:phase = upgrade 4/07/20 3:55 AM (ExecTask) init_upgrade - HeapSize Max = 4096m 4/07/20 3:55 AM (ExecTask) Datawarehouse Preupgrade Script Before Upgrade for Component:datamart 4/07/20 3:55 AM (ExecTask) Schema pre-upgrade for Datawarehouse schema 4/07/20 3:55 AM (ExecTask) Pre-upgrade schema for component = infrastructure and database schema=Datawarehouse 4/07/20 3:55 AM (ExecTask) Installing database schema... 4/07/20 3:55 AM (ExecTask) ========================================== 4/07/20 3:55 AM (ExecTask) DBTools Log - Tue Apr 07 03:55:15 CEST 2020 4/07/20 3:55 AM (ExecTask) ========================================== 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) Command: install database schema from driver file 4/07/20 3:55 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 3:55 AM (ExecTask) As user: PPM_DWH 4/07/20 3:55 AM (ExecTask) For vendor: oracle 4/07/20 3:55 AM (ExecTask) Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema 4/07/20 3:55 AM (ExecTask) Option: filtering on type "^pre-upgrade$" 4/07/20 3:55 AM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session. 4/07/20 3:55 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml 4/07/20 3:55 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml 4/07/20 3:55 AM (ExecTask) Current database version is infrastructure_20181116_0028 4/07/20 3:55 AM (ExecTask) DBDriver for infrastructure_20190222_0436 4/07/20 3:55 AM (ExecTask) Start installation of DBDriver ... 4/07/20 3:55 AM (ExecTask) 4/07/20 3:55 AM (ExecTask) Note: Foreign Keys have been disabled 4/07/20 4:04 AM (ExecTask) Note: Foreign Keys and Triggers have been enabled 4/07/20 4:04 AM (ExecTask) 4/07/20 4:04 AM (ExecTask) DBDriver successfully installed! 4/07/20 4:04 AM (ExecTask) 4/07/20 4:04 AM (ExecTask) Total time: 0H:8M:59S 4/07/20 4:04 AM (ExecTask) Pre-upgrade schema for component = datamart and database schema=Datawarehouse 4/07/20 4:04 AM (ExecTask) Installing database schema... 4/07/20 4:04 AM (ExecTask) ========================================== 4/07/20 4:04 AM (ExecTask) DBTools Log - Tue Apr 07 04:04:15 CEST 2020 4/07/20 4:04 AM (ExecTask) ========================================== 4/07/20 4:04 AM (ExecTask) 4/07/20 4:04 AM (ExecTask) Command: install database schema from driver file 4/07/20 4:04 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 4:04 AM (ExecTask) As user: PPM_DWH 4/07/20 4:04 AM (ExecTask) For vendor: oracle 4/07/20 4:04 AM (ExecTask) Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema 4/07/20 4:04 AM (ExecTask) Option: filtering on type "^pre-upgrade$" 4/07/20 4:04 AM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session. 4/07/20 4:04 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml 4/07/20 4:04 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml 4/07/20 4:04 AM (ExecTask) Current database version is datamart_20181116_0028 4/07/20 4:04 AM (ExecTask) DBDriver for datamart_20190222_0436 4/07/20 4:04 AM (ExecTask) Start installation of DBDriver ... 4/07/20 4:04 AM (ExecTask) 4/07/20 4:04 AM (ExecTask) Note: Foreign Keys have been disabled 4/07/20 4:13 AM (ExecTask) Note: Foreign Keys and Triggers have been enabled 4/07/20 4:13 AM (ExecTask) 4/07/20 4:13 AM (ExecTask) DBDriver successfully installed! 4/07/20 4:13 AM (ExecTask) 4/07/20 4:13 AM (ExecTask) Total time: 0H:8M:46S 4/07/20 4:13 AM (ExecTask) Schema core upgrade for Datawarehouse schema 4/07/20 4:13 AM (ExecTask) Updating schema for component = infrastructure and database schema=Datawarehouse 4/07/20 4:13 AM (ExecTask) Installing database schema... 4/07/20 4:13 AM (ExecTask) ========================================== 4/07/20 4:13 AM (ExecTask) DBTools Log - Tue Apr 07 04:13:03 CEST 2020 4/07/20 4:13 AM (ExecTask) ========================================== 4/07/20 4:13 AM (ExecTask) 4/07/20 4:13 AM (ExecTask) Command: install database schema from driver file 4/07/20 4:13 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 4:13 AM (ExecTask) As user: PPM_DWH 4/07/20 4:13 AM (ExecTask) For vendor: oracle 4/07/20 4:13 AM (ExecTask) Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema 4/07/20 4:13 AM (ExecTask) Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" 4/07/20 4:13 AM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session. 4/07/20 4:13 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml 4/07/20 4:13 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml 4/07/20 4:13 AM (ExecTask) Current database version is infrastructure_20190222_0436 4/07/20 4:13 AM (ExecTask) DBDriver for infrastructure_20190222_0436 4/07/20 4:13 AM (ExecTask) Resume installation of DBDriver ... 4/07/20 4:13 AM (ExecTask) 4/07/20 4:13 AM (ExecTask) Note: Foreign Keys have been disabled 4/07/20 4:13 AM (ExecTask) Note: Triggers have been disabled 4/07/20 4:13 AM (ExecTask) Process - function: IS_DWH_CUSTOMER_DB.xml 4/07/20 4:21 AM (ExecTask) Note: Foreign Keys and Triggers have been enabled 4/07/20 4:21 AM (ExecTask) 4/07/20 4:21 AM (ExecTask) DBDriver successfully installed! 4/07/20 4:21 AM (ExecTask) 4/07/20 4:21 AM (ExecTask) Total time: 0H:8M:36S 4/07/20 4:21 AM (ExecTask) Updating schema for component = datamart and database schema=Datawarehouse 4/07/20 4:21 AM (ExecTask) Installing database schema... 4/07/20 4:21 AM (ExecTask) ========================================== 4/07/20 4:21 AM (ExecTask) DBTools Log - Tue Apr 07 04:21:41 CEST 2020 4/07/20 4:21 AM (ExecTask) ========================================== 4/07/20 4:21 AM (ExecTask) 4/07/20 4:21 AM (ExecTask) Command: install database schema from driver file 4/07/20 4:21 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 4:21 AM (ExecTask) As user: PPM_DWH 4/07/20 4:21 AM (ExecTask) For vendor: oracle 4/07/20 4:21 AM (ExecTask) Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema 4/07/20 4:21 AM (ExecTask) Option: filtering on type "^((?!(?:pre|post)-upgrade).)*$" 4/07/20 4:21 AM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session. 4/07/20 4:21 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml 4/07/20 4:21 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml 4/07/20 4:21 AM (ExecTask) Current database version is datamart_20190222_0436 4/07/20 4:21 AM (ExecTask) DBDriver for datamart_20190222_0436 4/07/20 4:21 AM (ExecTask) Resume installation of DBDriver ... 4/07/20 4:21 AM (ExecTask) 4/07/20 4:21 AM (ExecTask) Note: Foreign Keys have been disabled 4/07/20 4:21 AM (ExecTask) Re-creating the index 4/07/20 4:21 AM (ExecTask) Existing index (drop) : DWH_FIN_TRANSACTION_N1( RESOURCE_KEY ) 4/07/20 4:21 AM (ExecTask) New Index (create): DWH_FIN_TRANSACTION_N1 ( RESOURCE_KEY ) 4/07/20 4:21 AM (ExecTask) Re-creating the index 4/07/20 4:21 AM (ExecTask) Existing index (drop) : DWH_FIN_TRANSACTION_N2( INVESTMENT_KEY ) 4/07/20 4:21 AM (ExecTask) New Index (create): DWH_FIN_TRANSACTION_N2 ( INVESTMENT_KEY ) 4/07/20 4:21 AM (ExecTask) Re-creating the index 4/07/20 4:21 AM (ExecTask) Existing index (drop) : DWH_FIN_TRANSACTION_N4( DW_UPDATED_DATE ) 4/07/20 4:21 AM (ExecTask) New Index (create): DWH_FIN_TRANSACTION_N4 ( DW_UPDATED_DATE ) 4/07/20 4:21 AM (ExecTask) Re-creating the index 4/07/20 4:21 AM (ExecTask) Existing index (drop) : DWH_FIN_TRANSACTION_PK( TRANSACTION_KEY ) 4/07/20 4:21 AM (ExecTask) New Index (create): DWH_FIN_TRANSACTION_PK ( TRANSACTION_KEY ) 4/07/20 4:21 AM (ExecTask) Re-creating the index 4/07/20 4:21 AM (ExecTask) Existing index (drop) : DWH_FIN_TRANSACTION_U3( CLARITY_TRANSACTION_KEY ) 4/07/20 4:21 AM (ExecTask) New Index (create): DWH_FIN_TRANSACTION_U3 ( CLARITY_TRANSACTION_KEY ) 4/07/20 4:21 AM (ExecTask) Note: Triggers have been disabled 4/07/20 4:21 AM (ExecTask) Process - table: DWH_CFG_OBJECT_TYPE.xml 4/07/20 4:21 AM (ExecTask) Process - table: DWH_FIN_TRANSACTION.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_INV_SECURITY.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_INV_SECURITY_V.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_SEC_INV_INST_SECURITY_V.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_SEC_INV_OBS_ENTITIES_MV.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_SEC_INV_OBS_ENTITIES_V.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_SEC_INV_OBS_PARTIAL_MV.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_TMP_FIN_ACT_PER_FACTS_V.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_TRD_SUM_TREND_BY_PER_MV.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_X_PLAN_ACT_I_PER_FACTS_V.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_X_PLAN_ACT_PER_FACTS_V.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_X_PLAN_PER_ACT_FACTS_MV.xml 4/07/20 4:21 AM (ExecTask) Process - view: DWH_X_RES_AVAIL_PER_FACTS_MV.xml 4/07/20 4:21 AM (ExecTask) Process - mview: DWH_TRD_SUM_TREND_BY_PER_MV.xml 4/07/20 4:21 AM (ExecTask) Process - procedure: DWH_FIN_PLAN_PER_FACTS_LOAD.xml 4/07/20 4:21 AM (ExecTask) Process - procedure: DWH_FIN_PLAN_SUM_FACTS_LOAD.xml 4/07/20 4:21 AM (ExecTask) Process - procedure: DWH_FIN_TRANSACTION_DIM_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_INV_ASSIGN_PER_FACTS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_INV_PER_FACTS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_INV_SUM_FACTS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_INV_TEAM_PERIOD_FACTS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_RES_PERIOD_FACTS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_SEC_ASSIGN_PERM_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_SEC_RIGHT_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_TMP_RECORD_KEYS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_X_INV_SUM_FACTS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_X_PLAN_ACT_PER_FACTS_LOAD.xml 4/07/20 4:22 AM (ExecTask) Process - procedure: DWH_X_RES_AVAIL_PER_FACTS_LOAD.xml 4/07/20 4:37 AM (ExecTask) Note: Foreign Keys and Triggers have been enabled 4/07/20 4:37 AM (ExecTask) 4/07/20 4:37 AM (ExecTask) DBDriver successfully installed! 4/07/20 4:37 AM (ExecTask) 4/07/20 4:37 AM (ExecTask) Total time: 0H:16M:17S 4/07/20 4:37 AM (ExecTask) Schema post-upgrade for Datawarehouse schema 4/07/20 4:37 AM (ExecTask) Post-upgrade schema for component = infrastructure and database schema=Datawarehouse 4/07/20 4:37 AM (ExecTask) Installing database schema... 4/07/20 4:38 AM (ExecTask) ========================================== 4/07/20 4:38 AM (ExecTask) DBTools Log - Tue Apr 07 04:38:01 CEST 2020 4/07/20 4:38 AM (ExecTask) ========================================== 4/07/20 4:38 AM (ExecTask) 4/07/20 4:38 AM (ExecTask) Command: install database schema from driver file 4/07/20 4:38 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 4:38 AM (ExecTask) As user: PPM_DWH 4/07/20 4:38 AM (ExecTask) For vendor: oracle 4/07/20 4:38 AM (ExecTask) Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema 4/07/20 4:38 AM (ExecTask) Option: filtering on type "^post-upgrade$" 4/07/20 4:38 AM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session. 4/07/20 4:38 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml 4/07/20 4:38 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/infrastructure/dwhschema/driver.xml 4/07/20 4:38 AM (ExecTask) Current database version is infrastructure_20190222_0436 4/07/20 4:38 AM (ExecTask) DBDriver for infrastructure_20190222_0436 4/07/20 4:38 AM (ExecTask) Resume installation of DBDriver ... 4/07/20 4:38 AM (ExecTask) 4/07/20 4:38 AM (ExecTask) Note: Foreign Keys have been disabled 4/07/20 4:55 AM (ExecTask) Note: Foreign Keys and Triggers have been enabled 4/07/20 4:55 AM (ExecTask) 4/07/20 4:55 AM (ExecTask) DBDriver successfully installed! 4/07/20 4:55 AM (ExecTask) 4/07/20 4:55 AM (ExecTask) Total time: 0H:17M:5S 4/07/20 4:55 AM (ExecTask) Post-upgrade schema for component = datamart and database schema=Datawarehouse 4/07/20 4:55 AM (ExecTask) Installing database schema... 4/07/20 4:55 AM (ExecTask) ========================================== 4/07/20 4:55 AM (ExecTask) DBTools Log - Tue Apr 07 04:55:07 CEST 2020 4/07/20 4:55 AM (ExecTask) ========================================== 4/07/20 4:55 AM (ExecTask) 4/07/20 4:55 AM (ExecTask) Command: install database schema from driver file 4/07/20 4:55 AM (ExecTask) To URL: jdbc:clarity:oracle://10.247.XXX.XXX:1521;SID=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true 4/07/20 4:55 AM (ExecTask) As user: PPM_DWH 4/07/20 4:55 AM (ExecTask) For vendor: oracle 4/07/20 4:55 AM (ExecTask) Previous schema directory: /home/clar/clarity/upgrade/infrastructure/previousSchema 4/07/20 4:55 AM (ExecTask) Option: filtering on type "^post-upgrade$" 4/07/20 4:55 AM (ExecTask) Option: -updateHistory=false - update history will not be recorded for this session. 4/07/20 4:55 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml 4/07/20 4:55 AM (ExecTask) Loading DBDriver file: /home/clar/clarity/upgrade/datamart/dwhschema/driver.xml 4/07/20 4:55 AM (ExecTask) Current database version is datamart_20190222_0436 4/07/20 4:55 AM (ExecTask) DBDriver for datamart_20190222_0436 4/07/20 4:55 AM (ExecTask) Resume installation of DBDriver ... 4/07/20 4:55 AM (ExecTask) 4/07/20 4:55 AM (ExecTask) Note: Foreign Keys have been disabled 4/07/20 4:55 AM (ExecTask) Process - post-upgrade: DWH_POSTUPG_MVIEW_INDEXES.xml 4/07/20 5:03 AM (ExecTask) Note: Foreign Keys and Triggers have been enabled 4/07/20 5:03 AM (ExecTask) 4/07/20 5:03 AM (ExecTask) DBDriver successfully installed! 4/07/20 5:03 AM (ExecTask) 4/07/20 5:03 AM (ExecTask) Total time: 0H:8M:49S 4/07/20 5:03 AM (ExecTask) Executing update-dwh-install-history from #4 for Datawarehouse 4/07/20 5:03 AM (ExecTask) Inside update-dwh-install-history install.type=dwh_release_marker install.id=dwh_release_version 4/07/20 5:03 AM (ExecTask) ========================================== 4/07/20 5:03 AM (ExecTask) DBTools Log - Tue Apr 07 05:03:58 CEST 2020 4/07/20 5:03 AM (ExecTask) ========================================== 4/07/20 5:03 AM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/07/20 5:03 AM (ExecTask) 4/07/20 5:03 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 5:03 AM (ExecTask) Inside update-dwh-install-history install.type=install install.id=dwhdatabase 4/07/20 5:04 AM (ExecTask) ========================================== 4/07/20 5:04 AM (ExecTask) DBTools Log - Tue Apr 07 05:04:00 CEST 2020 4/07/20 5:04 AM (ExecTask) ========================================== 4/07/20 5:04 AM (ExecTask) Custom Class Alias found for timeadmin.timesheetValidator: com.ca.custom.capgemini.validation.impl.TimesheetValidatorImpl 4/07/20 5:04 AM (ExecTask) 4/07/20 5:04 AM (ExecTask) Total time: 0H:0M:0S 4/07/20 5:04 AM (ExecTask) 4/07/20 5:04 AM (ExecTask) -------------------------------------------------------------- 4/07/20 5:04 AM (ExecTask) 2020-04-07 05:04:01: Finished updating Data warehouse database 4/07/20 5:04 AM (ExecTask) -------------------------------------------------------------- 4/07/20 5:04 AM (ExecTask) 4/07/20 5:04 AM (ExecTask) 4/07/20 5:04 AM (Java) Uploaded properties.xml 4/07/20 5:04 AM (Target) Target "installsteps" finished. 4/07/20 5:04 AM (Project) Trying to override old definition of task java 4/07/20 5:04 AM (Target) Target "init" started. 4/07/20 5:04 AM (Target) Target "init" finished. 4/07/20 5:04 AM (Target) Target "postupgrade" started. 4/07/20 5:04 AM (Target) Target "postupgrade" finished. 4/07/20 5:04 AM (Echo) Installation Successful - 07-April-2020 05:04:03 4/07/20 5:04 AM (Target) Target "_install" finished. 4/07/20 5:04 AM (Target) Target "_upgrade" finished. 4/07/20 5:04 AM (Target) Target "install" finished.