I am attempting to retrieve data in a BPM from a Character01 field in a UD table. I am using an Invoke BO Method widget to pass a key from the Vendor table to Key1 in the UD table. I am receiving the below error and am not sure how to sort it out. I’ve tried changing the variables for Key2 through Key5 to everything I could think of to resolve the error but to no avail. Has anyone seen this error message before?
Did you try just setting Key2 - 5 to be “” in the expression editor?
When I do that, I get the following different error message.
Can you confirm with a message box that the ShortChar in your vendor row actually has a value?
Yes, the value ‘S3 - Non-Critical’ is being pulled from the Vendor.ShortChar01 field.
Aaron:
After posting the above information message, I looked at the value and a light bulb went on!
The value I have stored in the ShortChar01 field doesn’t match the Key1 value in the UD table.
Mid way through the development of the customization I changed the format of the ShortChar01 field.
After I changed the format in the ShortChar01 field, the BPM worked like a charm. Thank you very much for your help! It got me on the right path!