Category: Windows

Windows 11 22H2 “Windows 11 installation has failed”

On By windows7bugsIn Windows, Windows 10, Windows 112 Comments

If your hardware is eligible, might have noticed a banner like below

whenever you visited Windows update settings area. It’s free, it’s ready & there are a million possibilities stop your computer from upgrading to Windows 11. The only one thing Windows upgrade manages to show is a popup telling you “Windows 11 installation has failed” after a failure.

Please note, as I already mentioned, there could be a million reasons failing the upgrade, especially when you are upgrading from Windows 10 that was upgraded from different versions of Windows 7,8 and 10 itself. I’ve lost of the count of upgrades I’ve made to my semi-server type desktop machine and didn’t expect Windows 11 upgrade all smooth at the first place. I knew I was in for a long game. My machine has different database software installed for testing, my Kids have heavy games like Doom & other and a clean installation was not at all my first choice.

So my first task was to find out where exactly the installation process writes the errors. To be quite frank, I haven’t had many installation/upgrade issues in near future and I totally forgot where to look for the logs! A quick search landed me on this post Log files that are created when you upgrade to a new version of Windows (microsoft.com) & as my upgrade failed, I was able to locate the “setuperr.log” file at this location “C:\$Windows.~BT\Sources\panther”

Based on the errors, the log file could have hundreds of lines. Mine had the below listed.

