Sitecore introduced Items as Resources (IAR) in 10.1
Starting with 10.2 it was also done for SPE (because SXA moved to IAR)
You might be wondering why - because it's necessary (SXA has a dependency on SPE). You can read more about it here
Here is where problems might occur
SPE is delivered right now as:
- SPE-NORMAL - regular package - items will be stored in SQL -
- SPE-IAR - IAR enabled package - items will be stored as
*.dat files -
If you pick the wrong for your case, you will have problems (missing items, broken SXA scaffolding). It happens because item provider takes items from both sources (SQL,
*.dat) which might led to unpredictable results.
Here are rules you should follow when upgrading/installing SPE/SXA for 10.2+.
FRESH INSTALLATION - install SPE-NORMAL or SPE-IAR - IAR is better for future upgrades (no leftovers in SQL) - I recommend it,
UPGRADE - install SPE-NORMAL - installing SPE-IAR is possible but you would have to cleanup items from SQL after that. With SXA it's done by upgrade script, you would have to do similar thing.
WITH SXA - for 10.2+ SPE-IAR is a must
FRESH INSTALLATION - install SPE-IAR before SXA,
UPGRADE - install SPE-IAR before you install SXA, then after you run SXA upgrade scripts (it will cleanup items for SXA and SPE form SQL so they are consumed from
Sitecore.PowerShell.Extensions-6.3 - IAR.zip) from Sitecore Downloads: dev.sitecore.net/Downloads/Sitecore_Experience_Accelerator/10x/…
Content architecture cleanupscript.