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.

New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.

What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.

During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.


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