EPMA Services Will Not start 'ORA-01502: index 'EPM_EPMA.PK_TRANHIST'
(Doc ID 1641633.1)
Last updated on MAY 23, 2018
Applies to:Hyperion Planning - Version 188.8.131.52.500 and later
Information in this document applies to any platform.
On : 184.108.40.206.500 version, BPM Architect
EPMA Services Will not Restart After Planning Deployment Crash
A Planning application deployment failed. EPMA crashed and services will not restart.
-- Log File --
[EPMA DimensionServer Startup] ERROR Exception occurred in the DAL. Error Message: 'ORA-01502: index 'EPM_EPMA.PK_TRANHIST' or partition of such index is in unusable state'. SQL command or stored proc:
INSERT INTO DS_TRANSACTION_HISTORY (
Windows Event viewer logs
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!