Unity Connection - A subquery has returned not exactly one row.
I recently had a Unity Connection Publisher go down and my Subscriber go down as well. When they came back up a realized that they were not communicating with each other due to a bad DNS record. I changed cluster settings to find the subscriber using an IP address and they are now acting as intended, Publisher/Subscriber. However when trying to modify some user information(mainly resetting passwords) I recieve the error " A subquery has returned not exactly one row." Any ideas? I'm leaning towards this being a database issue. Is there a way to repair the database?
UPDATE: I cannot make any changes to said users. When I try to change anything on them I get thrown a "database.error.-284".
Definitely sounds like a database issue that may be caused by a bad host file/reference in replication (not sure the nature of your DNS issue so this is an educated guess). The first thing I'd do is log into the CU Admin page of each server separately and attempt to modify a user to see if you get the same behavior on both servers or just one. I'd also check the DB replication and CUC cluster status as well. You may be able to simply stop/start replication but you may need to use the overwrite DB command to clear things up. Never a bad idea to open a TAC case when you have an issue like this as well.
New Cisco Champion Radio release on Zero Trust for WebexListen: https://smarturl.it/CCRS8E14 Follow us: https://twitter.com/CiscoChampion Cisco introduced End to End (E2E) Encryption in 2008 as a Webex Meeting option where only the me...
Community Live- Tour of the Real-Time Monitoring Tool
(Live event - Tuesday, 20 April, 2021 at 10:00 am Pacific/ 1:00 pm Eastern / 7:00 pm Paris)
This event will have place on Tuesday 20th, April 2021 at 10:00 hrs PDT
Learn: How to configure Cloud Connected PSTN with Webex Calling
CCP Provider Name
Product Home Page Link
Webex Calling Region
Countries Supported by Provider
Free Trial Link
Contact Provider Link
FR & LU
Meet the Authors Video - Leveraging SBCs to Empower a Changing World of Collaboration
(Live event – Tuesday, 16th, 2020 at 10:00 a.m. Pacific / 1:00 p.m. Eastern / 7:00 p.m. Paris)
This event had place on Tuesday 16th, February 2020 at 10am PST ...
This event had place on Tuesday 16th, February at 9:30am PST
The need for virtual collaboration across individuals, teams, organizations, and industries has been significantly changed with the global challenges presented in 2020. The indust...