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
CFKEY/A15='  A'|POLICYNUMBER|'01';
END
TABLE FILE LACAPP1
PRINT
     STATUSCODE AS 'STATUS CODE'
     BASICPLANCOD AS 'BASIC PLAN CODE'
     CFCURAMOUNT/D11.2M
BY POLICYNUMBER AS 'POLICY NUMBER'
ON POLICYNUMBER SKIP-LINE
HEADING
" "
"WEB FOCUS ANNUITY POLICIES WITH FUTURE VALUYE LESS THAN $5.00 ----- IA0035AN"
" "
FOOTING
" "
"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

Thanks

Dan

This message has been edited. Last edited by: Kerry,

Is it possible the table containing the amount has 'bad' data. Or allows nulls. Caster doesn't always allow some things to get by when the interactive environment does.

Dan,

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.

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.

Any other thoughts

Dan