When deleting a PDK 11.0 (GP 2010) user receiving missing stored procedure DYNAMICS.dbo.PDKsp_GetNumRegisteredUsers error

(0) Share

Report

Posted on by Community Member

When deleting a PDK 11.0 (GP 2010) user we get the following error even though the user appears to be successfully deleted: "Unhandled script exception: [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'DYNAMICS.dbo.PDKsp_GetNumRegisteredUsers'. EXCEPTION_CLASS_SCRIPT_MISSING SCRIPT_CMD_CALLSERVER"

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Benjamin,

I uncovered that bug about 2 years ago but never got a response about this. It lasts thru our latest updates and patches, and I now opened a ticket with Microsoft Connect (#720522).

It obviously seems that the delete process tries to execute an SP that is located in the company DB's and not the DYNAMICS DB... However, the SQL user gets dropped succesfully as well as deleted from a couple of PDK tables, but nobody know how much of the process (%) is completed.

Hope this helps...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Benjamin,

I ran a SQL Profile trace when deleting the user with the error and this shows the user records being deleted from the PDK tables in the company & DYNAMICS db's.

I got around the problem by re-creating the missing sp in the DYNAMICS db using the same sp that is located in the company db. I no longer get the error and the registered user count is also incremented for each user deleted.

Regards,

James Gomes

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Benjamin,

I almost forget about this post and appologize for this. I had a follow up with Microsoft in February this year and they confirmed the bug and sent me the missing sp_ to recreate in the DYNAMICS database. So what James mentionned above is correct and everything is working fine after that. Our payroll dept is happy now and can do a proper clean-up in PDK.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Beat,

I am runing into the same issue with a user on GP 10 and PDK. Is it possble to make the missing sp_ available to recreate in the DYNAMICS database?

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Michael,

it is actually pretty easy to recreate the missing SP in the DYNAMICS database... All you have to do is to use the SQL Studio Management and script the creation of the SP PDKsp_GetNumRegisteredUsers from one of the GP companies (where it is available).

Copy the SP creation script and run it against the DYNAMICS DB and you're up and running.

Hope this helps.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Question - what count is it that determines the number of users that you can have in PDK?

In one article I was reading on line it suggested that since v10 SP2 the employee count (active) and not TEST is what determined the number of licenses used.

However, I am not able to confirm this as (1) PDK / BP licenses shows 101 and (2) Canadian payroll shows 250.

I have gone through all company databases and determined that we have 181 ACTIVE employees, all unique, therefore I would expect that I would be under my 250 license for Payroll, but, we are confused by the count for PDK. Right now we are getting ZERO on the screen.

Where (what table) are all the PDK user ID stored? I have been beating this up for 1/2 hour and can not find the table - sure it will be simple, but, hope someone has a list.

Does anyone have an answer as to what controls Employee PDK / BP / Payroll license counts?

---------

Bill Campbell
billc.edmonton (skype)
billc@misltd.ca

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Bill,

Have a look in the Table PDK40001.. This is one of the tables used by SP to get the current active PDK users when deleting an employee...

Mine returns a pretty accurate number given the fact that we're operating across 3 companies.

The PDK40001 holds the list of all PDK logins linked with the GP company, and show you the Employee ID... With that you should be able to get a decent report out with SSRS or SQL.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

I created the SP in the Dynamics DB as suggested, I reviewed the PDK400001 table as noted and we seem to have about 70 more names in the PDK table than we do in the GP Payroll tables. We are running Payroll over 3 companies as well, however, for some reason, not clear, they are only using 2 companies in PDK.

Any way, the payroll works the way they are doing it now, so my questions are

1 - what number is the one that determines the number of licenses used by PDK?

2 - why do we get an error message stating that we can not delete the employee from PDK - it is the message that says the User Id failed to be deleted from SQL for an unknown reason - thanks a bunch and then nothing.

So, I wanted to know, if I do 'remove' the user from PDK40001 will that give me back registration licenses in PDK - which right now show ZERO

-----

Bill Campbell

billc.edmonton (skype)

billc@misltd.ca

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Bill,

After you recreated the SP in the DYNAMICS DB, have you granted access to the DYNGRP role ?

I would definitly not start to delete manually any entries in the PDK40001, unless you know exactly that some login & employee ID 's have been deleted in PDK in the past and they still show up there... Keep in mind that the lisencing of PDK counts the number of unique logins in that table, and you may have more login accounts that you have actual employees (it's the case for us, because for some users, they created in the past a different login per company, which is actually not required, since PDK tracks the relationship between login, employee and company in that table)...

If you have a look at the cotent of the sp, then you'll be able to figure out how PDK counts the number of licensed users. The count is a loop process that scans the entries of PDK40001 and SY01500 for the companies. It also grabs to the UPR00100 Employee Master table in GP from the Payroll and checks the active employees.

If you do want to delete records from you table, than make sure you have a good backup of your DB before you start and no one else is playing in the GP system. Test your PDK after that to see if you still can login and manage all your users properly.

The error message you get after trying to delete a user comes most certainly from the missing permissions to run the SP in either the DYNAMICS or a Company DB..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bill,

I came across the same issue and found the problem to be with PDK trying to remove the associated SQL login which didn't exist. In SQL check you can see teh SQL login id for the PDK user you're trying to delete.

Also, there are a couple of additional table to check user information for if you're going to delete these users directly from the table:-

- DYNAMICS..PDK90100

- DYNAMICS..PDK02000

- PDK00101 & PDK00102 in the company db

Regards,

James Gomes

Was this reply helpful? Yes No