2022-10-08 10:40:19, Error                 MOUPG  CDlpActionImpl<class CDlpErrorImpl<class CDlpObjectInternalImpl<class CUnknownImpl<class IMoSetupDlpAction> > > >::Suspend(1253): Result = 0xC1800104[gle=0x00000002] 2022-10-08 10:40:19, Error                 MOUPG  CDlpTask::CheckUserInterruptEx(3060): Result = 0x800704D3 2022-10-08 10:40:19, Error                 MOUPG  CDlpTask::CheckUserInterrupt(3112): Result = 0x800704D3 2022-10-08 10:40:19, Error                 MOUPG  CSetupManager::ExecuteInstallMode(1006): Result = 0x800705BB 2022-10-08 10:40:19, Error                 MOUPG  CSetupManager::ExecuteDownlevelMode(569): Result = 0x800705BB 2022-10-08 10:40:20, Error                 MOUPG  CSetupManager::Execute(313): Result = 0x800705BB 2022-10-08 10:40:20, Error                 MOUPG  CSetupHost::Execute(454): Result = 0x800705BB 2022-10-08 10:40:25, Error                 CONX   Appraiser: ERROR,SdbpGetManifestedMergeStubAlloc,1017,SdbpGetMergeSdbsDisabled failed [c0000034] 2022-10-08 10:43:37, Error                 DU     DU::CDUSession::Search: Failed to set WU internal configuration property for targeted scans. hr = 0x80070057 2022-10-08 10:45:12, Error                 CONX   Appraiser: ERROR,SdbpGetManifestedMergeStubAlloc,1017,SdbpGetMergeSdbsDisabled failed [c0000034] 2022-10-08 10:45:19, Error                 CONX   aeinv: ERROR,StoreAppFinder::EnumeratePackages,414,onecore\base\appcompat\inventory\software\inv\lib\storeappfinder.cpp(489)\aeinv.dll!00007FFF5F3ABB72: (caller: 00007FFF5F3AACD0) Exception(1) tid(13c8) 80070780 The file cannot be accessed by the system.## 2022-10-08 10:45:19, Error                 CONX   aeinv: ERROR,StoreAppFinder::EnumeratePackages,414,onecore\base\appcompat\inventory\software\inv\lib\storeappfinder.cpp(489)\aeinv.dll!00007FFF5F3ABB72: (caller: 00007FFF5F3AACD0) Exception(2) tid(13c8) 80070780 The file cannot be accessed by the system.## 2022-10-08 10:45:36, Error                 CONX   aeinv: ERROR,OrphanFileFinder::GetEvidence,98,onecore\base\appcompat\inventory\software\inv\lib\file.cpp(1881)\aeinv.dll!00007FFF5F3A6E51: (caller: 00007FFF5F3E8532) Exception(3) tid(13c8) 80070001 Incorrect function.## 2022-10-08 10:45:43, Error                 CONX   devinv: ERROR,DeviceMapInitializeTelemetryAndCache,144,TelCacheProvider::Initialize failed [0x80004002] 2022-10-08 10:45:43, Error                 CONX   acmigration: ERROR,CheckDriverStatus,2249,GetDevInventory failed_ 80004002 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\SQLTELEMETRY. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\SQLSERVERAGENT. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\MSSQLSERVER. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\SQLServerReportingServices. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\Classic .NET AppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v4.5. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\DefaultAppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v2.0. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v4.5 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v2.0 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\nop. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3682073875-1643277370-2842298652-3532359455-2406259117): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-2652535364-2169709536-2857650723-2622804123-1107741775): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1010): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3006700770-424185619-1745488364-794895919-4004696415): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-4050220999-2730734961-1537482082-519850261-379003301): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-500): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1001): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-4068219030-1673637257-3279585211-533386110-4122969689): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-4155437066-4169509114-2127487463-1916158496-2406408509): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-271721585-897601226-2024613209-625570482-296978595): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1023): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3876422241-1344743610-1729199087-774402673-2621913236): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-1036420768-1044797643-1061213386-2937092688-4282445334): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-2885764129-887777008-271615777-1616004480-2722851051): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:54:05, Error                 SP     Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1022): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLTELEMETRY. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLSERVERAGENT. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\MSSQLSERVER. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLServerReportingServices. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\Classic .NET AppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\DefaultAppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:30, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\nop. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:43, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\SQLTELEMETRY. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:43, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\SQLSERVERAGENT. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:43, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\MSSQLSERVER. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:43, Error      [0x0803b6] MIG        Can't retrieve group information for user NT SERVICE\SQLServerReportingServices. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:43, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\Classic .NET AppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:43, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v4.5. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:43, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\DefaultAppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:44, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v2.0. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:44, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v4.5 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:44, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\.NET v2.0 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:44, Error      [0x0803b6] MIG        Can't retrieve group information for user IIS APPPOOL\nop. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:54, Error      [0x0808ff] MIG        COutOfProcPluginFactory::CreateInstance: m_currentHostSurrogate->LoadDllServer(C:\$WINDOWS.~BT\Sources\ReplacementManifests\Microsoft-Windows-RasServer-MigPlugin\RasMigPlugin.dll, {D26AA4A5-92AD-48DB-8D59-95EF0DCE6939}, 1) failed, hr=[0x8007007f]. 2022-10-08 10:56:54, Error      [0x080387] MIG        Failure while calling IDiscovery->Discover for Plugin={ServerPath="Microsoft-Windows-RasServer-MigPlugin\RasMigPlugin.dll", CLSID={D26AA4A5-92AD-48DB-8D59-95EF0DCE6939}, ThreadingModel=Apartment, ExceptionHandling=Default}. Error: 0x8007007F 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLTELEMETRY. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLSERVERAGENT. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\MSSQLSERVER. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLServerReportingServices. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\Classic .NET AppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\DefaultAppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\nop. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3682073875-1643277370-2842298652-3532359455-2406259117): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-2652535364-2169709536-2857650723-2622804123-1107741775): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1010): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3006700770-424185619-1745488364-794895919-4004696415): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-4050220999-2730734961-1537482082-519850261-379003301): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-500): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1001): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-4068219030-1673637257-3279585211-533386110-4122969689): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-4155437066-4169509114-2127487463-1916158496-2406408509): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-271721585-897601226-2024613209-625570482-296978595): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1023): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3876422241-1344743610-1729199087-774402673-2621913236): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-1036420768-1044797643-1061213386-2937092688-4282445334): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-2885764129-887777008-271615777-1616004480-2722851051): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:56:55, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1022): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 10:57:11, Error                                MigPlatformStartupOnline caught exception: Win32Exception: Duplicate profile detected for S-1-5-21-3050672445-3209544092-517134063-1023. Abandoning.: The specified user does not have a valid profile. [0x000004E5] class Mig::CUserContext *__cdecl Mig::COnlineWinNTPlatform::AddUserContext(class Mig::CRegistryDataStore *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::Array<class UnBCL::String *> *,int,struct _FILETIME,int,int,int,class UnBCL::String *,class UnBCL::String *) 2022-10-08 10:57:11, Error                 SP         pSPDoMainGather: Engine initialization failed with error: 0x00000004 2022-10-08 10:57:11, Error                 SP         CGatherData: Migration phase failed. Status: 4 2022-10-08 10:57:11, Error                 SP     Operation failed: Gather data, scope: EVERYTHING. Error: 0x8007001F[gle=0x000000b7] 2022-10-08 10:57:12, Error                 SP     CSetupPlatform::ResurrectAutomation: Failed to resurrect automation: 0x80070002[gle=0x00000002] 2022-10-08 11:07:23, Error                            InitDownlevelOCMode caught exception: Win32Exception: Duplicate profile detected for S-1-5-21-3050672445-3209544092-517134063-1023. Abandoning.: The specified user does not have a valid profile. [0x000004E5] class Mig::CUserContext *__cdecl Mig::COnlineWinNTPlatform::AddUserContext(class Mig::CRegistryDataStore *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::Array<class UnBCL::String *> *,int,struct _FILETIME,int,int,int,class UnBCL::String *,class UnBCL::String *) 2022-10-08 11:07:23, Error                 MIG        OC Exception: OC::CDownlevelOCStore::CDownlevelOCStore: Engine's InitDownlevelOCMode failed. 2022-10-08 11:07:23, Error                 SP         OC Validator: Failed to gather OC status. Errors are not ignored 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLTELEMETRY. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLSERVERAGENT. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\MSSQLSERVER. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLServerReportingServices. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\Classic .NET AppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\DefaultAppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:24, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\nop. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLTELEMETRY. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLSERVERAGENT. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\MSSQLSERVER. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user NT SERVICE\SQLServerReportingServices. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\Classic .NET AppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\DefaultAppPool. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v4.5 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\.NET v2.0 Classic. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:25, Error      [0x0803b6] MIG            Can't retrieve group information for user IIS APPPOOL\nop. NetUserGetLocalGroups failed 0x000008AD 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3682073875-1643277370-2842298652-3532359455-2406259117): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-2652535364-2169709536-2857650723-2622804123-1107741775): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1010): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3006700770-424185619-1745488364-794895919-4004696415): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-4050220999-2730734961-1537482082-519850261-379003301): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-500): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1001): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-4068219030-1673637257-3279585211-533386110-4122969689): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-4155437066-4169509114-2127487463-1916158496-2406408509): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-271721585-897601226-2024613209-625570482-296978595): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1023): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-3876422241-1344743610-1729199087-774402673-2621913236): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-82-1036420768-1044797643-1061213386-2937092688-4282445334): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-80-2885764129-887777008-271615777-1616004480-2722851051): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:26, Error                 SP         Failure while getting the known folder path for CSIDL_PRINTHOOD (S-1-5-21-3050672445-3209544092-517134063-1022): Win32Exception: The system cannot find the file specified. [0x00000002] class UnBCL::String *__cdecl Mig::CFacadeUser::GetKnownFolderLocation(class UnBCL::String *,int *,class UnBCL::String **) 2022-10-08 11:07:41, Error                                MigPlatformStartupOnline caught exception: Win32Exception: Duplicate profile detected for S-1-5-21-3050672445-3209544092-517134063-1023. Abandoning.: The specified user does not have a valid profile. [0x000004E5] class Mig::CUserContext *__cdecl Mig::COnlineWinNTPlatform::AddUserContext(class Mig::CRegistryDataStore *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::String *,class UnBCL::Array<class UnBCL::String *> *,int,struct _FILETIME,int,int,int,class UnBCL::String *,class UnBCL::String *) 2022-10-08 11:07:41, Error                 SP         pSPDoMainGather: Engine initialization failed with error: 0x00000004 2022-10-08 11:07:41, Error                 SP         CGatherData: Migration phase failed. Status: 4 2022-10-08 11:07:41, Error                 SP     Operation failed: Gather data, scope: EVERYTHING. Error: 0x8007001F[gle=0x000000b7] 2022-10-08 11:07:41, Error                 SP     COperationQueue::Sort: Could not find an execution phase for 56[gle=0x00000002] 2022-10-08 11:07:41, Error                 SP     ExecuteOperations: Operations cannot be sorted. This is a fatal failure.[gle=0x00000002] 2022-10-08 11:07:41, Error                 SP     ExecuteOperations: Main operation execution failed. Error: 0x8007000D 2022-10-08 11:07:41, Error                 SP     ExecuteOperations: Failed execution phase Finalize. Error: 0x8007000D 2022-10-08 11:07:41, Error                 MOUPG  MoSetupPlatform: Finalize reported failure![gle=0x8007000d] 2022-10-08 11:07:41, Error                 MOUPG  MoSetupPlatform: Using action error code: [0x8007001F][gle=0x8007000d] 2022-10-08 11:07:41, Error                 MOUPG  CDlpActionFinalize::ExecuteSetupPlatformFinalize(1192): Result = 0x8007001F[gle=0x8007000d] 2022-10-08 11:07:41, Error                 MOUPG  CDlpActionFinalize::ExecuteRoutine(514): Result = 0x8007001F[gle=0x8007000d] 2022-10-08 11:07:43, Error                 MOUPG  CDlpActionImpl<class CDlpErrorImpl<class CDlpObjectInternalImpl<class CUnknownImpl<class IMoSetupDlpAction> > > >::Execute(493): Result = 0x8007001F 2022-10-08 11:07:43, Error                 MOUPG  CDlpTask::ExecuteAction(3300): Result = 0x8007001F 2022-10-08 11:07:43, Error                 MOUPG  CDlpTask::ExecuteActions(3454): Result = 0x8007001F 2022-10-08 11:07:43, Error                 MOUPG  CDlpTask::Execute(1631): Result = 0x8007001F 2022-10-08 11:07:43, Error                 MOUPG  CSetupManager::ExecuteTask(2928): Result = 0x8007001F 2022-10-08 11:07:43, Error                 MOUPG  CSetupManager::ExecuteTask(2891): Result = 0x8007001F 2022-10-08 11:07:43, Error                 MOUPG  CSetupManager::ExecuteInstallMode(1110): Result = 0x8007001F 2022-10-08 11:07:43, Error                 MOUPG  CSetupManager::ExecuteDownlevelMode(569): Result = 0x8007001F 2022-10-08 11:07:47, Error                 MOUPG  CSetupManager::Execute(313): Result = 0x8007001F 2022-10-08 11:07:47, Error                 MOUPG  CSetupHost::Execute(454): Result = 0x8007001F

