Home Products Downloads Purchase Support News Members Company
LINKS
MOST RECENT
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly. Click Here for more info.
FAQs
Quick answers to common questions. Click Here for more info.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.
Online Documentation
All of our help files for download or convenient viewing online. Click Here for more info.
Videos
Watch product demos, training videos, or tutorials of our products' main features.  We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools


Application crashes at startup in Windows Vista

SYMPTOMS
Application crashes at startup in Windows Vista

CAUSE
Windows Vista's advanced security does not allow applications to modify application’s folders.

RESOLUTION
Option 1: Run application as Administrator.



Option 2: Give write/modify permissions to users to the application’s folder



AUTHOR
Denis Mack

LAST REVIEW
27 February 2008

Labels:

...


ApexSQL tools generate an error after installation of Service Pack 1 (Beta version) for Windows Vista 32-bit

After installing a beta version of Service Pack 1 for Windows Vista 32 bit, all ApexSQL Tools stopped working and generated the following error:

Problem signature:
Problem Event Name: APPCRASH
Application Name: ApexSQLDoc.exe
Application Version: 2005.13.206.0
Application Timestamp: 465b0ca5
Fault Module Name: StackHash_1703
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Code: c0000005
Exception Offset: 04a18dc1
OS Version: 6.0.6001.2.1.0.256.1
Locale ID: 1033
Additional Information 1: 1703
Additional Information 2: 2264db07e74365624c50317d7b856ae9
Additional Information 3: 1344
Additional Information 4: 875fa2ef9d2bdca96466e8af55d1ae6e


CAUSE
This is a known error that occurs after installation of Windows Vista-32 bit Service Pack (Beta). This occurs for some non-ApexSQL Products as well. Click here for more information.

RESOLUTION
We recommend removing/uninstalling this beta version of the Service Pack 1 for Windows Vista 32-bit.

LAST REVIEW
22 October 2007

Labels:

...


The buttons of Wizards and dialogs of the application are of different sizes and some of the buttons are missing/not viewable

The buttons of Wizards and dialogs of the application are of different sizes and some of the buttons are missing/not viewable

CAUSE
This is a known bug.

The cause of the problem is incorrectly displaying the dialogs on machines using 120 dpi fonts.

RESOLUTION
Please set your font to 96 dpi to work around this issue:


  1. Open the Properties of your Desktop.
  2. Go to Settings tab.



  3. Click Advanced button.
  4. Set DPI setting combo box to “Normal size (96 DPI)”.


  5. Save your changes clicking the OK button.

We appreciate if you would send your report to support@apexsql.com. This will help us quick fix the problem.

LAST REVIEW
13 September 2007

Labels:

...


When I try to download a product help file from the website, all pages are displayed like this: “The page cannot be displayed” or “Action canceled”.

The below messages are shown when viewing a Compiled Help (.CHM) File downloaded from the Internet or opened from the Network place.

1) Action canceled



2) The page cannot be displayed



CAUSE
Computers using Windows XP Service Pack 2 or Windows Server 2003 Service Pack 1 will place a block on Compiled Help (.CHM) File that are downloaded from the Internet. The block will interfere with the operation of the help file and an ‘Action canceled’ or ‘The page cannot be displayed’ error will be displayed in the topic pane. The problem is caused by security features introduced in the security update MS05-026 designed to reduce vulnerabilities in HTML help

RESOLUTION
There are two methods to fix the problem:

Method I

  1. Double click on the download Compiled Help (.CHM) File
  2. Set ‘Always ask before opening this file’ checkbox OFF in the ‘Open File-Security Warning’ dialog


  3. Open File

Method II

  1. Right click on the downloaded Compiled Help (.CHM) File and select ‘Properties’ item from the raised context menu.
  2. Press on ‘Unblock’ button in the ‘Properties’ dialog and apply changes


  3. Double click on the CHM file.

SEE ALSO
See detailed information in the Microsoft Knowledge Base: http://support.microsoft.com/kb/896358

LAST REVIEW
30 August 2007

Labels:

...


I wanted to use my application in Command Line Mode but every time I run my batch file I have the program GUI opened

Every time I run my batch file from Command Prompt I have the program GUI opened

RESOLUTION
Please make sure you are using correct executable in your batch. Command Line program has .com extension, for example ApexSQLDiff.com. You can simply call the program as ApexSQLDiff or qualify it with ApexSQLDiff.com - but don't instantiate the executable via the CLI with ApexSQLDiff.exe

LAST REVIEW
27 JUly 2007

Labels:

...


Auto-updater told me that there is a fresh application version but when I updated the program it failed to start.

The program fails to start after it was autoupdated.
CAUSE
Depending on some changes to the applications (i.e. moving from .net 1.1 to .net 2.0) the auto-updating process might not function properly.

RESOLUTION
Please verify your application here, whether it can be successfully auto-updated or not. If no, please download and install it manually

LAST REVIEW
27 July 2007

Labels:

...


This application has failed to start because the application configuration is incorrect message under 64-bit OS

