My Oracle Support Banner

Error: "ORA-00904: "NEXTKEY"."DELETE_SESSION_ID": invalid identifier" and "ORA-00904: "PROJSHAR"."DELETE_SESSION_ID": invalid identifier" in Visualizer Log File (Doc ID 2219582.1)

Last updated on MARCH 14, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.2.0 and later
Information in this document applies to any platform.

Symptoms

 When running Timescale Logic Diagram (TSLD) or Gantt within Visualizer, the following errors are written to the Visualizer.log:

ERROR

TIMESTAMP Information Exception Exception trying to load global data for NextKey: Oracle.ManagedDataAccess.Client.OracleException (0x00000388): ORA-00904: "NEXTKEY"."DELETE_SESSION_ID": invalid identifier
at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Primavera.Venus.Data.DbStore.BaseSqlHydrator.<GetReaderAsync>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Primavera.Venus.Data.DbStore.OracleHydrator.<GetReaderAsync>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Primavera.Venus.Data.DbStore.BaseSqlHydrator.<QueryAsync>d__1a'1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Primavera.Venus.Data.DataStore.<LoadEntityAsync>d__2'1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Primavera.Venus.Data.DataStore.<LoadEntityAsync>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Primavera.Venus.DataRepository.BaseDataserviceContext.<LoadGlobalTables>d__2b.MoveNext()
TIMESTAMP Information Exception Exception trying to load global data for LockedProject: Oracle.ManagedDataAccess.Client.OracleException (0x00000388): ORA-00904: "PROJSHAR"."DELETE_SESSION_ID": invalid identifier
at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

The errors above do not result in functional issues, but can be misleading when attempting to troubleshoot.

STEPS TO REPRODUCE:

The following steps can be utilized for TSLD, but Gantt also generates the issue:

  1. Login to Visualizer
  2. Select +, TSLD
  3. Select one or multiple projects to the selected projects pane, click next.
  4. Create a new layout or select existing, click Draw.
  5. TSLD launches, but the errors are logged to the Visualizer.log in %TEMP%

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.