12-21-2015 09:50 PM - edited 03-14-2019 03:34 PM
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?
Solved! Go to Solution.
12-21-2015 10:40 PM
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 -
12-23-2015 07:33 AM
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 -
12-21-2015 10:40 PM
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 -
12-22-2015 07:52 PM
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.
12-22-2015 07:59 PM
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 -
12-23-2015 07:03 AM
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
12-23-2015 07:33 AM
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 -
12-23-2015 09:53 AM
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
12-23-2015 10:32 AM
One query do I need to run
utils uccx synctocuic all
12-09-2019 06:13 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide