VERIFIED SOLUTION i

Resolve error in Portrait Explorer when importing metadata to the Portrait Shared Repository fails

Product Feature: Administration

Issue

Importing metadata to the Portrait Shared Repository (PSR) fails, and the following error appears in the Portrait Shared Server (PSS) log file:

Exception Hierarchy
-----------------------------------------------------------------------

An error occurred while updating the entries. See the inner exception for details. - (Method: Update, Class: System.Data.Mapping.Update.Internal.UpdateTranslator, Source: System.Data.Entity)

The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements. - (Method: TdsExecuteRPC, Class: System.Data.SqlClient.TdsParser, Source: System.Data)

Cause

This error is generated by the SQL Server database and suggests a timeout has occurred while importing the metadata.
 

Resolution

UPDATED: March 23, 2017
By default the PSS web.config file, located in C:\Program Files (x86)\PST\Portrait Shared Server\Portrait Shared Services\, contains the following entry with a timeout set to 1 minute:

<!-- PSR internal transaction scope timeout HH:mm:ss. Default is 1 minute -->
<add key="TransactionScopeTimeout" value="00:01:00"/>


Increase this timeout setting as required.  Note that different spec machines may require different settings.