Procedure or Function taSOPLineIvcInsert has too many arguments
jmoreland asked 7 years ago
Running an existing map that ran successfully last month
and receiving this error.
Tried replacing the GP Rolling Column with a Custom Rolling column.
No luck.
It sounds like something either changed within SQL to the actual procedure or within SmartConnect to the reference that is saved for that procedure/node.
You could open up the procedure's parameters within SQL Management studio and compare them to the fields you see listed within SmartConnect's mapping window. That error generally occurs if too many values are being passed through to a procedure in SQL.
Does this occur on a new map that uses that same node? If it does, its something general that is failing – if not, then its something specific to that one map.
Chris