Virtual Happy Hour this month, Jun 28, we'll be getting a sneak preview at our soon to launch SaaS CMS!

Try our conversational search powered by Generative AI!

Microsoft.Data.SqlClient.SqlException: 'Could not find stored procedure 'FoundationConfiguration_List

Vote:
 

i have installed optimizely customized commerce v14 foundation code in visual studio 2022  from below github link and created database through below commands

https://github.com/episerver/Foundation

  1. dotnet-episerver create-cms-database Foundation.csproj -S servername -U sa -P "sa"
  2. dotnet-episerver create-commerce-database Foundation.csproj -S servername -U sa -P "sa"

when i run the solution locally on my machine i m getting below errors , dont know how to resolve this

error : Microsoft.Data.SqlClient.SqlException: 'Could not find stored procedure 'FoundationConfiguration_List'.'

Please help

#304974
Jul 11, 2023 6:12
Vote:
 

Hi Yogesh,

Even I was facing same issue.

Rather i tried like below. After running you can access the site at http://localhost:5000/en/  it works properly
Hope this helps to resolve the issue. Please accepts this as answer if solves your problem.

open command prompt as administrator
git clone https://github.com/episerver/Foundation.git
cd foundation
git checkout main
setup.cmd 
dotnet run --project .\src\Foundation\Foundation.csproj
#304978
Jul 11, 2023 8:25
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.