Workspace single score reports are showing a negative value (minus one)

Sebas Di Loreto · ‎05-18-2021

The OOB "chats queuing" single score report is showing -1 (minus one) when it is an impossible situation.
The report counts awa_work_items in "pending accept" OR "queued" states. You cannot COUNT a negative amount...
This report is a "data visualization" component in a workspace landing page. It has the "single score live updates" checked.

Anybody knows why is this happening?

PRB1102005 sort of refers to it but it is an old PRB that was fixed on London back in 2018

If I helped you with your case, please click the Thumb Icon and mark as Correct.

Aitor Cabello · ‎05-10-2022

Hi,

Docs:

https://docs.servicenow.com/en-US/bundle/sandiego-now-intelligence/page/use/dashboards/task/enable-r...

KB:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0693812

Mark if you found it useful

Regards.

View solution in original post

Sebas Di Loreto · ‎11-04-2022

I was finally able to reproduce this issue at will by commenting out the current.update() line on an AFTER business rule for the table where the report is running.

This issue is described on KB article KB0693812 and can happen going UP or DOWN.

Do this to solve your issue:

Pay attention to the report where you are seeing the negative number.
Take note of the table where that report is running. Let's say is the incident table.
Then type on the left nav: incident.config
While on the business rule tab and the following conditions:
1. When IS after
2. Script CONTAINS current.update()
Check all business rules and experiment by commenting out the line with current.update()
You will need to figure out if the "offending" business rule can be turn into a BEFORE (order 10000) one for example

If I helped you with your case, please click the Thumb Icon and mark as Correct.

View solution in original post

mballinger · ‎08-10-2021

Quebec with that latest patch

MG Casey · ‎09-02-2021

We are seeing the same issue - did you report this to ServiceNow Support?

Javier10 · ‎10-28-2021

Dear all,

I'm going through the same issue in Quebec Patch 7. Were you able to find any fix/solution for this?

There are more users reporting the same, but apparently there's nothing in /support, neither a known error or open problem.

Best regards,

Javier

Seike · ‎12-28-2021

Hello team,

were any of you able to resolve this issue? I am seeing this from time to time.

Thanks!

Sebas Di Loreto · ‎02-24-2022

I am still seeing this issue. Our instance is on Quebec Patch 10.

I could not find yet any solution or how to prevent it.

If I helped you with your case, please click the Thumb Icon and mark as Correct.