Applies to
ApexSQL Trigger
Symptoms
When opening the project file on another machine, the error appears:
“Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error
Applies to
ApexSQL Data Diff
Symptoms
The “Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error is encountered when running ApexSQL Data Diff synchronization script.
CHM file shows no content
Applies to
ApexSQL Doc
Summary
This article describes why CHM documentation output cannot be seen and how to fix it
The ‘Cannot connect to server’ error is encountered during the installation of ApexSQL Backup
Applies to:
ApexSQL Backup
Symptoms:
In the process of selecting a SQL Server that will host the ApexSQL Backup Central Repository Database the ‘Cannot connect to server’ error is encountered if selected server has a default named instance.
“RESTORE LOG is terminating abnormally” error is encountered in during the restore database step in the log shipping job
Applies to:
ApexSQL Backup
Symptoms:
If a destination database recovery state is not set to the no-recovery (restoring) state, log shipping job will fail during the process of transaction log restore with the "The log or differential backup cannot be restored because no files are ready to rollforward. RESTORE LOG is terminating abnormally" error.
Restore job fails during the log shipping process and the ‘System.Data.SqlClient.SqlError: …. An earlier log backup that includes LSN can be restored.’ error is encountered
Applies to:
ApexSQL Backup
Symptoms:
During the process of Log shipping, the restore transaction log job fails and the ‘System.Data.SqlClient.SqlError: The log in this backup set begins at LSN, which is too recent to apply to the database. An earlier log backup that includes LSN can be restored.’ error is encountered, and whole process fails.
The Out Of Memory exception is encountered when comparing large databases in ApexSQL Data Diff
Applies to:
ApexSQL Data Diff
Symptoms:
If very large databases are compared, in some cases, the memory limitation of the application may be exceeded. If so this will produce an Out Of Memory error.
The application’s GUI disappears and cannot be displayed when using multi-monitor setup
Applies to
ApexSQL Data Diff, ApexSQL Diff, ApexSQL Generate and ApexSQL Script
Symptoms
If the multi-monitor setup is used, while working with mentioned applications, the following issues could be experienced:
ApexSQL Doc fails to highlight SQL code for all objects consistently
Applies to
ApexSQL Doc
Summary
This article describes how to troubleshoot the problem of inconsistent SQL code highlighting in the output document for all database objects
ApexSQL Source Control shared database model doesn’t work after update
Applies to
ApexSQL Source Control
Symptoms
After upgrading from the previous versions to 2015.03.0065 or higher, ApexSQL Source Control cannot detect the previously linked shared databases and a “The path is not of a legal form” error is encountered when opening the Action Center tab:
