Troubleshooting

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script

Troubleshooting Home

MOST RECENT

Why is the picklist option disabled for the field I want?

ApexSQL Report doesn’t showing some/all of my stored procedures, but I’m sure they exist

I can't see my stored procedures in ApexSQL Report even after refreshing on MetaData management

I get runtime error immediately after login

Why can't I see textboxes on login screen?

I get a “Windows cannot open this file” message when trying to open .reg files

I can't enable Drill down reports for stored procedures that fail during MetaData refresh

I can't enable PickList feature for stored procedures that fail during MetaData refresh

Installer fails with runtime error when I install ApexSQL Report on VPS or virtual server

I have procedures selected for availability for use as picklist sources but the picklist is empty

MetaData refresh doesn't display my stored procedure(s)

Why can’t I see any of the graphs?

All of the SQL procedures are not being shown in the drop down lists when I log in.

SITE FEED

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

Why is the picklist option disabled for the field I want?

CAUSE

It is necessary to know where to find the list of values to populate the picklist with.

RESOLUTION

This can be resolved in few steps:

Log in as an administrator.
Go to the "Administration" tab and click on Procedure Management.
Click over the picklist box next to any procedures you would like to have associated with populating picklists for your reports.
Once you have selected the procedures you want and saved them by clicking save, you can go back to the "Administration" tab and select Picklist Management.
In this tab you will select the procedures you selected previously and choose what fields they will populate pick lists for.
Now if you return to your reports you will be able to use picklists for any fields you have associated with picklist procedures.

LAST REVIEW

13 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Monday, August 13, 2007 0 comments

ApexSQL Report doesn’t showing some/all of my stored procedures, but I’m sure they exist

What happened?

CAUSE

ApexSQL Report’s list of stored procedures is not updated.

RESOLUTION

It can be done in few steps:

Log in as an administrator.
Go to the "Administration" tab.
Click over the Metadata Management link.
Once inside the "Metadata Management" page click Start Refresh.
ApexSQL Report will then synchronize its list of stored procedures with those on the database.

LAST REVIEW

13 2007 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Monday, August 13, 2007 0 comments

I can't see my stored procedures in ApexSQL Report even after refreshing on MetaData management

CAUSE

ApexSQL Report doesn't recognize the stored procedures during Metadata synchronization.

RESOLUTION

Please confirm following if ApexSQL Report doesn't recognize your stored procedures during Metadata synchronization:

Do your stored procedure return resultset? ApexSQL Report skips stored procedures that do not return resultset.
Stored procedures with prefix dt_ & asprpt_ get ignored in MetaData refresh.
Do your stored procedure fail during synchronization? A list of failing stored procedures is shown each time metadata is refreshed. User has option to add such stored procedures to MetaData by selecting and adding manually. Examples of Stored procedures that fail during MetaData refresh:

Invalid or non-runnable stored procedures. Such stored procedures must be corrected before they can be used with ApexSQL Report.
Stored procedures that contain Temp tables or Complex queries. Such stored procedures are runnable on SQL query tool but fail during safe-mode synchronization. User can still make these available to ApexSQL Report by selecting and adding them manually to metadata.

LAST REVIEW

10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

I get runtime error immediately after login

CAUSE

ApexSQL Report will report reason for all runtime errors only from local machine. Remote users will only see a generic form of error.

RESOLUTION

It is necessary to make sure that database connection properties are correct. This can be done by editing web.config file found in ApexSQL Report installation directory.

LAST REVIEW

10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

Why can't I see textboxes on login screen?

CAUSE

This is caused when IIS is installed after .Net runtime 1.1.4322. Due to ASP.Net is not configured properly on IIS, it is occured the following:

RESOLUTION

This can be done by running aspnet_regiis.exe with the -i option. This file can be found at %systemroot%\Microsoft.NET\Framework\v1.1.4322 on a typical installation.

LAST REVIEW
10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

I get a “Windows cannot open this file” message when trying to open .reg files

CAUSE

The Registry Editor application is not associated with .reg files.

RESOLUTION

It is necessary to:

Choose “Select the program from a list” in the dialog displayed when you double-click the .reg file.
In the next step click “Browse…” and select \regedit.exe.

LAST REVIEW
10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

I can't enable Drill down reports for stored procedures that fail during MetaData refresh

RESOLUTION

Current ApexSQL Report does not support creation of drill down reports for stored procedures that fail during MetaData synchronization.

LAST REVIEW

10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

I can't enable PickList feature for stored procedures that fail during MetaData refresh

RESOLUTION

Currently ApexSQL Report does not support creation of pick lists for stored procedures that fail during MetaData synchronization.

LAST REVIEW

10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

Installer fails with runtime error when I install ApexSQL Report on VPS or virtual server

CAUSE

ApexSQL Report has been tested to work successfully on various virtual server environments.

RESOLUTION

Please report any such issue directly to support@apexsql.com.

LAST REVIEW

10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

I have procedures selected for availability for use as picklist sources but the picklist is empty

My parameter is a date/time field? Why am I given no procedures to select from for the picklists?

CAUSE

The possible cause is that procedure doesn't have date/time column in its resulting record set.

RESOLUTION

If procedure parameter requires a date/time field (for example) then ApexSQL Report chooses only procedures which have at least one date/time column in their record sets. For procedures to be made available they MUST return an implicit result set data type compatible with the data type of the input parameter.

LAST REVIEW

10 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Friday, August 10, 2007 0 comments

MetaData refresh doesn't display my stored procedure(s)

Please make sure that you can run your stored procedures from any SQL query tool without error.
CAUSE

Possible cause for that is:

Stored procedures may have error(s).
Stored procedures have temporary table references.

RESOLUTION

Check that stored procedures can run from any SQL query tool without error, because Meta data refresh will skip all stored procedures that may have error(s). Also, if the stored procedures have temporary table references they will skip by meta data refresh tool.
LAST REVIEW

07 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Tuesday, August 07, 2007 0 comments

Why can’t I see any of the graphs?

All I get is a broken picture image.

CAUSE

The explanation is that ApexSQL Report requires Adobe/Macromedia Flash Player to be installed on PCs viewing reports with graphs.

RESOLUTION

The Adobe/Macromedia Flash Player can be downloaded at Adobe's/Macromedia’s website http://www.adobe.com/ / http://www.macromedia.com/. After installing the program the user will be able view all of the graphs created by ApexSQL Report.

LAST REVIEW

07 August 2007 Date of Last Review

Labels: ApexSQL Report

...

posted by Jordan Davis on Tuesday, August 07, 2007 0 comments

All of the SQL procedures are not being shown in the drop down lists when I log in.

Is there some way we are supposed to update ApexSQ?

CAUSE

The reasons for such kind of problem: