Thursday, July 17, 2014

Maximum stored procedure, function, trigger, or view nesting level exceeded

While upgrade from GP10.0 SP2 to GP10.0 SP5 and running the GP utilities i got the below error 

Case:
CREATE TRIGGER [dbo].[zDT_MC40200U] ON [dbo].[MC40200] AFTER UPDATE 
AS
set nocount on
BEGIN
UPDATE dbo.MC40200 SET DEX_ROW_TS = GETUTCDATE()
FROM dbo.MC40200, inserted 
WHERE MC40200.CURNCYID = inserted.CURNCYID

END
set nocount off
GO
Invalid Column Name DEX_ROW_TS

Solution:
I've created this column manually in Dynamics.dbo.MC40200 then re-run the utilities and it has been passed.