Problem:
UCCX realtime reports not being displayed in walboard
UCCX version = 8.5
From UCCX MIVR logs we see below messages
431771: Dec 01 23:11:28.858 PST %MIVR-ICD_RTDM-3-WRITER_EXCEPTION:An exception has been caught by Real-time Snapshot data writer: A description for the nature of the exception=Writing RtCSQsSummary,Exception=javax.persistence.PersistenceException: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: [com.cisco.persistence.entities.RtcsqssummaryEntity#US_PL_KONE_ENG_Q]
431772: Dec 01 23:11:28.858 PST %MIVR-ICD_RTDM-3-EXCEPTION:javax.persistence.PersistenceException: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: [com.cisco.persistence.entities.RtcsqssummaryEntity#US_PL_KONE_ENG_Q]
This means there is a duplicate entry in the CSQ (US_PL_KONE_ENG_Q ) table in UCCX db_CRA
in Customer scenario in UCCX appadmin page we see 2 CSQ with same name US_PL_KONE_ENG_Q
Solution:
1.In my Scenario Customer rename one CSQ. else we can delete both the CSQs by noting down the config and add it again via appadmin page.
2.Restart the UCCX Engine (Primary First &Secondary )
3.Tested the results
4.Realtime data are getting in to UCCX system as well as wallboard
5.We can verify this by running following command in UCCX server
run uccx sql db_cra select * from RTCSQsSummary