RE: LEI truncating values after upgrade Eric Forte 9.May.14 02:27 PM a Web browser LEI LEI - 8.0Windows
Thanks David.
We are on LEI 8 (not sure what the minor version is) and Domino 8.5. I understand that 2012 support was only added in version 9. The odd thing is that it worked with the older version of LEI.
We've done a battery of tests including all of the stuff above and narrowed it down to LEI. Here's the scenario:
A direct transfer activity calls a stored procedure (SP1) with a CHAR(1) parameter. That stored procedure calls another stored procedure (SP2) with the same parameter and tries to insert into a non-null table column of width CHAR(1) and it complains that it won't accept NULL. This is after using a transformation formula to modify the value. Without the formula, it sends " " and gets successfully inserted into the table.
Starting from the table, we started changing the data types to VARCHAR(10). We then worked back and modified SP2 and then SP1 and success. We then removed the transformation formula and everything worked, too. Lastly, we changed the table and SP2 back to their original and everything was still working.
So, for some reason changing the parameter to VARCHAR(10) does something where the value is not removed. It's similar to an endianness issue or casting a long into an integer.
By the way, the data is never NULL and is a 0,1 or 2 from a radio button. When the SP1 is called manually, it works fine.
I've been working with LEI (actually all the way back to NotesPump) and I've never seen anything like this before.
Thanks in advance for any insight you can provide.
Eric
Return to top
. . . . RE: LEI truncating values after upg... (Eric Forte 9.May.14)
Print this page
