Re: UCCX 8.5 Historical Report Data Missing

Helmi Muzammil · ‎10-31-2017

Hi All,

We Have UCCX 8.5 HA. I have a problem when generate any agent report Oct 28-31 ( Agent Summary, Agent Detail, Login Logout ) from Historical Report.

Error : There were no report data view in the date range selected. Please select a different date range by changing the start date/time or the end date/time and try again.

I also try to direct query from CLI by using this command :

run uccx sql db_cra call sp_agent_log_activity('2017-10-29 07:00:00','2017-10-29 21:00:00','0','NULL',null,null,null)

and reply with : No records found

What should i check?

Appreciate for your help.

Vinod Patil · ‎10-31-2017

Hi Helmi Muzammil,

I only suggest to narrow down the filter like Run for only one hour and check.

Never worked on 8.5 UCCX reporting tool but I know in new version from UCCX 10.5 Cisco has introduced new reporting tool called CUIC and it has limitations like we can have only 8000 rows for each run of historical report, if it exceeds the limitation we get the same error. so you narrow down the filter like run between 30/10/2017 07:00:00 to 30/10/2017 08:00:00, if it has option to filter the agents then select fewer agents, I am sure you will get some data.

I hope this was helpful

Best regards,

Vinod

Helmi Muzammil · ‎10-31-2017

Hi Vinoy,

Thank you for your suggestion.

I have tried it and resulting the same message "No record found".

Thanks,

Vinod Patil · ‎10-31-2017

If you believe there is data then another way is to connect RazorSQL to UCCX and run the stored procedure, i do not think Cisco can support 8.5

Regards,

Vinod.

Helmi Muzammil · ‎10-31-2017

Hi Vinod,

I have tried to run the Store Procedure directly from the CLI and got the report in October 27th

admin:run uccx sql db_cra call sp_agent_log_activity('2017-10-27 07:00:00','2017-10-27 08:00:00','0','NULL',null,null,null)
AGENT_NAME      AGENT_LOGIN_ID AGENT_EXTENSION OP1     LOGIN_TIME      OP2     LOGOUT_TIME     LOGOUT_REASON_CODE      LOGON_DURATION LATESTSYNCHEDTIME
----------------------------------------------------------------------------------------------------------------------------
------- ------- null    null    null    null    null    null    -8888   2017-10-18 10:06:57.0
Indra Daud      iddaudin        8310    <       null    null    2017-10-27 07:47:08.447 32765   null    2017-10-18 10:06:57.0
Indriani ZZ     IDINDRIANZZ     8392    <       null    null    2017-10-27 07:00:47.855 8       null    2017-10-18 10:06:57.0
Jemmy Andriansyah       idandrianje     8329    <       null    null    2017-10-27 07:21:37.829 32765   null    2017-10-18 10:06:57.0
Jemmy Andriansyah       idandrianje     8329    null    2017-10-27 07:34:33.431 null    2017-10-27 07:54:44.637 32765   1211    2017-10-18 10:06:57.0
Jemmy Andriansyah       idandrianje     8329    null    2017-10-27 07:58:02.995 >       null    null    null    2017-10-18 10:06:57.0
Jonferianson Simanjorang        IDSIMANJO       8433    <       null    null    2017-10-27 07:36:02.414 0       null    2017-10-18 10:06:57.0
Jonferianson Simanjorang        IDSIMANJO       8433    null    2017-10-27 07:36:13.834 >       null    null    null    2017-10-18 10:06:57.0
Maiyori Tama    IDTAMAMA        8696    <       null    null    2017-10-27 07:36:08.146 32765   null    2017-10-18 10:06:57.0
Maiyori Tama    IDTAMAMA        8696    null    2017-10-27 07:37:54.794 >       null    null    null    2017-10-18 10:06:57.0
Muhammad Fajrul Muharrom        idmuharromu     8636    <       null    null    2017-10-27 07:39:38.281 32765   null    2017-10-18 10:06:57.0
Muhammad Fajrul Muharrom        idmuharromu     8636    null    2017-10-27 07:40:10.904 >       null    null    null    2017-10-18 10:06:57.0
Retno Astuti    IDASTUTIRE1     8328    null    2017-10-27 07:11:09.163 >       null    null    null    2017-10-18 10:06:57.0
Siti Fatimah    IDFATIMAHSI     8360    <       null    null    2017-10-27 07:25:15.428 8       null    2017-10-18 10:06:57.0
Siti Fatimah    IDFATIMAHSI     8360    null    2017-10-27 07:32:34.236 null    2017-10-27 07:52:52.864 8       1218    2017-10-18 10:06:57.0
Syarif Hidayat idhidayatsy     8607    null    2017-10-27 07:11:35.336 >       null    null    null    2017-10-18 10:06:57.0
Teddy Supriady idcotedd        8620    <       null    null    2017-10-27 07:38:38.219 32765   null    2017-10-18 10:06:57.0
Tria Maryanah   idmaryanatr     8336    null    2017-10-27 07:42:04.008 >       null    null    null    2017-10-18 10:06:57.0
arifudin Arifudin       IDARIFUDI       8572    <       null    null    2017-10-27 07:45:38.415 32765   null    2017-10-18 10:06:57.0
arifudin Arifudin       IDARIFUDI       8572    null    2017-10-27 07:57:36.237 >       null    null    null    2017-10-18 10:06:57.0
retno Astuti    IDASTUTIRE      8347    <       null    null    2017-10-27 07:00:47.35 8       null    2017-10-18 10:06:57.0
zz Indriani     IDINDRIANZZ2    8394    null    2017-10-27 07:02:13.652 >       null    null    null    2017-10-18 10:06:57.0

if i tried more than october 27

admin:run uccx sql db_cra call sp_agent_log_activity('2017-10-28 07:00:00','2017-10-28 08:00:00','0','NULL',null,null,null)
AGENT_NAME AGENT_LOGIN_ID AGENT_EXTENSION OP1 LOGIN_TIME OP2 LOGOUT_TIME LOGOUT_REASON_CODE LOGON_DURATION LATESTSYNCHEDTIME
----------------------------------------------------------------------------------------------------------------------------

No records found

Command successful.

Thanks

Vinod Patil · ‎10-31-2017

This means reports are working fine but there is no data in UCCX DB

Helmi Muzammil · ‎10-31-2017

Hi Vinod,

Why there is no data in UCCX DB? before October 28th everything was working well?

Is it impacted to the UCCX DB if i query the SQL directly from the CLI?

Becaise The last change we have done is directly query on CLI in October 27th.

Many Thanks

Vinod Patil · ‎10-31-2017

I am not sure if there is data or not in UCCX but sure that It does not impact the UCCX if query to DB. Here is the document which might help you

https://www.cisco.com/c/en/us/support/docs/customer-collaboration/unified-contact-center-enterprise/112103-ipcc-data-00.html#topic1

OwL · ‎07-30-2020

Hi Helmi

Did you solve this issue ?