Software Developer 20.Dec.10 12:06 PM a Web browser LEI LEI - 6.0; LEI - 6.5 Windows
Using a direct transfer activity I am migrating data from 7 Notes (8.5) views into 7 SQL (2005) tables.
3 of these work while 4 fail. The only difference between the successful and unsuccessful activities is that the unsuccessful ones are attempting to retrieve response document data from the Notes views.
All the views are built to ensure that the column values are text and the activities are running succesfully (the truncation of the destination tables prior to load is successful) they just won't load any rows, e.g....
20/12/2010 16:26:46 Activity started
20/12/2010 16:26:50 Removed all records from metadata 'MY DESTINATION', Connector 'MY SOURCE', Method -Action [Truncate]-
20/12/2010 16:26:51 Activity finished
Elapsed Time: 00:00:05
Records Fetched From All Connectors: 0
Records Inserted From All Connectors: 0
Records Updated From All Connectors: 0
Records Removed From All Connectors: 0
If the other Direct Transfer activities didn't work I would broaden my investigation but they're fine, it's just the 4 processes where I want to load response data that seem to fail.
I'd appreciate any thoughts you experts may have
- many thanks