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.
May 26, 2016, 05:24 AM
reena
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
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 " " "1 <20 Company Total <38 <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 *-------*
-*-------------* Exit Program on Success *-------------*
-QUIT FOCUS 0
-*-------------* Exit Program on Error *----------------*
-ERR -QUIT FOCUS &FOCERRNUM
WebFOCUS 8 Unix, All Outputs
July 05, 2016, 06:26 AM
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 -*-
WebFOCUS 8 Unix, All Outputs
July 05, 2016, 06:28 AM
reena
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