Among of a list of issues, I recognized the duplicate profile error(s) without much sweat as this issue has been persistent from the Windows 7 times.

Now the fix that is discussed here is not for a normal computer user. If you have landed here, searching for a solution for your home computer and haven’t dealt with Windows registry in the past, manually managing it, please stop & seek the help of someone who is familiar with these kind of activities.

Make a backup for complete Windows Registry. This is very important to rollback incase if something goes wrong.

Go to “Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList” node. From the setuperr.log file you already have a profile id that is reported as “duplicate”. Browse through the profile ids and locate the profile that doesn’t exist. For example, my user account for the system is “rajesh” and I had two profile ids, one having the Profile Image Path “C:\Users\rajesh” and the other profile id having profile image path “C:\Users\Rajesh”

I deleted that non-existing profile id from the registry (ie, C:\Users\Rajesh) and restarted upgrade. Everything went ahead smooth and within next 10-15 minutes, Windows 11 booted without issues.

A list of other measures that you could try in case if your upgrade fails are:

  • Remove all connected external devices other than keyboard & mouse
  • Uninstall SSD/NVMe managers (software that help you to monitor the SSD drives)
  • Uninstall 3rd party antivirus software. One of the major reasons for failures
  • Check for adequate free storage space on your system drive, normally C: drive
  • Use Windows built-in troubleshoot to fix Windows update errors
  • During installation, let the installer check for updates and download the necessary

