PFT 8.0.2 Language Pack Installation Fails With Many Errors (Doc ID 2452871.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

On PFT 8.0.6, when installing the OFS PFT 8.0.2 language pack on top of a OFS PFT 8.0.6 install, there are several errors reported:

ERROR

Executing file @Migration/CreateView_Cube_NODE_FORMULAE.sql
Executing migration scripts on atomic schema's
Executing migration Scripts on ofsaaepm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('EPMINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAEPM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing migration Scripts on ofsaaalm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('ALMINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAALM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing migration Scripts on ofsaafccm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('FCCMINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAFCCM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing migration Scripts on ofsaaepm806
Calling atomic.sql
Error while executing - call generateGUIDRevBIHier('OFSPFTINFO')
ORA-06550: line 1, column 7:
PLS-00905: object OFSAAEPM806.GENERATEGUIDREVBIHIER is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
...
Error while executing - -- technique master duplicate MERGE INTO MF_TECHNIQUE_MASTER MTUSING (SELECT MT.V_TECHNIQUE_ID,MT.V_NAME,MT.V_DESCRIPTION,MT.V_IS_SAMPLING_TECH,MT.V_SCRIPT,MT.V_IS_AUTHORIZED,MT.V_INFODOM,LOCREP.VALUE V_SOURCE_LANG_CD,MT.V_CREATED_USER,MT.D_CREATION_DATE,MT.V_MODIFIED_USER,MT.D_MODIFICATION_DATE,MT.V_AUTHORIZED_BY,MT.D_AUTHORIZATION_DATE,MT.V_ACTION_TYPE,MT.V_COMMENTS,MT.V_ORE_OPTIONFROM LOCALEREPOSITORY LOCREPLEFT OUTER JOIN ( MF_TECHNIQUE_MASTER MTINNER JOIN MF_TECHNIQUE T ON MT.V_TECHNIQUE_ID = T.V_UNIQUE_IDAND MT.v_Source_Lang_Cd = T.v_Source_Lang_CdAND T.N_LEVEL = 2AND T.V_TYPE = 'P'AND MT.V_INFODOM IS NULL ) ON 1=1WHERE locrep.localecontext = 'INSTALL'AND locrep.parametername = 'POSTFIXSTRING') SSON (MT.V_TECHNIQUE_ID = SS.V_TECHNIQUE_ID AND UPPER(MT.V_SOURCE_LANG_CD) = UPPER(SS.V_SOURCE_LANG_CD) AND MT.V_INFODOM IS NULL)WHEN NOT MATCHED THENINSERT(MT.V_TECHNIQUE_ID,MT.V_NAME,MT.V_DESCRIPTION,MT.V_IS_SAMPLING_TECH,MT.V_SCRIPT,MT.V_IS_AUTHORIZED,MT.V_INFODOM,MT.V_SOURCE_LANG_CD,MT.V_CREATED_USER,MT.D_CREATION_DATE,MT.V_AUTHORIZED_BY,MT.D_AUTHORIZATION_DATE,MT.V_ACTION_TYPE,MT.V_COMMENTS,MT.V_ORE_OPTION)values(SS.V_TECHNIQUE_ID,SS.V_NAME,SS.V_DESCRIPTION,SS.V_IS_SAMPLING_TECH,SS.V_SCRIPT,SS.V_IS_AUTHORIZED,'',UPPER(SS.V_SOURCE_LANG_CD),'SYSADMN',SYSDATE,COALESCE(SS.V_AUTHORIZED_BY,NULL,''),SS.D_AUTHORIZATION_DATE,SS.V_ACTION_TYPE,SS.V_COMMENTS,SS.V_ORE_OPTION)
ORA-01400: cannot insert NULL into ("OFSAACONF806"."MF_TECHNIQUE_MASTER"."V_TECHNIQUE_ID")
...
********************************************************
 Utility execution started
********************************************************
[AESCryptor] The FIC_HOME path (got from GlobalParameters) is null
[AESCryptor] The FIC_HOME path (got from Environment Variable) is /ofsaa/fccm/fccm806
[AESCryptor] Security File Directory path is : /ofsaa/fccm/fccm806/conf/
[AESCryptor] File exists at /ofsaa/fccm/fccm806/conf/AESCryptKey.ext
java.sql.SQLRecoverableException: IO Error: Connection reset
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:752)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
  at java.sql.DriverManager.getConnection(DriverManager.java:664)
  at java.sql.DriverManager.getConnection(DriverManager.java:208)
  at DBUtil.connect(DBUtil.java:77)
  at LMigration.main(LMigration.java:62)

Additional script errors are also found in the logs:

[Mon 27/8/2018 01:59:50] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_aai_source_framework_tl_pt_BR.sql ###########
[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - Error while executing - MERGE INTO AAI_SOURCE_FRAMEWORK_TL T USING ( SELECT 'pt_BR' V_LOCALE_CODE,'MF' V_SOURCE_FRAMEWORK_CODE,'Infraestrutura Avançada do Analytics' V_SOURCE_FRAMEWORK_NAME,'Infraestrutura Avançada do Analytics' V_SOURCE_FRAMEWORK_DESC FROM DUAL ) S ON ( T.V_LOCALE_CODE = S.V_LOCALE_CODE AND T.V_SOURCE_FRAMEWORK_CODE = S.V_SOURCE_FRAMEWORK_CODE ) WHEN MATCHED THEN UPDATE SET T.V_SOURCE_FRAMEWORK_NAME = S.V_SOURCE_FRAMEWORK_NAME, T.V_SOURCE_FRAMEWORK_DESC = S.V_SOURCE_FRAMEWORK_DESC WHEN NOT MATCHED THEN INSERT (V_LOCALE_CODE,V_SOURCE_FRAMEWORK_CODE,V_SOURCE_FRAMEWORK_NAME,V_SOURCE_FRAMEWORK_DESC ) VALUES ( S.V_LOCALE_CODE,S.V_SOURCE_FRAMEWORK_CODE,S.V_SOURCE_FRAMEWORK_NAME,S.V_SOURCE_FRAMEWORK_DESC)
[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.AAI_SOURCE_FRAMEWORK_TL_FK_1) violated - parent key not found
...
[Mon 27/8/2018 01:59:50] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_aai_menu_tl_pt_BR.sql ###########

[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - Error while executing - MERGE INTO AAI_MENU_TL T USING ( SELECT 'pt_BR' V_LOCALE_CODE,'OFS_SANDBOX_MODELING' V_MENU_ID,'Modelagem' V_MENU_NAME,'Manter definições de modelagem analítica, exibir saídas do modelo etc.' V_MENU_DESC FROM DUAL ) S ON ( T.V_LOCALE_CODE = S.V_LOCALE_CODE AND T.V_MENU_ID = S.V_MENU_ID ) WHEN MATCHED THEN UPDATE SET T.V_MENU_NAME = S.V_MENU_NAME, T.V_MENU_DESC = S.V_MENU_DESC WHEN NOT MATCHED THEN INSERT (V_LOCALE_CODE,V_MENU_ID,V_MENU_NAME,V_MENU_DESC ) VALUES ( S.V_LOCALE_CODE,S.V_MENU_ID,S.V_MENU_NAME,S.V_MENU_DESC)
[Mon 27/8/2018 01:59:50] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.AAI_MENU_TL_FK) violated - parent key not found

...
[Mon 27/8/2018 01:59:51] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_rev_object_types_mls_pt_BR.sql ###########
[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - Error while executing - MERGE INTO REV_OBJECT_TYPES_MLS T USING ( SELECT 'pt_BR' MLS_CD,'1303' OBJECT_TYPE_ID,'Variável' OBJECT_TYPE_NAME FROM DUAL ) S ON ( T.MLS_CD = S.MLS_CD AND T.OBJECT_TYPE_ID = S.OBJECT_TYPE_ID ) WHEN MATCHED THEN UPDATE SET T.OBJECT_TYPE_NAME = S.OBJECT_TYPE_NAME WHEN NOT MATCHED THEN INSERT (MLS_CD,OBJECT_TYPE_ID,OBJECT_TYPE_NAME ) VALUES ( S.MLS_CD,S.OBJECT_TYPE_ID,S.OBJECT_TYPE_NAME)
[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.FK_REV_OBJECT_TYPES_MLS) violated - parent key not found

[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - Error while executing - MERGE INTO REV_OBJECT_TYPES_MLS T USING ( SELECT 'pt_BR' MLS_CD,'1304' OBJECT_TYPE_ID,'Técnica' OBJECT_TYPE_NAME FROM DUAL ) S ON ( T.MLS_CD = S.MLS_CD AND T.OBJECT_TYPE_ID = S.OBJECT_TYPE_ID ) WHEN MATCHED THEN UPDATE SET T.OBJECT_TYPE_NAME = S.OBJECT_TYPE_NAME WHEN NOT MATCHED THEN INSERT (MLS_CD,OBJECT_TYPE_ID,OBJECT_TYPE_NAME ) VALUES ( S.MLS_CD,S.OBJECT_TYPE_ID,S.OBJECT_TYPE_NAME)
[Mon 27/8/2018 01:59:51] [LANGPACK] [ERROR] - ORA-02291: integrity constraint (OFSAACONF806.FK_REV_OBJECT_TYPES_MLS) violated - parent key not found
...
[Mon 27/8/2018 02:03:23] [LANGPACK] [DEBUG] - ########### Executing scripts from insert_mdb_i18n_es_ES.sql ###########
[Mon 27/8/2018 02:03:59] [LANGPACK] [DEBUG] - /vol01/oracle/ofsaa/fccm/fccm806/commonscripts/config/insert_mdb_i18n_es_ES.sql (No such file or directory)

...

[Mon 27/8/2018 04:03:19] [OFS_PFT] [ INFO] - Executing file:/vol01/oracle/ofsaa/fccm/fccm806/scripts/pt_BR/atomic/insert/pft_DIM_CONSOLIDATION_MLS.sql
[Mon 27/8/2018 04:03:19] [OFS_PFT] [ERROR] - Query:'MERGE INTO DIM_CONSOLIDATION_MLS T
USING (
SELECT 'Real' V_CONSOLIDATION,'Real' V_DESCRIPTION,'9100' N_CONSOLIDATION_CD,'pt-BR' V_MLS_CD,to_date('16-06-2015','dd-mm-yyyy') FIC_MIS_DATE FROM DUAL
) S
ON (T.N_CONSOLIDATION_CD = S.N_CONSOLIDATION_CD)
WHEN MATCHED THEN
UPDATE
SET T.V_CONSOLIDATION = S.V_CONSOLIDATION,
  T.V_DESCRIPTION = S.V_DESCRIPTION,
  T.V_MLS_CD = S.V_MLS_CD,
  T.FIC_MIS_DATE = S.FIC_MIS_DATE
WHEN NOT MATCHED THEN
INSERT
 (V_CONSOLIDATION,V_DESCRIPTION,N_CONSOLIDATION_CD,V_MLS_CD,FIC_MIS_DATE)
VALUES
 (S.V_CONSOLIDATION,S.V_DESCRIPTION,S.N_CONSOLIDATION_CD,S.V_MLS_CD,S.FIC_MIS_DATE )'
 Error:ORA-00904: "FIC_MIS_DATE": invalid identifier

The installation appears to be successful however and there are no issues found in the UI.

The issue can be reproduced at will with the following steps:
1. Apply OFS PFT 8.0.2 language pack
2. Check logs

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.