CUIC 11_0_1_11001_43 : Cannot use filter function Error. updating the filter information. com.cisco.ccbu.cuic.objectmodel.CuicHibernateException

[syahrulngadim]

Hi,

While I am trying to run the any report on CUIC I am getting below mentioned error.

updating the filter information. com.cisco.ccbu.cuic.objectmodel.CuicHibernateException.

UCCX ver : 11.0.1.11001-43

Note : All service is normal

[bill.king1]

This bug says it is for 10.6 but seems to match the issue you're having as far as error message, no collections displayed, etc.

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCux63026

[syahrulngadim · Accepted solution]

Hi Bill,

Thanks for your reply.
I've solved this. I am Running the below commands for UCCX Pub and Sub, could resolve the issue temporarily:

run sql delete from cuic_data:cuicdataset
run sql delete from cuic_data:cuicstatisticsdatasets
run sql delete from cuic_data:cuicstatisticsviews
run sql delete from cuic_data:cuicdatasetreplicated

utils service restart Cisco Unified Intelligence Center Reporting Service
utils service restart Cisco Unified Intelligence Center Serviceability Service

If the commands above didn't resolve the issue, please contact TAC to run the cleanupshell.sh script with root access.

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvg04634

Thanks