"This application has failed to start because the application configuration is incorrect" message appears under 64-bit Operating System

RESOLUTION
If you got this error message for the applications that must support x64 OS according to this sheet, you should use CorFlags utility running from the command line, for example: corflags ApexSQLDiff.exe /32BIT+

LAST REVIEW
27 July 2007

Labels:

...


Application fails to login, it says that my SQL Server doesn't exist.

ApexSQL application fails to loging to the SQL server. Server doesn't exist message appears.

RESOLUTION
If your server has developer or enterprise edition and it is named as MACHINE_NAME\MSSQLSERVER.

To work around your issue please:

  • remove "\MSSQLSERVER" suffix from the instance name
  • if you cannot: create the aliases for the desired servers and connect through them

If your server is SQLExpress please put \SQLEXPRESS at end of your server name.

LAST REVIEW
27 July 2007

Labels:

...


Activation Problems

Problem with ApexSQL product activation

RESOLUTION
Click here for a FAQ on Common Activation FAQs and Trouble Shooting items.

LAST REVIEW
27 July 2007

Labels:

...


I ran the downloaded installer but it failed at start up

Downloaded install fails to run.



CAUSE
The most common reason for this is the downloadable installation file wasn't completely downloaded.

RESOLUTION
Please try re-downloading the installer. Make sure that the installer size listed on our Downloads page matches with the size of the downloaded file. Then try again.

LAST REVIEW
13 September 2007

Labels:

...


I ran ApexSQL product under Vista and got the following report

The following error appears under Vista when ApexSQL application is launched:
Problem signature:
Problem Event Name: APPCRASH
Application Name: ApexSQLDoc.exe
Application Version: 2005.11.203.0
Application Timestamp: 45eec5a1
Fault Module Name: StackHash_1703
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Code: c0000005
Exception Offset: 0398b530
OS Version: 6.0.6000.2.0.0.256.6
Locale ID: 7177
Additional Information 1: 1703
Additional Information 2: 2264db07e74365624c50317d7b85 6ae9
Additional Information 3: 1344
Additional Information 4: 875fa2ef9d2bdca96466e8af55d1 ae6e

RESOLUTION
Please try the following workarounds:

  1. Set the application to run with Administrator privileges (this is done by right clicking on the exe and selecting the Administrator option at the bottom of the Compatibility tab).


  2. Set the application to run being compatible with Windows XP (find this option at the same Compatibility tab)


  3. Disable Data Execution Prevention (DEP) on your computer for the product:

    • Open System by clicking the Start button, clicking Control Panel, clicking System and Maintenance, and then clicking System.
    • Click Advanced System Settings. Administrator permission is required. If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
    • Under Performance, click Settings.
    • Click the Data Execution Prevention tab, and then click Turn on DEP for all programs and services except those I select.
    • Select the check box next to the program that you want to turn off DEP for, and then click OK. If the program is not in the list (we assume it isn't), click Add. Browse to the Program Files folder, find the executable file for the program (ApexSQL.exe), and then click Open.


LAST REVIEW
26 July 2007

Labels:

...


My ApexSQL application fails on startup silently.

ApexSQL application does not start.

CAUSE
If you installed your program over an older version, at start up new version tries to load the old profiles and, depending on the product and version, it may cause this type of behavior

RESOLUTION
To work around this problem, please uninstall the application. Delete the installation dir to clean out of all profiles and xml files then re-install.

LAST REVIEW
26 July 2007

Labels:

...


My ApexSQL application fails on startup displaying a .Net exception. I’ve got .Net framework installed already

.Net exception raises on ApexSQL application launch:



CAUSE
Almost all our applications require .Net 2.0 run-time library, the above message shows up when you have .Net 1.1 run-time library installed.

RESOLUTION
Please install .Net 2.0 run-time library first (you should not uninstall your .Net 1.1 library, so this installation won’t affect the existing applications). Also, check the particular system requirements for your application here

LAST REVIEW
26 July 2007

Labels:

...


My ApexSQL application fails on startup displaying a general Windows GPF exception

ApexSQL application fails to startup displaying a general Windows GPF exception:



CAUSE
You are receiving this error message due to the unavailability of the installed pre-requisites. Almost all of our applications require .Net 2.0 run-time library, the above message shows up when you have no .Net run-time library installed.
Issue cause

RESOLUTION
Please, check the particular system requirements for your application here

LAST REVIEW
24 July 2007

Labels:

...


My ApexSQL application fails on startup displaying JIT debugger window with unhandled exception

My ApexSQL application fails on startup displaying JIT debugger window with unhandled exception:


CAUSE
The cause of such behavior is either damage to the application files or an installation process failure.

RESOLUTION
Please uninstall the application and delete the installation folder. Then re-install the product.

LAST REVIEW
30 September 2007

Labels:

...


Welcome to the ApexSQL Troubleshooting and Known Issues

Welcome to the ApexSQL Troubleshooting and Known Issues. This is an online resource to help you find solutions to known issues with Apex SQL tools.

Labels: , , , , , , , , , , ,

...

© 2008 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy