What were you trying to do that didn't work?

Automation regression failure

Please provide the package NVR for which the bug is seen:

idm-pki-ca noarch 11.6.0-0.3.alpha2.el9 rhel-9.6-AppStream 2.1 M
2025-01-22T17:40:23 idm-pki-kra noarch 11.6.0-0.3.alpha2.el9
389-ds-base-2.6.0-2.el9.x86_64

CTC2 compose : 

http://download.devel.redhat.com/rhel-9/nightly/RHEL-9/RHEL-9.6.0-20250121.2/compose/

How reproducible is this bug?:

Always

Steps to reproduce

1.    pki -d nssdb -c SECret.123 -p 8443 -n 'PKI Administrator for hosted.upshift.rdu2.redhat.com' ca-user-add "Shalini" --fullName "Shalini"
2. pki -d nssdb -c SECret.123 -p 8443 -n 'PKI Administrator for hosted.upshift.rdu2.redhat.com' ca-cert-request-approve 0xd3bcdd35ac504104c9aa81e74c0e6c5
3. pki -d nssdb -c SECret.123 -p 8443 -n 'PKI Administrator for hosted.upshift.rdu2.redhat.com' ca-user-cert-add "Shalini" --serial 0x6f626a0e47e0f87e3167385a54b19016
4. pki -d nssdb -c SECret.123 -p 8443 -n 'PKI Administrator for hosted.upshift.rdu2.redhat.com' ca-user-cert-find "Shalini" 
5. pki -d nssdb -c SECret.123 -p 8443 -n 'PKI Administrator for hosted.upshift.rdu2.redhat.com' ca-user-cert-show "Shalini" "2;148055303691119745832330794814722379798;CN=CA Signing Certificate,OU=pki-tomcat,O=hosted.upshift.rdu2.redhat.com Security Domain;UID=Shalini,CN=Shalini"
6.  pki -d nssdb -c SECret.123 -p 8443 -n 'PKI Administrator for hosted.upshift.rdu2.redhat.com' ca-user-cert-del "Shalini" "2;148055303691119745832330794814722379798;CN=CA Signing Certificate,OU=pki-tomcat,O=hosted.upshift.rdu2.redhat.com Security Domain;UID=Shalini,CN=Shalini"

Expected results

ca-user-cert-show and ca-user-cert-del command should work successfully.

Actual results

ca-user-cert-del Failed with following console output :

PKIException: Internal Server Error

from debug logs :

2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-13] INFO: PKIService: Response format: application/json
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-13] INFO: PKIService: Response class: Account
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: Retrieving user uid=caadmin,ou=People,o=pki-tomcat-CA
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: User uid=caadmin,ou=People,o=pki-tomcat-CA:
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: - uid: caadmin
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: - cn: caadmin
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: - mail: caadmin@hosted.upshift.rdu2.redhat.com
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: - password: ********
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: - type: adminType
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: - state: 1
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem: - cert:
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem:   - serial: 0x3520821d1af7fb8558c4fd245b30c240
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem:   - subject: CN=PKI Administrator,E=caadmin@hosted.upshift.rdu2.redhat.com,OU=pki-tomcat,O=hosted.upshift.rdu2.redhat.com Security Domain
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: UGSubsystem:   - issuer: CN=CA Signing Certificate,OU=pki-tomcat,O=hosted.upshift.rdu2.redhat.com Security Domain
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] INFO: AAclAuthz: Granting execute permission for certServer.ca.users
2025-01-23 12:19:45 [https-jsse-jss-nio-8443-exec-14] SEVERE: Servlet.service() for servlet [org.dogtagpki.server.ca.rest.v1.CAApplication] in context with path [/ca] threw exception
org.jboss.resteasy.spi.UnhandledException: java.util.NoSuchElementException
        at org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:78)
        at org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:222)
        at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:179)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:422)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:213)
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)

Failing tests in automation :
pki-pytest-ansible/pytest/ca/pki_user/user_cert/test_pki_ca_user_cert_del.py

ca-user-cert-show command failed with following error on console :

ResourceNotFoundException: No certificates found for Shalini

Output from debug logs :

2025-01-23 12:38:01 [https-jsse-jss-nio-8443-exec-25] INFO: UGSubsystem:   - subject: UID=Shalini,CN=Shalini
2025-01-23 12:38:01 [https-jsse-jss-nio-8443-exec-25] INFO: UGSubsystem:   - issuer: CN=CA Signing Certificate,OU=pki-tomcat,O=hosted.upshift.rdu2.redhat.com Security Domain
2025-01-23 12:38:01 [https-jsse-jss-nio-8443-exec-25] INFO: PKIExceptionMapper: Returning ResourceNotFoundException
2025-01-23 12:38:01 [https-jsse-jss-nio-8443-exec-25] INFO: PKIExceptionMapper: XML exception:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<PKIException>
    <ClassName>com.netscape.certsrv.base.ResourceNotFoundException</ClassName>
    <Attributes/>
    <Code>404</Code>
    <Message>No certificates found for Shalini</Message>
</PKIException>

Failing automation file :
pki-pytest-ansible/pytest/ca/pki_user/user_cert/test_pki_ca_user_cert_show.py

test_pki_ca_user_cert_add_with_i18n_character