This document is designed to help troubleshoot some commonly seen issues while installing or upgrading the ThingWorx application, prior or instead of contacting Tech Support. This is not a defined template for a guaranteed solution, but rather a reference guide that provides an opportunity to eliminate some of the possible root causes.
While following the installation guide and matching the system requirements is sufficient to get a successfully running instance of ThingWorx, some issues could still occur upon launching the app for the first time. Generally, those issues arise from minor environmental details and can be easily fixed by aligning with the proper installation process.
Currently, the majority of the installation hiccups are coming from the postgresql side. That being said, the very first thing to note, whether it's a new user trying out the platform or a returning one switching the database to postgresql, note that: Postgresql database must be installed, configured, and running prior to the further Thingworx installation.
Generally, this type of error point at the security/permission issue. As all of the installation operations should be performed by a root/Administrator role, the following points should be verified:
The error means that the postgres user was not able to create a directory in the ‘ThingworxPostgresStorage’ directory. As it's related to the security/permission, the following steps can be taken to clear out the error:
2. Installation error message "relation root_entity_collection does not exist" is displayed with Postgresql version of the ThingWorx platform.
Such an error message is displayed only if the schema parameter passed to thingworxPostgresSchemaSetup.sh script is different than $USER or PUBLIC. To clear out the error:
Other common errors upon launching the application.
Two of the most commonly seen errors are 404 and 401. While there can be a numerous reasons to see those errors, here are the root causes that fall under the "very likely" category:
Again, it should be kept in mind that while the symptoms are common and can generally be resolved with the same solution, every system environment is unique and may require an individual approach in a guaranteed resolution.
Basic troubleshooting points for:
psql:./thingworx-database-setup.sql:14: ERROR: could not create directory "pg_tblspc/16419/PG_9.4_201409291/16420": No such file or directory
psql:./thingworx-database-setup.sql:16: ERROR: database "thingworx" does not exist
Replacing /ThingworxPostgresqlStorage in the .bat file by C:\ThingworxPostgresqlStorage and omitting the -l option in the command window.
Also, note the following error Troubleshooting Syntax Error when running postgresql set up scripts
Hi, I am trying to swith from TWX 6.5 Neo4j to 7.1
And I am stuck with the 401 error on Windows 10
Nothing to do, I always get the "HTTP 401 - Could not handle request"
How do you verify if the DB is correctly linked?
Where is the "installation guide" you mention?
Are you forced to use POstgre? Was all Neo4j compatibility removed?
Thanks in advance.
@Pierre D, The installation guide is in the support site's reference documents. Just an FYI, ThingWorx recommends to use Postgresql 9.4.x. I had issues with Postgresql 9.5.
Also, please post the issue as a forum question. So that you can get a broader assistance from the community.
Please share the links to obtain the below batch files,
Thanks in Advance.
You can download these batch files from PTC eSupport portal using your Customer Name and Number. You will need valid credentials to login to eSupport portal.
On PTC Software Download page with selection as Thingworx Platform and search for Thingworx PostgreSQL under Releases. You will get a download file as MED-61111-CD-070_F000_ThingWorx-Platform-Postgres-7-x-x as per the release selected. On unzipping this you will have the required files inside Update folder.
After following every required step even,I'm getting 404 Error with message "
Could you please open a separate thread with the issue? We could troubleshoot it there, and upon disocvering the root cause, possibly update this article (as this serves as a reference only). Thank you!