Oracle Database 19c | Convert non CDB Database to PDB

On By windows7bugsIn Oracle database 11g, Oracle database 12c, Oracle Database 19c, Windows 10, Windows 114 Comments

We’ve our Oracle EBS instance hosted from Linux environment. However I post much for the Windows OS as I see there are not many articles targeting Oracle on Windows. I think for better view counts, I should consider posting the articles for both OS.

In my last post about restoring 1g RMAN online backup to 19c non CDB database, I said my ultimate goal was to convert the upgraded database from non CDB to PDB, that is plugged on to an existing CDB. Let us see how to achieve this goal this time.

Before start, there are few mandatory checks you must do to insure a successful migration from Non CDB to PDB. I will list few of them those came as hurdles for me.

  1. Character Set. Make sure that your CDB and the Non CDB database have the same character set. There are few possible conversions. Please check 12c Multitenant Container Databases (CDB) and Pluggable Databases (PDB) Character set restrictions / ORA-65116/65119: incompatible database/national character set ( Character set mismatch: PDB character set CDB character set ) (Doc ID 1968706.1) for more details. My CDB was using Arabic character set and the upgraded non CDB database was using a noncompatible set. So I dropped the CDB and created a new CDB without PDB(s). Dropping a CDB will not be always possible because other PDBs are attached to it.
  2. Available storage space. This could be a real concern incase if you are planning to create a PDB, cross verify & then delete the non CDB database. You will need approximately the same size of your non CDB datafiles size storage available to do this activity. My database was less than 5 GB in size, hence it never occurred to me. If your database has a bigger size, plan accordingly.

Let’s do it now.

From and elevated command prompt (Windows Terminal is not yet matured enough to handle such “heavy” tasks) source the non CDB. Shutdown and startup mount exclusive.

C:\Windows\system32>set ORACLE_SID=KAZEMA
C:\Windows\system32>sqlplus / as sysdba
SQL> shu immediate
SQL> startup mount exclusive
SQL> alter database open read only;

Create manifest file for the non CDB now.

SQL> exec dbms_pdb.describe (pdb_descr_file=>'D:\Oracle19c\kazema_manifest_file.xml');
SQL> shu immediate

Source the CDB now.

C:\Windows\system32>set ORACLE_SID=KAZEMACDB
C:\Windows\system32>sqlplus / as sysdba
SQL> SHOW CON_NAME

CON_NAME
------------------------------
CDB$ROOT

Now, we need to see whether non CDB meets the compatibility requirements. There could be multiple elements those you may have to fix before, the non CDB is ready for a successful migration as PDB. You will have to refer PDB_PLUG_IN_VIOLATIONS view for these details. Go ahead, execute the below code block.

SQL>   SET SERVEROUTPUT ON;
SQL>    DECLARE
       Compatible CONSTANT VARCHAR2(3) :=CASE  DBMS_PDB.CHECK_PLUG_COMPATIBILITY
       (pdb_descr_file => 'D:\Oracle19c\kazema_manifest_file.xml')
       WHEN TRUE THEN 'YES'
       ELSE 'NO'
       END;
       BEGIN
          DBMS_OUTPUT.PUT_LINE(compatible);
       END;
     /
