JSON does not allow non-finite numbers for infotable creation

[hjimene3]

Hey guys!

I'm working on creating a chart bar for a series of boolean tags that identify errors from a process.

In this case, the chart bar shows the total of times an error appears during an specific period of time. What I did for this was creating two services, the first one adds a "1" for each error into a stream everytime its value it's "true" and the second service does the addition of each 1 for every error in the stream to create an infotable that allows me to put these results into the chart. 

However, this testing was made with 5 errors, but the real process has 511 and when trying to test this, I get a "JSON does not allow non-finite numbers" error when executing the service. I really think the service created may be inneficient for the amount of tags there are, so I was wondering what would you suggest for creating the services to allow me to see these 511 errors in the bar chart? or maybe your suggestions to see this amount of tags as bar charts.

Thanks for your help!

P.S. I'm attaching the two services I created in .txt

The above table is what I'm trying to get:

[VladimirN · Accepted solution]

A question with a description of a similar error was previously - "Totaling valuestream - JSON does not allow non-finite numbers problem": https://community.ptc.com/t5/ThingWorx-Developers/Totaling-valuestream-JSON-does-not-allow-non-finite-numbers/td-p/584993

Also some helpful articles:

• "Problems accessing services in Thingworx and experiencing major CPU spikes in Thingworx 7.3": https://www.ptc.com/en/support/article/CS267063
• "Enhancement request: ThingWorx platform to handle NaN numerical values": https://www.ptc.com/en/support/article/CS267450
• "ThingWorx Analytics - Time Series Training job with Boolean goal not rendering Model Results": https://www.ptc.com/en/support/article/CS309814

[Sathishkumar_C]

what is the data shape fields of "StreamNumerico" stream? Usually this issue occurs while trying to insert (1/0 = infinity or any string = NaN) kind of numbers.

[hjimene3]

Hi @Sathishkumar_C , thanks for the feedback. Precisely, there were some NaN values I wasn't aware of. I'm marking @VladimirN as accepted solution since he gave the first answer.

Thanks to both of you!

[VladimirN]

You're welcome.