HTTP Status 500 – Internal Server Error with Thingworx MFG

[meliu]

Hi Team，

There‘s 'HTTP Status 500 – Internal Server Error' when I open Thingworx MFG Apps in browser. The error shows 'java.lang.NullPointerException' message.

I opened the MFG Apps with nothing wrong yesterday. I tried to restart the Configure PTC Servlet Engine, but it still shows the same.

I don't know how to deal with it, could you please help me? Thank you!

The error is like shown below:

[hrajpal]

Greetings Mengjue Liu,

The instance is not able to create connection with the database . The error thrown in the application logs is :

2017-11-09 09:44:10.354+0800 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Connections could not be acquired from the underlying database!].

Try restarting the services again after clearing the cache.

Regards,

Himesh Rajpal

[meliu]

Hi Himesh,

Thank you for replying !.

I tried to cleared the cache and restart the service. It shows the 'An exception occurred processing JSP page /login/FormLogin.jsp at line 390' message.

The page is as shown below:

The Application logs is as shown below:

2017-11-09 11:52:46.892+0800 [L: ERROR] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-9080-exec-2] Error [authenticating connection], Server websocket will be closed.  cause: Server EndpointContainer was not initialized!  Make sure the Communication Subsystem is configured/enabled!

2017-11-09 11:52:46.892+0800 [L: WARN] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-9080-exec-2] Server WebSocket closed unexpectedly and has already been unregistered from Server Endpoint [ws session id: b3] java.io.IOException: An established connection was aborted by the software in your host machine

2017-11-09 11:52:46.892+0800 [L: INFO] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-9080-exec-2] Server WebSocket is closing and has already been unregistered from Server Endpoint [ws session id: b3] CloseReason: code [1011], reason [Error [authenticating connection], Server websocket will be closed.]

2017-11-09 11:52:46.892+0800 [L: WARN] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-9080-exec-2] Server WebSocket closed unexpectedly and has already been unregistered from Server Endpoint [ws session id: b3] null

Cloud you please help me again?Thank you!

Best Regards,

Mengjue

[hrajpal]

Hi Mengjue,

Is this error thrown after you logged in to the Welcome page ?

Could you please attach the application logs after you did the restart ?

Thanks,

Himesh Rajpal

[hrajpal · Accepted solution]

Hi Mengjue,

The issue was related to the database service .

Restart of Postgres and ThingWorx server service resolved the issue.

Thanks,

Himesh Rajpal