Dynamics Community Forum Thread Details

Cannot delete a quick send request

We're trying to delete a quick send request in the Edit Quick Send Requests screen and we are getting the following SQL Server error: "Could not find stored procedure 'AppServerRequest_delete_all'.

Has anyone else experienced this issue? Please advise, thanks.

Hello Sharon O,

Thank you for posting to the Microsoft Online Community.

I could duplicate this issue in my 7.0 SP3 database. After selecting the request I wanted to delete and clicking the X on the toolbar, I answered Yes that I want to delete. Then when clicking the Save icon, the 501 error message appeared.

As the error message indicates, the AppServerRequest_Delete_All stored procedure is missing. This is a bug and I will submit it right away. In the meantime, you can open up SQL Server Management Studio and create the stored procedure. I have included the create statement below. Run this statement on your system database. After creating this stored procedure on your system database, you will be able to delete Quick Send requests in the Edit Quick Send Requests screen. Please let me know if you have any questions. I apologize for the inconvenience.

create Proc AppServerRequest_Delete_All @parm1 int as

Begin

Delete from asrdatabase where id = @parm1;

Delete from asrdistlist where requestid = @parm1;

Delete from asrtirecs where reqid = @parm1;

Delete from ASRReqEDD where id = @parm1;

Delete from AppSrvRequest where id = @parm1;

End

Quick Links

Leaderboard