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.
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, 2014