Article - CS356149
"sqlcmd: command not found" is seen when attempting to execute the thingworxAzureSingleInstanceSchemaSetup or thingworxAzureManagedInstanceSchemaSetup during installation of ThingWorx Platform
Modified: 15-Mar-2024
Applies To
- ThingWorx Platform 8.5 to 9.5
Description
- ThingWorx Platform Azure SQL database scripts fail to execute
- Cannot execute the schema setup scripts for Azure SQL when installing ThingWorx Platform
- ThingWorx Platform Azure SQL schema setup scripts fail to complete successfully
- thingworxAzureSingleInstanceDBSetup or thingworxAzureManagedInstanceDBSetup completes as expected but thingworxAzureSingleInstanceSchemaSetup or thingworxAzureManagedInstanceSchemaSetup fails
- ThingWorx database schema is not created because the schema setup script reports sqlcmd: command not found
- Issue with the database schema not being set, getting sqlcmd: command not found error when trying to run thingworxAzureSingleInstanceSchemaSetup or thingworxAzureManagedInstanceSchemaSetup
- Executing one of the following ThingWorx database scripts results in sqlcmd: command not found:
- thingworxAzureSingleInstanceSchemaSetup.ps1
- thingworxAzureSingleInstanceSchemaSetup.sh
- thingworxAzureManagedInstanceSchemaSetup.ps1
- thingworxAzureManagedInstanceSchemaSetup.sh
- Seeing the following in the command line when executing the ThingWorx Azure SQL database schema setup scripts:
- Start Execution
Setting up ThingWorx schema and creating user <Azure SQL User> in <Azure SQL DB>...
Password: ./thingworxAzureSingleInstanceSchemaSetup.sh: line 154: sqlcmd: command not found
Setting up model schema...
Password: ./thingworxAzureSingleInstanceSchemaSetup.sh: line 170: sqlcmd: command not found
Setting up property schema...
Password: ./thingworxAzureSingleInstanceSchemaSetup.sh: line 176: sqlcmd: command not found
Setting up data schema...
Password: ./thingworxAzureSingleInstanceSchemaSetup.sh: line 182: sqlcmd: command not found
Setting up grants schema...
Password: ./thingworxAzureSingleInstanceSchemaSetup.sh: line 188: sqlcmd: command not found
End Execution
- Start Execution
This is a printer-friendly version of Article 356149 and may be out of date. For the latest version click CS356149