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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] FOC1425 - FOC1400 - FOC1407 error

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] FOC1425 - FOC1400 - FOC1407 error
 Login/Join
 
Gold member
posted
All,

I have a report that has functioned without issue until recently and even now it seems to work except when the parameters have a certain value. Below is my code, and after that is my output with SQL trace on. Any and all help would be appreciated. I can run the SQL statement perfectly fine in SQL developer without errors. Database is Oracle.

SET TRACEON = SQLCALL
SET TRACEON = SQLTRANS
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = ON


JOIN FGBTRNH_DOC_SEQ_CODE AND FGBTRNH_DOC_CODE AND FGBTRNH_ITEM_NUM AND
     FGBTRNH_SEQ_NUM AND FGBTRNH_SUBMISSION_NUMBER AND FGBTRNH_SERIAL_NUM AND FGBTRNH_REVERSAL_IND IN FGBTRNH TO
     FGBTRND_DOC_SEQ_CODE AND FGBTRND_DOC_CODE AND FGBTRND_ITEM_NUM AND
	 FGBTRND_SEQ_NUM AND FGBTRND_SUBMISSION_NUMBER AND FGBTRND_SERIAL_NUM AND FGBTRND_REVERSAL_IND IN FGBTRND AS J1
END
TABLE FILE FGBTRNH
PRINT *
BY FGBTRND_DOC_SEQ_CODE NOPRINT
WHERE FGBTRND_FSYR_CODE EQ '&FISCALYEAR.((21)).';
WHERE FGBTRND_FUND_CODE EQ '&FUNDCODE.((A101)).';
WHERE FGBTRND_ORGN_CODE EQ '&ORGCODE.((22320)).';
WHERE FGBTRND_LEDGER_IND EQ 'O';
ON TABLE HOLD AS DETAIL1
END


 
SET GRAPHSERVURL=https://webfocus.nwmissouri.edu:443/ibi_apps/IBIGraphServlet
 SET GRAPHENGINE=GRAPH53
 -INCLUDE mrheader
 -* mr header include start
 -* mr as NOT html
 -SET &FOCEXURL=/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=ECHOALL&IBIAPP_app=financeapp& | '&' | 'IBIMR_drill=IBFS,RUNFEX,IBIF_ex,true' | '&';
 -OLAP ON
 SET FOCEXURL='/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=ECHOALL&IBIAPP_app=financeapp&&IBIMR_drill=IBFS,RUNFEX,IBIF_ex,true&'
 -OLAP OFF
 -* mr header include end
 -*
 -INCLUDE ADHOCRQ
 SET TRACEON = SQLCALL
 SET TRACEON = SQLTRANS
 SET TRACEON = STMTRACE//CLIENT
 SET TRACEON = SQLAGGR//CLIENT
 SET TRACEUSER = ON
 JOIN FGBTRNH_DOC_SEQ_CODE AND FGBTRNH_DOC_CODE AND FGBTRNH_ITEM_NUM AND
 FGBTRNH_SEQ_NUM AND FGBTRNH_SUBMISSION_NUMBER AND FGBTRNH_SERIAL_NUM AND FGBTRNH_REVERSAL_IND IN FGBTRNH TO
 FGBTRND_DOC_SEQ_CODE AND FGBTRND_DOC_CODE AND FGBTRND_ITEM_NUM AND
 FGBTRND_SEQ_NUM AND FGBTRND_SUBMISSION_NUMBER AND FGBTRND_SERIAL_NUM AND FGBTRND_REVERSAL_IND IN FGBTRND AS J1
 END
 TABLE FILE FGBTRNH
 PRINT *
 BY FGBTRND_DOC_SEQ_CODE NOPRINT
 WHERE FGBTRND_FSYR_CODE EQ '21';
 WHERE FGBTRND_FUND_CODE EQ 'A101';
 WHERE FGBTRND_ORGN_CODE EQ '22320';
 WHERE FGBTRND_LEDGER_IND EQ 'O';
 ON TABLE HOLD AS DETAIL1
 END
 13.45.13 BT  (FOC2590) AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
 13.45.13 BT  (FOC2594) AGGREGATION IS NOT APPLICABLE TO THE VERB USED
 13.45.13 AE    SELECT
 13.45.13 AE   T1."FGBTRNH_DOC_CODE",
 13.45.13 AE   T1."FGBTRNH_ITEM_NUM",
 13.45.13 AE   T1."FGBTRNH_SEQ_NUM",
 13.45.13 AE   T1."FGBTRNH_DOC_SEQ_CODE",
 13.45.13 AE   T1."FGBTRNH_SUBMISSION_NUMBER",
 13.45.13 AE   T1."FGBTRNH_REVERSAL_IND",
 13.45.13 AE   T1."FGBTRNH_SERIAL_NUM",
 13.45.13 AE   T1."FGBTRNH_RUCL_CODE",
 13.45.13 AE   T1."FGBTRNH_ACTIVITY_DATE",
 13.45.13 AE   T1."FGBTRNH_USER_ID",
 13.45.13 AE   T1."FGBTRNH_DOC_REF_NUM",
 13.45.13 AE   T1."FGBTRNH_TRANS_DATE",
 13.45.13 AE   T1."FGBTRNH_TRANS_AMT",
 13.45.13 AE   T1."FGBTRNH_TRANS_DESC",
 13.45.13 AE   T1."FGBTRNH_DR_CR_IND",
 13.45.13 AE   T1."FGBTRNH_BANK_CODE",
 13.45.13 AE   T1."FGBTRNH_BUD_ID",
 13.45.13 AE   T1."FGBTRNH_COAS_CODE",
 13.45.13 AE   T1."FGBTRNH_FSYR_CODE",
 13.45.13 AE   T1."FGBTRNH_ACCI_CODE",
 13.45.13 AE   T1."FGBTRNH_FUND_CODE",
 13.45.13 AE   T1."FGBTRNH_ORGN_CODE",
 13.45.13 AE   T1."FGBTRNH_ACCT_CODE",
 13.45.13 AE   T1."FGBTRNH_PROG_CODE",
 13.45.13 AE   T1."FGBTRNH_ACTV_CODE",
 13.45.13 AE   T1."FGBTRNH_LOCN_CODE",
 13.45.13 AE   T1."FGBTRNH_POSTING_PERIOD",
 13.45.13 AE   T1."FGBTRNH_DEP_NUM",
 13.45.13 AE   T1."FGBTRNH_ENCD_NUM",
 13.45.13 AE   T1."FGBTRNH_ENCD_ITEM_NUM",
 13.45.13 AE   T1."FGBTRNH_ENCD_SEQ_NUM",
 13.45.13 AE   T1."FGBTRNH_ENCD_ACTION_IND",
 13.45.13 AE   T1."FGBTRNH_PRJD_CODE",
 13.45.13 AE   T1."FGBTRNH_AUTO_JRNL_ID",
 13.45.13 AE   T1."FGBTRNH_DIST_PCT",
 13.45.13 AE   T1."FGBTRNH_BUD_DISPN",
 13.45.13 AE   T1."FGBTRNH_CMT_TYPE",
 13.45.13 AE   T1."FGBTRNH_CMT_PCT",
 13.45.13 AE   T1."FGBTRNH_ENCB_TYPE",
 13.45.13 AE   T1."FGBTRNH_VENDOR_PIDM",
 13.45.13 AE   T1."FGBTRNH_BUDGET_PERIOD",
 13.45.13 AE   T1."FGBTRNH_ACCRUAL_IND",
 13.45.13 AE   T1."FGBTRNH_ABAL_OVERRIDE",
 13.45.13 AE   T1."FGBTRNH_CURR_CODE",
 13.45.13 AE   T1."FGBTRNH_CONVERT_AMT",
 13.45.13 AE   T1."FGBTRNH_EXCHANGE_AMT",
 13.45.13 AE   T1."FGBTRNH_EXCHANGE_DIFF",
 13.45.13 AE   T1."FGBTRNH_SUM_POST_DOC_CODE",
 13.45.13 AE   T1."FGBTRNH_COAS_CODE_POOL",
 13.45.13 AE   T1."FGBTRNH_FUND_CODE_POOL",
 13.45.13 AE   T2."FGBTRND_RUCL_CODE",
 13.45.13 AE   T2."FGBTRND_DOC_SEQ_CODE",
 13.45.13 AE   T2."FGBTRND_DOC_CODE",
 13.45.13 AE   T2."FGBTRND_SUBMISSION_NUMBER",
 13.45.13 AE   T2."FGBTRND_ITEM_NUM",
 13.45.13 AE   T2."FGBTRND_SEQ_NUM",
 13.45.13 AE   T2."FGBTRND_RULP_CODE",
 13.45.13 AE   T2."FGBTRND_LEDGER_IND",
 13.45.13 AE   T2."FGBTRND_FIELD_CODE",
 13.45.13 AE   T2."FGBTRND_POSTING_PERIOD",
 13.45.13 AE   T2."FGBTRND_ACTIVITY_DATE",
 13.45.13 AE   T2."FGBTRND_USER_ID",
 13.45.13 AE   T2."FGBTRND_PROC_CODE",
 13.45.13 AE   T2."FGBTRND_COAS_CODE",
 13.45.13 AE   T2."FGBTRND_FSYR_CODE",
 13.45.13 AE   T2."FGBTRND_ACCI_CODE",
 13.45.13 AE   T2."FGBTRND_FUND_CODE",
 13.45.13 AE   T2."FGBTRND_ORGN_CODE",
 13.45.13 AE   T2."FGBTRND_ACCT_CODE",
 13.45.13 AE   T2."FGBTRND_PROG_CODE",
 13.45.13 AE   T2."FGBTRND_ACTV_CODE",
 13.45.13 AE   T2."FGBTRND_LOCN_CODE",
 13.45.13 AE   T2."FGBTRND_BUD_ID",
 13.45.13 AE   T2."FGBTRND_BUDGET_PERIOD",
 13.45.13 AE   T2."FGBTRND_ENCD_NUM",
 13.45.13 AE   T2."FGBTRND_ENCD_ITEM_NUM",
 13.45.13 AE   T2."FGBTRND_ENCD_SEQ_NUM",
 13.45.13 AE   T2."FGBTRND_TRANS_AMT",
 13.45.13 AE   T2."FGBTRND_DR_CR_IND",
 13.45.13 AE   T2."FGBTRND_OTHER_DATA",
 13.45.13 AE   T2."FGBTRND_RECON_IND",
 13.45.13 AE   T2."FGBTRND_REVERSAL_IND",
 13.45.13 AE   T2."FGBTRND_SERIAL_NUM",
 13.45.13 AE   T2."FGBTRND_AMT_IND",
 13.45.13 AE   T2."FGBTRND_PRJD_CODE",
 13.45.13 AE   T2."FGBTRND_SUM_POST_DOC_CODE",
 13.45.13 AE   T2."FGBTRND_CMT_TYPE",
 13.45.13 AE   T2."FGBTRND_CMT_PCT",
 13.45.13 AE   T2."FGBTRND_ALLOC_DOC_NUM",
 13.45.13 AE   T2."FGBTRND_ALLOC_SEQ_NUM",
 13.45.13 AE   T2."FGBTRND_ALLOC_PCT",
 13.45.13 AE   T2."FGBTRND_DEFER_GRANT_IND",
 13.45.13 AE   T2."FGBTRND_IC_RATE_PERCENT",
 13.45.13 AE   T2."FGBTRND_IC_MEMO_RATE_PERCENT",
 13.45.13 AE   T2."FGBTRND_CS_RATE_PERCENT",
 13.45.13 AE   T2."FGBTRND_CS_MEMO_RATE_PERCENT"
 13.45.13 AE    FROM
 13.45.13 AE   FIMSMGR.FGBTRNH T1,
 13.45.13 AE   FIMSMGR.FGBTRND T2
 13.45.13 AE    WHERE
 13.45.13 AE   (T2."FGBTRND_DOC_SEQ_CODE" = T1."FGBTRNH_DOC_SEQ_CODE") AND
 13.45.13 AE   (T2."FGBTRND_DOC_CODE" = T1."FGBTRNH_DOC_CODE") AND
 13.45.13 AE   (T2."FGBTRND_ITEM_NUM" = T1."FGBTRNH_ITEM_NUM") AND
 13.45.13 AE   (T2."FGBTRND_SEQ_NUM" = T1."FGBTRNH_SEQ_NUM") AND
 13.45.13 AE   (T2."FGBTRND_SUBMISSION_NUMBER" =
 13.45.13 AE   T1."FGBTRNH_SUBMISSION_NUMBER") AND
 13.45.13 AE   (T2."FGBTRND_SERIAL_NUM" = T1."FGBTRNH_SERIAL_NUM") AND
 13.45.13 AE   (T2."FGBTRND_REVERSAL_IND" = T1."FGBTRNH_REVERSAL_IND") AND
 13.45.13 AE   (T2."FGBTRND_LEDGER_IND" = 'O') AND
 13.45.13 AE   (T2."FGBTRND_ORGN_CODE" = '22320') AND
 13.45.13 AE   (T2."FGBTRND_FUND_CODE" = 'A101') AND
 13.45.13 AE   (T2."FGBTRND_FSYR_CODE" = '21')
 13.45.13 AE    ORDER BY
 13.45.13 AE   T2."FGBTRND_DOC_SEQ_CODE";
 (FOC1425) OVERFLOW, ZERODIVIDE OR CONVERSION ERROR ON ITEM #  : 7/FGBTRNH_SERIAL_NUM
 (FOC1425) OVERFLOW, ZERODIVIDE OR CONVERSION ERROR ON ITEM #  : 83/FGBTRND_SERIAL_NUM
 (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
 (FOC1407) SQL FETCH CURSOR ERROR.  : FGBTRNH
 

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


WebFocus App Studio 8.1.0.5, Windows 7 64bit.
 
Posts: 65 | Location: Missouri, USA | Registered: March 06, 2014Report This Post
Gold member
posted Hide Post
Refreshing of the master file fixed the issue. My best guess is a recent upgrade/change to the table caused the issue.


WebFocus App Studio 8.1.0.5, Windows 7 64bit.
 
Posts: 65 | Location: Missouri, USA | Registered: March 06, 2014Report 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] FOC1425 - FOC1400 - FOC1407 error

Copyright © 1996-2020 Information Builders