ThingWorx Analytics Model Creation Failed

[JS_10369742]

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!" 

Model Configurations I tried are as follows:

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

Thanks in Advance!

[cmorfin]

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

[JS_10369742]

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

[cmorfin · Accepted solution]

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