Hyperion Essbase (MOSC)

MOSC Banner

Error running EPMA transactions history Purge utility

edited Oct 5, 2015 4:04PM in Hyperion Essbase (MOSC) 2 commentsAnswered ✓

'ORA-00955: name is already used by an existing object' the log is attached below. Any have an idea what this may caused by? Thanks =]

2015-10-01 16:35:00,693 ----------------------------------------------------------------------------

2015-10-01 16:35:00,693 EPMA Transaction History Purge Utility

2015-10-01 16:35:00,693 

2015-10-01 16:35:00,694 Connecting to database...

2015-10-01 16:35:02,709 Connected successfully

2015-10-01 16:35:02,710 Only items dated September 1, 2015 or earlier will be deleted.

2015-10-01 16:35:02,710 

2015-10-01 16:35:02,710 Creating deletion summary...

2015-10-01 16:35:03,414 Exception occurred in the DAL. Error Message: 'ORA-00955: name is already used by an existing object'. SQL command or stored proc: CREATE TABLE tmpVXQDTransIDsToKeep(i_transaction_id NUMBER(38, 0) NOT NULL) NOLOGGING

 

Oracle.DataAccess.Client.OracleException ORA-00955: name is already used by an existing object at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

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