SQL Server Does Not Exist...When clicking GET VERSION button in Server Form in Admin Module.
Did Not Receive Reg Keys
Sometimes the user's email server will block the email with the
Registration Keys from arriving due to tight SPAM controls. Check your SPAM folder if possible. While we are aware of
the problem, and know it is not SPAM, the user must contact us, and we will resend the keys. You may need to provide an alternate email address.
top
KEY INVALID
Make sure that the keys are entered exactly as they appear
This
means the key is case-sensitive. Ensure there are no leading or trailing spaces.
Also, make sure the number
of licenses is entered correctly. (ie 10 lics= '010')
top
Reinstall SQLCentric
SQLCentric can only be installed one time during
the evaluation period
If you need to reinstall the product, please contact us and we will send you the reset_eval utility.
The Reset Utility is available on-line. It can only be used one time. Please scroll to the bottom,
and download the utility by clicking the appropriate link.
top
Run-time error '76'
Make sure you have a C:\temp directory, where certain application
.tmp files are placed. If not, simple create one.
In addition, you will need to create two blank files. Using notepad,
name the the two files, by saving them as:"fireops.tmp" and "MSstat.tmp", respectively. Then re-run SQLCentric
main app. (We can send you these files if you contact us.)
top
Either BOF or EOF is True
While this is a generic error and could occur under
varied circumstances, it commonly occurs in SQLCentric, due to the following reason.
When automatic server updates are
turned on, ie search for new SQL Servers on the network during run-time monitoring, this error may occur b/c of a known bug.
This is a little used feature and SHOULD BE TURNED OFF. It will NOT affect any of the monitoring functions.
To turn it
off, either use the Admin Module configuration, or make sure the UPDSVR=0 in the SQLCnt.cfg file in the SQLCentric
application directory. Once set off, rerun SQLCentric.
We may remove this feature in future versions.
top
Invalid Object Name
First, confirm that the SQLCentric database was successfully created, and
the referenced 'tablename' exists. If they don't, create a database named 'SQLCentric', and run the SQLCnt1_23_tabs.sql
against the database to create the tables.
Next, if the above does not apply, ensure that the following is true: SQLCentric
requires that the database is any variation of case-insensitive sort order and collation. If you are on SQL Server
version 2000, you can set the sort order/collation at the database level, so it will ONLY affect the SQLCentric database.
Open
up your query window, and execute this tsql:
Alter database SQLCentric collate SQL_Latin1_General_CP1_CI_AS
If
you are using version 7.0, you will need to either reinstall with a case-insensitive sort order, or move to another CI server
top
Operation is not allowed when the object is closed
Ensure that the following is true: SQLCentric
requires that the database is any variation of case-insensitive sort order and collation. You can run sp_helpsort.
If you are on SQL Server version 2000, you can set the sort order/collation at the database level, so it will ONLY affect
the SQLCentric database.
Open up your query window, and execute this tsql:
Alter database SQLCentric
collate SQL_Latin1_General_CP1_CI_AS
If you are using version 7.0, you will need to either reinstall with a case-insensitive
sort order, or move to another CI server
top
Install Server Extensions
This error is likely due to your configuration
of IIS/ISM home directory path. Please see this Microsoft KB Article for more information: http://support.microsoft.com/?kbid=201522
top
Nothing seems to happen when I run SQLCentric
SQLCentric is meant to be scheduled.
When you first install and configure the app, you may use the program menu item to test it out. Once you launch SQLCentric
from the program menu, open up task manager, and you will see it run. Once complete, go to the browser (ie http://YourLocalHost/SQLCentric.htm)
and see if the page displays your servers.
For continuous monitoring, SQLCentric must be scheduled. Using Windows scheduler,
point it to the SQLCentric_RTM1_23.exe, and schedule it to run at your desired interval (ie every 10-15 minutes)
Please
note, that in our next release, the schedule will be managed through SQLCentric's own interface...
top
DB Status always displays red light
We are aware that in some environments,
that the DB Status light always appears to be red, even though the databases are fine. We think it may be related to the XP
OS environment and use of xp_cmdshell (even though we recommend Windows 2000 Server or higher). Nonetheless, for this rare
behavior, we have an available hot fix (that will be posted here shortly). Please contact us immediately to get this patch.
top
Uptime Detail
This is a known issue that occurs when the SQLCentric designated
master SQL Server is installed separate from the IIS/application components. We are working on a resolution, but have a current
workaround.
WORKAROUND: Copy the file UPTIME.EXE from your application server's WINDOWS\SYSTEM32 directory, to the
WINDOWS\SYSTEM32 folder on the designated master SQL Server.
top
Send Test Email - '429' error
Although this is a common Active X component error,when
attempting to send a test email from SQLCentric, this can occur under the following conditions:
If the operating system you are using for SQLCentric is Windows XP, you must manually obtain and register the file CDONTS.dll.
Place this file in the Windows\SYSTEM32 folder, and use 'regsvr' to register the .dll
If you are using Windows NT/2000, you may not have installed the SMTP service. Goto the control panel, Add/Remove Windows
Components, and Install SMTP
top
ASP Page TimeOut
Sometimes it may take a long time to generate output via ASP,
and time out. For example, when trying to generate DB schema for a large database structure. If this happens, you can
take the following approach:
Open up the .asp page in question. Under the tag, create a new line and enter < %Server.ScriptTimeout=500% >
(w/o the spaces between < and %) and then click File->Save->and Exit. Try again.
Or, goto your IIS/ISM admin tools in the Control Panel. Using the Microsoft Management Console, select your web site.
Right-click to select the properties. From the Properties dialog, click Home Directory, then the "Configuration" button. Choose
the "App Options" tab. Set the "ASP Script Timeout" to the desired number of seconds.
The first option is recommended, as the latter is the overall server setting.
The conversion of a char data type to a datetime data type resulted in an out-of-range
datetime value
This is a known issue that occurs usually for INTERNATIONAL USERS ONLY, when trying to manually
add servers via the SQLCentric Admin Module, and click on the UPDATE button.
This is due to Microsoft SQL Server Default
Language Installation: us_english.
If the date format of the user's environment and SQL Server do not match, it will result
in this error.
WORKAROUND:Goto Control Panel, Regional Settings, and select any date format that is Month/Date/Year
(m/d/y)
We have a fix upon request, and have incorporated it into our next version.
top
SQL Server Does Not Exist..Named Instances
BUG: When a user types in
a SQL Server Named Instance on the Server Form in Admin Module, and attempts to get the version build via the GET VERSION
button, this error occurs, because of a know bug. It incorrectly parses the Named Instance, and does not recognize the instance
name.
WORKAROUND: Use the drop-down list to select version. We have fixed this for our next version.
top
