Hello,
I am upgrading GP2013 SP2 to GP2013 R2 and when I am running GP Utilities I get the error message:
The stored procedure GrantAllToTableZDPs() of duSQL Pass Through SQL returned the following results: DBMD: 15151, Microsoft Dynamics GP: 0
Error 15151 is relating to permissions, but as I am logged in as sa, I don't think it is lack of permissions that is the issue. I ran a SQL Trace and found the error is caused when a cursor is cycling through this script:
DECLARE @sqlstring CHAR(255) DECLARE p_cursor CURSOR for select 'grant execute on [' + o.name + '] to [DYNGRP]' from sysdepends d, sysobjects o where d.depid = object_id('AF40201') and d.id = o.id and o.type = 'P' set NOCOUNT on open p_cursor FETCH NEXT FROM p_cursor INTO @sqlstring while(@@fetch_status <> -1) begin if (@@fetch_status <> -2) begin exec (@sqlstring) end FETCH NEXT FROM p_cursor INTO @sqlstring end DEALLOCATE p_cursor
The odd thing is that not all of the 20 databases that are being upgraded receives this error message and when you click OK in the pop window the process continues and completes without any further errors. And when I go back in GP Utilities the companies have been upgraded and have that cheerful green tick next to them. Odd thing number two is that object GrantAllToTableZDPs is nowhere to be found in the either the DYNAMICS database or the company database after the upgrade.
I would appreciate any ideas or suggestions of what it might cause the error.
