Focal Point
[SOLVED] HOLD file

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

January 12, 2018, 11:26 AM
Thanit
[SOLVED] HOLD file
Hello -

I work on my predecessor's report that getting data from a HOLD file. The HOLD file needs to be updated before running the report based on the result (old data shown up). I could not find any documentation left for me. Would it be possible to trace back which fex generate that HOLD file? Otherwise, I might have to start that report from scratch.

Thank you.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105m
Windows, All Outputs
January 12, 2018, 12:07 PM
FP Mod Chuck
Thanit

Do these fex files exist in the content area in the repository or in the application folders?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
January 15, 2018, 02:29 AM
Dave
No...

it's not registered which .fex creates which HOLD file.

It could even be several fex that create or write to the same HOLD file...

...but!

You could query the repository and scan all sourcecode on that specific HOLD file name.

it should be in there somewhere.


_____________________
WF: 8.0.0.9 > going 8.2.0.5
January 15, 2018, 03:55 AM
Wep5622
App and Dev Studio have a feature on master files to scan where that master is used named "Impact Analysis". That does the reverse of what you want.

Something feature to scan where a master is generated (if it is a HOLD-file), would be useful.

It happens frequently enough that we're looking in a procedure that someone else created, or one of our own that was created a while ago, that we're left searching.

We usually grep the *.fex files in the file system.

If you're stuck with the repository you can probably use a select with a like expression - if the field type used to store the fex in the DBMS in question permits that. BLOBs are often not very query-friendly, for example.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
January 16, 2018, 12:44 PM
Michael L Meagher
From within App Studio (and Developer Studio) you can copy all the files (fex, mas, acx ...) to a Windows directory. I do this frequently to keep the previous versions before I change focexecs. You can then use a search tool to look for the focexecs(s) that create your hold file. I have had good luck with Agent Ransack.


WebFOCUS 8.2.03 - Production
WebFOCUS 8.2.04 - Sand Box
Windows 2012 R2 Server
HTML, PDF, Excel
In FOCUS since 1980
January 16, 2018, 05:03 PM
MathematicalRob
Thanks for the tip, Michael; I didn't know we could do that!


WebFocus 8201m on Windows; App Studio 8201; Procedures: WebFocus with SQL; HTML Parameter Pages & Dashboard; Output: Excel, HTML, & PDF.
January 17, 2018, 11:00 AM
Thanit
Sorry for delay reply. I was out of office.


Chuck - I don't see the fex file that creating this HOLD file. I only see the fex that using this HOLD file to generate the report I want in the Content folder. The HOLD file is in EDASERVE\Application folder.


Dave - I checked that HOLD filename, but unfortunately no other filename being similar to that HOLD file.


Wep5622 - thanks for that tip. After using Impact analysis, all I see are fex files using that HOLD file, not the one creating it.


Michael - thanks for the advice. I will do this from now on. Sometimes I feel that files are disappeared for no reason. Maybe too many hands in the pot.


I will wait until my IT staff takes a look on this and his backup. If file is not found, I have no choice to recreate that fex file and mimic that output for that HOLD file.

Thank you all!


WebFOCUS 8105m
Windows, All Outputs
January 17, 2018, 11:14 AM
Francis Mariani
It is possible that the HOLD file is created by a program that is not in the Repository, but on the reporting server - in one of the application folders. I would check there.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 17, 2018, 11:34 AM
Thanit
Thank you Francis. I will ask IT to check that as well.


WebFOCUS 8105m
Windows, All Outputs
January 18, 2018, 03:34 PM
Thanit
Finally, after troubleshooting with IT, we found the fex file that generates that HOLD file. It was simply that I didn't have permission to see it before.

Thank you all for your time and suggestion to help me out.


WebFOCUS 8105m
Windows, All Outputs