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 firstname.lastname@example.org and provide your corporate email address, company, and name.
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
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.