HFM is not working with scan ips
orignal JDBC connection works fine for FOUNDATION shcema.Another piece he has to install in HFP_HFM schema and that uses TNSNAMES.ora and that's the part that is failing.
We are using scan ips in our connect string.Please guide us for proper connect string to use r SCAN ip with Hyperion application.
Error from config tool.
[2013-10-15T11:26:45.367-05:00] [EPMCFG] [NOTIFICATION] [EPMCFG-07130] [oracle.EPMCFG] [tid: 44] [ecid: 0000K6wvWN23v1qawLJb6G1INM_z00000A,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Starting parse routine[2013-10-15T11:26:45.367-05:00] [EPMCFG] [TRACE] [EPMCFG-06062] [oracle.EPMCFG] [tid: 44] [ecid: 0000K6wvWN23v1qawLJb6G1INM_z00000A,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Oracle DB CLSID default value: {3F63C36E-51A3-11D2-BB7D-00C04FA30080}[2013-10-15T11:26:45.367-05:00] [EPMCFG] [TRACE] [EPMCFG-06063] [oracle.EPMCFG] [tid: 44] [ecid: 0000K6wvWN23v1qawLJb6G1INM_z00000A,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Oracle DB file path to OraOLEDB10.dll: