Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] HOLD file
 Login/Join
 
Member
posted
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
 
Posts: 7 | Registered: August 01, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1586 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 669 | Location: Veghel, The Netherlands | Registered: February 16, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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 :
 
Posts: 1644 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 116 | Location: Seattle, WA | Registered: April 07, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
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.
 
Posts: 86 | Location: MI | Registered: July 23, 2009Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 7 | Registered: August 01, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thank you Francis. I will ask IT to check that as well.


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 7 | Registered: August 01, 2017Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 7 | Registered: August 01, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.