search

Azure / Commercial-Marketplace-SaaS-Accelerator

A reference example with sample code for developers interested publishing transactable, Software as a-Service offers in the Microsoft commercial marketplace.
MIT License
179 stars 276 forks source link

Could not find file '/home/USER/Commercial-Marketplace-SaaS-Accelerator/deployment/script.sql'. #575

Closed msmassimo closed 9 months ago

msmassimo commented 9 months ago

To Reproduce Steps to reproduce the behavior:

  1. Run Deploy Script

OUTPUT - CANNOT PROCEED ➡️ Execute SQL schema/data script Invoke-Sqlcmd: /home/USER/Commercial-Marketplace-SaaS-Accelerator/deployment/Deploy.ps1:347 Line | 347 | Invoke-Sqlcmd -InputFile ./script.sql -ServerInstance $ServerUri -dat … | ~~~~~~~~~~~~~~~~~ | Could not find file '/home/USER/Commercial-Marketplace-SaaS-Accelerator/deployment/script.sql'.

santhoshb-msft commented 9 months ago

Hi @msmassimo this most likely means the build didnt succeed. Did you run the complete deployment script which install dotnet 6?

msmassimo commented 9 months ago

@santhoshb-msft Correct.

However, according to the instllation guide the command:

dotnet tool install --global dotnet-ef;

will install 7.0

Used: dotnet tool install --global dotnet-ef --version 6.0.0

and it now works.

santhoshb-msft commented 9 months ago

@msmassimo I dont think the error is caused by the dotnet-ef version. It might be the dotnet version itself. I just ran with dotnet-ef 7 and build works fine, image

But yes we need to run the first 4 lines of installation script to have dotnet 6.0 installed. Closing this as no further changes needed, please feel free to reopen with additional info.