Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

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.