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.
No comments:
Post a Comment