You’re offline. This is a read only version of the page.
Hello,
We have a client that is cleaning up old users in PDK. When they try to delete the user they receive an unknown error message and it says to contact SQL admin.
When we review the users that we are trying to delete in SQL, each user is the owner of it's own schema. The schema is not tied to any other user. If we make another user (dbo) the owner of that schema, we are able to delete the user.
We ran the Mass Drop User Schemas script found on PartnerSource, but it did not remove the user's schema.
If I go into the schemas and manually delete the user schema and then attempt to delete the user in PDK, I receive the following error:
Unhandled script exception:
[Microsoft][ODBC SQL Server Driver][SQL Server]Count not find stored procedure
'DYNAMICS.dbo.PDKsp_GetNumRegisteredUsers'
Any suggestions on the best way to resolve?
*This post is locked for comments
I have the same question (0)
Well the error is self explanatory, you are missing stored procedures. A way to validate this is first make a backup of your environment, make sure everyone is out then you can open the Dynamics Database Maintenance and recreate Stored Procedures / views and Triggers for the PDK product.
If that does not solve it, then try deleting the PDK product from your test and re-install it.
Other tasks you can do is going to Tools > Maintenance > SQL and choose the PDK product, select all tables and drop/create all autoprocedures.
But make sure you have a backup, don't risk it.
Share
Report
All responses (
Answers (
2
