Focal Point
File Updates from Maintain Programs and .FEX Modify

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

February 04, 2008, 03:20 PM
KentO
File Updates from Maintain Programs and .FEX Modify
We have 20 users updating our files using Maintain programs. So we have the Simultaneous Update features active in our odin.cfg.

Our problem is that we have .FEX modify programs that run daily to spread updates made by the maintain programs to billing files. With SU on, the .FEX modify programs will not update the files.

Is there a way to close certain files to the maintain programs while the .FEX modify programs are updating those files? If not, is there another way to do once a day updates?

Thanks, Kent


Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE
February 04, 2008, 05:21 PM
GinnyJakes
Kent,

I'm not sure what your problem is but please check to make sure that your MODIFY programs have a

USE
yourfile ON FOCSU01
END

in them.

If they don't, they aren't running under the sync machine. Having a service in your odin.cfg is not sufficient.

You may also have to put the directory in the app path in the suprof.prf file.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
February 05, 2008, 10:30 AM
KentO
Ginny, I added the USE statement as you suggested but am still getting the message "FOC535 - More memory is needed to execute the request: Commit Source".
I am not sure what I need in SUPROF.PRF. Alan B posted on January 16 that it should be something like:

APP DISABLE
SET EDAPATH=C:\someplace\META;C:\someplace\FDS;

Is the "someplace\META" the program directory and the "someplace\FDS" the file directory? And is the "APP DISABLE" correct?
Kent


Windows2003 Server, WebFOCUS 7.7.02 Developers Studio and MRE
February 05, 2008, 10:47 AM
Alan B
Kent

The SUPROF.PRF I use points to 2 directories, one for MFDs and one for the FOCUS datafiles. What you need is for the FDS to be able to pick up both, wherever they may be.

I use this for MODIFY and MAINTAIN, the EDAPATH is older syntax, needing the APP DISABLE.

Ginny is correct that you should issue a USE prior to any MODIFY or MAINTAIN, which I have in my EDASPROF.PRF.

However, MAINTAIN needs COMMIT=ON in the EDASPROF.PRF and MODIFY seems to prefer it OFF, so I issue a SET COMMIT=OFF prior to any MODIFY.

Now some may comment on my set up, but this has been working from 4.3 to 7.6 without any hitches, so I am loath to change it.....


Alan.
WF 7.705/8.007
February 05, 2008, 12:19 PM
GinnyJakes
You can put the USE in suprof.prf as well.

As for the mapping in suprof.prf, I wouldn't do an APP DISABLE. SET EDAPATH is very old syntax. Use APP PATH instead to point to the directories where your sync FOCUS files and masters are located.

When you are done, you should be able to go to an adhoc screen and type ? USE and see the files owned by the sync machine.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
February 05, 2008, 12:43 PM
Alan B
Ginny

Whilst you can put a USE in SUPROF, you cannot issue a
USE
fn.FOC on FOCSU01
END
only
USE
app/fn.FOC
END
as the SUPROF is only read by FDS, not by the application needing to use the FDS server. When there are multiple users updating a .FOC file, then a USE pointing to the FDS should be prior to the application, for MAINTAIN I have found this best in the EDASPROF.PRF.

APP PATH will work, but so does EDAPATH.


Alan.
WF 7.705/8.007