Preview Tool

Cisco Bug: CSCtc73077 - Extra peresourceprofile causing exception

Last Modified

Jul 04, 2017

Products (2)

  • Cisco Unified Communications Manager IM & Presence Service
  • Cisco Unified Presence Version 8.0

Known Affected Releases


Description (partial)


On CUPC - encountering "The server was unable to perform the operation. Please try again later".


Looging on a test User in Tupelo Sanity Environment

The user with the issue has a duplicate peresourceprofile entry.  Test for a duplicate entry by running the CLI command
run sql select rp.pkid rp_pkid, eu.pkid eu_pkid from peresourceprofile rp inner join enduser eu on rp.fkenduser = eu.pkid where rp.tkperesourceprofile = 0 and eu.userid = 'auser'; 
(replacing auser with the real userid)
If more than one row is returned,  there is a duplicate entry issue.

The epassoap log files show an exception:
 java.sql.SQLException: A subquery has returned not exactly one row.
Bug details contain sensitive information and therefore require a account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.