Hi Gurus,
We are currently facing issues with our HFM environment. We have two HFM servers (Windows. load balancing) and one DB server (Linux). We are repeatedly getting an error " An error occurred in executing the previously prepared ODBC command." from one of the HFM servers. Our DBA is seeing huge number of connections to the database and high usage of memory. We increased the memory from 64 to 128GB on the DB server but still we see all them being used. We have 7 HFM applications, all connected to one DB.
Snipped of the log from the server where we are seeing the issue:
[pid: 12072] [tid: 876] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 8004022C] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.201.5177] The POV selected for this function is invalid. [[]]
[2018-01-09T08:33:30.227029-07:00] [XFM] [ERROR:1] [EPMHFM-01057] [XFM] [ecid: 00ikEzfXb2dFw00Fzzw0w00003c80008D5] [File: c:\stm10371_build_view\hfm\source\xfmdatasourceroot\xfmdatasource\../XdsCommon/XdsSliceHelper.h] [Line: 781] [userId: ] [appName: XXXX] [pid: 12072] [tid: 876] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 8004022C] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.201.5177] The POV selected for this function is invalid. [[]]
[2018-01-09T08:33:31.133309-07:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: ECID:X] [File: XfmODBC.cpp] [Line: 2093] [userId: ] [appName: XXXX] [pid: 1528] [tid: 9168] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 800402BD] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.201.5177] An error occurred in executing the previously prepared ODBC command. [[]]
[2018-01-09T08:33:31.133309-07:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: ECID:X] [File: ..\..\SharedSourceCode\AccessorSystemChange.cpp] [Line: 72] [userId: ] [appName: XXXX] [pid: 1528] [tid: 9168] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 800402BD] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.201.5177] An error occurred in executing the previously prepared ODBC command. [[]]
[2018-01-09T08:33:31.133309-07:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: ECID:X] [File: Events.cpp] [Line: 586] [userId: ] [appName: XXXX] [pid: 1528] [tid: 9168] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 800402BD] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.201.5177] An error occurred in executing the previously prepared ODBC command. [[]]
[2018-01-09T08:33:34.149022-07:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: ECID:X] [File: XfmODBC.cpp] [Line: 2093] [userId: ] [appName: XXXX] [pid: 1528] [tid: 9168] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 800402BD] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.201.5177] An error occurred in executing the previously prepared ODBC command. [[]]
[2018-01-09T08:33:34.149022-07:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: ECID:X] [File: ..\..\SharedSourceCode\AccessorSystemChange.cpp] [Line: 72] [userId: ] [appName: XXXX] [pid: 1528] [tid: 9168] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 800402BD] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.201.5177] An error occurred in executing the previously prepared ODBC command. [[]]
[2018-01-09T08:33:34.149022-07:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: ECID:X] [File: Events.cpp] [Line: 586] [userId: ] [appName: XXXX] [pid: 1528] [tid: 9168] [host: pwhprcora001] [nwaddr: 10.230.19.104:0;] [errorCode: 800402BD] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.201.5177] An error occurred in executing the previously prepared ODBC command. [[]]
Thanks