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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     NO HTML OUTPUT - SQL FETCH ERROR

Read-Only Read-Only Topic
Go
Search
Notify
Tools
NO HTML OUTPUT - SQL FETCH ERROR
 Login/Join
 
Gold member
posted
Hi,
We are using SQL server 2005 as database, we are using the Microsoft JDBC driver 1.2 for connection.We are running 15 reports (quite complex). whenever we are executing multiple reports (parallely) we get this error-
NO HTML OUTPUT
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 00000
: Other Exception: null
(FOC1407) SQL FETCH CURSOR
ERROR. :
whenever we run the program individually it works with less data. Also when huge data is being (approx 1 million and more) retrived then also we got the same error.

Any guess what can be the issue?

We wrote the program such a way that all the needed columns with grouping and filtering are reteived from db first, then we do all the needed calculation in webfocus.

The query created by webfocus, is getting executed in the sql server client without any issues.

Is there be any problem in jdbc connection, where we need to mention anything for retrieving more records or processing multiple request?

Any previous forum discussion or your suggestion is appreciated


Dev:
Dev Studio 7.1.6,Report Caster 7.1.1,Servlet
Local:
Dev Studio 7.1.6,Report Caster 7.1.1,Apache 5.0.2,
Win XP


 
Posts: 80 | Registered: March 21, 2007Report This Post
Expert
posted Hide Post
Actually, I would check to see what was going on in SQL Server first. Can you take the generated SQL and run it successfully in an SQL Server tool? Is there a concept such as spool or workspace in SQL Server. We often run into spool space issues in Teradata when a query is trying to retrieve too much data.

You are getting an SQL error code so I think that is where you need to start looking.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
My rule for using RDBMS sources -

Get the RDBMS to do as much of the work for you!! Especially sorts and column manipulation.

By doing this you will return the smallest resultset required for your final report output and WF will be able to do what it does best - create your styled report output.

This is an extension of the general rule - Use the best tool for the job in hand!

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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     NO HTML OUTPUT - SQL FETCH ERROR

Copyright © 1996-2020 Information Builders