Can you try with port 25 instead of 587 and see if that works?  smtp.port=25 Also, check below and see if that helps?  https://www.positioniseverything.net/unrecognized-ssl-message-plaintext-connection/  

1. Here is a working configuration for GMail : smtp.host=smtp.gmail.com smtp.port=587 smtp.ssl=yes smtp.user="me@gmail.com" smtp.password="myPassword" You must use port 587 (and so activate SSL) 2. Also ensure that Two factor authentication is not activated (otherwise you must generate a new applic...

where is your query builder related logic written? is it at component level model or service or at the servlet level? 1. if the your custom code is written on sling model /service level, then you can get the current page path and split the path to identify the languagecode/locale then construct the ...

You should rearrange under cq:dialog node level, if you don't see cq:dialog node under your page/template code level, then you can copy the cq:dialog node from core components and then rearrange the fields the way you want. Path: /apps/core/wcm/components/page    

You can construct the AEM url in the sling model and use the same while sending email. 1. First get the current page path using Page object. @inject private Page currentPage;  2. Use Externalizer to get the hostname and the construct complete url ("<hostname>" + "/editor.html/+"<Page path>"+"html" y...

Also, if it's Java version compatibility issue, please make sure to create a fresh instance and try after installing required Java version. 

Can you please share more info:  1. how frequently you need generate these kind of reports?  2. do you have to run script every time for all the pages in one particular locale and check whether pages exist other locales or it's just one page and verify whether it is exists on other locales or not? e...

please make sure core components version is which is installed is compatible with AEM version. https://experienceleague.adobe.com/docs/experience-manager-core-components/using/versions.html?lang=en 

Please check https://experienceleague.adobe.com/docs/experience-manager-learn/assets/metadata/custom-smart-tags.html?lang=en . hope this helps you.

If the other users are part of any common group then you can also simply deny the access to that group.