Browse "Reports and Graphs" Questions:

Q7780100: Is it recommended to migrate the Statistical Database to MS SQL or MySQL?
There are three modules that make use of the statistical database: Report module History View module (accessible from the Manager's context menu) Graph module (accessible from the Manager's context menu) All of the above modules use complex SQL queries to retrieve the information from the database. By default, an MS SQL Server Compact database is used (it is installed with the product). It is strongly recommended to migrate the SQL Server Compact statistical database to MS SQL Server (or ...
Network Monitor > Reports

Q7780015: I want to schedule my reports so that reports are generated automatically, once every week and every month. Is this possible?
Yes that is possible. You must use the command-line utility 'AxRgCmd.exe' (or 'AxRgCmd32.exe' for 32-bits) to create reports without user intervention. You can use this 'AxRgCmd.exe' (or 'AxRgCmd32.exe') from the Windows Task Scheduler to create reports automatically and send the reports to a group of e-mail recipients. The 'AxRgCmd.exe' (or 'AxRgCmd32.exe') utility requires a few parameters. There are a few batch jobs (.cmd) included with the product. Each batch jobs use the 'AxRgCmd.exe' (or 'AxRgC...
Network Monitor > Reports

Q7780178: I get the following System Warning in my log file: "Too many outstanding graph table insert requests. Reconfigure or disable Reports and Graphs using the Reports and Graphs Configuration Tool".
This means that there are more insert requests on the Statistical Database Graph table than the ActiveXperts Network Monitor service can handle. There can be various reasons for that: The statistical database is offline The statistical database cannot be connected The network connection to the statistical database is slow The performance of the statistical database is slow Too many statistical database requests as a result of many failed checks Statistical Database Graph requests are queued ...
Network Monitor > Reports

Q7780176: I get the following System Warning in my log file: "Too many outstanding report table insert requests. Reconfigure or disable Reports and Graphs using the Report and Graphs Configuration Tool".
This means that there are more insert requests on the Statistical Database Report table than the ActiveXperts Network Monitor service can handle. There can be various reasons for that: The statistical database is offline The statistical database cannot be connected The network connection to the statistical database is slow The performance of the statistical database is slow Too many statistical database requests as a result of many failed checks Statistical Database Report requests are queue...
Network Monitor > Reports

Q7780120: Is there any performance difference between MS SQL Server and MS SQL Server Express Edition?
No, there's no performance difference between MS SQL Server and MS SQL Server Express Edition. It is strongly recommended to migrate your statistical database to either MS SQL Server or MS SQL Server Express Edition to boost the performance of the reporting and graphing tools.
Network Monitor > Reports

Q7780152: When I create a History View from the Manager's context menu, there is a note saying "The Statistical Database is based on an SQL Compact Edition database. This slows down the creation of a History View. It is strongly recommended to migrate this database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool' to boost performance". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780150: When I create a report, there is a note saying "The Statistical Database is based on an SQL Compact Edition database. This slows down the creation of a report or graph. It is strongly recommended to migrate this database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool' to boost performance". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780010: Can I customize the HTML reports?
Yes you can. The HTML report is based on the XSL stysheet that you define in the 'ActiveXperts Reports and Graphs Configurator' tool. Feel free to modify the underlying XSL stylesheet to modify make-up, sorting of data, filtering of data, etc.
Network Monitor > Reports

Q7780162: When I create a History View from the Manager's context menu, there is a warning "There's a large number of records in the ReportData table of the Statistical Database, based on SQL Server Compact. This slows down the creation of a reports. It is strongly recommended to migrate this database to MS SQL Server or MySQL". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780110: Can I migrate the Statistical Database to MS SQL Server Express Edition? If so, how can it be done?
Yes, MS SQL Express Edition is supported. Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Express Edition database in the 'Host' field. For example, if the name of the database server is named 'DbServer01', and the instance id of the database is named 'SQLExpress', then specify 'DbServer01\SQLExpress'. There's no performance difference between MS SQL Server and ...
Network Monitor > Reports

Q7780172: When I create a History View from the Manager's context menu, there is an error "There are too many records in the ReportData table of the Statistical Database, based on SQL Server Compact. Please migrate the database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool'". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780170: When I create a report, there is an error "There are too many records in the ReportData table of the Statistical Database, based on SQL Server Compact. Please migrate the database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool'". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780210: My Activity View frequently shows the following messages: "SYSTEM ERROR: Query failed: [INSERT INTO GraphData( TimeSecs ) VALUES( 0 )]; Modify failed, error 0x80040E14 error #3092: One or more errors during processing of command." and also "SYSTEM ERROR: Query failed: [SELECT * FROM ReportData WHERE ID=x]; Open failed, error 0x80030070, The is insufficient disk space to complete operation."
The reason for this problem is, that the maximum size of the statistics database file has exceeded. Although the maximum size for SQL Compact .SDF files is 4GB, the database driver uses a default maximum of 256MB. This 256MB limit can be increased by specifying a limit in the connnection string in ActiveXperts Network Monitor. The following patch script sets the limit to 4GB. Simple run the script on the machine that has the Network Monitor engine installed: activexperts.com/files/network-monitor/...
Network Monitor > Reports

Q7780164: When I create a Graph from the Manager's context menu, there is a warning "There's a large number of records in the ReportData table of the Statistical Database, based on SQL Server Compact. This slows down the creation of a reports. It is strongly recommended to migrate this database to MS SQL Server or MySQL". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780160: When I create a report, there is a warning "There's a large number of records in the ReportData table of the Statistical Database, based on SQL Server Compact. This slows down the creation of a reports. It is strongly recommended to migrate this database to MS SQL Server or MySQL". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780154: When I create a Graph from the Manager's context menu, there is a note saying "The Statistical Database is based on an SQL Compact Edition database. This slows down the creation of a History View. It is strongly recommended to migrate this database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool' to boost performance". Why is it?
See FAQ #7780100.
Network Monitor > Reports

Q7780174: When I create a Graph from the Manager's context menu, there is an error "There are too many records in the ReportData table of the Statistical Database, based on SQL Server Compact. Please migrate the database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool'". Why is it
See FAQ #7780100.
Network Monitor > Reports

Q7780012: I'm attempting to print a Network Monitor Report, however the bar graphs don't show up. How can I enable the graph bars on a report?
When you print the report, the graph bars on the document indicating the up/downtimes of the checks may not appear on the printed paper. This is because 'Backgroud Printing' is disabled in an internet Browser by default. To enable background Printing in Internet Explorer, choose 'Internet Options' from the 'Tools' menu, and enable 'Print background colors and images' from the 'Advanced' tab. To enable background printing in Mozilla Firefox, choose 'Page Setup' from the 'File' menu and enable 'P...
Network Monitor > Reports

Q7780011: Can I customize the PDF reports?
Yes you can. The PDF report is based on the XSL stysheet that you define in the 'ActiveXperts Reports and Graphs Configurator' tool. Feel free to modify the underlying XSL stylesheet to modify make-up, sorting of data, filtering of data, etc.
Network Monitor > Reports

Q7780200: When hovering the mouse over a Graph to get the tooltip of time and data, the CPU utilisation increases and takes all CPU of one core. Is this a bug?
This is indeed a known issue in the Graph control that we are using. There no solution for that available yet.
Network Monitor > Reports

Q7780018: When running a new report or graph, I get Error 20016: "Check ID(s) do not exist in the "Checks" table in the Statistical Database."
This problem sometimes occurred in v.2015 build 830.50628 or older. If you're not that build level, please download the product from the ActiveXperts web site and re-install, as described in Q6500005. Reason for this problem is the fact that some (new) CheckTypes records are missing in the MS SQL or MySQL statistical database. Or else the CheckTypes table misses the 'GraphEnabled' BIT field, which can be altered manually from MS SQL Management Studio. If the problem persists, please create directo...
Network Monitor > Reports

Q7780030: My statistical data is logged only once per 5 minutes. How can I increase this frequency so I can make more accurate Reports and Graphs?
It is true that statistical data - used by the Report and Graph Tools - is logged only once per 5 minutes (default). Statistical data is also logged at every state transition (e.g. transistion from success to failure). You can adjust the following registry values in the 'HKEY_LOCAL_MACHINE\SOFTWARE\ActiveXperts\Network Monitor\Stats\' key in order to increase the logging frequency: RpLogFrequencySecs - Report Log frequency seconds. Default value is 300 GrLogFrequencySecs - Graph Log frequency...
Network Monitor > Reports

Q7780020: I want to create a new report. I want to show monitor checks per customer. Can you tell me how I should achieve this?
You should create a new XSL stylesheet. This style sheet is the layout for your new reports. Please visit the online Custom XML Reports page for details. The page describes how to create a new XML Report.
Network Monitor > Reports

ActiveXperts Error codes
Click here to view the full list of ActiveXperts error codes
Contact Support
To contact the ActiveXperts Help Desk, click here.