3PAR System Reporter 2.8 Release Notes

Page 7
320-200258 Rev A System Reporter Release Notes November 2010
Item Description
An overflow message can be
generated by the Build Report
Menu for some reports with a
large number of objects (such as
LD space).
Excel 2003 has the row limit set at 65,536. Excel 2007 has a
maximum limit of 1,048,576 rows. If the data being retrieved
from the database exceeds these limits, an overflow error occurs.
Workaround:
No workaround has been found for this problem except filtering
the data to run smaller queries.
System Reporter does not work
correctly if a database user is
created without a password.
System reporter requires that the database user in Oracle and
MySQL must have a password.
Workaround:
Ensure that the database user has a password.
The extraction utility can take a
long time to perform the
extraction process when
working with large databases.
The speed of extraction depends on the speed of the database.
Also, the current version of the extraction utility is a single
threaded application where the IO speed depends on the speed
of the destination disks.
Workaround:
Extract smaller chunks of data at a time.
The extraction utility can only
be run from a Server that has
System Reporter installed.
The extract utility is designed to execute from the server that
has System Reporter installed. It uses the System Reporter
parameter file to execute.
Workaround:
None.
The files resulting from the
processing of the extraction
utility can be large.
The extracted files are stored in ASCII files with line feed, tab
and spaces so the size of the extraction file can be much larger
than the original data stored in the database.
Workaround:
None.