Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Hello,
I have placed the war file in tomcat installation location and started tomcat but licence file is not created. Please find the attached logs.
Hi,
You have some errors with connectivity to Postgres database. Please check the article: https://www.ptc.com/en/support/article?n=CS235937
After platform is starting, you will see new file called LicenseRequestFile.txt that will contain the device ID needed for licensing, not the license itself. Please see this article for licensing part: https://www.ptc.com/en/support/article?n=CS271439
Thank you,
Raluca Edu
After platform is starting, i cannot see new file called LicenseRequestFile.txt that will contain the device ID needed for licensing.Following error i am getting
2019-10-04 18:42:30.812+0530 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] [message: Connections could not be acquired from the underlying database!]
2019-10-04 18:42:30.977+0530 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: main] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
2019-10-04 18:42:30.978+0530 [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: main] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing
2019-10-04 18:42:30.980+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]
2019-10-04 18:42:30.981+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] *** Web Application STATE is being set to ERROR! ***
Hi @isha.
From the log snippet you provided, you still haven't corrected the connectivity issue with the database. When you connect to the database using pgAdmin, how many tables do you see? It could be that the database was not created successfully. Did you get any errors when running the scripts to create the db?
Regards.
--Sharon
Hi @isha.
I can see that you have 58 tables which is expected for the version of ThingWorx you are installing.
For the next step, we need to review your platform-settings.json file located in \ThingworxPlatform and your logs located in \ThingworxStorage\logs. Please attach these files so we can investigate further.
Regards.
--Sharon
2019-10-07 13:37:59.782+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-3] Could not handle request
2019-10-07 13:39:34.346+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-5] Could not handle request
2019-10-07 13:40:26.110+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-8] Could not handle request
2019-10-07 13:41:09.441+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-5] Could not handle request
2019-10-07 13:47:33.138+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-8] Could not handle request
Hi @isha.
These errors are not enough to troubleshoot the issue. Please attach the files themselves:
Regards.
--Sharon
Hi @isha.
Have you resolved your issue? If so, please either mark an existing reply as the Accepted Solution, or post an update with the details of the solution and mark that one. This will help others on the community with similar issues.
Regards.
--Sharon