18.1.11

SAP Note 17811 - Problems when exporting report with many columns

Symptom:

The export of a report to the presentation server terminates with runtime error TSV_TNEW_ENTRY_TOO_LARGE (editor program), or ASSIGN_OFFSET_NOTINFIELD (program SAPLGRAP), or
approximately after 8000 signs, the lines that have been exported are truncated with a *.

Additional key words

Report Writer ----- SUPPORTGUIDE 20010613143936 -----
REPORTWRITER, SGRW_EXPORT, SGRW_EXPORT_TABLE, SGRW_EXPORT_EXCEL, SGRW_EXPORT_HTML, SGRW_EXPORT_TEXT, SGRW_MESSAGE, SGRW_DOCU_CONS_NOTE
SGRW_OM SGRW_PS SGRW_PC SGRW_SL SGRW_PCA SGRW_EC SGRW_LIS

Cause and prerequisites

The report probably has a very high number of columns, and the export table is too wide as a result. Currently, only 8010 bytes can be exported per line.
In Release 2.2, in the Report Writer, 85 of those bytes are for the line text. Each report column requires 50 bytes. This means that reports can only be exported up to a maximum of 158 data columns.
As of Release 3.0A, for the download when generating report groups, the column widths are transferred from the print class.
For more information about the technical restrictions, refer to Note 6750.

Solution
In Release 2.2, correct the lines marked with "H17811 below in program MGRW1F11. Once you install this correction, the amount of space used per column in the export table is reduced when you have more than 158 columns. The affected report groups must be regenerated.
In Release 3.0A and later releases, set the column width to 0 for all print classes that are not used in the report, reduce, if necessary, the column widths of the print classes used in the report, and regenerate the report group.
If these measures do not help eliminate the error, reduce the number of colums in your report.

No comments:

Post a Comment