Skip to main content
J
JS_103697425-Regular Member
5-Regular Member
January 16, 2023
Solved

ThingWorx Analytics Model Creation Failed

  • January 16, 2023
  • 1 reply
  • 2480 views

I have imported a time series data in dataset of Thingworx Analytics Builder with three fields Temporal (DateTime), Goal (Continuous) and Entity_ID (Int). 

 

When i tried to build a Analytics Model with Lookback size 2 and lookahead size 1, I am getting an error "java.lang.IllegalArgumentException: Comparison method violates its general contract!" 

JS_10369742_0-1673870283105.png

 

Model Configurations I tried are as follows:

 

JS_10369742_1-1673870376775.pngJS_10369742_2-1673870406926.png

 

It would be helpful if someone can help/guide for this.

Thanks in Advance!

Best answer by cmorfin

Hi @JS_10369742 

 

Thank you for this.

It appear that the date are not chronologically ordered in your csv file.

Especially all the date at midnight are not in the right order.

For example:

12/29/2004 21:00,17093,1
12/29/2004 22:00,16736,1
12/29/2004 23:00,15984,1
12/30/2004 00:00,14900,1
12/28/2004 01:00,17580,1
12/28/2004 02:00,17158,1
12/28/2004 03:00,17002,1

 

notice that 12/30/2004 00:00  is between 12/29/2004 23:00 and 12/28/2004 01:00

 

Can you make sure the date time are correctly ordered and try again ?

 

Thanks

Christophe

 

1 reply

C
cmorfin19-Tanzanite
19-Tanzanite
January 16, 2023

Hi @JS_10369742 

 

Could you please confirm what version of ThingWorx Analytics you are using.

Also is it possible for you to upload the dataset.csv file you are using so we can make a test ?

 

Thanks

Christophe

 

 

J
JS_103697425-Regular MemberAuthor
5-Regular Member
January 16, 2023

Hi  cmorfin,

 

Thank You for your reply!

 

I am using Thingworx Analytics 9.3.4.

PFA csv file which i am using as dataset.

 

Thanks,

Jayesh Sharma

C
cmorfin19-TanzaniteAnswer
19-Tanzanite
January 16, 2023

Hi @JS_10369742 

 

Thank you for this.

It appear that the date are not chronologically ordered in your csv file.

Especially all the date at midnight are not in the right order.

For example:

12/29/2004 21:00,17093,1
12/29/2004 22:00,16736,1
12/29/2004 23:00,15984,1
12/30/2004 00:00,14900,1
12/28/2004 01:00,17580,1
12/28/2004 02:00,17158,1
12/28/2004 03:00,17002,1

 

notice that 12/30/2004 00:00  is between 12/29/2004 23:00 and 12/28/2004 01:00

 

Can you make sure the date time are correctly ordered and try again ?

 

Thanks

Christophe

 

Terms & ConditionsAccessibility statement