Skip to main content
D
drichter1-Visitor
1-Visitor
January 11, 2018
Solved

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

  • January 11, 2018
  • 4 replies
  • 3774 views

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):

b4973fae-6d3b-434a-9179-69a4deb391ef.png

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

Best answer by drichter

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.

4 replies

M
mchehaibi5-Regular Member
5-Regular Member
January 11, 2018

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

D
drichter1-VisitorAuthor
1-Visitor
January 11, 2018

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.

D
drichter1-VisitorAuthor
1-Visitor
January 16, 2018

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.

Terms & ConditionsAccessibility statement