Is there a list of error codes for LF cloud to give their meaning?
We have a rule trying to insert a row to an internal lookup table, the error is "DM81301" Provided input parameter not used in query.
Hi Beau, your case looks a little different to mine and the fact yours is random seems unusual. I think i understand lookup tables and rules a little better now, i think the issue i had related to datatypes. Importing data from an csv that is not typed, LF makes a determination on the best type when it imports initially. Where I've gone wrong in the past is when rules are written, my understanding is they inherit that datatype from the table at that point in time. If the table is reimported and the datatype changes then the rule breaks but there is no way to know why. The rule doesn't display an error, nor is it possible to see the type its expecting. Long story short, I've found removing all the select and reloading was my solution.
That makes perfect sense as the data we were pulling was the same (Employee ID, First name, Last name, ...) but the source providing it had changed. I wish the error would say something like "The data type is no longer valid for ..." but these more complete error messages will come as Cloud matures. Thanks for pointing me in the right direction!
Were you ever able to find out anything on this error? I am getting the same error but only sporadically. The query works 99% of the time and then occasionally has this error.
Could you open a support case and attach the instance ID for the workflow were you are seeing this issue, please?