Error [EPMHFM-07400]: An error occurred in executing the previously prepared ODBC command
We are using HFM 11.1.2.4.208 and we are experiencing some connectivity problems. We observe this in our logs:
2020-10-09T13:56:35.014618+02:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 2093] [userId: ] [Msg arguments: ] [appName: REDUCED] [pid: 6224] [tid: 8712] [host: NHYPMADRID02] [nwaddr: 172.24.10.62:0;] [errorCode: 800402BD] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.208.5333] An error occurred in executing the previously prepared ODBC command. [[]]
Sometimes this implies consolidations being aborted, sometimes only errors being generated in log files. Once errors begin to be generated, they are spread out over time in the log for several hours or even days.
All servers are virtualized and at first we considered that problems came from VEEAM backups being performed. But sometimes these errors happens even when no backups are scheduled. Furthermore, these errors are generated in files but not in system messages inside HFM consolidation administration.