Focal Point
[WORKED AROUNDED] Data Migrator Using Temporary FOCUS File, Running Out of 2Gig Limit

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/8867051916

April 18, 2012, 09:50 AM
John_Edwards
[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
John_Edwards
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.

J.



April 22, 2012, 05:40 PM
Waz
I suppose the question here is how were you getting your 50 record sample ?

Was it with RECORDLIMIT, READLIMIT or other filters.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

April 22, 2012, 08:14 PM
John_Edwards
It's a setting in Data Migrator.

J.



April 22, 2012, 08:38 PM
Waz
Ah, so only data Migrator knows....




Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code