Error transporting changes: "[810164] Object referenced from table DialogGroup not found" (185709)

The complete error is:

[System.Exception] Import 'C:\D1IM\Transports\Transport_MSSQL_TRANSPORTNAME.zip' failed.

[810164] Object referenced from table DialogGroup not found (Key: <Key><Table Name="DialogGroup" Display="CCCEditPermissions" Key="CCC-0DECFDD3D8D16340A20474165270B726"><Prop Name="UID_DialogGroup"><Value>CCC-0DECFDD3D8D16340A20474165270B726</Value></Prop></Table></Key>).

   at VI.Transport.Transport.SaveToDatabase(TransportParts tParts)

   at VI.Transport.TagTransport._ImportTags(TransportTaskArguments args)

   at VI.Transport.TagTransport._ImportTag(String strTagPath, TransportParts tParts)

   at VI.Transport.ObjectCollection.Save(ISession session)

   at VI.Base.SyncActions.Do[T](Func`1 function)

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   ---- Start of Inner Exception ----

   at VI.DB.Entities.Transport.TransportFormatConversion.<GetEntityGraphAsync>d__61.MoveNext()

   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

--- End of stack trace from previous location where exception was thrown ---

   at VI.Base.TaskExtensions.<SelectAsync>d__4`2.MoveNext()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

--- End of stack trace from previous location where exception was thrown ---

   at VI.DB.Entities.Transport.TransportFormatConversion.<>c__DisplayClass5c.<<GetEntityGraphAsync>b__47>d__5e.MoveNext()

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

--- End of stack trace from previous location where exception was thrown ---

   at VI.DB.Entities.Transport.TransportFormatConversion.<_GetEntityAsync>d__82.MoveNext()

WORKAROUND

None

STATUS

A hotfix can be provided by Support.

Required steps:

You will need to confirm a few things before proceeding.  Please execute the following:

select GroupName, UID_DialogGroup as 'current UID_DialogGroup' from DialogGroup

where UID_DialogGroup like 'CCC%'

If there are more than the two default groups (CCCViewPermissions and CCCEditPermissions) you have to create a custom script with the content of the 1st file provided in the hotfix.  After that execute it in the script tester in Object Browser to determine the new UIDs for all existing custom groups.

If there are only the 2 groups you can use the 2nd file (Database_UID_Replace_Script.ms.sql.txt) which contains a SQL script.  In the header of the script you have to define the old and the new UIDs.

- The old UIDs come from the mentioned statement.

- The new UIDs for the default groups are the following:

CCCViewPermissions: 'CCC-925C30BDB9A63C89EF4F28512BC91B49'

CCCEditPermissions: 'CCC-EC7AC7AB947DA4956ABBD46787C75C02'

After the replacement you have to export the Transport package again.  This will be importable in the other database.