Cisco Bug: CSCtc73077 - Extra peresourceprofile causing exception
Jul 04, 2017
- Cisco Unified Communications Manager IM & Presence Service
- Cisco Unified Presence Version 8.0
Known Affected Releases
Symptom: On CUPC - encountering "The server was unable to perform the operation. Please try again later". Conditions: 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 Cisco.com account to be viewed.
Bug Details Include
- Full Description (including symptoms, conditions and workarounds)
- Known Fixed Releases
- Related Community Discussions
- Number of Related Support Cases