Error: "Process did not complete successfully. Do you want to view the log file?" When Attempting to Check-in Projects Back Into P6 Professional, From a SQLite Database.

(Doc ID 2419764.1)

Last updated on JULY 10, 2018

Applies to:

Primavera P6 Professional Project Management - Version 17.12.2.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to Check-in Projects that were checked out to a local SQLite database the following error is observed:

"Process did not complete successfully. Do you want to view the log file?

ERROR
-----------------------
Prism.Modularity.ModuleInitializeException: An exception occurred while initializing module 'CommandLineModule'.
  - The exception message was: One or more errors occurred.
  - The Assembly that the module was trying to be loaded from was:Primavera.Mercury.CommandLineModule, Version=17.12.4.27994, Culture=neutral, PublicKeyToken=null
  Check the InnerException property of the exception for more information. If the exception occurred while creating an object in a DI container, you can exception.GetRootException() to help locate the root cause of the problem.
  ---> System.AggregateException: One or more errors occurred. ---> System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.
  at System.Data.SqlClient.SqlTransaction.ZombieCheck()
  at System.Data.SqlClient.SqlTransaction.Rollback()
  at Primavera.Venus.Data.DbStore.BaseSqlHydrator.RollbackTransaction()
  at Primavera.Venus.Data.DataStore.d__18.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
  at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
  at Primavera.Venus.DataRepository.BaseDataserviceContext.d__3c.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
  at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
  at Primavera.Mercury.CommandLineModule.ExecuteImportExport.d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
  at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
  at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
  at Primavera.Mercury.CommandLineModule.ExecuteImportExport.d__0.MoveNext()
  --- End of inner exception stack trace ---
  at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
  at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
  at Primavera.Mercury.CommandLineModule.CommandLineModule.Initialize()
  at Prism.Modularity.ModuleInitializer.Initialize(ModuleInfo moduleInfo)
  --- End of inner exception stack trace ---
Failed to load type for module CommandLineModule.
Error was: An exception occurred while initializing module 'CommandLineModule'.
  - The exception message was: One or more errors occurred.
  - The Assembly that the module was trying to be loaded from was:Primavera.Mercury.CommandLineModule, Version=17.12.4.27994, Culture=neutral, PublicKeyToken=null
  Check the InnerException property of the exception for more information. If the exception occurred while creating an object in a DI container, you can exception.GetRootException() to help locate the root cause of the problem.


STEPS TO DUPLICATE:
-------------------------
The issue can be reproduced at will with the following steps:

  1. Login to P6 Professional.
  2. Open desired Projects.
  3. Check-out Projects and in the 'Select Destination' dialog window select "Check out to P6 Pro Local Database (SQLite)".
  4. Renter in password for SQLite Database to be created.
  5. Check-in Projects and select in the 'Select Source' dialog window select "Check in to P6 Pro Local Database (SQLite)".
  6. Observe error.

Cause

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