Q7780220: On generating a Graph, we get error 20005: "Unable to open database connection". How can we fix this error?
There can be various reasons for this. ActiveXperts provides tools to troubleshoot such problems.
First of all, check the status of the connection in the Reports&Graphs Configration Tool:
In the Manager, open the 'Tools->Reports&Graphs' from the menu bar and launch the 'Reports&Graphs Configuration' tool
Check out the status line at the bottom of the 'Statistical Database' tab; it displays a detailed error - if any. In case of an error, you'll be able to adjust your settings in this tab.
...
Network Monitor > ReportsQ7780225: On generating a Graph, we get error 20005: "Unable to open database connection. Client does not support authentication protocol requested by server; consider upgrading MySQL client". How can we fix this error?
MySQL versions from 4.1x upwards use a different algorithm to hash passwords than the pre 4.1 versions. If your client does not implement this algorithm, it’s possible you will get this error when you try to connect.
In your MySQL shell, type the command below:
ALTER USER 'myaccount'@'myhost' IDENTIFIED WITH mysql_native_password by 'mypassword';
Where myaccount is the database-account, myhost is the hostname or IP address of the MySQL server, and mypassword is the root password for the dat...
Network Monitor > Reports 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 Engine 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 ...
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 Engine 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 ar...
Network Monitor > Reports Q7780117: Which database driver should I select for my Microsoft SQL Express statistical database?
ActiveXperts Network Monitor supports the following database drivers for Microsoft SQL Express:
Mcrosoft SQL Express 2017 and 2019:
{SQL Server}
{SQL Server Native Client}
Microsoft SQL Express 2022:
{SQL Server}
NOTE: ActiveXperts does NOT support ODBC Driver 17, ODBC Driver 18 and SQL Server Native Client RDA 11.0 on Microsoft SQL Express 2022
The database driver can be selected during database migration in the 'Reports and Graphs Configuration' tool.
Network Monitor > Reports Q7780005: When I open the ActiveXperts Reports and Graphs Configuration Tool, I get an error: "Unable to connect [Driver={SQL Server};Server=sqlserver01;UID=ax_sql_admin;pwd=**************], error 0x80004005, Unspecified error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security Error". What should I do?
This is most likely caused by the fact that your SQL server requires TLS (Transport Layer Security). If TLS is enabled on the SQL Server, the {SQL Server} driver on the ActiveXperts monitoring server won't work; you must use the {SQL Server Native Client} driver instead.
The {SQL Server Native Client} may already be installed on your system; if not, you can download it from the Microsoft web site.
We recommend the following steps:
First, start the ActiveXperts Reports and Graphs Configuration T...
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 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 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 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 Q7780110: Can I migrate the statistical database to MS SQL Server Express Edition? If yes, how can this be done?
Yes, MS SQL Express Edition is supported.
For a list of suppported SQL Express versions, see FAQ #7780115
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...
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 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 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 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 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 Q7780115: Which versions of Microsoft SQL Express are supported?
ActiveXperts Network Monitor supports the latest versions of Microsoft SQL Express. ActiveXperts Network Monitor v.2022 and v.2023 have full support for the following SQL Express versions:
Microsoft SQL Express 2017
Microsoft SQL Express 2019
Microsoft SQL Express 2022
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 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 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 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 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 Q7780152: When I create a new Graph, I get an error: "The following feature couldn't be installed: .NET Framework 3.5.". But when I try to install this feature from the Server Manager, I need to specify an alternate source path.
In recent Operating Systems, including Windows Server 2016 and Windows Server 2019, the .NET Framework 3.5 installation files are NOT included in the Operating System. You need the Windows Server installation media (usually a CD-ROM, or .ISO image).
To install .NET Framework 3.5, please take the following steps:
Mount the Windows Server installation media (DVD or .ISO)
Start a new Command Prompt in Administration mode
Type: Powershell
Type: Install-WindowsFeature Net-Framework-Core -source "...
Network Monitor > Reports
|
