Developer forum

Hi

Do you have any errors and exceptions in the eventlog?

If you try with developer tools do you get an exception?

Please post and we can have a look.

We have previously created a copy of an existing language layer, which was shortly thereafter deleted. Now when attempting to make a new copy the error persist.
Could this potentially cause the error?

This is the log:

2026-03-23 09:47:10.4982: Error happened while executing operation! Area was not copied!. System.Exception: Failed to create the paragraph copy(page: 4923; paragraph id: 20341; ).
 ---> System.Exception: Failed to create copy of the paragraph(20341) item('Swift_EmployeeCentralized' with id '4').
 ---> System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK__ItemType__3214EC072D6BFA4F'. Cannot insert duplicate key in object 'dbo.ItemType_Swift_EmployeeCentralized'. The duplicate key value is (281).
The statement has been terminated.
   at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at Dynamicweb.Content.Items.Queries.Repository.Update(IEnumerable`1 items, ItemContext context, Boolean synchronizePages)
   at Dynamicweb.Content.Items.ItemEntry.Save(ItemContext context)
   at Dynamicweb.Content.AreaService.CopyItem(Entity`1 source, String itemId, String itemType)
   at Dynamicweb.Content.AreaService.CopyParagraphItem(Paragraph paragraph, Paragraph copiedParagraph, Dictionary`2 itemIndex)
ClientConnectionId:2a44e793-6b54-492e-8bc6-41b6f0f68211
Error Number:2627,State:1,Class:14
   --- End of inner exception stack trace ---
   at Dynamicweb.Content.AreaService.CopyParagraphItem(Paragraph paragraph, Paragraph copiedParagraph, Dictionary`2 itemIndex)
   at Dynamicweb.Content.AreaService.CopyParagraphs(CopyAreaInfo copyAreaInfo, Action`1 copyStatusFn, Area sourceArea, List`1 itemsToUpdateLinks, Dictionary`2 itemIndex, Dictionary`2 pageIndex, Dictionary`2 paragraphIndex, IEnumerable`1 paragraphs)
   --- End of inner exception stack trace ---
   at Dynamicweb.Content.AreaService.CopyParagraphs(CopyAreaInfo copyAreaInfo, Action`1 copyStatusFn, Area sourceArea, List`1 itemsToUpdateLinks, Dictionary`2 itemIndex, Dictionary`2 pageIndex, Dictionary`2 paragraphIndex, IEnumerable`1 paragraphs)
   at Dynamicweb.Content.AreaService.CopyArea(CopyAreaInfo copyAreaInfo)
2026-03-23 09:47:10.5051: Request headers: [
  "Accept",
  "Accept-Encoding",
  "Accept-Language",
  "Authorization",
  "Connection",
  "Content-Length",
  "Content-Type",
  "Cookie",
  "Host",
  "Referer",
  "User-Agent",
  "sec-ch-ua-platform",
  "sec-ch-ua",
  "sec-ch-ua-mobile",
  "origin",
  "sec-fetch-site",
  "sec-fetch-mode",
  "sec-fetch-dest",
  "priority"
]
2026-03-23 09:47:10.5053: Request item keys: [
  "DW_Current_ExecutionTable"
]
2026-03-23 09:47:10.5054: Request form: []

Hi, 
I have a similar problem when create a new language layer.

Error messages: 
2026-05-07 10:49:54.4057: Warning: could not update item links for 'Swift-v2_Text' (id '2779') — links may point to source area.. System.Transactions.TransactionException: The operation is not valid for the state of the transaction.
   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.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& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.Open()
   at Dynamicweb.Data.DatabaseConnectionProvider.CreateConnection(Boolean open)
   at Dynamicweb.Data.Database.CreateConnection()
   at Dynamicweb.Content.Items.Queries.Repository.Update(IEnumerable`1 items, ItemContext context, Boolean synchronizePages)
   at Dynamicweb.Content.Items.ItemEntry.Save(ItemContext context)
   at Dynamicweb.Content.AreaService.UpdateItemLinks(ItemLinkInformation information, Dictionary`2 pageindex, Dictionary`2 paragraphIndex, Dictionary`2 itemIndex)

2026-05-07 10:49:54.4104: Error happened while executing operation! Area was not copied!. System.Transactions.TransactionException: The operation is not valid for the state of the transaction.
   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.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& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.Open()
   at Dynamicweb.Data.DatabaseConnectionProvider.CreateConnection(Boolean open)
   at Dynamicweb.Data.Database.CreateConnection()
   at Dynamicweb.Data.Database.ExecuteNonQuery(CommandBuilder commandBuilder, Boolean useTransaction, Int32 commandTimeout)
   at Dynamicweb.Content.Items.ColorSwatchRepository.Save(ColorSwatch colorSwatch)
   at Dynamicweb.Content.Items.ColorSwatchService.Save(ColorSwatch colorSwatch)
   at Dynamicweb.Content.AreaService.CopyArea(CopyAreaInfo copyAreaInfo)
2026-05-07 10:49:54.4138: Request headers: [
  "Accept",
  "Accept-Encoding",
  "Accept-Language",
  "Authorization",
  "Connection",
  "Content-Length",
  "Content-Type",
  "Cookie",
  "Host",
  "Referer",
  "User-Agent",
  "sec-ch-ua-platform",
  "sec-ch-ua",
  "sec-ch-ua-mobile",
  "origin",
  "sec-fetch-site",
  "sec-fetch-mode",
  "sec-fetch-dest",
  "priority"
]
2026-05-07 10:49:54.4141: Request item keys: [
  "Dynamicweb.Environment.Web",
  "__AuthorizationMiddlewareWithEndpointInvoked",
  "Dynamicweb|UserContext",
  "DW_Current_ExecutionTable"
]

2026-05-07 10:49:54.4144: Request form: []

400

{
    "status": "error",
    "message": "Error happened while executing operation! Area was not copied!",
    "exception": "The operation is not valid for the state of the transaction.",
    "model": {
        "sourceAreaId": 3,
        "name": "German",
        "culture": "de-DE",
        "copyPermissions": true,
        "asWebsite": false,
        "permissionLevelCurrentUser": null
    },
    "modelIdentifier": null
}