This error occurs when importing transport packages with extensions of views as well as permissions on them:
Additional columns in an existing view (R-table) are created by changing the ViewAddOn. The additional DialogColumns are then created by the DBQueueProcessor. Permissions are assigned to these additional DialogColumns. If these two changes (ViewAddOn and Permissions) are transported in one package, an error occurs during the import because the DialogColumns are correctly not part of the package:
Import 'C:\Transports\Transport_MSSQL_OneIM_ViewAddon.zip' failed.
[810391] Error flushing changes to database.
[810023] Error during execution of statement: insert into DialogColumnGroupRight (CanSee, UID_DialogColumn, UID_DialogGroup, xdateinserted, xuserinserted, xdateupdated, xuserupdated, xobjectkey) values (1, 'CCC-5F17867B3FC3C7FE933E3E59ABC2DA36', 'CCC-EC7AC7AB947DA4956ABBD46787C75C02', GetUTCDate(), N'viadmin', GetUTCDate(), N'viadmin', '<Key><T>DialogColumnGroupRight</T><P>CCC-5F17867B3FC3C7FE933E3E59ABC2DA36</P><P>CCC-EC7AC7AB947DA4956ABBD46787C75C02</P></Key>')
[810143] Database error 50000: detected in (SRV=MYSRV, DB=OneIM) Procedure GEN_T126C625A6DD5B162EAED847F0, Line 43
[810143] Database error 50000: Cannot insert object in DialogColumnGroupRight because the associated object in DialogColumn does not exist. Rule QBM_RFRL27
This is a product defect (33849).
WORKAROUND
Import once with the option "Ignore error". And then again.
Or
The DialogColumn object is added manually to the change label. It does not matter whether the change of the ViewAddon and the permissions to the new column are contained in one transport package or in several. It is only important that the DialogColumn object is moved BEFORE the DialogColumnGroupRight objects.
STATUS
This will be fixed in a future release of the product. If you require this immediately corrected, please contact Support for a hotfix referencing the defect ID 33849.
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center