Extracting data from the database with sysbck, Extracting data from the database with, Sysbck – HP 3PAR System Reporter Software User Manual
Page 227
to medium or low (see
“Setting the Security Level for Excel” (page 58)
) and reopen the
workbook.
•
If you see a warning containing "internal state was inconsistent", the code has detected an
inconsistency and has tried to recover, but may not be able to. If errors continue, go to the
3PAR menu and click Reset All. If errors persist, close and reopen the workbook. Entering and
exiting Excel's design mode can cause these inconsistencies and should be avoided.
•
Run-time error warnings indicate potential problems with the System Reporter code. To clear
the problem, go to the 3PAR menu and click Reset All or close and reopen the workbook.
Using a fresh copy of the workbook is recommended.
•
If Microsoft Office Excel encounters an internal problem and needs to close (
), in most of the cases the recovered Excel copy of the workbook may not work as
expected.
Figure 67 Microsoft Office Excel Internal Error
If you experience a problem with a recovered copy of the workbook (
), try
starting with a fresh copy of System Reporter workbook.
Figure 68 Microsoft Excel Recovery Error
Extracting Data from the Database with sysbck
Sometimes it is necessary to extract some of the data from the System Reporter database. For
example, you may want to send that data to HP to help in analyzing a performance problem. This
section describes how you can extract all or some of the data from a database using the sysbck
command into a set of files that can then be loaded into a different database.
NOTE:
If necessary, when using sysbck to extract large amounts of data from a database, the
contents may be saved in separate 2 Gb files.
Extracting Data from the Database with sysbck 227