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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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
 
Egon
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
Egon
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