YES

My case I didn’t have incompatibilities blocking possible migration. Your case could be different. If the output is “NO”, run the following query (use SQL Developer for better view)

select * from PDB_PLUG_IN_VIOLATIONS where name='<your non CDB name>';

Fix each and every other ERROR & you can safely ignore the “WARNINGS” for now.

Proceed with creating a new PDB from the manifest file that we have created in the 1st step.

SQL> CREATE PLUGGABLE DATABASE KAZEMA USING 'D:\Oracle19c\kazema_manifest_file.xml' COPY FILE_NAME_CONVERT=('D:\ORACLE19C\DB\ORADATA\KAZEMA\DATAFILE','D:\ORACLE19C\DB\ORADATA\KAZEMA');

Pluggable database created.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 KAZEMA                         MOUNTED

Once the PDB has been created, confirm the same & proceed with balance activities. Run “noncdb_to_pdb.sql”

SQL> alter session set container=KAZEMA;

Session altered.

SQL> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql

Based on the resource available, this might take a while for the script to complete execution. Once completed you can try to open the PDB. Check for Errors and Warnings in the PDB_PLUG_IN_VIOLATIONS view. If there are new ERRORS & WARNINGS fix them.

A typical scenario could list you many things like this (reference image only)

After fix attempts, I am still left with one Warning about sys lock issues. This is mainly due to the password file format 12.2. I hope to find a solution soon for it. Status column states whether the Error/Warning was taken care off. 

SQL> alter pluggable database open;

Pluggable database altered.

SQL> SELECT name, open_mode FROM v$pdbs;

NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
KAZEMA
READ WRITE


1 row selected.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 KAZEMA                         READ WRITE NO
SQL>

Now you have a non CDB and PDB with the same SID. You can proceed with dropping the non CDB database after cross verifying the concerns.

Reference documents:

Foot Note: If you are plugging a database that was hosted in another server/computer after converting, make sure to verify the “local_listener” parameter for the PDB exist.

D:\Oracle19c>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 10 11:18:33 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_KAZEMACDB
SQL> alter session set container="KAZEMA";

Session altered.

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_KAZEMACDB
SQL>

If the local listener is not reachable, PDB level services will fail to register with listener and the applications those depend on such services will fail to establish connections. This applies mostly to Oracle E-Business Suite environments and could be mapped to sophisticated applications that use specific service names to establish connections to the database.

KB5009543 | Jan 2022 cumulative update breaks IKEv2 VPN Connections

On By windows7bugsIn Windows, Windows 10, Windows 11Leave a comment

KB5009543 or Cumulative update Jan 2022 for Windows 10 and Windows 11 is currently breaking IKEv2 VPN connections. If you are experiencing an unexpected connection failure with a vague error message like “General processing error”, please follow the below steps.

Go to Program and Features -> Installed Updates and uninstall KB5009543. Reboot the box and the VPN connection should start working normally. Optionally you may disable the Windows Update for a period of time so that the same update will not get installed once again. Please note, Microsoft releases updates to their products quite often to resolve issues those were identified. Few times these updates open new issues, like the one happened with this particular KB.

While there are no straight forward methods available to “stop” Windows updates, you can use multiple methods to disable Windows update completely, which we don’t recommend. One of them is using group policies on the local machine.

If you still consider disabling Windows updates temporarily/long term, please refer this excellent tutorial

Hope this helps.

Connecting Oracle Developer 10g to 11G database takes long time

On By windows7bugsIn Oracle Applications (R12.0.4), Oracle database 11g, Oracle Forms, Oracle SQL Developer, Windows 10, Windows 11Leave a comment

We migrated to 11G R2 (11.2.0.4) for our Oracle Applications R12 few years back, yes few years back (2017) & lived with one of the worst experiences…

Connecting Oracle Developer 10g (Forms/Reports) suite to 11G database.

I have scavenged through community articles for long time before giving up. I hardly came across a single fix for the connection time that used to hang up the Developer suite at times…

Today, I decided to find a solution for the nagging SSH connection issues from Windows 11 to our LINUX application servers and realized that we didn’t update the DNS settings for them once after we decommissioned a domain controller. Once the SSH issues were rectified and addressed, my next attempt was to find a solution for “frmcmp_batch” taking long time to start compiling modules & I landed on the below post.

Credit: Oracle Applications DBA: Form Compilation Against a 11g Database Hangs or Takes a Very Long Time [ID 880660.1] (appsjagan.blogspot.com)

As we are already on 11G R2 11.2.0.4, patching was not required. All I needed was to alter the hidden parameter “_FIX_CONTROL” as mentioned in the article.

SQL> ALTER SYSTEM SET "_FIX_CONTROL"='8560951:ON';

(Use scope=spfile to make this change permanent. This will require you to restart the database.)

