|
Calibration
Manager Frequently Asked Questions - 3.x
Printing
Reports back
to top
Q. When printing
a report, I receive the following error: ERROR FROM
PE StartPrintJob: 599 Cannot open SQL Server.
A. This error will occur in version 3.0 if you
try to print reports that were created in version 2.11.
You will need to upgrade these reports, as described
in Appendix F of the 3.0 User Manual. You only need
to upgrade reports that have been customized or created
from scratch. If you are using any of the default reports,
you will find updated versions in the /Calman3/Data/Reports
directory.
If you receive this error
and you are sure that you are not trying to print version
2.11 reports, contact Tech Support for further assistance.
Q.
When I try to print a Log report, I get incorrect information
or an error message.
A. Every Calibration Manager database has an
associated log file. The Log reports need to be pointed
to the correct log file for the database you want to
print from. This is done using the Set Location feature
of the Crystal Reports Designer. Refer to the "External
Logs, Printing" section of the User’s Manual for step-by-step
instructions on doing this.
The most important part
of this process is pointing the report to the correct
log file. If you choose the wrong file, the report will
not print properly. The log files are found in the Logs
folder, which will be located in the same folder as
the database. The log file will have the same name as
the database, but with an .MDB extension. For example,
let’s say that you have a database called TEST.CAL that
is located in the C:\Calman3\Data folder. The log file
for this database will be found in the C:\Calman3\Data\Logs
folder, and will have the name TEST.MDB.
Note that this process
is only necessary for the following default reports:
Archive and Unarchive Log.rpt, Database Log.rpt, and
Deleted Record Log.rpt. Do not attempt to perform a
Set Location on any other report.
Q.
When I print my reports using a Select/Sort, the data
is not sorting as I specified.
A. It is possible to apply a Calibration Manager
Select to a report, but the reports will not recognize
a Calibration Manager Sort. If you want to change the
Sort order of a report, you must do so in design mode
using Crystal Reports. For more information please refer
to Chapter 9, in the section "Modifying Existing Reports
and Templates".
Q.
When I'm printing a calibration certificate w/measurement
data for multiple pieces of equipment the page numbers
keep incrementing instead of resetting to 1 whenever a
new item is printed.
A.
You need to specify that the Group Footer #3 resets the
page number. This can be done as follows:
- Select Reports|Design
and open "CcertM.rpt" (version 2.x) or "Calibration
History Report with Measurement Data.rpt" (version
3.x)
- Right-click on the Group
Footer #3 section in the gray area of the design window
(left side).
- Select Format Section.
- Click on "Reset Page
Number After"
- Click OK then save the
report.
Q.
How can I get a print out of my picklist entries?
A. While it is not possbile to print a list of
the Picklist directly, you can print a unique listing
of entries for a particular field. Follow the steps
below to create this report.
- Select Reports|Design
and open "Basictab.rpt" (version 2.x) or "Basic Tabular.rpt"
(version 3.x)
- Select Insert|Group
- Select the field you
want to print the list for.
- Select "Ascending Order"
- Select "Keep Group Together"
- Click OK.
- Suppress the Details
and Group Footer #1 sections
- Right-Click on the field
"Group #1 Name" and select "Format Field".
- Place a checkmark in
the "Suppress if Duplicated" field.
- Complete any further
customization then select File|Save As and give the
new report an appropriate name.
Installation
& Network Activation Disks back
to top
Q. Is Calibration
Manager 3.x compatible with Windows 2000 and Windows
Millennium Edition?
A. Calibration Manager 3.x is compatible with
both Windows 2000 and Windows Millennium Edition. To
run Calibration Manager under Windows 2000, we suggest
that a computer have a minimum of 128 MB of RAM. After
installing under Windows 2000, you may receive an error
the first time you use the shortcuts in your Calibration
Manager Programs group. Allow Windows 2000 to fix the
shortcut, and it should do so successfully. Also, please
note that Calibration Manager version 2.x does NOT run
under Windows 2000, even though it may appear to install
successfully.
Q.
I am receiving a runtime error when running the Calibration
Manager network activation disk.
A. The network activation disk can only be run
from a Calibration Manager workstation. If you attempt
to run the activation disk at the server or any other
computer where you have not installed the client version
of Calibration Manager, you will receive a runtime error.
Q.
Do
I need to run the network activation disk at every workstation?
A. No. Although the network activation is run from
a client machine, it actually updates the system databases
on the server, which are shared by all client machines.
Therefore, you only need to run the activation disk one
time from one workstation.
Q. I have run
the network activation disk according to instructions,
but I am still unable to have multiple users access Calibration
Manager simultaneously.
A.
The client machines may not be configured correctly, or
the network activation disk may not have successfully
updated the system databases. Contact Tech Support for
further assistance.
Errors
Opening Calibration Manager back
to top
Q. When opening Calibration
Manager, I get a message saying that "C:/LocalCal30/report30.mdb
is corrupt or may not be a database," and the program
will not open.
A.
Report30.mdb is a file used by Calibration Manager when
printing, and it has become damaged. Locate the report30.mdb
file and delete it. A new copy of the file will be created
automatically the next time you open Calibration Manager.
(NOTE: If you receive a similar message about any file
other than report30.mdb, do NOT delete the file. Instead,
contact Technical Support to have a technician repair
the damaged file.)
Q.
When opening Calibration Manager, I get a message saying
that "The entry 'SystemDB' [(share drive)/Data/bms80.mdw]
specified in the Calibration Manager INI [C:\\WINNT\CALMAN30.INI]
cannot be found. This program cannot function properly
without this file."
A. This error occurs when trying to open data from
a shared drive on a network, and indicates that the user
is unable to access the necessary databases. This could
have any number of possible causes, all of them related
to network access. First, make sure that the computer
is able to connect to the network, and that the specific
share drive is available. It may be necessary to reestablish
a drive mapping for the user. (NOTE: All Calibration Manager
workstations must use the same drive mapping to ensure
proper print functionality.) Check that the user has the
necessary network permissions to access the files in the
Data directory, and that these files have not been compressed.
Verify that the Calibration Manager data has not been
moved to a different location, and that no directories
in the path have been renamed.
Q.
(Windows 2000 only) When trying to open Calibration Manager
from the Programs group in the Start menu, I get an error
about the target not being found.
A. Allow Windows 2000 to locate the target of the
shortcut. It will locate the file successfully and repair
the shortcut.
Q.
I receive the following error When opening Calibration
Manager: "BMQRBroker.main:429 ActiveX component can't
create object BMQRENVIRON.Environment".
A. This problem may occur in versions 3.00.0061
and 3.00.0095 of Calibration Manager. If you are unsure
of your version number, locate the CALMAN30.EXE in your
Calman3 directory. Right-click on this file and choose
Properties, then select the Version tab to see the file
version.
If you are running either
of the above versions of Calibration Manager and received
this message, you need to apply Service Pack 1G to Calibration
Manager. This can be done using the blue Calibration
Manager installation CD. If you have previously applied
the Service Pack to the computer and still receive the
error, you may need to re-run the Service Pack with
all applications closed and anti-virus software disabled.
If you have more than one workstation running Calibration
Manager, you must apply the Service Pack to all of them,
including computers with the Satellite module.
Q.
I receive the following error when opening Calibration
Manager: "You don't have an appropriate
license to use the functionality [[frmEM] public sub
Init/Calvin/429]".
A. Your computer may have an older version of
a file named DBList32.ocx. You can determine the file
version by following these steps:
- Locate the DBList32.ocx
file. It should be located in either c:\windows\system\
(Windows 95/98/ME) or c:\winnt\system32\ (Windows
NT/2000).
- Right-click on the
file and select "Properties".
- Click on the "Version"
tab.
If the file version is
lower than 6.00, you can request an updated file from
Technical Support. If the file version is already 6.00
or higher, contact Technical Support for further assistance.
Date
Fields and Date Formats back to top
Q. Some of my dates
are displaying the wrong year. For example, a date that
should be
in 1999 might display as 1899.
A.
You will need to change a setting in the Windows
date formats. Perform the following steps:
- Close Calibration
Manager.
- From the Start menu,
choose Settingsà
Control Panel.
- Open the Regional
Settings Control Panel, and click on the Date tab.
- Locate the Short Date
Style setting. It will most likely be set for a
format of "M/d/yy". Change this to a format with
a four-digit year, such as "M/d/yyyy" or "MM/dd/yyyy".
- Click OK to close
the Control Panel and apply the new settings. Dates
should now display properly in Calibration Manager.
Q.
When adding a history record I receive an Invalid date
value error: [[dateglobal]PublicSub DGVerifyDate/PublicSub
DGVerifyDate/23333]
A. The Event Due Date has become corrupted for
that piece of equipment. Follow these steps to correct
it:
- Ensure that the history
record in question is deleted.
- On the Equipment Master
- Scheduling Tab set the Due Date one day ahead
and save the record, then set the date back to the
original and save again.
- Add the history record.
If the error still occurs,
save the history record and adjust the Due Date on the
Equipment Master. Verify that the Windows Regional Settings
/ Short Date Format is set to display a 4-digit year
(m/d/yyyy), as described in the question above.
Q.
Why do I have a wrong/out-of-date Due Date in my History
records?
Q. Why is the Due Date in my History record different
from the Due Date in my Equipment Master record?
A. You should only refer to the Due Date field
on the Equipment Master record to see when an event is
due. The Due Date in a History record is for historical/tracking
purposes, and does not reflect the current/pending due
date for a piece of equipment. Think of a History record
as a snapshot in time. If you enter a History record for
an event that was due on 4/1/1999, the History record
will always show that this particular event was due on
4/1/1999. This allows you to track whether or not past
events have been performed on time or not.
DB
Integrity back to top
Q.
How often should I run Database Integrity?
A. It is a good idea to run Database Integrity
on a regular basis, even if you are not experiencing
problems with your database. This can prevent future
problems from occurring. Under normal circumstances,
running Integrity every week to two weeks should be
fine. If your database is used very heavily, or you
seem to experience frequent problems, you can safely
run Integrity more often, even on a daily basis if need
be.
Q.
What is the difference between Database Maintenance and
Database Integrity?
A.
Database Maintenance will perform a basic repair and compact
operation. Database Integrity will perform a repair, a
compact, and a full structural verification on your databases.
Integrity takes longer to run, but has a greater potential
to fix database problems.
Q. When I
try to run Database Integrity, I get a message that user
‘Calvin’ is still logged on. Who
is user Calvin?
A.
Calvin is an internal designation used by the Calibration
Manager and AutoReminder programs. Make sure that Calibration
Manager and AutoReminder are closed on all computers.
AutoReminder may be running minimized, as indicated by
a red alarm clock icon in your system tray. If you are
certain that no machines are running Calibration Manager
or AutoReminder, and you still receive the error message
when running Integrity, contact Technical Support.
Q. Database Integrity found errors in my database.
I viewed the error log, and it lists errors by Equip ID,
Event ID, and other numbers that I don’t recognize. What
are these numbers, and how do I know which records they
refer to?
A. These values are internal numbers that Calibration
Manager assigns to database records. Equip ID refers to
an Equipment Master record, History ID refers to an Equipment
History record, and so on. These fields are not displayed
in Calibration Manager, nor is the user able to edit them.
However, you are able to list these values in the Crystal
Reports designer.
To find out the specific
records these numbers refer to, you can add these fields
to the design of a pre-existing report. You can also
contact Tech Support to obtain a pre-made report, or
create your own custom report. For example, let’s say
you wanted to find out what record an Equip ID referred
to. You would make a simple report containing the fields
Equipment.Equip ID, Equipment.System ID, and Equipment.Component
ID. This report would display the internal Equip ID
numbers, matched up with System/Component ID values
that the user will recognize. (Tip: If you have a large
number of records in your database, create a Crystal
Select using the Equip ID values, so that only specific
records are displayed.)
|