[SOLVED] FOC1425 - FOC1400

November 30, 2020, 02:50 PM

Egon

[SOLVED] FOC1425 - FOC1400 - FOC1407 error

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,