My Oracle Support Banner

Updating a Certification Line Item with REST Fails with HTTP error 500: "getSingleResult() did not retrieve any entities." (Doc ID 2711634.1)

Last updated on APRIL 27, 2023

Applies to:

Identity Manager - Version and later
Information in this document applies to any platform.


A certification reviewer got the following certification to review containing 3 line items:



The reviewer wants to certify the entitlement Entitlement2 so he performs the following chain of REST calls


.Run a GET on the certifications endpoint to see the certifications he got assigned



.Using the href associated to the certification task from the previous call http://$OIM_HOST:$OIM_PORT/iam/governance/selfservice/api/v1/certifications/1/tasks/8b3f91f6-51d2-43da-a8ee-9a6c1c20d253 add /lineitems/1 to get all the lineitems associated to the and run a GET



With the above call the reviewer knows that the line item number associated to Entitlement2 is 2 (see value entityId : 2)


Now the reviewer will send the following payload using a PUT to certify Entitlement2:

   "lineItemDetails": [
         "entityId": 2,
         "entityType": "Entitlement",
         "action": "certify",
         "fields": [
                "name": "comment",
                "value": "Certified"


as shown below:


The call will fail with:

"title": "getSingleResult() did not retrieve any entities.",
"status": 500,
"detail": "getSingleResult() did not retrieve any entities.",
"instance": "javax.persistence.NoResultException",



and logs will capture the following stack trace:

[2020-09-16T18:02:05.360-06:00] [XXX] [ERROR] [] [] [tid: [ACTIVE].ExecuteThread: 'XX' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: XXXX] [ecid: XXXX] [APP: oim] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: XXXX] Exception[[

javax.persistence.NoResultException: getSingleResult() did not retrieve any entities.

at org.eclipse.persistence.internal.jpa.QueryImpl.throwNoResultException(

at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(

at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(

at oracle.iam.certification.dao.jpa.JpaUserCertificationDaoImpl.getUserAccountByEntityId(

at oracle.iam.certification.manager.impl.UserCertificationManagerImpl.certifyUserAccount(

at oracle.iam.certification.manager.impl.UserCertificationManagerImpl.certifyUserAccount(

at oracle.iam.certification.impl.CertificationServiceImpl.certifyUserEntitlements(


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.