Error 0x80073CFA: Can't Uninstall Apps using Remove-AppxPackage in Windows 10 | Windows OS Hub (2024)

admin January 15, 2020 - 8:00 am

Download the PsExec tool (_https://docs.microsoft.com/en-us/sysinternals/downloads/psexec) and extract it to a local folder.
Next, run the elevated cmd.exe, go to the folder with psexec: cd c:\tools\psexec and run the command: psexec.exe -i -s -d cmd.exe

Reply

admin March 31, 2020 - 8:48 am

Make sure you run the DB Browser on behalf of the Local System. And specify your Windows 10 build.

Reply

movAxAx July 29, 2021 - 5:47 pm

To anyone with this problem. It arises because the table has a trigger after update. There are two options: 1) If you are updating the database through a custom program or script, use the sqlite3_create_function() API function to create the function the triffer requires. 2) From the command-line utility: drop the trigger before update, and you can (in my case I do not did it) recreate it later. a) Use .schema Package to list the triggers, and copy the text of the trigger, in my case it was TRG_AFTER_UPDATE_Package_SRJournal. b) DROP TRIGGER TRG_AFTER_UPDATE_Package_SRJournal; c) Do your update. d) Recreate the trigger, in my case CREATE TRIGGER TRG_AFTER_UPDATE_Package_SRJournal AFTER UPDATE ON Package FOR EACH ROW WHEN is_srjournal_enabled() BEGIN UPDATE Sequence SET LastValue=LastValue+1 WHERE Id=2 ;INSERT INTO SRJournal(_Revision, _WorkId, ObjectType, Action, ObjectId, PackageIdentity, WhenOccurred, SequenceId)SELECT 1, workid(), 1, 2, NEW._PackageID, pi._PackageIdentityID, now(), s.LastValue FROM Sequence AS s CROSS JOIN PackageIdentity AS pi WHERE s.Id=2 AND pi.PackageFullName=NEW.PackageFullName;END

Reply

Nevermind, solved using this steps: https://gist.github.com/DoubleLabyrinth/ffae94cb9444bbdae1d11deeaa247310

Dave May 27, 2021 - 12:18 pm

Nevermind. Even though the sound apps shouldn’t have required special system access doing so allows me to nuke the damn things.

Reply

17 march 2022
this is just after my update for windows 10 22H2. i chose to eliminate edge. when i looked in the database above, i found two versions to remove, the out of the box version that came with windows 10, and the new version that was automatically installed with 22H2. there are registry edits that will keep edge from reinstalling beyond the scope of this update.

i had to take ownership from TrustedInstaller in file properties/advanced/ on the database to be modified, before the database could open it: C:\ProgramData\Microsoft\Windows\AppRepository\StateRepository-Machine.srd

Returning ownership after was easy with a quick online search.

step 7 above may not be possible until the “IsInBox” field is unlocked. the trigger that must be removed to disable the lock and allow editing on is: TRG_AFTER_UPDATE_Package_SRJournal in the “Database Structure” tab in the database. a sql command to copy the trigger back is available via right click – and must be done prior to the temporary deletion of the trigger. the trigger must be recreated after – the sql script below is what i put into the “Execute SQL” tab.

to recreate this trigger on my system – yours may differ – my sql script was:

CREATE TRIGGER TRG_AFTER_UPDATE_Package_SRJournal AFTER UPDATE ON Package FOR EACH ROW WHEN is_srjournal_enabled()BEGIN UPDATE Sequence SET LastValue=LastValue+1 WHERE Id=2 ;INSERT INTO SRJournal(_Revision, _WorkId, ObjectType, Action, ObjectId, PackageIdentity, WhenOccurred, SequenceId)SELECT 1, workid(), 1, 2, NEW._PackageID, pi._PackageIdentityID, now(), s.LastValue FROM Sequence AS s CROSS JOIN PackageIdentity AS pi WHERE s.Id=2 AND pi.PackageFullName=NEW.PackageFullName;END

ETA – got here after seeing:

DB Browser for SQLite
Error changing data:
no such function: is_srjournal_enabled

removing the trigger, then writing the change, then returning the trigger put the database back to its working state.
finished removing edge using powershell commands that are found easily with a search. the prior methods of removing edge fail after the 22H2 win10 update.