News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Sandbox to dev bacpac ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Sandbox to dev bacpac import is missing a stored procedure

(1) Share

Report

Report

Posted on by EK-26061005-0

100

In LCS i have restored the sandbox with production DB, exported sandbox, then followed this guide to import the production DB to the dev environment. Everything works fine except a WHSExecution action which throws the following sql error:

Object Server Azure:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not find stored procedure
'MyStoredProcedure'.

The action works in sandbox and production environments so i was wondering if i made a mistake when creating the bacpac in LCS...

Categories:

Dynamics 365 Finance

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 9,782 Super User 2024 Season 2 on at

Like (0)

Report

Sandbox to dev bacpac import is missing a stored procedure

Hi @EK-26061005-0,

I think you need to Run Tutorial_WHSSetup class to initialize WHS related stored procedures.

https://community.dynamics.com/blogs/post/?postid=61aff2aa-000f-48c9-8dac-2322a007e195

Best regards,

Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,374 Super User 2024 Season 2

#2

Martin Dráb 230,407 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans