EPMA Services Will Not start 'ORA-01502: index 'EPM_EPMA.PK_TRANHIST'
Last updated on APRIL 01, 2014
Applies to:Hyperion Planning - Version 184.108.40.206.500 and later
Information in this document applies to any platform.
On : 220.127.116.11.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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms