Focal Point
What's causing a ERROR WRITING OUTPUT FILE?

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

December 12, 2007, 03:36 PM
Jason K.
What's causing a ERROR WRITING OUTPUT FILE?
I've got a fex that builds a simple html phone list for our company. We had it up and running for months before we upgraded to 7.6.2 in July.

Now we're getting...
0 ERROR AT OR NEAR LINE 97 IN PROCEDURE rpt_phone_list
(FOC350) ERROR WRITING OUTPUT FILE: JK

The fex is very simple...
FILEDEF JK DISK \\SVR99MAIL\PHONE\PAGE.HTM
*focus code*
ON TABLE HOLD AS JK FORMAT HTML
*stylesheet code*

We've checked and double check the permissions on this SVR99MAIL server, but we're missing something.

Anyone seen this before? I didn't see anything in focal point that was useful, so it's either really really simple or really complex. Wink


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
December 12, 2007, 04:11 PM
GinnyJakes
I'm in a Unix shop and whenever I see that message, it is because

a. the file now belongs to someone else and the person who is trying to write it is not allowed.
b. the person trying to write it in Dev Studio is not who he thinks he is, i.e. the cookie got messed up.

You were right to look at permissions. The only other thing I can think of is space issues.


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
December 12, 2007, 04:54 PM
Jason K.
Well, the system's admin and I are having a hard time of all this.

Does anyone know where we can find the user the IBI is using to create a file listed in a filedef so we can grant that user the appropriate permissions?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
December 12, 2007, 04:59 PM
GinnyJakes
-SET &USERID=GETUSER('A8');
-TYPE THE USERID FROM GETUSER IS &USERID
  


That is if you are using a secured reporting server.


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
December 13, 2007, 01:06 AM
susannah
say Jason
does your file get written if you
TABLE FILE CAR
PRINT *
ON TABLE....
END
?
If so, its not the filedeffing and writing, its something whacky in your phone number data, perhaps. Check that sort of thing first.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 13, 2007, 02:36 AM
GamP
Or just do a -WRITE to the filedef after the filedef has been registered.
So:
FILEDEF JK DISK .....
-RUN
-WRITE JK Something

Maybe you'll find what's wrong in this way.
By the way, if you're running non-secure, the user the server runs under is the local system account. And that account only has full rights on the local machine and will not be allowed to write on other servers, regardless of the security level of that other server.
If that's the case it may be advisable to run the server as a secure (EDAEXTSEC=ON) or pass through (EDAEXTSEC=PTH) server.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
December 13, 2007, 08:50 AM
hammo1j
Jason has your report changed to using Amperautoprompt?



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
December 13, 2007, 09:01 AM
Jason K.
GamP: I think you're on to something with your suggestion. I think we are running non-secure. Is there any way to make this work with the non-secure setup that we have?

All: we are able to create the file on local drives, c: for example, but not on any other server, either through the UNC path or through mapping the drive on the reporting server first.

Thanks!


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.