Skip to main content
1-Visitor
Sep 23, 2019 9:25 PM UTC
Solved

Foundation - 503 Service Unavailable error

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"
}
}
}
}

slangleyAnswer
Support
Oct 3, 2019 6:22 PM UTC

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
Sep 24, 2019 12:59 PM UTC

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

Translate
GSPatil1-VisitorAuthor
1-Visitor
Sep 24, 2019 2:49 PM UTC

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

Translate
raluca_edu
17-Peridot
Sep 24, 2019 3:03 PM UTC

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

Translate