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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED by case] Three Tier environment and saving HOLD files

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED by case] Three Tier environment and saving HOLD files
 Login/Join
 
Francis Mariani
Expert
posted
In our two tier AIX environment, when I want to save a HOLD file and Master for future use, I run the following commands:

UNIX mkdir -p /home/user-id/webfocus_data
-RUN

APP MAP webfocus_data /home/user-id/webfocus_data
-RUN

APP HOLDMETA webfocus_data
APP HOLDDATA webfocus_data
-RUN


This will save all HOLD files and Masters to a sub-directory in the user's home directory.

In the new three tier AIX environment, I get the following error when creating the webfocus_data sub-directory:


mkdir: 0653-358 Cannot create /home/sdqw02.
/home/sdqw02: The file access permissions do not allow the specified action.

This is most likely because the User ID is not defined on the middle tier where the WebFOCUS server operates - only on the third tier where DB2 runs.

Do we have to get the User ID's defined on both the second and third tier servers?

Thanks,

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


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, 2005Report This Post
GinnyJakes
Expert
posted Hide Post
It sounds like you are either running the reporting server with security off or with a default AIX userid specified in the client config.

You can find out by running a quick fex that does a GETUSER.

I don't recommend the administrative hassle of having to set up ids for your users on yet another box as that would require them to have to log onto your application and then deal with password changes.

What you could do, however, is have your UNIX admin set up a special place where these files could be stored and then make sure that the default id has the appropriate permissions to create directories and write files to this area. Most regular users are never given the authority to write to /home/userid.

I think this would be the easiest way to go. We have a /data directory structure where this is done.

Let me know if you have any other questions on this.


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
Ginny, thanks for your ideas. I'll discuss it with the UNIX administrators.

Thanks,

Francis.


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, 2005Report This Post
Kerry
Expert
posted Hide Post
Hi all,

FYI, Francis has a case opened for this issue and here is the response in the case (50852557):

Since the user ID and associated permissions are not defined where WebFOCUS is running, you're receiving the error. The IDs will need to be set up for WebFOCUS.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report 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     [SOLVED by case] Three Tier environment and saving HOLD files

Copyright © 1996-2020 Information Builders