not able to connect to thingworx

Question

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.

VP_8991104 · Accepted Answer

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

VladimirN · Answer

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

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded