Transporter crashed when selecting "By Change Label"

Question

Since recently, we are cannot create transport packages any more (the way we like to): 
 Start Transporter -> Create Package -> Select "By Change Label" -> Transporter exits without comment. 
 
 It is reproducable within stage by several users. 
 All other options, eg. "Favorite Objects" are working 
 
 Windows Event Log says 
 Faulting application name: Transporter.exe, version: 9.1.328.23, time stamp: 0x8e1611c2 Faulting module name: clr.dll, version: 4.8.4645.0, time stamp: 0x648f6f63 Exception code: 0xc00000fd Fault offset: 0x00000000000b1c50 Faulting process id: 0x1fa0 Faulting application start time: 0x01da7f72b65d85dd Faulting application path: C:\Program Files\One Identity\One Identity Manager\Transporter.exe Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll Report Id: 45c0d362-76e9-49bc-9eca-8ee6511da01c Faulting package full name: Faulting package-relative application ID: 
 
 Exception could be a STATUS_STACK_OVERFLOW (according to Microsoft) 
 The clr.dll is identical in version (4.8.4645.0) and size to other stages where the transporter does not have this issue 
 The transporter.exe is identical in version (9.1 v91-201110 ) and size to other stages where the transporter does not have this issue 
 Windows scan sfc.exe did not identify any issues 
 Last package was created about two weeks ago. No (known) updates after that. 
 
 SQL Server Profiler says 
 SQL:BatchStarting select IsClosed, TagType, UID_DialogTagParent, UID_DialogTag, Ident_DialogTag, xmarkedfordeletion from DialogTag where (TagType = N'CHANGE') order by Ident_DialogTag Transporter - {Host}\{User} {User} {Host}\{User}r 4556 115 2024-03-26 13:21:33.560 SQL:BatchCompleted select IsClosed, TagType, UID_DialogTagParent, UID_DialogTag, Ident_DialogTag, xmarkedfordeletion from DialogTag where (TagType = N'CHANGE') order by Ident_DialogTag Transporter - {Host}\{User} {User} {Host}\{User} 0 9 0 0 4556 115 2024-03-26 13:21:33.560 2024-03-26 13:21:33.560 Audit Logout Transporter - {Host}\{User} {User} {Host}\{User}r 48 882 0 27283 4556 115 2024-03-26 13:21:16.303 2024-03-26 13:21:43.587 
 My first idea is a data issue with the change labels -maybe some incorrect characters or a loop in item references. 
 On first glance, I cannot detect anything, but maybe one of you guys has an idea.

Andreas Finsterbusch · Accepted Answer

You have a data loop. Check with: with cte as (
 select e.UID_DialogTag, e.UID_DialogTagParent, 
 convert(varchar(max),concat(e.UID_DialogTag, ' --> ', e.UID_DialogTagParent )) fullpath, 1 as lev, 
 (case when e.UID_DialogTag = e.UID_DialogTagParent then 1 else 0 end) as has_cycle
 from DialogTag e
 union all
 select cte.UID_DialogTag, e.UID_DialogTagParent,
 convert(varchar(max),concat(cte.fullpath, ' --> ', e.UID_DialogTagParent )) fullpath, lev + 1,
 (case when cte.UID_DialogTag = e.UID_DialogTagParent then 1 else 0 end) as has_cycle
 from cte join
 DialogTag e
 on e.UID_DialogTag = cte.UID_DialogTagParent
 where cte.has_cycle = 0 
 )
select *
from cte
where has_cycle = 1;

Endpoint Privilege Management

Transporter crashed when selecting "By Change Label"

Top Replies