Skip to main content
1-Visitor
September 23, 2019
Solved

Foundation - 503 Service Unavailable error

  • September 23, 2019
  • 12 replies
  • 4951 views

Hi ,

 

I am also facing same error message while trying to access the ThingWorx composer. Hence attaching the log files. 

 

1. Setttings.json file is at ThingworxPlatform folder

2. JDBC .Jar files are at <Tomcat>\lib folder

3. Table are created in thingworx database

4. Using Thingworx 8.4.4 with MS SQL server database

 

gone through article Connections could not be acquired from the underlying database

 

Please give your opinions

 

Json file is as :

 

{
"PlatformSettingsConfig": {
"AdministratorUserSettings": {
"InitialPassword": "trUf6yuz2?_Gub"
},
"OrchestrationSettings": {
"EnableOrchestration": true,
"QueueHost": "win-5aoe9h447vu",
"QueuePort": 5672,
"QueueName": "256mb",
"QueueUsername": "flowuser",
"QueuePassword": "e24bbe712caab365b11a5a4f4b21a0b3",
"QueueVHost": "orchestration"
}
},
"PersistenceProviderPackageConfigs": {
"MssqlPersistenceProviderPackage": {
"ConnectionInformation": {
"driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"jdbcUrl": "jdbc:sqlserver://localhost:1433;databaseName=thingworx;applicationName=Thingworx;",
"password": "PlantPAxPTC@1234",
"username": "twadmin"
}
}
}
}

Best answer by slangley

Hi @GSPatil.

 

Are you having issues importing just this one extension or all extensions?  If this is affecting all extensions you probably need to check \ThingworxPlatform\platform-settings.com to ensure the Extension Package Import policy exists?  Here's an example:

 

{
    "PersistenceProviderPackageConfigs": {
        "MssqlPersistenceProviderPackage": {
            "ConnectionInformation": {
                "driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
                "jdbcUrl": "jdbc:sqlserver://localhost:1433;databaseName=thingworx;applicationName=Thingworx;",
                "password": "twadmin",
                "username": "twadmin"
            }
        }
    },
    "PlatformSettingsConfig": {
        "LicensingConnectionSettings":{
            "username":"username",
            "password":"password"
        },
        "ExtensionPackageImportPolicy": {
            "allowCSSResources": true,
            "allowEntities": true,
            "allowExtensibleEntities": true,
            "allowJSONResources": true,
            "allowJarResources": true,
            "allowJavascriptResources": true,
            "allowWebAppResources": true,
            "importEnabled": true
        },
        "ContentTypeSettings": {
            "supportedMediaEntityContentTypes": [
                "image/svg+xml",
                "image/png",
                "image/gif",
                "image/bmp",
                "image/jpeg",
                "application/pdf",
                "image/vnd.microsoft.icon"
            ]
        }
    }
}

 

I don't have any knowledge indicating that the relational database extension is no longer needed but I will check on it..

 

Regards.

 

--Sharon

12 replies

raluca_edu
17-Peridot
September 24, 2019

Hi,

 

Can you connect in MSSQL with twadmin user? If yes, I am recommending to check Tomcat logs, there some exceptions are thrown and can help with investigation.

If you want, you can attach Tomcat logs here to look into.

 

Thank you,

Raluca Edu

GSPatil1-VisitorAuthor
1-Visitor
September 24, 2019

Hi, 

Thanks for immediate reply, Yes I am able to connect MSSQL  to 'twadmin' user.

 

Also I have gone through the logs, but could not find any error.  Attaching available logs for your review.

 

 

Regards;

Ganesh Shete

raluca_edu
17-Peridot
September 24, 2019

Hi,

 

I think I found why this is failing:

 

ERROR com.thingworx.system.configuration.PlatformSettings - Configuration setting ContentTypeSettings.supportedMediaEntityContentTypes cannot be null

 

You need to add ContentTypeSettings in platform-settings.json , please follow this article: https://www.ptc.com/en/support/article?n=CS305798

After this, restart Tomcat.

 

Best regards,

Raluca Edu