Larry Lovstad 6.May.08 03:49 PM a Web browser Connector for Notes LEI - 7.0 Windows
I am having issues with a Direct Transfer and Replication activities from a Notes database to a file on the I Series. I started by trying a direct transfer because I thought it was a simple insert of rows into the target file. No success with inserts. The activity would be over in 1 or 2 seconds with no errors. When I unchecked skip updates it managed to find a few rows on the I Series that partially matched the keys needed for the transfer and it did update those rows with new info. Going back to just inserts it would not do a thing. I have the connector using a view for the transfer and a Formula to Execute During Select of SELECT @All; CAETransfer = "1". The CAETransfer field is text. The view shows the 3 test documents that I am trying to transfer.
I have a similar set up in the Replication activity that I tried. When I try update and set it to log conflicts it lists 500 conflicts in the log before the activity ends. I know it is connecting to the I Series file. It seems to ignore the view in the Notes database that has the documents that I want to transfer. When I set the Replication activity to just insert it finishes in 1 second and totally ignores the Notes view. I have tried Sort Metaconnectors and other tweaks in the settings. I made sure that the versions of Notes and LEI matched.
Why does the log entries only show a connection made to the I Series and never where it was selecting from my Notes view?
05/06/2008 09:16:40 AM Activity started
05/06/2008 09:16:41 AM Trace Statement: <SELECT LOCATION,MASTER0CO,SYMBOL,POLICY0NUM,MODULE,TRANS0STAT,ID02,MRSUID,ADD0LINE03,ADD0LINE04,FILLR1,RPT0AGT0NR,FILLR2 FROM PHID11DAT.PMSP0200 WHERE (TRANS0STAT != 'V') ORDER BY LOCATION,MASTER0CO,SYMBOL,POLICY0NUM,MODULE,TRANS0STAT,ID02>, Connector 'BC', Method -Select-
05/06/2008 09:16:44 AM Activity finished
Elapsed Time: 00:00:04
Records Fetched From All Connectors: 26581
Records Inserted From All Connectors: 0
Records Updated From All Connectors: 0
Records Removed From All Connectors: 0
What do I need to look for to get this to work? I am totally frustrated with LEI at this point and hoping that someone would have an answer.