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:
  1. Select Reports|Design and open "CcertM.rpt" (version 2.x) or "Calibration History Report with Measurement Data.rpt" (version 3.x)
  2. Right-click on the Group Footer #3 section in the gray area of the design window (left side).
  3. Select Format Section.
  4. Click on "Reset Page Number After"
  5. 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.

  1. Select Reports|Design and open "Basictab.rpt" (version 2.x) or "Basic Tabular.rpt" (version 3.x)
  2. Select Insert|Group
  3. Select the field you want to print the list for.
  4. Select "Ascending Order"
  5. Select "Keep Group Together"
  6. Click OK.
  7. Suppress the Details and Group Footer #1 sections
  8. Right-Click on the field "Group #1 Name" and select "Format Field".
  9. Place a checkmark in the "Suppress if Duplicated" field.
  10. 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:

    1. 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).
    2. Right-click on the file and select "Properties".
    3. 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:

    1. Close Calibration Manager.
    2. From the Start menu, choose Settingsà Control Panel.
    3. Open the Regional Settings Control Panel, and click on the Date tab.
    4. 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".
    5. 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:
    1. Ensure that the history record in question is deleted.
    2. 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.
    3. 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.)

© Blue Mountain Quality Resources, Inc.
The Blue Mountain Quality Resources, Inc. logo, Blue Mountain Regulatory Asset Manager and Calibration Manager are registered trademarks of BMQR, Inc.
Products ~ Services ~ Calibration Management ~ Maintenance Management ~ Quality ~ Engineering ~ Implementation ~ Enterprise Asset Management
CMMS Software ~ Industry ~ Support ~ Resources ~ Maintenance, Calibration and Quality Webinars ~ Company ~ Contact Us ~ Site Map
Search Engine Optimization Copyright © 2008 Search Engine Optimization by Cherryoneweb.com Website Optimized by: Cherryoneweb.com