I opted to go without spfile for testing & as soon as applied, the “frmcmp_batch” started compiling the modules instantly, against the usual delay that ran into many minutes other times.

Out of curiosity, I tried to connect to the database from Developer 10g & the connection was instant! within a fraction of a second.

So DNS being one of the most important elements establishing successful connections, patches and fixes also play crucial role in providing stable connections. Were you stuck with the same issue? give the solution a try and let us know whether it helped you also.

IIS 7.5+ | Windows Authentication

On By windows7bugsIn WindowsLeave a comment

We decided to retire one of our Windows 2008 (32-Bit) servers, hosting multiple classic ASP intranet applications. Our immediate choice was another VM, that runs Windows 2008 R2, 64-Bit OS with IIS 7.5.x as intermediatory until we setup a brand new VM running Windows 2019 & soon realized that we were in tight spot as any attempt to access intranet application(s) from the new host started prompting for authorization for applications that were using “Windows Authentication”. All our application servers are domain members, so are our clients.

We did an apple to apple comparison between servers/IIS setup, visited dozens of threads & yet were unable to fix the “problem”, that was the site/application asking for authentication for a user who is already authenticated by the Active Directory!

Credits:

Although Midas site article Configuring Web Browsers for Active Directory Integration | MIDAS clearly mentioned about adding the website to local intranet zone, we missed it completely!

After referring third link, had the answer to our problem. Actually, if a client wants to negotiate authentication using “Windows Authentication” through a website by passing currently logged in user credentials, that website should be in Local Intranet zone, which was, for us controlled using a Group policy. This is strictly to make sure that user details are not shared with Internet zones, as a security measure.

Once the new site name was added to the zone list and group policies updated, we were able to access the intranet applications without further issues.

Install Oracle Developer 10G on Windows 11

On By windows7bugsIn Windows, Windows 10, Windows 112 Comments

Today I re-installed Windows 11 on my computer. Actually I had upgraded from Windows 10 to Windows 11 on October 5th, 2021 the same day Microsoft released the half baked OS to public & all of a sudden I realized that, it was a blunder. So, after regretting over a month, I decided to re-install the OS and started installing all my development tools & you know what, I had to refer my Windows 7 post for installing Oracle Developer Suite 10g on my Windows 11!

Much of the post below is from the earliest post that I had for Windows 7, explaining hacks to install Oracle Database 10g and the Suite. Oracle Database 10g is not anymore significant, hence I removed the database part and posting the rest for few unfortunate Oracle developers out there. Well, 10g is used by many business application as on date & if you are looking for a method to install Oracle Database 10g on Windows 11, Please search the blog for Database 10g and you will land on multiple posts explaining to how (Refer Windows 10 articles)

Step 1 Setup Virtual Memory

If your computer has 8GB or more physical memory, all you need is to setup the Virtual Memory for the name sake. Limit the virtual memory to 2048 (2G) or max 4096 (4G). Please use the below images only for reference purposes. After changing the Virtual Memory, You will be asked to restart the computer and please restart.

Step 2 Setting up the Developer Suite

Depending upon the media that you are using for the installation, Oracle Developer 10g has 2 discs & I have copied the content from both disks inside a folder on my computer. (As you could see in the image above)

Open the Disk 1 folder and locate “Setup.exe’, right click and change the compatibility to Windows XP Service Pack 2 or 3 (doesn’t make any difference)

That’s all. Right click and run “setup.exe” as Administrator. If you have a JAVA installation already on the computer, you might receive a warning message for missing entry point, that you can safely ignore.

Follow the same compatibility setting for patch sets, if you have any. Let me know about your experience through comments.

Install Oracle 21c database on Windows

On By windows7bugsIn Oracle related, WindowsLeave a comment

If you have already installed Oracle 19c following instructions available here, installing Oracle database 21c is not much different. Basically 21c is “Innovation Release” & 19c is going to be the long supported version as on date. It plainly means, there is no need to hurry to upgrade your 19c to 21c as next release will be the next long supported version.

Let us see how to install Oracle 21c on Windows (Installed on Windows 10 21H1) & the instructions are same for Windows 11 also.

You can download the 21c Windows installation media from Oracle Database 21c Download for Microsoft Windows x64

Extract the .zip and change the root folder to something like “Oracle12c” (or a name that prefer. Please avoid using spaces with the folder name, example: “Oracle 21c”)

I used a virtual machine with single drive, hence the zip file was extracted and I renamed the extracted folder root to “Oracle21c”

Once the folder is renamed to your choice, open the folder and execute the “setup.exe” as administrator. Please note, you must start the setup as administrator, regardless whether your Windows user account has administrator privileges on the system.

This will kick start the installation process and depending upon the resources available it could take minutes before the installation GUI appears for you.

Choose “Server class” regardless whether you are installing it on a Server OS or client OS. It’s all about managing the resources.

