Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Saving output file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Saving output file
 Login/Join
 
Member
posted
I am trying to save the ouptut from a report to a local drive. Below is the command:

ON TABLE SAVE FILENAME 'C:\FOCUS\TEST.PDF' FORMAT PDF

Below is the error message:

(FOC350) ERROR WRITING OUTPUT FILE: SAV*****

I was at the summitt this past week. According to the person I spoke with in the Expert's Room, this should work. I have spoken with my WF administrator, he tells me that WF should not be the problem.

Anyone have any input?

This message has been edited. Last edited by: Kerry,


7.6.4, Windows XP SP 2
XLS, PDF, HTML output formats
 
Posts: 1 | Location: Falls Church, VA | Registered: January 15, 2009Report This Post
Expert
posted Hide Post
George,

Welcome to the Forum.

I disagree with the statement that "this should work", though...

WebFOCUS Programs are stored and executed on the "Reporting Server", that is where "files" are stored as well.

How does the server know the IP address of "your C drive"?

You save files on the Reporting server and FTP to another server/machine; you can APP MAP the server/machine via the Reporting server in edasprof.prf and SAVE to the MAPped DRIVE:\\foldername

? 350
-EXIT

Displays the message: An I/O type error prevented the file named from being written.

This may mean there are zero records to SAVE, OR, C:FOCUS is not a folder on the Reporting Server.

hth

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Virtuoso
posted Hide Post
Tom is right and I think that under a proper context, the person who told you that it should work may be right too.

If you run your code using Developer Studio and/or a Reporting Server physically running in your desktop computer then ON TABLE SAVE ... will create the file in the specified location.

This works as expected using my local environment:
TABLE FILE CAR
PRINT CAR BY COUNTRY
ON TABLE SAVE FILENAME C:\mycars.pdf FORMAT PDF
END


If your Reporting Server runs somewhere else (as usually is the case in a Production environment) then it simply won't work as you intended due to the well explained reasons Tom provided you with.

So, which one is your case?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Expert
posted Hide Post
Another possible explanation is that it attempts to "ON TABLE SAVE FILENAME 'C:\FOCUS\TEST.PDF' FORMAT PDF" and that "C:" is the C drive of the reporting server to which you do not have that kind of write access... Try allocating it to your C drive.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
George, I think we need to know where you are running the program, locally on your PC or on a server somewhere, before we can make any suggestions that may be useful.

Also, just in case, can you post your code.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
<JG>
posted
Also bear in mind that the directory/folder must exist because WF cannot create a folder
 
Report This Post
Expert
posted Hide Post
quote:
because WF cannot create a folder
This is true from your syntax, however you can check for the folder existance before your file save and create it if necessary -
CMD IF NOT EXIST "C:/FOCUS" MKDIR "C:\FOCUS"

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Member
posted Hide Post
Not forgetting the most basic of all.
Make sure you don't have the test.pdf already open Smiler


Developer Studio Release : 7.6.11
 
Posts: 21 | Location: TataSteel Strip Products UK , Port Talbot , South Wales | Registered: November 28, 2006Report This Post
Master
posted Hide Post
PCHOLD doesn't work?


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
Virtuoso
posted Hide Post
Sure, PCHOLD works, but only for loading files that the brwoser knows how to handle. And this will never result in a file on your local disk, it will only try to open the files that's being sent, not store it. If you want that, you'll have to do it manually.

Another option I once tried (successfully) was to:
1. create a share on my local PC to hold the file
2. give everyone full control to that share
3. in the fex add a line to add a network connection with the NET USE command
4. do an APP MAP to that newly created drive
5. do APP HOLD to the newly created APP MAP.

This is a very static solution and is not advisable.
But, if you really need it, this may work for you.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Gold member
posted Hide Post
hi all ,

which access can save the file?

I added the everyone,but still not work...

Thanks,
James


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
 
Posts: 97 | Registered: August 18, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Saving output file

Copyright © 1996-2020 Information Builders