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     [CLOSED] (FOC920) FOCSORT HAS REACHED ITS PAGE LIMIT 524287

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] (FOC920) FOCSORT HAS REACHED ITS PAGE LIMIT 524287
 Login/Join
 
Gold member
posted
How can I increase the PAGE LIMIT to avoid below error

(FOC920) FOCSORT HAS REACHED ITS PAGE LIMIT 524287

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


WebFocus 5.2.5
HP-UX(UNIX)
EXCEL, HTML, PDF and OLAP
 
Posts: 50 | Registered: August 04, 2009Report This Post
Virtuoso
posted Hide Post
Does your procedure have BY fields? If not you can change your TABLE FILE To TABLEF FILE

TABLEF does not use FOCSORT.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Gold member
posted Hide Post
quote:
Does your procedure have BY fields? If not you can change your TABLE FILE To TABLEF FILE

TABLEF does not use FOCSORT.


Yes, I have BY fields. also I am using "FORMAT FOCUS INDEX"


WebFocus 5.2.5
HP-UX(UNIX)
EXCEL, HTML, PDF and OLAP
 
Posts: 50 | Registered: August 04, 2009Report This Post
Virtuoso
posted Hide Post
are you sure the end result will fit in the focus database?
there are limits to that too...2 giga is more or less the limit




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Gold member
posted Hide Post
I am not sure. So you mean to say that I can't process the whole table data in batch(together)?


WebFocus 5.2.5
HP-UX(UNIX)
EXCEL, HTML, PDF and OLAP
 
Posts: 50 | Registered: August 04, 2009Report This Post
Virtuoso
posted Hide Post
You need to tell us more about what you want
what is the source
how many records has the source?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Member
posted Hide Post
How to solve below error in focus?

ERROR AT OR NEAR LINE 159 IN PROCEDURE ../023396.fex


(FOC920) FOCSORT EXCEEDED CURRENT PAGE LIMIT

Focus Error Number=8
ErrHandler: BL-REG-XCHG-CUST-TP focus report failed


WebFOCUS 8
Unix, All Outputs
 
Posts: 10 | Registered: May 23, 2016Report This Post
Master
posted Hide Post
I see you are on UNIX. Did you run out of allotted disk space?

What is the source? If it is relational, then you can use TABLEF with BY fields (depending on other things like DEFINE, COMPUTES, etc.) and FOCUS will not resort. You also need to examine the SQL generated.

In more recent releases there is a SET command (SQLTOPTTF) that tells WebFOCUS to use TABLEF when it can. I don't think it is in your release of WebFOCUS.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Member
posted Hide Post
Below is my fex file which creating reoprt.
I dont know how to solve the isshu.

ERROR AT OR NEAR LINE 159 IN PROCEDURE ../023396.fex
(FOC920) FOCSORT EXCEEDED CURRENT PAGE LIMIT

----------------------------------------------------------

SET PANEL=136
SET WIDTH=200
SET LINES=52
SET SCREEN=OFF

-*---------* Define input and outpt file names *------*
-SET &EXT_NAME=FGETENV(19,'FCS_SHRT_INPUT_EXTR',14,'A14');
-SET &LAY_NAME=FGETENV(20,'FCS_SHRT_OUTPUT_LAY7',14,'A14');
-SET &&REP_FILE=('../'||&LAY_NAME);
-SET &EXT_FILE=('../'||&EXT_NAME);

-SET &FROM_DATE=FGETENV(9,'FROM_DATE',8,'A8');
-SET &TO_DATE=FGETENV(7,'TO_DATE',8,'A8');
-SET &CYCLE=FGETENV(5,'CYCLE',2,'A2');

-SET &PF_DATE=EDIT(&FROM_DATE,'$$$$99$$') | '/' | EDIT(&FROM_DATE,'$$$$$$99')
- | '/' | EDIT(&FROM_DATE,'9999$$$$');
-SET &PT_DATE=EDIT(&TO_DATE,'$$$$99$$') | '/' | EDIT(&TO_DATE,'$$$$$$99')
- | '/' | EDIT(&TO_DATE,'9999$$$$');
-SET &CYCLE = IF &CYCLE EQ ' ' THEN 'ALL' ELSE &CYCLE;

