UCCX 8.5 to 10.5 upgrade CUIC stock reports not appearing

[shyam2014]

Hi Guys,

We have upgraded our UCCX environment from 8.5 to 10.5 hence with HRC gone we are expected to see the stock reports in CUIC. We are unable to view any stock reports in CUIC as this is not a UCCE for which we can import reports from cisco.com.

Is there any issue with which will prevent stocks report from appearing?

[Deepak Rawat · Accepted solution]

Shyam,

The issue you are facing there is happening because of the below defect:

https://tools.cisco.com/bugsearch/bug/CSCup31962/?reffering_site=dumpcr

Please note that you will need to enter the same userid that you want should be the CUIC Super User in all the three commands mentioned in the workaround. In an ideal situation, the CUIC Super User is the Application User created during the installation and is also used to login into Cisco Unified Serviceability page on UCCX

So lets say, your Application User is admin then the commands should be like below:

run sql update mmca_propertydef set defaultvalue='admin' where propertyname='OAMP.Superuser'
run sql delete from cuic_data:cuicuser where name='CUIC\admin' and id!='1111111111111111111111111111AAAA'
run sql update cuic_data:cuicuser set name='CUIC\admin' where id='1111111111111111111111111111AAAA'

After you have performed the workaround, restart the below CUIC services from CLI

utils service restart Cisco Unified Intelligence Center Reporting Service

utils service restart Cisco Unified Intelligence Center Serviceability Service

Please note the above mentioned workaround will only need to be done on Primary UCCX server but the services will need to be restarted on both the UCCX servers (in case of HA)

Regards

Deepak

- Rate Helpful Posts -

[shyam2014]

Hi Deepak,

I actually know about that bug and I already ran these commands. Still in reporting I am not seeing the stock reports.

If you can see the image I can access the report but can't see the stock reports although I have all permission.

I actually updated the role id for admin from 64 to 127.

[Deepak Rawat]

When you login into CUIC, the top right hand section Signed on as shows you logged in as:   CUIC\<userid> or CCX\<userid>

Provide the outputs of below two commands from the Primary UCCX CLI:

run sql select * from cuic_data:cuicuser
run sql select * from mmca_propertydef where propertyname='OAMP.Superuser'  

Regards

Deepak

- Rate Helpful Posts -

[shyam2014]

admin:run sql select * from cuic_data:cuicuser
id version name description partition defaultgroupid sharingpermission alias firstname lastname organization emailaddress contactphone cuicroles timezoneid isactive startoftheweek
================================ ======= ================== ==================================== ========= ================================ ================= ===== ========= ======== ============ ============ ============ ========= ========== ======== ==============
1111111111111111111111111111AAAA 4 CUIC\cuicadmin This is system's super administrator Default 2222222222222222222222222222BBBB 3 Super Admin 127 t 0
BED8CE9E10000151000001D50A86F119 3 CUIC\administrator Default 2222222222222222222222222222AAAA 0 127 t 0
C08145BB10000151000001D70A86F119 1 CCX\ps304070 NULL Default 2222222222222222222222222222AAAA 0 NULL NULL NULL NULL NULL NULL 127 NULL t 0
C082CA6310000151000001DC0A86F119 0 CCX\administrator NULL Default 2222222222222222222222222222AAAA 0 NULL NULL NULL NULL NULL NULL 64 NULL t 0
admin:

admin:run sql select * from mmca_propertydef where propertyname='OAMP.Superuser'
propertydefid propertyname description defaultvalue subsystype ouid
============= ============== ===================================================== ============ ========== ====
80258 OAMP.Superuser The username of the first super user to log into OAMP 0 2

[Deepak Rawat · Accepted solution]

Looking at your output, it looks like that you have not run the workaround properly yet and this is the reason you still have two users as CUIC\ i.e., CUIC\cuicadmin and CUIC\administrator along with one user also listed as CCX\administrator. There should only be one user listed as CUIC\ and the user id as administrator. Please run the below commands exactly as mentioned below followed with the restart of CUIC services

run sql update mmca_propertydef set defaultvalue='administrator' where propertyname='OAMP.Superuser'

run sql delete from cuic_data:cuicuser where name='CUIC\administrator' and id!='1111111111111111111111111111AAAA'

run sql delete from cuic_data:cuicuser where name='CCX\administrator' and id!='1111111111111111111111111111AAAA'

run sql update cuic_data:cuicuser set name='CUIC\administrator' where id='1111111111111111111111111111AAAA'

Regards

Deepak

- Rate Helpful Posts -

[shyam2014]

Hi Deepak,

Thanks a lot for your help. It's nice to have a Cisco expert here. The issue is fixed now. Have a great holiday.

Thanks,

Shyam

[shyam2014]

One query do I need to run 

utils uccx synctocuic all

[Citynet Smartnets]

I was facing a unexpected and RTMT Alert User issue in after our upgrade and the SQL delete query was exactly what I needed. Thanks