episerver / Foundation

Foundation offers a starting point that is intuitive, well-structured and modular allowing developers to explore CMS, Commerce, Personalization, Search and Navigation, Data Platform and Experimentation.
https://docs.developers.optimizely.com/digital-experience-platform/docs/optimizely-foundation-demo-sites
Apache License 2.0
132 stars 137 forks source link

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

Open YogeshLTI opened 1 year ago

YogeshLTI commented 1 year ago

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

To Reproduce i have installed foundation code in visual studio 2022 and created database through below commands

  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 whow to resolve this

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

Please help

akfo commented 6 months ago

Have you executed the setup.cmd file (or setup.sh file) located in the root of the Foundation project? This file does different things, but one of the tasks is to create database elements.

Segimara commented 3 months ago

Hi, have same issue, i used setup.cmd and resetup.cmd multiple times but still same issue

CharcoalStyles commented 2 months ago

I'm having this issue, too.

Running it on a Mac with Docker. Runinning the setup.sh file seems to work fine, but when I go to run the application, it shows this error message: Unhandled exception. EPiServer.Framework.Initialization.InitializationException: Initialize action failed for Initialize on class Foundation.Infrastructure.InitializeSite, Foundation, Version=2021.4.1.0, Culture=neutral, PublicKeyToken=null ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'FoundationConfiguration_List'.