script errors on AZure SQL thingworx schemas
Hello,
I have created Azure SQL srever and created thingworx database. I am trying to create schemas on thingworx database using script which provided by thingworx installation. Below are errors while running the schema setup script. I am using thingworx 8.5.11 Thingworx version.
Setting up ThingWorx schema and creating user twadmin in thingworx...
Password: sqlcmd : The term 'sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable progr
am.
Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Softwares\MED-61280-CD-085_SP11_ThingWorx-Platform-Azuresql-8-5-11\install\thingworxAzureSingleInstanceSchemaSetu
p.ps1:84 char:1
+ sqlcmd -S $server\\$serverinstance,$port -U $sqlserverloginname -d $database -i ...
+ ~~~~~~
+ CategoryInfo : ObjectNotFound: (sqlcmd:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
cat : Cannot find path 'C:\Softwares\MED-61280-CD-085_SP11_ThingWorx-Platform-Azuresql-8-5-11\install\tempLogFile.log'
because it does not exist.
At C:\Softwares\MED-61280-CD-085_SP11_ThingWorx-Platform-Azuresql-8-5-11\install\thingworxAzureSingleInstanceSchemaSetu
p.ps1:41 char:19
+ $tempContents = cat tempLogFile.log | Select-String -NotMatch "Password:"
+ ~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (C:\Softwares\ME...tempLogFile.log:String) [Get-Content], ItemNotFoundEx
ception
+ FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.GetContentCommand
rm : Cannot find path 'C:\Softwares\MED-61280-CD-085_SP11_ThingWorx-Platform-Azuresql-8-5-11\install\tempLogFile.log'
because it does not exist.
At C:\Softwares\MED-61280-CD-085_SP11_ThingWorx-Platform-Azuresql-8-5-11\install\thingworxAzureSingleInstanceSchemaSetu
p.ps1:45 char:3
+ rm tempLogFile.log
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (C:\Softwares\ME...tempLogFile.log:String) [Remove-Item], ItemNotFoundEx
ception
+ FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.RemoveItemCommand
Setting up model schema...
Password: sqlcmd : The term 'sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable progr
am.
Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Softwares\MED-61280-CD-085_SP11_ThingWorx-Platform-Azuresql-8-5-11\install\thingworxAzureSingleInstanceSchemaSetu
p.ps1:94 char:3.............................................
........................................
Regards,
Vidyullatha