Create new Dataset in Analyticsserver -> SSLException: Unrecognized SSL message, planetext connection?

[drichter]

Hi,

I implement a service that create a json and a csv file consisting on a given thing. This both files will be sent via AnalyticsServer_DataThing.CreateDataset() to Analytics. Relatively common I get an SSLException on anyltics (job details):

When it comes to this error it does not work to add a dataset via the analytics mashup either. I get the same error. On Analytics settings SSL is unchecked, and I'm not using a SSL (because I working on a local mashine).

Sometime it help to restart analytics or the maschine where its runs.

PS: I'm using Thingworx 8.1.1-b108 & Analytics 8.1.040000

[mchehaibi]

Hi David,

Could you please paste a sample of your Dataset inccluding the header Line as well as the json metadata file which are created through the service you implemented ?

Best Regards,

Amine

[drichter]

The JSON-File looks so:

[{"fieldName": "id","dataType": "STRING","opType": "INFORMATIONAL"},
{"fieldName": "Temperature","dataType": "DOUBLE","opType": "CONTINUOUS"},
{"fieldName": "Pressure","dataType": "DOUBLE","opType": "CONTINUOUS"},
{"fieldName": "OverheatingError","dataType": "DOUBLE","opType": "CONTINUOUS"},
{"fieldName": "Brightness","dataType": "DOUBLE","opType": "CONTINUOUS"},
{"fieldName": "Concentration","dataType": "DOUBLE","opType": "CONTINUOUS"},
{"fieldName": "timestamp","dataType": "STRING","opType": "INFORMATIONAL"}]

The csv-File looks so:

Brightness,Concentration,id,OverheatingError,Pressure,Temperature,timestamp
75,551,AnalyticsTestThing_1,1,76,63,Thu Jan 11 2018 15:00:40 GMT+0100 (MEZ)
75,733,AnalyticsTestThing_1,1,77,62,Thu Jan 11 2018 15:00:40 GMT+0100 (MEZ)
75,584,AnalyticsTestThing_1,1,70,60,Thu Jan 11 2018 15:00:40 GMT+0100 (MEZ)
75,506,AnalyticsTestThing_1,1,70,60,Thu Jan 11 2018 15:00:40 GMT+0100 (MEZ)
75,556,AnalyticsTestThing_1,1,77,62,Thu Jan 11 2018 15:00:40 GMT+0100 (MEZ)
75,565,AnalyticsTestThing_1,1,79,60,Thu Jan 11 2018 15:00:40 GMT+0100 (MEZ)
....

The error seems quite random. Sometimes its work fine, sometimes I get this error. After a server reboot, it usually work fine - but not always.

[drichter]

Hmm, if I first create a dataset (after start the server) via analytics builder mashup everything are fine and I can create datasets with my code. If I first create dataset with my code I must restart the server to avoid the SSLException. I think the analytics mashup is set something that my code is not set.

A documentation about the AnalyticsServer_xxx Things would be great.

[drichter · Accepted solution]

Ok, problem solved!

For the path of the csv and the json file I used thingworxs://... but this is only for using SSL. Now I use thingworx://... and it works.