Hello Experts,
I am having a weird issue with integration 2 HFM applications,(same dimensions with few hierarchy changes)
I am able to load data for past few years. How ever for years 2009 to 2016 I can not load and seeing the following errors,(Trying to create new period keys for older years and in same format as previous period keys)
a) aif-WebApp.log
[SRC_METHOD: invoke0] Server DEVHFM is unavailable, connection could not be established.[[
oracle.epm.fm.common.exception.HFMException: EPMHFM-66076: Server DEVHFM is unavailable, connection could not be established.
b) xfm.odl.APPNAME-1.Log
[2019-07-25T12:29:06.777852-04:00] [XFM] [ERROR:1] [EPMHFM-04014] [XFM] [ecid: 00ivHUEgDZ_E^MG6yz7i6G0002380000Bz] [File: ..\Handlers\loadExtract\DataExtractHelper.cpp] [Line: 420] [userId: ] [Msg arguments: ] [appName: APPNAME] [pid: 3868] [tid: 12152] [host: DEVHFM] [nwaddr: 172.16.5.59:0;] [errorCode: 80040258] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.207.5298] A required parameter was not included for one or more dimensions. You need to provide at least one valid member for each dimension. [[Year]]
[2019-07-25T12:29:06.793475-04:00] [XFM] [ERROR:1] [EPMHFM-00000] [XFM] [ecid: 00ivHUEgDZ_E^MG6yz7i6G0002380000Bz] [File: DataExtractHelper.cpp] [Line: 665] [userId: ] [Msg arguments: ] [appName: APPNAME] [pid: 3868] [tid: 12152] [host: DEVHFM] [nwaddr: .59:0;] [errorCode: 80004005] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.207.5298] [[Data extract completed with errors for Application APPNAME using prefix APPNAME. Error code is: -2147220904]]
Any help with how I should troubleshoot this further?
Thanks,
Manoj