HFM Missing Tables after restart
We recently added additional servers to our Dev environment. HFM was up and functioning on both servers.
We tried to run a copy and immediately got "Invalid object name" errors. A couple examples are shown below.
<DStr>Invalid object name '<app>_PARAMETERS'.</DStr>
<Param>SELECT * from <app>_PARAMETERS WHERE UPPER(NAME) = N'LAST_PHASED_SUB_GRP_ASSGN_UPDATE'</Param>
<DStr>Invalid object name '<app>__USERPARAMS'.</DStr>
<Param>SELECT BLOBData FROM <app>__USERPARAMS WHERE Username = N'admin@Native Directory' AND ParameterKey = 'HsvSystemInfo_NumberFormat' order by EntryIDX</Param>
The USERPARAMS Error turned up quite frequently. We allowed the copy to run until it completed with errors.