-SET &&APPARTXT1 = 'From Date';
-SET &&APPARVAL1 = &PF_DATE;

-SET &&APPARTXT2 = 'End Date ';
-SET &&APPARVAL2 = &PT_DATE;

-SET &&APPARTXT3 = 'Cycle ';
-SET &&APPARVAL3 = &CYCLE;

-*------------* Define report code and report name *---*
-SET &REPCODE='ARIN-03-REC';
-SET &REPNAME='CYCLE BILLING RECAP BY NPANXX';
-INCLUDE gnrpdef.fex

-*---------*Define input file *------------------------*
FILEDEF ARRP_BL DISK &EXT_FILE ( RECFM V LRECL 263
SET ASNAMES=ON

-RUN

-*---------*Define output file *-----------------------*
FILEDEF OFFLINE DISK &&REP_FILE (RECFM V LRECL 132
OFFLINE



DEFINE FILE ARRP_BL
DUMMY/A1=' ';
T_AMT/P13.2C=RCCHG+OCCHG+UCCHG+PCCHG;
B_AMT/P13.2C=RCCHG;
P_AMT/P11.2C=PCCHG;
O_AMT/P11.2C=OCCHG;
U_AMT/P11.2C=UCCHG;
NO_MSGS/I9C=NOMSGS;

CATPRE/A6 = EDIT(CATEGORY,'999999') ;
CATSUF/A6 = EDIT (CATEGORY,'$$$$$$999999');
CATCODE/A13 = CATPRE | ' ' | CATSUF ;
ACCTTYPE_NAME/A8=IF ACCTTYPE EQ 'B' THEN 'BUSINESS'
ELSE 'RESIDENT';
NPA_NXX/A7=EDIT(PRODUCTID,'999-999$$$$$$$$$$');
PCYCLE/A3=IF CYCLE NE '0 ' THEN CYCLE ELSE 'ALL';
END

TABLE FILE ARRP_BL
HEADING
-INCLUDE gnrphdr.fex
"CYCLE : "COMPANY : -*---"EXCHANGE : " "
SUM GLCODE AS 'ACCT, CODE ' IN 1
-* CATEGORY AS 'CATEGORY, CODE ' IN 12
CATCODE AS 'CATEGORY, CODE ' IN 10
CATDESC AS ' DESCRIPTION , ' IN 24
T_AMT AS ' TOTAL ' IN 49
B_AMT AS ' RECURRING , AMOUNT ' IN 65
P_AMT AS ' PARTIAL , AMOUNT ' IN 81
O_AMT AS ' ONE TIME , AMOUNT ' IN 95
U_AMT AS ' USAGE , AMOUNT ' IN 109
NO_MSGS AS ' # OF, MESSAGES' IN 123

BY DUMMY NOPRINT
BY CYCLE NOPRINT
BY COMPANY NOPRINT
BY NPA_NXX NOPRINT NOSPLIT PAGE-BREAK
BY GLCODE NOPRINT
BY CATEGORY NOPRINT
BY CATCODE NOPRINT
-*--BY CATDESC NOPRINT
-*-

ON NPA_NXX SUBFOOT
"<13 NPA-NXX <92 " "
WHEN COMPANY NE 'S080'

ON COMPANY SUBFOOT
"" <92
ON CYCLE SUBFOOT SKIP-LINE
"<20 Cycle Total <38 <92
ON DUMMY SUBFOOT
""<20 Report Total <38 <92 " "
FOOTING BOTTOM

-INCLUDE gnrpftr
END


-RUN
-*-------------* Check status of report section *-------*

-IF &FOCERRNUM NE 0 GOTO ERR;

-*-------------* Empty Report Handling *----------------*

-INCLUDE gnrpempt

-*-------------* Exit Program on Success *-------------*

-QUIT FOCUS 0

-*-------------* Exit Program on Error *----------------*

-ERR
-QUIT FOCUS &FOCERRNUM


WebFOCUS 8
Unix, All Outputs
 
Posts: 10 | Registered: May 23, 2016Report This Post
Member
posted Hide Post
quote:
Originally posted by jgelona:
I see you are on UNIX. Did you run out of allotted disk space?

What is the source? If it is relational, then you can use TABLEF with BY fields (depending on other things like DEFINE, COMPUTES, etc.) and FOCUS will not resort. You also need to examine the SQL generated.

In more recent releases there is a SET command (SQLTOPTTF) that tells WebFOCUS to use TABLEF when it can. I don't think it is in your release of WebFOCUS.



Yes,I am on unix.Actually this is a monthally Job and for april it failed, then for May it did not failed,
Now for June it agan failed.This is on production data.

I dont understand how is this happening.

What do u mean by source ?

snippet of my code:

TABLE FILE ARRP_BL
HEADING
-INCLUDE gnrphdr.fex
"CYCLE : "COMPANY : -*---"EXCHANGE : " "
SUM GLCODE AS 'ACCT, CODE ' IN 1
-* CATEGORY AS 'CATEGORY, CODE ' IN 12
CATCODE AS 'CATEGORY, CODE ' IN 10
CATDESC AS ' DESCRIPTION , ' IN 24
T_AMT AS ' TOTAL ' IN 49
B_AMT AS ' RECURRING , AMOUNT ' IN 65
P_AMT AS ' PARTIAL , AMOUNT ' IN 81
O_AMT AS ' ONE TIME , AMOUNT ' IN 95
U_AMT AS ' USAGE , AMOUNT ' IN 109
NO_MSGS AS ' # OF, MESSAGES' IN 123

BY DUMMY NOPRINT
BY CYCLE NOPRINT
BY COMPANY NOPRINT
BY NPA_NXX NOPRINT NOSPLIT PAGE-BREAK
BY GLCODE NOPRINT
BY CATEGORY NOPRINT
BY CATCODE NOPRINT
-*--BY CATDESC NOPRINT
-*-


WebFOCUS 8
Unix, All Outputs
 
Posts: 10 | Registered: May 23, 2016Report This Post
Member
posted Hide Post
quote:
Originally posted by reena:
[QUOTE]Originally posted by jgelona:
I see you are on UNIX. Did you run out of allotted disk space?

What is the source? If it is relational, then you can use TABLEF with BY fields (depending on other things like DEFINE, COMPUTES, etc.) and FOCUS will not resort. You also need to examine the SQL generated.

In more recent releases there is a SET command (SQLTOPTTF) that tells WebFOCUS to use TABLEF when it can. I don't think it is in your release of WebFOCUS.



Yes,I am on unix.Actually this is a monthally Job and for april it failed, then for May it did not failed,
Now for June it agan failed.This is on production data.

I dont understand how is this happening.

What do u mean by source ?

snippet of my code:

TABLE FILE ARRP_BL
HEADING
-INCLUDE gnrphdr.fex
"CYCLE : "COMPANY : -*---"EXCHANGE : " "
SUM GLCODE AS 'ACCT, CODE ' IN 1
-* CATEGORY AS 'CATEGORY, CODE ' IN 12
CATCODE AS 'CATEGORY, CODE ' IN 10
CATDESC AS ' DESCRIPTION , ' IN 24
T_AMT AS ' TOTAL ' IN 49
B_AMT AS ' RECURRING , AMOUNT ' IN 65
P_AMT AS ' PARTIAL , AMOUNT ' IN 81
O_AMT AS ' ONE TIME , AMOUNT ' IN 95
U_AMT AS ' USAGE , AMOUNT ' IN 109
NO_MSGS AS ' # OF, MESSAGES' IN 123

BY DUMMY NOPRINT
BY CYCLE NOPRINT
BY COMPANY NOPRINT
BY NPA_NXX NOPRINT NOSPLIT PAGE-BREAK
BY GLCODE NOPRINT
BY CATEGORY NOPRINT
BY CATCODE NOPRINT
-*--BY CATDESC NOPRINT
-*-

How to solve below error in focus?

ERROR AT OR NEAR LINE 159 IN PROCEDURE ../023396.fex


(FOC920) FOCSORT EXCEEDED CURRENT PAGE LIMIT

Focus Error Number=8
ErrHandler: BL-REG-XCHG-CUST-TP focus report failed


WebFOCUS 8
Unix, All Outputs
 
Posts: 10 | Registered: May 23, 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     [CLOSED] (FOC920) FOCSORT HAS REACHED ITS PAGE LIMIT 524287

Copyright © 1996-2020 Information Builders