Now, this is a very interesting perspective. “The software directory is the Oracle Database home directory” & the path that you will mention in the edit box is going to be the Oracle base. I hope, now you understood why renaming the media extracted folder to a very meaningful name is important. As usual Oracle suggests you the defaults, however I recommend you to follow a pattern that you can feel comfortable with.

As you could see, the default installation sets up one pdb. You may rename the default PDB at this level.

Here I left everything to defaults as my intentions were pretty limited to installation. Unless you have a reason to set up Automatic Memory management, go ahead with the well trusted manual management, that gives you granular level control on how the memory is utilized by the database.

You can change the database character set to another from the “Choose from the following list of character sets” (Specifically for Arabic and other left to right languages)

You may choose a different location for the database data files. Just make sure that the current user has full access to the path.

Use the same password for a TEST installation & follow the Oracle recommendations for PRODUCTION environments. Please note, it’s better to use the complex passwords with expiry disabled for the default profile.

That’s all folks. It’s not like the earlier times when one had to hack the installation files to install Oracle database on newer Windows OS. Starting from 11g, Oracle database gets installed on Windows 7 and later OS without complaining as long as the OS is fully patched with updates and .NET components.

Hope this post helps few newbies (& me)

Windows 11 | Dial a VPN Connection using PowerShell script

On By windows7bugsIn Windows, Windows 111 Comment

I started blogging once after upgrading to Windows 7 & posted mostly about the ridiculous bugs Microsoft exported with that OS. Gradually Windows 7 got matured (hardly ever fixing the yellow triangle network icon issue) & my entire attention switched to what I do for salaries, Oracle development & later much of my posts were about the stack.

Now Microsoft has released another half cooked OS, Windows 11. From a layman perspectives I cannot understand how someone could make such decisions that affect the established stability and ease of use of an OS that creates huge disappointments for general userbase!

Other than cosmetic changes and revamped settings area, I cannot defer Windows 11 from Windows 10, plus the disappointment of losing the start menu that I was getting used to after loads of patience and efforts. Among many of such grievances, connecting to VPN that is defined using Windows new connection wizard at work is so ridiculous, requiring 4 mouse clicks! So I decided to go with a cmd/powershell script this time to avoid those 4 mouse clicks. If you are using Cisco or other VPN solutions, this will not apply to you.

After weighing the possibilities of extending , I decided to go with PowerShell (Version 5)

So let us check how it works. Copy the following in to a text file

rasdial.exe "Your VPN Name"

Save the file as “Dial VPN.ps1” or any other name you prefer with extension “.ps1”.

Make sure you wrap the VPN name using double quotes. “rasdial.exe” is not a powershell cmdlet, an old Windows OS friendly dialer. This executable is generally found in the Windows\System32 folder and there is no need to specify the path, unless you modified the PATH environment variable. Now create a new shortcut on the desktop and type/copy the following (Please adjust the file path as per your setup) as command for the shortcut

powershell.exe -File "C:\scripts\Dial-VPN.ps1"

Please note, you must configure the Powershell execution police “RemoteSigned” inorder to make this work. Example:

PS C:\Users\<username>> Set-ExecutionPolicy RemoteSigned

Usually I keep all my scripts in a folder named “Scripts” on the C: drive. Hence the -File parameter clearly mentions the script’s path.

That’s all, you can double click and open the pre-configured VPN connection without going through the 4 click hassles on Windows 11 (or multiple clicks on other Windows OS versions)

Now, let us look at a fancier version of the above. What if you want to connect if not connected and disconnect if already connected? Please note, this script could be extended beyond this level depending upon specific requirements. I have started with the skeleton and will be happy to receive better scripts from you.

Code block modified on 11th December 2022 for better error handling. 

<#
https://community.spiceworks.com/topic/2271983-auto-connect-vpn
http://woshub.com/popup-notification-powershell/
POWERSHELL error handling for Invoke-Expression
https://stackoverflow.com/questions/32348794/how-to-get-status-of-invoke-expression-successful-or-failed
#>
            
$vpnname = 'Your VPN Name'
$vpnusername = "YOURUSERNAME"
$vpnpassword = "YOURPASSWORD"
$cmd = $env:WINDIR + "\System32\rasdial.exe"
            
try {
    $vpn = Get-VpnConnection -Name $vpnname -ErrorAction Stop
    $Success = $vpn.ConnectionStatus
}
catch {
    Write-Host "Please use Windows Network and Internet Setting to define a VPN Connection"
}

