Skip to main content
Oct 10, 2017 12:56 PM UTC
Question

Error invoking service on ThingWorx Analytics Builder mashup

Hi,

After trying to delete a dataset from ThingWorx Analytics Builder mashup i got the following error:

Error invokins service: Wrapped java.net.SocketException: Connectionreset Cause: Connection reset.

Screenshot-2017-10-10 ThingWorx Analytics Builder.png

In the application monitoring i see:

Screenshot-2017-10-10 ThingWorxMonitor.png

In the application log (attached) i read a lot of:

2017-10-10 14:39:33.817+0200 [L: WARN] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-8080-exec-5] Server WebSocket closed unexpectedly and has already been unregistered from Server Endpoint [ws session id: 0] An established connection was aborted by the software in your host machine

2

I do not see anymore any dataset, model and in the settings area, clicking on "verify configuation": There are 0 datasets configured in this Analytics Server.

How can i fix it?

THank you

10 replies

Oct 10, 2017 2:09 PM UTC

Hi Marco

Could you give some more info as below:

- are ThingWorx Platform and ThingWorx Analytics installed on the same machine or different ?

- on which OS version is ThingWorx Analytics installed ?

- is it a new / recent installation or has been used for some time (how much) ?

- Could you send the output of the followign commands:

docker ps -a

docker logs analytics

Note if using Windows 7 and Docker Toolbox, you will need to execute eval "$(docker-machine env DockerMachinePTC)" prior executing the above 2 commands

Thank you

Christophe

Oct 11, 2017 9:02 AM UTC

Hi,

i have 2 environments in 2 different VM but in the same server.

ThingWorx Platform 8 in Windows Server 2008 and Analytics 8 in CentOS.

Here the result from the commands:

docker -ps a

Schermata 2017-10-11 alle 10.49.03.png

logs analytics:

Schermata 2017-10-11 alle 10.53.23.png

Marco

Oct 11, 2017 9:50 AM UTC

Hi Marco

Thank you for this.

This does not show much.

Coudl you pelase perform the following commands:

sudo docker logs analytics > analytics.log

sudo docker cp a5713fcb9dbd:/opt/gridworker/logs .  (the command does end with a . )

sudo docker logs community_postgres > postgres.log

then attach the 3 files analytics.log, postgres.log and zip the logs directory of gridworker1.

Also prior to this issue happen, do you remember performing anything on the analytics server , maybe run again the installer or some other installer, stop some containers , install new component/patches , or possibly a forced shutdown of the VM ... ?

Thank you

Kind rgeards

Christophe

Oct 11, 2017 10:29 AM UTC

Ok,

i surely not run any installer, the unique thing i have done it was running and stopping microservices but  it happened many weeks ago (meanwhile it worked fine) !).Finally, no new components was installed and no forced shutdowns was done.

After the error was show up i restarted  Windwos VM (Thingworx platform) but nothing change.

i attached the logs.

Thanks you

Oct 11, 2017 3:18 PM UTC

Hi Marco

Could you send me also the zookeeper log, I see some error related to that: sudo docker logs zookeeper > zookeeper.log

Also could you confirm when this happens, so I look at the right time range in the logs ?

Thank you

Kind rgeards

Christophe

Oct 11, 2017 3:38 PM UTC

here the zookepper log attached.

Marco

Oct 12, 2017 8:28 AM UTC

Hi Marco

Thank you for this.

I do not see so far anything that would explain the dataset to disappear.

Are you sure you did not maybe revert to a previous snapshot in the VM ?

Also could you send me the follwoign files (I am still trying to find something):

- Complete <ThingworxStorage>/logs/ (including the archive subfolder)

- analyticsLS.txt and pgLS.txt created by the followign commands:

sudo docker exec -i -t analytics ls -lR /opt/analytics/data > analyticsLS.txt

sudo docker exec -i -t community_postgres ls -lR /var/lib/postgresql/data/base > pgLS.txt

Thank you

Kind regards

Christophe

Oct 12, 2017 10:24 AM UTC

Here the new 2 logs file.

Until now we do not have snaphost of this VM, so i did not  revert action.

Marco