Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

HFM Missing Tables after restart

edited Apr 28, 2015 8:48AM in Hyperion Financial Management (HFM) (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center