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 firstname.lastname@example.org for further assistance. Reference the community FAQ to learn more about the community.
Hello I have a fex that works fine outside of report caster.
When I try to run this program in Report caster it pumps this error out into the log.
Starting worker thread Starting task: 35AN Task type: EDA RPC Procedure name: internal_audit/IA0035AN Connecting to server EDASERVE with execution id dmoyer Executing focexec. INTERRUPT. DATA EXCEPTION FORMAT CONVERSION ERROR FIELD/KEY : CFCURAMOUNT SQLCODE IS 200 (HEX: 000000C8) : INTERRUPT. DATA EXCEPTION SQL FETCH CURSOR ERROR. : LACAPP1 Task error: INTERRUPT. DATA EXCEPTION No report to distribute.
The CFCURAMOUNT field is normally a P13.2 we run with D11.2M out side of report caster. But either way in report caster it doesnt work. Here is the code.
SET EMPTYREPORT = ON
JOIN CFKEY WITH POLICYNUMBER IN lacapp1 TO MULTIPLE CFCODE IN lacapcf AS POCF
DEFINE FILE LACAPP1
TABLE FILE LACAPP1
STATUSCODE AS 'STATUS CODE'
BASICPLANCOD AS 'BASIC PLAN CODE'
BY POLICYNUMBER AS 'POLICY NUMBER'
ON POLICYNUMBER SKIP-LINE
"WEB FOCUS ANNUITY POLICIES WITH FUTURE VALUYE LESS THAN $5.00 ----- IA0035AN"
"Prepared on <+0>&DATEtrMDYY <+0> &TOD Page <TABPAGENO of <TABLASTPAGE "
WHERE ( STATUSCODE IN ('1','2','3','4','P') ) AND ( CFNEXTDATE EQ '0000000' ) AND ( CFCURAMOUNT LT 5.00 );
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
We are on version 7.1.1 VSAM database
DanThis message has been edited. Last edited by: Kerry,
Are you sure the report runs correctly outside report caster? As Leah states caster isn't as tolerant as online environment. As soon as it gets something not really perfect, it refuses to send the report, because the result may be not ok. Whereas WebFocus always tries to do something to produce a result. Even if it may be wrong. And in fact the 'INTERRUP.DATA EXCEPTION' leads to an abend normally after the 10th occurrence. If you have less than 10 messages like that, your procedure will run stating the warnings somewhere in the back.
Test your procedure in the online environment using ON TABLE HOLD instead of ON TABLE PCHOLD FORMAT PDF and check out, if there are really no error/information/warning messages. About the error itself: check out the message codes of your DB. What may this SQLCode 200 mean? I guess there is something in the master which is the reason of the problem. Or as Leah says: something wrong with your data in one of the rows.
Prod: WF 7.1.5 Test: WF 7.6.4 Unix Sun Solaris HTML, PDF, EXL2K
Posts: 54 | Location: Switzerland | Registered: May 13, 2003
Well So far a ran it on table hold and didn't get any errors.
The SQL CODE I believe is this. (Which I think was when I was trying to use a set command in the report)
SQLCode -200 Constant SQLE_INVALID_OPTION SQLState 42W16 ODBC State 37000 Parameter 1 Name of the invalid option.
Probable cause You have probably misspelled the name of an option in the SET OPTION command. You can only define an option for a user if the database administrator has supplied a PUBLIC value for that option.