The resourceType of "nav" node is expected to be "nt:unstructured" but it already exists as "nt:folder"That might happen if you already have an overlay of "nav".  You may change it and test

When you removed your vanity url from page properties, did you check that page's jcr:content node that sling:vanityPath property is removed or does it still exist even after removing from page properties?Do you see that rule on 'Resolver Map Entries' or 'Mapping Map Entries' on jcrresolver?Could you...

If a bundle is already available/active in OSGI say com.fasterxml.jackson.annotation then add its symbolic name to maven-bundle-plugin in your pom.xml and test it<Require-Bundle>com.fasterxml.jackson.annotation</Require-Bundle>Alternatively, you could also package the jar/bundle within your code-bun...

I meant OSGI bundles and not that jar files (you'd find both versions on web in mvnrepository and other sites)

If the updated rule doesn't appear in '/system/console/jcrresolver'  console immediately, then definitely check error.log as mentioned by Jaideep and share the resultsDoes it appear after refreshing or logging-out/logging-in again?

I assume the environments are not in sync w.r.t. CFP/SP/core components/OOB bundle versions.The best approach would be to identify the gaps. Another solution could be to drill down into filter paths of ASC apps/content packages and check its impact.Compare your STAGE & PROD and STAGE & local environ...

You'd need to extend/customize the available servlet for those propertiessource -acs-aem-commons/SiteMapServlet.java at master · Adobe-Consulting-Services/acs-aem-commons · GitHub

check  9 JCR-SQL2 Queries Every AEM Developer Should Know - Blog - 6D Global SELECT p.* FROM [nt:base] AS p WHERE p.[cq:lastModified] >= CAST('2008-01-01T00:00:00.000Z' AS DATE) AND p.[cq:lastModified] <= CAST('2008-12-31T23:59:59.999Z' AS DATE)orSELECT p.* FROM [nt:base] AS pWHERE p.[some_date] >= ...

For com.fasterxml.* packages, install OSGIfied bundles from Maven Repository: Search/Browse/Explore ​for org.springframework.*, aspectj.*, joda.* use Spring DM bundles and install in OSGIfor org.apache.http.*, update maven-bundle-plugin to import it dynamically from AEM-OOB -- use org.apache.httpcom...

As Ravi mentioned above, allocate more RAM when starting up AEM. If you're using Mac, use top to check RAM used by AEM and assign more using -Xmx2048m or 4096m