London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off

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

Yogesh Kumar
Yogesh Kumar
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
Avinash Pawar
Avinash Pawar
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.