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] Hold Files are being Created in Baseapp instead of Foccache

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Hold Files are being Created in Baseapp instead of Foccache
 Login/Join
 
Gold member
posted
Hi All,

I am having a Dashboard which creates a bunch of Hold Files. When Tested in DEV 8105 i believe that they are being created in Foccahe. We recently upgraded our TEST from 8009 to 8105 and promoted the Dashboard package over there.

Now all the hold files are being created in baseapp in TEST. Now this might be a problem moving on for multiple users. Is there something we are missing over here? Like a Mapping to Foccahe in Admin Console ? or do i have to append the the path to FOCCACHE every time?

 

ENGINE INT CACHE SET ON


-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';

DEFINE FILE SALES_POS_LN_NONPII_BV
DEPT/A40V=SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_DEPT_ID || '-' || SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_DEPT_DESC;
ACTIVITY/A2=EDIT( SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.ACTIVITY_HOUR,'99$');
END

TABLE FILE SALES_POS_LN_NONPII_BV
SUM
     SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.UNITS_SOLD AS 'Units Sold'
     SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.EXTENDED_AMT
     SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.SELLING_UNIT
BY TOTAL HIGHEST 30 SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.EXTENDED_AMT NOPRINT
BY  SALES_POS_LN_NONPII_BV.MSTR_ITEM_DIMENSION.ITEM_SCAN_CD_ID AS 'UPC/PLU'
BY  SALES_POS_LN_NONPII_BV.MSTR_ITEM_DIMENSION.ITEM_DESC
WHERE ( SALES_POS_LN_NONPII_BV.MSTR_DATE_DIMENSION.CAL_DATE EQ '&CAL_DATE.(FIND SALES_POS_LN_NONPII_BV.MSTR_DATE_DIMENSION.CAL_DATE IN SALES_POS_LN_NONPII_BV).CAL_DATE:.' );
WHERE SALES_POS_LN_NONPII_BV.MSTR_LOCATION_DIMENSION.STORE_NUM EQ &STORE_NUM.(OR(FIND SALES_POS_LN_NONPII_BV.MSTR_LOCATION_DIMENSION.STORE_NUM,SALES_POS_LN_NONPII_BV.MSTR_LOCATION_DIMENSION.STORE_NUM IN SALES_POS_LN_NONPII_BV)).STORE_NUM:.;
WHERE SALES_POS_LN_NONPII_BV.MSTR_POS_DEPARTMENT_DIMENSION.POS_DEPT_SALES_DEPT_FL EQ 'Y';
WHERE SALES_POS_LN_NONPII_BV.MSTR_TRANSACTION_TYPE_DIMENSION.CUST_TX_FL EQ 'Y';
WHERE SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_BIZ_UNIT_ID EQ '011';
WHERE SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_ORG_UNIT_ID EQ '000';
WHERE SALES_POS_LN_NONPII_BV.MSTR_POS_ITEM_TYPE_DIMENSION.POS_ITEM_TYPE_NET_SALE_INC_FL EQ 'Y';
WHERE SALES_POS_LN_NONPII_BV.MSTR_GL_DEPARTMENT_DIMENSION.GL_DEPT_ID NE '09' OR '13';
WHERE SALES_POS_LN_NONPII_BV.SALES_POS_LN_VW.UNITS_SOLD GT 0.00;
ON TABLE HOLD AS HLD01
END

GRAPH FILE HLD01
-* Created by Info Assist for Graph
SUM HLD01.HLD01.EXTENDED_AMT AS 'Net Sales'
BY HIGHEST HLD01.HLD01.EXTENDED_AMT NOPRINT
BY HLD01.HLD01.ITEM_DESC AS 'UPC/PLU'
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setLegendPosition(1);
setLegendPosition(1);
setTextString(getX1Title(),"Item Desc");
setDisplay(getX1Title(),true);
setTextString(getY1Title(),"Net Sales");
setDisplay(getY1Title(),true);
setDataTextPosition(1);
setDisplay(getDataText(),false);
setDataTextDisplay(false);
setTextRotation(getO1Label(),3);
setLabelStagger(getO1Label(),false);
setFillColor(getSeries(0),new Color(83,172,205));

*END
*GRAPH_JS
"introAnimation": {
    "enabled": true
}
,

*END
ENDSTYLE
END

-RUN

-IF &LINES NE 0 THEN GOTO :SKIPERROR;
-HTMLFORM IBFS:/WFC/Repository/Dashboard_Analytics/HTML/nodata.htm
-:SKIPERROR


 

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


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
 
Posts: 52 | Location: BOWL OF PASTA | Registered: October 13, 2016Report This Post
Virtuoso
posted Hide Post
Hi Tharun

By default all hold files are created in the edatemp directory under the tsxxxxxx folder for the agent used during the request. The APP HOLD command overrides this behavior. You may have a profile fex that has the setting APP HOLD baseapp in it. There are several places this may be. On the WebFOCUS client under the administration console in the Client Settings / General area there is a _site_profile setting where a -INCLUDE is used. on the Reporting Server check the edasprof.prf (Server profile). The other place this may be coded is directly in the fex you are executing but I don't see that in your code.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
I think you mean the HOLD-files were being created as temporary files in EDATEMP. FOCCACHE is different from that, it holds files belonging to the same session, which can span a bunch of procedures called by the same user from the same browser.

As for your issue, you probably have APP HOLD BASEAPP somewhere. Perhaps a line like that is in a server profile?


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Gold member
posted Hide Post
Thanks Chuck and Wep5622.

I found out APP HOLD BASEAPP in our server profile. Commenting it out made everything back to normal again.


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
 
Posts: 52 | Location: BOWL OF PASTA | Registered: October 13, 2016Report 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] Hold Files are being Created in Baseapp instead of Foccache

Copyright © 1996-2020 Information Builders