Return
-
Title
Validating Stat compatibility with environment in the stat oracle agent log -
Description
The following error occur in the stat oracle agent log when trying to start it up:
2015-05-18 18:10:56,393 TRACE [main] (Environment.java:559) - SQL: select EXTRACTVALUE(XMLType(TEXT),'//file_edition_name') from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'run' 2015-05-18 18:10:56,394 INFO [main] (Environment.java:701) - Validating Stat compatibility with environment
-
Cause
Incorrect CONTEXT_NAME -
Resolution
1. Run this SQL against your Ebiz Oracle Instance as apps/password to determine the correct CONTEXT_NAMEselect EXTRACTVALUE(XMLType(TEXT),'//oa_context_name[@oa_var="s_contextname"]') CONTEXT_NAMEfrom FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F'));2. Make sure you got this parameter in the stat.confenter_environment_code.env.CONTEXT_NAME:enter_value_returned_from_query1