Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Error Message - FOC1400 [SOLVED]
Go
New
Search
Notify
Tools
Reply
  
Error Message - FOC1400 [SOLVED]
 Login/Join
 
Member
posted
Anyone know what would cause this error? Been reading the boards searching for it, but haven't found anything that really explained it yet.

(FOC1400) SQLCODE IS -901 (HEX: FFFFFC7B)
: [58004] [IBM][CLI Driver][DB2/AIX64] SQL0901N The SQL statement failed
: because of a non-severe system error. Subsequent SQL statements can be p
: rocessed. (Reason "Too many columns or record length exceeded.".) SQLS
: TATE=58004
L (FOC1405) SQL PREPARE ERROR.
(FOC1400) SQLCODE IS 1400 (HEX: 00000578)
: SQLCODE IS -901 (HEX: FFFFFC7B)
L (FOC1406) SQL OPEN CURSOR ERROR. : WCCLM

This message has been edited. Last edited by: Corky,
 
Posts: 4 | Registered: September 16, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
Too many columns or record length exceeded

Doesn't this comment make sense?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
FOC1400 errors are errors that WebFOCUS gets back from the SQL data adapter - in this case DB2.

To find the root of the issue you need to read the next few lines and search on the SQL error codes returned from the database.

A quick google on the SQLSTATE=58004 and "Too many columns or record length exceeded" returned this from IBM

http://www-01.ibm.com/support/....wss?uid=swg1IC98761

Are you using DB2 10.1 by any chance? You might need to apply a fix.

Otherwise your record set being returned is too big for DB2 to process.

Cheers

Stu


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 240 | Location: Melbourne, Australia | Registered: February 07, 2007Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by Francis Mariani:
quote:
Too many columns or record length exceeded

Doesn't this comment make sense?

Not really, because it wasn't very much data.

What I ended up doing was moving one of my WHERE statements in the first hold to another part of the program.

So essentially when I tried pulling even more data in the first hold (by eliminating one of the WHERE statements) the program worked.

It wasn't much different from any other programs I've written, so I have no idea.
 
Posts: 4 | Registered: September 16, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Error Message - FOC1400 [SOLVED]

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.