Anybody aware of this kind error in WebFOCUS 7.1.1?
"(FOC1400) SQLCODE IS -1(HEX: FFFFFFFF) (FOC1407) SQL FETCH CURSOR ERROR. : AR_INVOICES"

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

Querying FOCUS 1407 error code:

? 1407

quote:

(FOC1407) SQL FETCH CURSOR ERROR. %1%2%3%4

An error condition occurred while attempting to fetch data through a cursor in the RDBMS.

An additional error message specifying the appropriate RDBMS error code will usually accompany this message.

Consult the appropriate RDBMS error message reference for proper corrective measures.

What RDBMS are you using?

If you are using DB2, in order to retrieve native DB2 Error Message, try also:

SQL DB2 SET ERRORTYPE DBMS


Regards,
Mikel

We are using Oracle 9.2. Is this related to Oracle version? This error comes only in WebFOCUS 7.1 and 7.1.1 versions, report runs fine in 5.32.

Thanks,
Jeeva

Are you able to access any tables from database through WF711?

Yes, we are. We have about 250 reports in WebFOCUS 7.1.1 only few of them having problems like this.

Thanks,
Jeeva

Only a few? Are there unusual columns in these, VARCHAR, CLOB, etc?

Did you recently upgrade Oracle? If so, did you generate new meta-data?

Thanks Francis. I've changed all VARCHAR fields on master file to ALPHA but still I am getting the same error.
We did not upgrade Oracle recently but I've created new metadata for the master files as well. Any other advices?

Was there a more detailed error message from Oracle?

Check the NLS settings of the data sources that don't work. If they are different from the ones that do, that may be related to the issue we are having with 7.1.1

Hi Jeeva,

I ran some search regarding the error messages and came across the following topics from Information Builders' online documents, which may be of interest:

Oracle 10g - converting column overflows decimal datatype
http://techsupport.informationbuilders.com/sps/12502046.html

FOC1407 SQL FETCH ERROR when request includes ORA VARCHAR2
http://techsupport.informationbuilders.com/sps/12082115.html

SQL passthru - overflows decimal datatype
http://techsupport.informationbuilders.com/sps/93431129.html

Summary: Oracle SQLCODE -1 fetch cursor after upgrade from 524 to 711
http://techsupport.informationbuilders.com/known_problems/13092002.html

Summary: copy table fail from sql server with datetime field to Oracl
http://techsupport.informationbuilders.com/known_problems/93011014.html

Hope this helps.

Cheers,

Kerry

Thanks to all of you who posted your suggestions on this. We have patched Oracle client on WebFOCUS server to 9.2.0.6. Everything is working fine after the patch.

I get the the same error when executing a fex against Oracle 10 g database. The server has the 10 g client installed on it. On further investigation I realised that the error occured when trying to sum a column which had null values. I fixed the error by replacing null with zeroes in define. The new code looks something like this

DEFINE FILE tab
NEWCOL/D15.2 = IF COL EQ MISSING THEN 0 ELSE COL;
END
TABLE FILE tab
SUM NEWCOL
BY COL1
BY COL2
END

My question is if this is the expected behavior when trying to SUM null columns. The code worked fine in 532.

TIA
M
WF711/WIN2K/IIS