We are calling a WebFOCUS 7.1.6 Self Service report from a .NET 1.1 Web Service and are experiencing an unusual problem. This is a very simple "proof of concept" report, so it doesn't do much. The scenario is this:

A report with 3 columns is generated from a SQL query using 2 optional parameters, one of which (Name) is populated by a web page front-end. The SQL table rows only contain 3 columns as well. There are a total of 22,000 rows in the table.

Report output in HTML, PDF, and Excel work fine with 10,000 rows returned, but does not work for HTML if 12,000 rows are returned.

The query that returns 12,000 rows does not fail in SQL Server, and WebFOCUS can generate the HTML report if I run the FEX directly in Developer Studio by hard-coding the parameter values.

The FEX is very simple:

-* File newfexSQL.fex

-DEFAULT &UserName = '?'
-DEFAULT &UserTitle = '?'
-DEFAULT &TypeOfQuery = 'WebFOCUSReport'
-DEFAULT &FMT = 'HTML'

ENGINE SQLMSS SET DEFAULT_CONNECTION CreditAdmin
SQL SQLMSS
EX projections.dbo.prcGetReportTestRow '&UserName', '&UserTitle', '&TypeOfQuery';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END
TABLE FILE SQLOUT
PRINT
Name
Title
Users
ON TABLE SUBHEAD
"MIS Staff Report"
"&DATEMDYY <+0> "
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &FMT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=14,
STYLE=BOLD+ITALIC,
$
TYPE=TABHEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=14,
STYLE=BOLD+ITALIC,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=14,
STYLE=BOLD+ITALIC,
$
TYPE=TABHEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

It appears that the WebFOCUS web service is quitting for some unknown reason as the trace logs are showing.

136:4093:at 151
137:4093:regularExpressionSIterator index = 14
138:4123:regularExpressionSIterator index = 15
139:4163:regularExpressionSIterator index = 16

A "good result" continues on as follows:

136:2979:at 151
137:2979:regularExpressionSIterator index = 14
138:2999:regularExpressionSIterator index = 15
139:3019:regularExpressionSIterator index = 16
140:3118:regularExpressionSIterator index = 17
141:3128:toXML createXmlTimeNode done
142:3128:doconvertCRtoNL = true
143:3128:before output.length = 778927
144:3538:toXML output done
145:3538:after outputlength = 778927
146:3538:toXML outputlength done
147:3538:1178211659847

.
.
.
Report output
.
.
.

Has anyone experienced a similar issue?

Regards,

Jim Woods

We discovered that the issue was caused by insufficient memory allocated to ServletExec (MaxHeapSize).

I modified the "maxHeapSize" setting in VMSettings.pref from the default of 64K
to 128K, and the report with 12,000 rows now works.