Getting an Error "The operation is not valid for the state of the transaction" When Building a Personal Dashboard in Archer

[KB-Sync1]

Article Number

000039978

Applies To

Product(s): Archer
Version(s): All Versions
Primary Deployment: On Premises/AWS Hosted/AWS SaaS

---

Description

The following error is shown to the user:

0EMVM000006CfC1.png

The Archer logs show the following:

<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
        <EventID>46</EventID>
        <Type>3</Type>
        <SubType Name="Error">0</SubType>
        <Level>2</Level>
        <TimeCreated SystemTime="xxxx-xx-xx:12:02.2218619Z" />
        <Source Name="Archer.NET" />
        <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
        <Execution ProcessName="w3wp" ProcessID="xxxxx" ThreadID="18" />
        <AssemblyVersion>x.x.xxx.xxxx</AssemblyVersion>
        <Channel />
        <Computer>Server Name</Computer>
    </System>
    <ApplicationData>
        <TraceData>
            <DataItem>
                <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <TraceIdentifier>Archer.NET</TraceIdentifier>
                    <UserId>20341</UserId>
                    <Description>The operation is not valid for the state of the transaction.</Description>
                    <AppDomain>/LM/W3SVC/2/ROOT/api-2-132827276004800548</AppDomain>
                    <Exception>
                        <ExceptionType>System.Transactions.TransactionException, System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
                        <Message>The operation is not valid for the state of the transaction.</Message>
                        <Source>System.Transactions</Source>
                        <StackTrace>   at System.Transactions.TransactionState.EnlistPromotableSinglePhase(InternalTransaction tx, IPromotableSinglePhaseNotification promotableSinglePhaseNotification, Transaction atomicTransaction, Guid promoterType)
   at System.Transactions.Transaction.EnlistPromotableSinglePhase(IPromotableSinglePhaseNotification promotableSinglePhaseNotification, Guid promoterType)
   at System.Transactions.Transaction.EnlistPromotableSinglePhase(IPromotableSinglePhaseNotification promotableSinglePhaseNotification)
   at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
   at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx)
   at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
   at System.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
   at Microsoft.Practices.EnterpriseLibrary.Data.TransactionScopeConnections.GetConnection(Database db)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
   at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.&lt;&gt;c__DisplayClass6_0.&lt;ExecuteNonQuery&gt;b__0()
   at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap)
   at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.ExecuteNonQuery(DbCommand command)
   at ArcherTech.Kernel.DataSource.Db.DashboardDataSource.SaveDashboardLayout(Int32 dashboardId, IList`1 layoutItems)
   at ArcherTech.Kernel.Brokers.DashboardBroker.SaveDashboardLayout(Int32 dashboardId, IList`1 layoutItems)
   at ArcherTech.Kernel.Brokers.DashboardBroker.SaveDashboard(Dashboard dashboard, DomainAuthorization domainAuthorization, IList`1 layoutItems, Int32 workspaceId)
   at ArcherTech.Kernel.Managers.DashboardManager.SaveDashboard(SessionContext sessionContext, Dashboard dashboard, DomainAuthorization domainAuthorization, IList`1 layoutItems, Int32 workspaceId)</StackTrace>
                    </Exception>
                </TraceRecord>
            </DataItem>
        </TraceData>
    </ApplicationData>
</E2ETraceEvent>

Cause

This can be caused by the iView name not being unique. Selecting a different iView name can correct this error.

Defect ID

ARCHER-44004