Rick Macguigan 4.Jun.08 04:28 PM a Web browser LEI LEI - 6.5 Windows
As per fixlist there are a bunch of LEI fixes in 6.5.6. Just updated Domino server to 6.5.6 to FP 3 . You also ned to do a reinstall of LEI 6.5.6 code (no need to uninstall.)
<see my previous post on 6.5.6>
One big fix was the properly equating blank Notes fields to Oracle Null values. In 6.5.4 this was inserting/updaing a hex '00' insted of Null leading SQL to produce false results when test for Nulls (or Not.) Enterprise reporting tools are not able to handle cross tabs if the Null value is not there in Oracle.
After upgrading to LEI 6.5.6, discovered that simply re-running existing LEI (replication) activities from Notes to Oracle tables will not update existing hex '00' Oracle fields to Null. Instead have to delete all records in these Oracle tables that are populated with Notes data and repopulate. This inserts the proper Nulls.
I think there is still a bug. Read carefully. Only "Inserts" are fixed,....not Updates.
Unless someone can come up with another explanation ? And yes, I did do a design refresh on the DECSADM.NSF after the LEI 6.5.6 update.