not able to connect to thingworx

[VP_8991104]

We got a popup saying - "Unable to execute service SpotlightSearch on SearchFunctions : Unable to get search entries: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.". When we tried to clear storage space in server, we lost connection with thingworx.

Database log:

[T: http-nio-8080-exec-21] Unexpected exception while trying to get all avatars from the database.

Application log:

[T: FileTransfer-5] Error removing job reservation or removing job from database. 

[L: ERROR] [O: c.t.s.s.f.e.FileCopyTask] [I: ] [U: ] [S: ] [P: ] [T: FileTransfer-6] Error occurred during transfer.

[VladimirN]

Read the following articles: 

• "Error "FATAL: sorry, too many clients already" reported in PostgreSQL in ThingWorx Platform": https://www.ptc.com/en/support/article/CS273381
• "ThingWorx Composer displays popup error "REST service failure"": https://www.ptc.com/en/support/article/CS313633
• "Server is unresponsive with an error "Unable to execute SpotlightSearch on SearchFunctions" in ThingWorx": https://www.ptc.com/en/support/article/CS34104

A similar topic was previously - "Issue on Thingworx Composer": https://community.ptc.com/t5/ThingWorx-Developers/Issue-on-Thingworx-Composer/td-p/510468 

[VP_8991104 · Accepted solution]

Postgress DB connection were disabled. Once it is enabled thingworx started working.