try {
    if ($vpn.ConnectionStatus -eq "Disconnected") {
        $expression = "$cmd ""$vpnname"" "
        $Success = Invoke-Expression -Command $expression 
        if ($LASTEXITCODE -ne 0) {
            $wshell = New-Object -ComObject Wscript.Shell
            $Output = $wshell.Popup("$Success", 0, "$vpnname Status", 64)
        }
        else {
            $wshell = New-Object -ComObject Wscript.Shell
            $Output = $wshell.Popup("Connected.", 0, "$vpnname Status", 64)
        }
    }
    else {
        $vpnstatus = $vpn.ConnectionStatus
        if ($vpnstatus -eq "Connected") {
            $wshell = New-Object -ComObject Wscript.Shell
            $Output = $wshell.Popup("$vpnname will be disconnected, Are you sure?", 0, "$vpnname Status", 4 + 32)
            if ($Output -eq 6) {
                $expression = "$cmd ""$vpnname"" /DISCONNECT"
                Write-Host $expression
                Invoke-Expression -Command $expression 
                $wshell = New-Object -ComObject Wscript.Shell
                $Output = $wshell.Popup("VPN Disconnected", 0, "$vpnname Status", 64)
            }
        }
    }
}
catch {
    $wshell = New-Object -ComObject Wscript.Shell
    $Output = $wshell.Popup("There was an unexpected error connecting VPN," + 
        " Please check whether you have defined the $vpnname correctly." + 
        " Check your username & password, Server IP address etc", 0, "$vpnname Status", 64)
}

Please note, I am a beginner with PowerShell(Also) and always will be. As usual, I have provided the links to original codes & possible other links those helped me to device the above.

The above can, dial your VPN connection, warn you before you disconnect etcetera. For my ease, I prefer to use the extended version of the script as I keep on switching the connections. You may able to extend the script once again by accepting the VPN connection name, so that you can use the same script for dialing different VPN connections (if you have many)

Have suggestions? please pass them to me through the comments section.

Windows 11 | Remote Server Administration Tools (RSAT)

On By windows7bugsIn Windows 11Leave a comment

A wonderful article about installing RSAT (Remove server administration tools) on Windows 11 is available at How To Install RSAT On Windows 11 PCs HTMD Blog (anoopcnair.com)

I would like reiterate something Anoop has mentioned in his article. If you are using Microsoft SCCM or Windows Update Services (WU), then you must enable the local group policy as he has mentioned clearly in his post.

The image attached by Anoop could be bit confusing for the local group policy setup, hence I am uploading one with better visibility. The path is “Computer Configuration->Administrative Templates->System” & you need to open “Specify settings for optional component installation and component repair”

No need to reboot the computer for installing RSAT components. Follow Anoop’s thread and be a happy Administrator!

Windows | Search & WIFI cannot type

On By windows7bugsIn Windows, Windows 10, Windows 2016Leave a comment

There are situations, especially while using Windows 10 gen OS (Windows 2016+ Servers included) a user might not able to type inside

  • Windows Search Textbox
  • WIFI Password Textbox

For some strange reasons, typing inside these text boxes are supported by “CTF Loader”(C:\Windows\System32\ctfmon.exe)” & that is loaded into computer’s memory normally after a restart/reboot.

This is facilitated by one of the Windows Tasks & certain attempts like using KMSPICO tool to activate Microsoft software, which is ILLEGAL and many times breaks this Task.

So, how do we fix it? There are two different approaches

  • Rebuild the Task
  • Using Registry

We’ll see both methods in detail now.

1# Rebuild the Task

If the KMSpico tool or other reason corrupts the Task, you will not find any entries in the folder “TextServicesFramework”

Edited image for demo.

when an intact task should look like below

So how do we recreate this task, that is a custom handler?

Browse to “C:\WINDOWS\System32\Tasks\Microsoft\Windows\TextServicesFramework” & check whether you can find a file “MsCtfMonitor” inside the folder. If you cannot find the file in this folder, copy the file from another Windows machine that has the same version.

Copy the file to desktop and add the extension “.xml” to it.

Opening the file with notepad or another text editor should look like the following:

Go back to Task Scheduler and right click on “TextServiceFramework” and select “Import Task”

Point to the xml file that you have created in the desktop & apply. This should create a new task under the folder “TextServiceFramework”

Restart and confirm you can type in the search box and WIFI password text boxes. Alternatively you can use the Task Manager to check whether “CTF Loader” has been loaded.

2# Registry

Remember, registry entries might get removed through updates/new versions. However, as a temporary measure you can use the following hack to address the keyboard issues.

Make a full backup for the Registry. You must know, tampering registry could force you to a fresh installation of the OS!

Once a full backup for the Registry is made, browse to “Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run”

Create a new string key and call it anything that you want. Example

I have called the string key as “CTFLoader” and for the Value make sure to enter “ctfmon”=”CTFMON.EXE”

Reboot the computer and check whether the typing issues resolved. Alternatively use Task Manager to check whether CTF Loader has been loaded.

Although both fix the typing issues, the right way is to recreate the missing Task. Choose wisely & don’t pirate! We know many interesting software are pricely and many of us cannot afford them. There are free alternatives for maximum pirated software like

And many more software that you need for Office/School/Home works! Piracy not only breaks the businesses that develop them, helps cyber criminals to unleash attacks like Ransomware through serial number generators and patches.

Hope this has helped you today.