Focal Point
Invaild string or buffer length error

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8591043092

July 03, 2008, 03:49 PM
Prasanna
Invaild string or buffer length error
Hi,

I'm facing an issue while running the reports in WebFocus.

The error description is as below:

(FOC1400) SQLCODE IS 1 (HEX: 00000001)
: [S1090] [DataDirect][ODBC lib] Invalid string or buffer length
L (FOC1405) SQL PREPARE ERROR.

I'm using Teradata as the databse and it appears the issue occurs due to more values in the where clause of the query. I'm using direct SQL in my code. The query does run fine when I directly run it in database. I'm getting the error only when I try to run the query from WebFocus. Anyway to handle this?

Thank you very much!

Regards
Prasanna
WF 717


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


July 03, 2008, 04:43 PM
Francis Mariani
Perhaps you could post the QL code that is getting the error.


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