Share
ReportI am trying to upgrade a client from GP2010 to GP2016. I get the following error message
The following SQL statement produced an error:
CREATE TRIGGER [uprWF_DD20100UpdateTrigger] ON DD20100 FOR UPDATE AS declare @EmpID char(15), @Inactive smallint, @DDREMAIN int, @INDXLONG int, @Error_State int, @WorkflowInstanceID char(37), @WorkflowStepInstanceID char(37) if update(Workflow_Status) and ((select Workflow_Status from inserted)=6 or (select Workflow_Status from inserted)=3) begin select @EmpID = (select EMPLOYID from inserted) select @Inactive = (select INACTIVE from DD20100 where EMPLOYID = @EmpID) delete DD00100 where EMPLOYID = @EmpID insert into DD00100 select EMPLOYID, INACTIVE, DDREMAIN, INDXLONG from DD20100 where EMPLOYID = @EmpID delete DD00200 where EMPLOYID = @EmpID insert into DD00200 select EMPLOYID, INDXLONG, INACTIVE, DEDNMTHD, DEDUCTON, DDPRE, DDPRECNT, DDPCT, DDAMTDLR, DDACTNUM, DDTRANUM, DDTRANS from DD20101 where EMPLOYID = @EmpID delete DD20101 where EMPLOYID = @EmpID end
Then I get
'Column name or number of supplied values does not match table definition'
I tried creating the DD20100 table and then restarting the upgrade - this worked for all of the companies except for one. Does anyone know how to get around it?
Thanks!
*This post is locked for comments
All responses (
Answers (
26,225
