Skip to main content
T
TanmeyTWX17-Peridot
17-Peridot
September 27, 2019
Solved

Not able to Load composer - MSSQL Thingworx Platform

  • September 27, 2019
  • 13 replies
  • 3597 views

Hi Folks,

 

I'm trying to do a fresh installation of Thingworx 8.3 version and followed required steps and configurations but getting 404 error everytime I try to load Composer (localhost:8080/Thingworx)

 

Below is the Error log and Platform-settings json code. I believe its related to Platform-settings as per the logs but I'm not really able to catch the cause. kindly help.

 

**********************************************************Logs**************************

14:28:04.309 [localhost-startStop-1] ERROR SecurityLog.com.thingworx.security.authentication.AuthenticationFilter - Could not load session timeout from database, using default: null

14:28:04.325 [localhost-startStop-1] ERROR ErrorLog.com.thingworx.security.authentication.HAAuthenticationFilter - Failed to initialize HA Authentication
java.lang.Exception: Table [ExtensionPackageImportPolicy] does not exist
at com.thingworx.types.collections.ConfigurationTableCollection.setValues(ConfigurationTableCollection.java:272)
at com.thingworx.types.collections.ConfigurationTableCollection.setValues(ConfigurationTableCollection.java:305)
at com.thingworx.system.configuration.PlatformSettings.<init>(PlatformSettings.java:620)
at com.thingworx.system.configuration.PlatformSettings.getInstance(PlatformSettings.java:1115)
at com.thingworx.security.authentication.HAAuthenticationFilter.init(HAAuthenticationFilter.java:36)
at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:283)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:264)
at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:108)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4546)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5191)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:970)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1841)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
14:28:04.335 [localhost-startStop-1] INFO org.tuckey.web.filters.urlrewrite.UrlRewriteFilter - destroy called
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: destroy called
 
************************************Platform Settings file:****************************
 
{
"PlatformSettingsConfig": {
 "AdministratorUserSettings": {
  "InitialPassword": "Administrator@12345"
 },
"ExtensionPackageImportPolicy":{  
  "importEnabled":true,
  "allowJarResources":true,
  "allowJavascriptResources":true,
  "allowCSSResources":true,
  "allowJSONResources":true,
  "allowWebAppResources":true,
  "allowEntities":true,
  "allowExtensibleEntities":true
 }
},
"PersistenceProviderPackageConfigs": {
 "MssqlPersistenceProviderPackage": {
  "ConnectionInformation": {
   "driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
   "jdbcUrl": "jdbc:sqlserver://myserver.database.windows.net:1433;databaseName=thingworx;applicationName=Thingworx;",
   "password": "MyApp@123#",
   "username": "MyAdmin",
   "maxPoolSize": 300,
   "maxStatements": 100,
   "minPoolSize": 10,
   "numHelperThreads": 8,
   "idleConnectionTestPeriod": 60,
   "initialPoolSize": 10,
   "acquireRetryDelay": 10000,
   "checkoutTimeout": 1000000
 
  }
 
 }
}
}
 
 
Best answer by TanmeyTWX

Resolved.

 

some required SQL tables were not created in the SQL server which was not letting it loaded with ExtensionPackageImportPolicy.

I did a fresh installation starting from required SQL DB creation and connection details,followed by recommended steps of Thingworx installation and it worked for me 🙂

13 replies

V
vangne16-Pearl
16-Pearl
September 27, 2019

@TanmeyTWX  The installation instructions for Thingworx 8.3 are here

 Have you had an opportunity to check this article?

 

Also, these community posts might be helpful for you

https://community.ptc.com/t5/ThingWorx-Developers/Thingworx-Platform-8-3-installation-issue/m-p/587251

https://community.ptc.com/t5/ThingWorx-Developers/Thingworx-8-3-trial-installation-fails/m-p/579362

 

If the error persists, please provide us the application and tomcat logs.

 

Thanks,

Vibhuti

T
TanmeyTWX17-PeridotAuthor
17-Peridot
September 30, 2019

Hi Vangne,

 

I have already tried mentioned documents and reference links but no luck.

 

Tomcat log is already copied in the this thread as well as the Platform-Settings.json file content.

 

raluca_edu
raluca_edu17-Peridot
17-Peridot
September 30, 2019

Hi,

 

I don't know exactly what version of Thingworx 8.3 you install, but it is possible that ExtensionPackageImportPolicy NOT needed in platform-settings.json.

Try to remove that setting and restart Tomcat.

 

Thank you,

Raluca Edu

S
slangleyCommunity Manager
Support
October 16, 2019

Hi @TanmeyTWX.

 

If you found a solution to your issue, please feel free to post it here and mark it as the Accepted Solution.  This will help others in the community with the same problem.

 

Regards.

 

--Sharon

T
TanmeyTWX17-PeridotAuthorAnswer
17-Peridot
January 27, 2020

Resolved.

 

some required SQL tables were not created in the SQL server which was not letting it loaded with ExtensionPackageImportPolicy.

I did a fresh installation starting from required SQL DB creation and connection details,followed by recommended steps of Thingworx installation and it worked for me 🙂

Terms & ConditionsAccessibility statement