The following error occur when trying to start up the stat ebiz agent:
Exception in thread "main" java.lang.NullPointerException at com.quest.stat.oracle.util.Products.getDirectory(Products.java:158) at com.quest.stat.oracle.Environment.getProgram(Environment.java:2204) at com.quest.stat.oracle.Environment.isValid(Environment.java:894) at com.quest.stat.oracle.EnvironmentWF.isValid(EnvironmentWF.java:92) at com.quest.stat.oracle.EnvironmentUIImpl.isValid(EnvironmentUIImpl.java:644) at com.quest.stat.oracle.OAStatAgent.main(OAStatAgent.java:272)
RESOLUTION:
1. Run this SQL against your Ebiz Oracle Instance as apps/password to determine the correct CONTEXT_NAME
select EXTRACTVALUE(XMLType(TEXT),'//oa_context_name[@oa_var="s_contextname"]') CONTEXT_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'));
2. Validate the stat.conf file
XXXX.env.CONTEXT_NAME:returns from the SQL in item #1 (case sensitive)
