EPM Services Are Not Working After Rehosting Relational Database
(Doc ID 2991643.1)
Last updated on DECEMBER 18, 2023
Applies to:
Hyperion BI+ - Version 11.2.8.0.000 and laterInformation in this document applies to any platform.
Symptoms
After moving repository from MSSQL 2012 server to MSSQL 2019 Server to new server/DB, EPM Admin Server and individual EPM WebApp services failing to start.
AdminServer.log shows error similar to:
[SQLServer]Invalid object name 'JPS_DN'.
Error Code: 208
Call: SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))
bind => [5 parameters bound]
Query: ReadAllQuery(referenceClass=JpsStore sql="SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))")
FetchGroup(){jpsParent, jpsDnEntryid, attrval, attrname, jpsAttrsId}
Error Code: 208
Call: SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))
bind => [5 parameters bound]
Query: ReadAllQuery(referenceClass=JpsStore sql="SELECT t1.JPS_ATTRS_ID, t1.ATTRNAME, t1.ATTRVAL, t1.JPS_DN_ENTRYID FROM JPS_DN t0, JPS_ATTRS t1 WHERE ((((t1.JPS_DN_ENTRYID = t0.ENTRYID) AND (t0.RDN = ?)) AND (t0.PARENTDN = ?)) AND (t1.ATTRNAME IN (?, ?, ?)))")
FetchGroup(){jpsParent, jpsDnEntryid, attrval, attrname, jpsAttrsId}
Queries succeed if the dbname.schema.tablename format is used when executing the query
EX: select top 3 * from [dbname].[schema].JPS_DN;
Changes
Database tables migrated from MSSQL 2012 server to MSSQL 2019
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |