Focal Point
[Solved]MASTER or PASS has changed since last DEFINE

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

July 07, 2010, 11:14 AM
Rick Man
[Solved]MASTER or PASS has changed since last DEFINE
The report has a pre-process procedure. Each when run sepately work just fine. When in Report Caster I get this message. yes they both create SQLOUT files. What might be the work around to prevent this? Thanks

BTP1020 Executing focexec.
BTP1020 MASTER or PASS has changed since last DEFINE for filename SQLOUT
BTP1020 MASTER or PASS has changed since last DEFINE for filename SQLOUT
BTP1020 Change to MASTER or SET PASS forces DEFINE CLEAR for filename SQLOUT
BTP1010 Task error: MASTER or PASS has changed since last DEFINE for filename SQLOUT
BTP1010 No report to distribute.

This message has been edited. Last edited by: Rick Man,


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
July 07, 2010, 02:01 PM
Tom Flynn
Rick,

Try this:
 
DEFINE FILE SQLOUT 
  YADDA/A30= 'Whatever;
END
TABLE FILE SQLOUT
PRINT/SUM
   YADDA
END
-RUN

DEFINE FILE SQLOUT CLEAR
END

-EXIT


hth


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
July 07, 2010, 02:52 PM
Rick Man
Great, that did it. Hmmmm
Thanks


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
July 07, 2010, 03:03 PM
njsden
Very interesting tip, Tom. Nice to be kept in mind.



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.
January 13, 2012, 01:02 PM
Doug
Confused
quote:
Rick Man : Hmmmm
How about the "@0000024" in this error: "Completed with errors/warnings Task error: MASTER or PASS has changed since last DEFINE for filename @0000024 No report to distribute" ?




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206