[WORKED AROUNDED] Data Migrator Using Temporary FOCUS File, Running Out of 2Gig Limit
I have a Data Migrator process that's running one main table connected to a bunch of lookup tables (nine or ten). When I ask it to give me back a 50 record sample of the selection the agent creates a temporary Focus file in C:\ibi\srv77\dm\edatemp\ts000xxx, fills it with 2Gigs of something, and then crashes. This is 7.7.03.
This is WAY more data than I'm asking for and it doesn't make sense. I have other migrator runs that work with more data and they dump material into a temp file that doesn't run into the 2Gig limit. Can anyone tell me what I've done to kick this thing into FOCUS file mode and is there at least a way I can get it to use XFOCUS instead?
J.This message has been edited. Last edited by: John_Edwards,
April 18, 2012, 01:07 PM
Well, since nobody reads or replies to things in the I-Way forum I'll tell you what I did.
I coded it in FOCUS. Worked like dream. FOCUS uses an ftm for temporary storage which solved my problem.
April 22, 2012, 05:40 PM
I suppose the question here is how were you getting your 50 record sample ?
Was it with RECORDLIMIT, READLIMIT or other filters.