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     FORMAT CONVERSION ERROR FIELD/KEY : CFCURAMOUNT

Read-Only Read-Only Topic
Go
Search
Notify
Tools
FORMAT CONVERSION ERROR FIELD/KEY : CFCURAMOUNT
 Login/Join
 
Platinum Member
posted
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,


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Report This Post
Virtuoso
posted Hide Post
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.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Gold member
posted Hide Post
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.


Roland

Prod: WF 7.1.5
Test: WF 7.6.4
Unix Sun Solaris
HTML, PDF, EXL2K
 
Posts: 54 | Location: Switzerland | Registered: May 13, 2003Report This Post
Platinum Member
posted Hide Post
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


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Report 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     FORMAT CONVERSION ERROR FIELD/KEY : CFCURAMOUNT

Copyright © 1996-2020 Information Builders