 |
|||||
|
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. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| NO HTML OUTPUT - SQL FETCH ERROR | Login/Join |
| Gold member |
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 | ||
|
| Expert |
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 | |||
|
| Expert |
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
| |||||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |