Tuesday, June 8, 2010

Autoconfig errors with icxwebprf.sh INSTE8_PRF 1

Running a post clone process on a test server results in a failure to successfully run all components and the log shows the below error


[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/UAT/apps/prodcomn/admin/install/UAT_gva2ebs
icxwebprf.sh INSTE8_PRF 1

AutoConfig is exiting with status 1

select constraint_name from user_cons_columns where table_name = 'FND_OAM_CONTEXT_FILES' and column_name = 'CTX_TYPE';


/u01/UAT/apps/prodcomn/admin/log/UAT_gva2ebs

applprod@gva2ebs:/u01/UAT/apps/prodcomn/admin/log/UAT_gva2ebs $ more icxwebprf.txt
Enter value for 4: http
Enter value for 5: 8002
Updated profile option value - 1 row(s) updated
Application Id : 178
Profile Name : POR_CACERT_FILE_NAME
Level Id : 10001
New Value : /u01/UAT/apps/prodora/iAS/Apache/Apache/conf/ssl.crt/ca-bundle.crt
Old Value : /u01/PROD/apps/prodora/iAS/Apache/Apache/conf/ssl.crt/ca-bundle.crt
declare
*
ERROR at line 1:
ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating,
trigger/function may not see it
ORA-06512: at "APPS.FND_CORE_LOG", line 25
ORA-06512: at "APPS.FND_CORE_LOG", line 432
ORA-06512: at "APPS.FND_PROFILE", line 110
ORA-06512: at "APPS.FND_GLOBAL", line 539
ORA-06512: at "APPS.FND_PROFILE_OPTION_VALUES_AI", line 1
ORA-04088: error during execution of trigger
'APPS.FND_PROFILE_OPTION_VALUES_AI'
ORA-06512: at line 61
ORA-06512: at line 120


Solution

Disable the following 3 triggers and run autoconfig all should be okay

ALTER TRIGGER FND_PROFILE_OPTION_VALUES_AD DISABLE;
ALTER TRIGGER FND_PROFILE_OPTION_VALUES_AI DISABLE;
ALTER TRIGGER FND_PROFILE_OPTION_VALUES_AU DISABLE;

No comments:

Post a Comment