Focal Point
Solved - "Hard" filter on Master File - "Not parameter objects"

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

February 16, 2015, 01:59 PM
BM
Solved - "Hard" filter on Master File - "Not parameter objects"
HI,
Trying to apply filter on Master file so it will exclude certain records. trying DBA solution but getting the error below:

Error:
(FOC047) THE USER DOES NOT HAVE SUFFICIENT ACCESS RIGHTS TO THE FILE



DBA=DBA, $
USER=, ACCESS=R, RESTRICT=VALUE, NAME=SYSTEM, VALUE=FLAG EQ 'N', $


Not sure what I am doing wrong.

Thanks

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


WebFOCUS 8202M
February 16, 2015, 04:07 PM
Mike in DeLand
I think you have to have some user or group named after USER= on your MFD there.


Webfocus 8
Windows, Linux
February 16, 2015, 04:26 PM
BM
Thanks.

I had referred to the post below and in there it was mentioned that I don't.

http://forums.informationbuild...1057331/m/8767034626


WebFOCUS 8202M
February 16, 2015, 06:24 PM
Alan B
quote:
DBA=DBA, $
USER=, ACCESS=R, RESTRICT=VALUE, NAME=SYSTEM, VALUE=FLAG EQ 'N', $

The code should be fine.

Where, when and how are you getting this error message?


Alan.
WF 7.705/8.007
February 16, 2015, 08:43 PM
BM
In infoAssist and dev studio.


WebFOCUS 8202M
February 17, 2015, 06:31 AM
Rifaz
Give a space after USER= and try

DBA=DBA, $
USER= , ACCESS=R, RESTRICT=VALUE, NAME=SYSTEM, VALUE=FLAG EQ 'N', $   



-Rifaz

WebFOCUS 7.7.x and 8.x
February 17, 2015, 08:17 AM
BM
Thanks.. Tried it , doesn't work Frowner


WebFOCUS 8202M
February 17, 2015, 08:40 AM
Rifaz
Strange! One more try. Add END and try

END
DBA=DBA, $
USER= , ACCESS=R, RESTRICT=VALUE, NAME=SYSTEM, VALUE=FLAG EQ 'N', $

Are you able to access when commenting out ?


-Rifaz

WebFOCUS 7.7.x and 8.x
February 17, 2015, 11:55 AM
eric.woerle
BM,

Can you inlcude the entire masterfile? It might help us in seeing something that might be causing the issue.

Do you use the command SET PASS = XXXX or SET PERMPASS = XXXX anywhere? If so, your masterfile might be looking for a reference to that password in your masterfile. In this case it wouldn't find it at all.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
February 24, 2015, 04:46 PM
BM
Thanks eric.
I think that's the issue


WebFOCUS 8202M
February 26, 2015, 01:01 PM
TeePee
[QUOTE]Originally posted by eric.woerle:
...include command SET PASS = XXXX or SET PERMPASS = XXXX anywhere? ...

Is this a literal statement to include in the master file? ie. FILENAME = xxx, SET PASS = XXXX

Thanks,
TP


WF 8.0.08