My Oracle Support Banner

Warning in Soa server due to DB resiliency:javax.persistence.NonUniqueResultException: More than one result was returned from Query.getSingleResult() (Doc ID 2926763.1)

Last updated on JUNE 04, 2024

Applies to:

Oracle SOA Suite - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Goal

Below error trace is observed in soa server out logs
...
Warning> <oracle.soa.tracking.business.resiliency.DBAllocatedSpaceMetricResiliencyManagerImpl> <SOA-66076> <Error while retrieving DB allocated space used percent.
javax.persistence.NonUniqueResultException: More than one result was returned from Query.getSingleResult()
       at org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:985)
       at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:534)
       at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
       at oracle.soa.tracking.business.persistence.jpa.DBHealthHandlerImpl$OracleDBHealthHandler.getTableSpaceName(DBHealthHandlerImpl.java:633)
       at oracle.soa.tracking.business.persistence.jpa.DBHealthHandlerImpl$OracleDBHealthHandler.getUsedPercent(DBHealthHandlerImpl.java:542)
       at oracle.soa.tracking.business.persistence.jpa.DBHealthHandlerImpl.getUsedPercent(DBHealthHandlerImpl.java:217)
       at oracle.soa.tracking.business.resiliency.DBAllocatedSpaceMetricResiliencyManagerImpl.checkMetricsPull(DBAllocatedSpaceMetricResiliencyManagerImpl.java:129)
       at oracle.soa.tracking.business.resiliency.ResiliencyManagerImpl.onPullTimeout(ResiliencyManagerImpl.java:239)
       at oracle.soa.tracking.business.resiliency.timer.DBSpaceMonitoringTimer$TimerResiliencyTask.run(DBSpaceMonitoringTimer.java:358)
       at java.util.TimerThread.mainLoop(Timer.java:555)
       at java.util.TimerThread.run(Timer.java:505)



 

Solution

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
Goal
Solution
References


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