SSIS package failed with following error message. So far, I detect Event ID:1530, user profile and registry issue could be related with this failure.
-- SSIS Package Error at AM 6:57:59
Error Code = 0x800703fa : Illegal operation attempted on a registry key that has been marked for deletion.
-- Application Log at AM 6:57:59
Event ID: 1530
Log Name: Application
Source: Microsoft-Windows-User Profiles Service
User: SYSTEM
Description:
Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards.
Detail:
8 user registry handles leaked from \Registry\User\S-1-5-21-1348334522-1236167527-1790366802-500_Classes:
Process 7788 (\Device\HarddiskVolume1\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
Process 7788 (\Device\HarddiskVolume1\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
Process 23060 (\Device\HarddiskVolume1\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
Process 23060 (\Device\HarddiskVolume1\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
Process 23060 (\Device\HarddiskVolume1\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
Process 52040 (\Device\HarddiskVolume1\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
Process 23060 (\Device\HarddiskVolume1\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
Process 52040 (\Device\HarddiskVolume1\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-21-1348334522-1236167527-1790366802-500_Classes
According to Microsoft Information and other users blog, I changed Group Policy(gpedit.msc) as follows;
Computer Configuration->Administrative Templates->System-> UserProfiles
Do not forcefully unload the user registry at user logoff -- Effective
However, ID:1530 kept logging. And ID:1512/1517 is apprearing. (I expected ID:1512/1517 can be coming instead of ID:1530, as Microsoft explained it and ID:1512/1517 can be ignored)
Fortunately, another SSIS package failure is not coming yet, but I'm afraid it would happen again when ID:1530 is coming during the SSIS package is running.
Is anyone encounter the same issue, please share your solutions. Any advice would be highly appreciated.
Regards.
User contributions licensed under CC BY-SA 3.0