Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Update ATG Lite and FSM failed for OBIA11.1.1.10.2

Question
1
Views
0
Comments

Hi All,

Please let me know if you have faced the below kind of error while updating ATG Lite and FSM for OBIA11.1.1.10.2

I am setting up OBIA 11.1.1.10.2 on linux 7.2 environment, I have installed all the software's successfully and also applied Patches. As per the oracle doc I have to update ATG Lite and FSM data. But I when I run the tool, I faced an error for ATG Lite: "

2016-09-21 02:13:21.090 rcu:Extracted SQL Statement: [INSERT INTO FND_LANGUAGES_B (LANGUAGE_ID,NLS_LANGUAGE,NLS_TERRITORY,ISO_LANGUAGE,ISO_TERRITORY,NLS_CODESET,INSTALLED_FLAG,LANGUAGE_CODE,LANGUAGE_TAG,ISO_LANGUAGE_3,LANG_SQLSERVER,LANG_DB2,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN) SELECT 118,'ESTONIAN','ESTONIA','et','EE','NEE8ISO8859P4','I','ET','et','est',null,null,to_timestamp(SYSDATE,'DD-MON-RR HH.MI.SS.FF AM'),'SEED_DATA_FROM_APPLICATION',to_timestamp(SYSDATE,'DD-MON-RR HH.MI.SS.FF AM'),'SEED_DATA_FROM_APPLICATION','-1'FROM DUAL WHERE NOT EXISTS ( SELECT 1 FROM FND_LANGUAGES_TL WHERE LANGUAGE_CODE = 'ET')]

2016-09-21 02:13:21.090 rcu:Statement Type: 'DML Statement'

JDBC SQLException - ErrorCode: 1843SQLState:22008 Message: ORA-01843: not a valid month"

FSM Error:

[FSM] [ERROR] [UPG-FUNCTIONAL_SETUP_MANAGER-05501] [upgrade.FSM.FSM] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0] Oracle Fusion Functional Setup Manager upgrade is invalid.

[2016-09-21T02:17:32.376-05:00] [FSM] [ERROR] [] [upgrade.FSM.FSM] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0] Cause: Specified Oracle Fusion Functional Setup Manager schema was updated but is invalid.

[2016-09-21T02:17:32.376-05:00] [FSM] [ERROR] [] [upgrade.FSM.FSM] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0] Action: Restore the Oracle Fusion Functional Setup Manager schema from a backup and retry. Check the error messages in the log file for Oracle Fusion Functional Setup Manager component. Correct the problem before running the Assistant again.

[2016-09-21T02:17:32.379-05:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0] Finished upgrading FSM.FSM with status: FAILURE.

[2016-09-21T02:17:32.380-05:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0] Finished upgrading components.

[2016-09-21T02:17:32.380-05:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0]   0 components upgraded with success.

[2016-09-21T02:17:32.380-05:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0]   1 components upgraded with failure.

[2016-09-21T02:17:32.380-05:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0]   0 components already upgraded.

[2016-09-21T02:17:32.380-05:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 26] [ecid: 0000LTBacw3EkJD5zB_AiW1NsZDx000004,0]   0 components skipped.

=======================