Category
Versión del producto
Tema
Subtema
Idioma
"Error importing report schedule. Check connection to central instance" message is displayed when trying to import the previously exported report schedule (4369346)
Check connection to central instance" message is displayed when trying to import the previously exported report schedule
A connection issue is encountered when trying to run the ApexSQL Audit API call (4376480)
A connection issue is encountered when trying to run the ApexSQL Audit API call <p>To avoid any kind of connection issues while configuring the ApexSQL Audit API calls it is mandatory that all steps of the below shared articles are completed successfully.<br>If any of those steps are omitted or not completed successfully the connection issues are to be xpected.<br><br>Please check detailed guide into configuring ApexSQL Audit API calls to be used for SQL auditing reports:<br>https://knowledgebase.apexsql.com/using-api-to-generate-sql-auditing-reports/<br><br>To import audit data using Power BI please check the "Importing audit data into Power BI using API call" section of the below guide:<br>https://solutioncenter.apexsql.com/extract-sql-auditing-data-into-power-bi/</p>
Is there a unique identifier field in ApexSQL Audit that links before and after lines, allowing you to join the two together in a report? (4376481)
Is there a unique identifier field in ApexSQL Audit that links before and after lines, allowing you to join the two together in a report? <p>The only unique ApexSQL Audit identifiers we could offer are:</p>
Does ApexSQL Audit have the capability to set alerts when changes are made to reports? (4376059)
Does ApexSQL Audit have the capability to set alerts to notify you when changes are made to reports? <p>This is not currently possible at the moment, but an Enhancement has been created for such functionality in the future.<br><br>WORKAROUND:<br>None.</p>
SQL Parser throws a syntax error during the parsing of an internal query that contains 'OPENROWSET(TABLE' keywords in conjunction (4375777)
SQL Parser throws a syntax error during the parsing of an internal query that contains 'OPENROWSET(TABLE' keywords in conjunction ... In the log files was founded: ... 2024-05-08 12:07:05.622 DEBUG [QDQ6X6Y2]: SQL Parser exited with code 1
SQL Parser throws a syntax error during the parsing of a T-SQL query that contains keyword 'PARTITION' (4375778)
SQL Parser throws a syntax error during the parsing of a T-SQL query that contains keyword 'PARTITION' ... Add a server and a database for auditing using Extended event data collection. ... Run the query below on the audited server:
Alerting has a limit of 10 notifications per minute and subsequently causes extensive memory usage and alert duplication (4375495)
Alerting has a limit of 10 notifications per minute.<br><br>Can the way the application forwards and handles notifications in the background between components be addressed, to remove this constraint?<br><br>When communication between the central and the distributed server continuously interrupts, alerts are not sent to the central server, and memory usage significantly increases.
The date range of reports does not include the entire month or includes days from the previous month when "Last one month" is selected as the period for report generation. (4375054)
Start ApexSQL Audit, add a server and database for auditing using any technology ... Go to Start, find Services and stop the Windows time service (to be able to change the date and time on the VM without issues)
SQL Parser throws a syntax error during the parsing of a T-SQL query "EXECUTE AS USER = SUSER_NAME()" (4375069)
Connect to the audited server in SSMS and make sure that the current user (the user which is currently logged in) is mapped to the database you are auditing. ... In the context of the db that is being audited, run the following command: EXECUTE AS USER = SUSER_NAME();
Can ApexSQL Audit monitor scheduled SQL Server Agent jobs? (4373215)
ApexSQL Audit can monitor scheduled SQL Server Agent jobs but for that either SQL Audit or Trace auditing technology must be used, since the Extended events technology have limitation in the way SQL Server is gathering events into a session file.<br><br>So to change auditing technology for the SQL Server that is currently in use within the ApexSQL Audit, please navigate to the Configuration tab, select the SQL Server and click on the Edit button.
Preparing for ApexSQL Audit Upgrade (4372941)
Export the auditing configuration for both server and database levels. ... If the configuration is different across servers, individual templates will need to be exported for each server/database.
ApexSQL Audit performance usage - Testing case using Trace auditing technology (4369130)
Testing that was performed below provides metrics obtained by the usage of ApexSQL Audit and SQL Server within a specific testing environment with no extra processes running except for SQL engine and auditing.
ApexSQL Audit installation guides (4211247)
This article provides key information and links to all important ApexSQL Audit installation articles, making it easier for users to locate relevant articles and easy implement ApexSQL Audit into their respective environment.
ApexSQL Audit 2021.01 building up files in Quarantine folder (4373734)
While troubleshooting the reasons ApexSQL Audit stopped, the quarantine folder takes large amount of drive space where the temporary folder is located. ... Package 019e4da6-15a6-49ab-b4a6-285aa44f8449.ApexSqlComplyPackage will be moved to quarantine folder due to following error: Unable to read beyond the end of the stream.<br><br> The query or the information captured goes over the default 512- character limit of the sql data captured and the information is truncated causing the issue.
Installing ApexSQL Audit (4341140)
This article describes how to install ApexSQL Audit and its components. ... Permissions and requirements ... Before proceeding with ApexSQL Audit deployment, please check the Permissions and requirements knowledgebase article to ensure that your target system meets the requirements listed in the article.
Deploying, installing and configuring ApexSQL Audit in a clustered environment (4211283)
<p>ApexSQL Audit supports auditing of SQL Server clusters right out of the box, whether they are in simple Failover mode or with Always On – High availability groups. ... At any moment, the active node is being audited and if the failover occurs, the auditing will switch to the newly activated node automatically.</p>
How to process thousands of packages within the Received Packages_old folder? (4373701)
The above mentioned packages should be moved to the newly created <strong>Received Packages </strong>folder manually, in the times when SQL Server has low traffic.<br>Simply select up to 500 packages from it and move it to the new folder, thus emptying the "old" folder for that amount of packages.<br><br>If there are packages within the <strong>Quarantine </strong>folder as well, than the same process should be repeated when SQL traffic is low, select up to 500 packages from it and
Why is 'Active Traces' folder empty for monitored SQL Server instance? (4373700)
Why is the 'Active Traces' folder empty for a monitored SQL Server instance? When Auto is set for auditing data collection while configuring SQL Server audit technology within the ApexSQL Audit, it will use the latest available technology:<br><br>SQL Server 2005 - Trace<br>SQL Server 2008 - Trace<br>SQL Server 2012 - Extended events (Auto), Trace<br>SQL Server 2014 - Extended events (Auto), Trace<br>SQL Server 2016 - Extended events (Auto), Trace<br>SQL Server 2017 - SQL Audit (Auto), Extended events, Trace<br>SQL Server 2019 - SQL Audit (Auto), Extended events, Trace<br>SQL Server 2022 - SQL Audit (Auto), Extended events, Trace<br><br>For SQL Servers 2017, 2019 and 2022 by default the SQL Audit technology is set and for those instances Active Traces folders should be empty, for other servers where Trace technology is selected those folders will have active traces in it.<br>This is as designed behavior
ApexSQL Audit Processor Distributed process high ram usage (4373694)
ApexSQL Audit Processor Distributed process high ram usage on the machine running the affected SQL Server<br> WORKAROUND<br>The following is the text file of the restart DistributedProcess powershell script:<br><br># Variable for storing the the log file path for ApexSQL Audit process restarts<br>$filePath = "C:\Users\central\Desktop\TestPath\restartingDistributedProcess.txt"<br><br>#Check if the process named "ApexSQL.Audit.Processor.Distributed" is running and restart it (end it)<br>if (Get-Process -Name ApexSQL.Audit.Processor.Distributed -ErrorAction SilentlyContinue) <br>{<br> taskkill /IM ApexSQL.Audit.Processor.Distributed.exe /F<br><br> # Write/append output to the textual log file every time the process is successfully restarted<br> "[$(Get-Date)] ApexSQL.Audit.Processor.Distributed process(es) successfully restarted." | Out-file $filePath -Width 200 -Append<br><br>} <br>else <br>{<br> # Write/append output to the textual log file every time the process is not successfully restarted<br> "[$(Get-Date)] ApexSQL.Audit.Processor.Distributed is not running or the process(es) can not be accessed." | Out-file -Width 200 $filePath -Append<br>}<br><br>Simply schedule the above script in the task scheduler with the admin rights on the machine running the affected SQL Server<br><br>STATUS<br>Waiting for fix in future release of ApexSQL Audit<br><br>DEFECT ID<br>204956
The "Object reference not set to an instance of an object." error is encountered within the ApexSQL Audit log files when trying to pull back auditing information (4373207)
Stack trace<br> ... at ApexSQL.Audit.UI.Shared.Classes.ViewModel.ReportsViewModel.LoadReportPreview() There are 2 steps that needs to be performed in this situation:<br>1. ... Restart the SQL Server instance you are pulling auditing information from<br>2.
How to check events that are being written in the ApexSQL Audit Central for your reports? (4373206)
If there is a suspicion that something is wrong with the SQL auditing reports, what is the simplest way to check if all its events/data is collected the specific query needs to be performed?<br><br><br><br> To check events that are being written in the ApexSQL Audit Central just run the following query in the SSMS and this will ensure the insight into all those events:<br><br>SELECT [Id]<br> ,[ServerName]<br> ,[StartTime]<br> ,[RowVersion]<br> ,[Duration]<br> ,[ApplicationName]<br> ,[ClientHostName]<br> ,[LoginName]<br> ,[DatabaseName]<br> ,[DatabaseId]<br> ,[Success]<br> ,[ObjectId]<br> ,[SchemaName]<br> ,[ObjectName]<br> ,[TransactionId]<br> ,[TextData]<br> ,[Operation]<br> ,[AccessedObjectsList]<br> ,[Error]<br> ,[EventSource]<br> ,[EventTypeId]<br> ,[BeforeValue]<br> ,[AfterValue]<br> ,[ColumnName]<br> ,[SensitiveColumnName]<br> FROM [ApexSQLCrd].[ApexSQL].[EventView]<br> ORDER BY StartTime DESC
List of actions that are performed when Availability Group is added within the ApexSQL Audit GUI (4373205)
What is the list of actions and steps that are performed when an Availability Group is added through the ApexSQL Audit's GUI.? ... Immediately after the name of the Listener is entered/typed within the ApexSQL Audit GUI:
"Remote server forbidden" message is encountered when using the API (4373204)
When using the API calls to generate SQL auditing reports the "Remote server forbidden" message is encountered WORKAROUND<br>Paste the API call link into a web browser on the remote server (while being logged on as the same AD user which generated the API call).<br>The data can then be copied and saved as a .json file<br><br>STATUS<br>Waiting for fix in future release of ApexSQL Audit<br><br>DEFECT ID<br>228961
ApexSQL Audit Remote/Silent Installation (4372771)
There is a known issue with the way the provided credentials in ApexSQL Audit interact with the remote host. ... There are two workarounds are available. ... <h2>Option 1. ... Command line deployment.</h2>
Understanding the changes implemented in ApexSQL Audit 2021.01.2098 hotfix and using it to retrieve quarantined data information (4372321)
ApexSQL Audit 2021.01.2098 hotfix utilizes a more comprehensive quarantine and processing mechanism which may result in an increase in the number of session files contained in the quarantine folder on the audited server as well as the overall count of events inserted into the central repository.
Asociación de nuevos productos
- Herramientas de autoservicio
- Base de conocimientos
- Notificaciones y alertas
- Soporte de productos
- Descargas de software
- Documentación técnica
- Foros de usuarios
- Tutoriales en video
- Aviso de actualizaciones de páginas web (RSS)
- Comuníquese con nosotros
- Soporte Técnico
- Ver todos