Running a SmartConnect map to create employees in the Create Employee destiantion and receiving the error, “ErrorNumber =11997 Stored Procedure = Error Description = Error Codes were not found in table DYNAMICS..taErrorCode. Please insure that the table taErrorCode is up to date.
This is caused by a missing error message in the taErrorCode table. The actual message should be, “The USERID parameter is invalid”.
You can update the taErrorCode table and insert the correct message so that eConnect returns the proper error message. Run the following script in SQL management studio against the DYNAMICS database to insert the missing error code.
insert taErrorCode values(11997,'taCreateEmployee','The USERID specified is not a valid Dynamics GP user','EMPLOYID LASTNAME FRSTNAME','USERID')
