I am trying to read excel file and write it's content into JCR under content folder. For that, I am using ACS AEM Commons Ensure user. I could see that my service user is created and it has root read and content write access. However, I'm not able to create resource resolver object and get the session. I tried to debug the code, when my debugger reaches below step, nothing happens and debugger doesn't move further.
The issue is resolved. I was trying to register service user for com.<myapp>.core as below code, but my OSGi bundle symbolic name was core only, however, I'm not sure why bundle name didn't have artifact id. Ideally, BSN should have GroupID+ ArtifactID or ArtifactID.
Your source code looks correct. It seems like you might be having a system user and Apache Sling User Mapping Situation. Have you set up the Apache sling Service User Mapper Service Amendment Factory configuration? com.mysite.core:excel-service-user=my-system-user or the System User + ACL permissions?
This is not anything I've seen before unless you've made some configuration error. I do have one question though. If the data you are trying to manipulate is under the /content node, why are you using a service user (especially with root access)? Would it not be simpler and safer to use the session?