cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

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

drichter
14-Alexandrite

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
drichter
14-Alexandrite
(To: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.

View solution in original post

4 REPLIES 4
mchehaibi
5-Regular Member
(To:drichter)

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
14-Alexandrite
(To:mchehaibi)

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
14-Alexandrite
(To: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
14-Alexandrite
(To: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.

Top Tags