Request upgrade

FAQ's

How do I print Event worksheets?
  1. To print an Event Worksheet on QFM Web navigate to the event you wish to print and click ‘Print Worksheet’. Q14IMAGE1

    You will be presented with a pop-up window, click ‘OK’ on this and the worksheet will be downloaded. Q14IMAGE2

    To print an Event Worksheet on QFM Desktop, navigate to the event you wish to print and click the printer icon in the top left.
    Q14IMAGE3

  2. You will be presented with a pop-up window, click ‘Yes’ on this and the worksheet will be downloaded to a report viewer and from here you can save it where you want.
    Q14IMAGE4
How can I change the view on Event Director so it looks the same on QFM Web and QM Desktop?

Problem
How can I change the view on Event Director so it looks the same on QFM Web and QM Desktop?

Resolution
The Event Director on the Desktop contains all the data in the system; it has the capacity to do this as it is a standalone program.

The Event Director programme on QFM Web is filtered based on time scale – the default value for this is 30 days but this can be changed as you require.  The reason we have a filter on the Web Event Director is to increase the performance of the system.

It is not recommend that you make these two Directors match, as the filters prevent performance issues on QFM Web.

How do I import data into QFM?

Problem
How do I import data into QFM?   

Resolution
QFM data import not recommend by SWG without prior training, as incorrectly imported data can result in problems throughout the system.

The import can be collated on an Excel document named ‘Data Import Spreadsheet’, and a blank copy of the spreadsheet can be found on the root directory of your QFM5 Desktop install.

SWG offer training courses on the QFM Import; please contact your SWG Account Manager or Support team on support@swg.com to learn more.

 

How do I delete old event data from QFM?

Problem
How do I delete old event data from QFM?

Resolution
Event  data is locked down and cannot be easily deleted from the system, since it is standard practice to retain historical event data for auditing purposes. If required, SWG can archive old data and create a blank database which does not contain any historical event data, which can be used moving forward.

If you wish to find out more about SWG’s data archiving services, please email support@swg.com or contact your SWG Account Manager.

 

 

 

How do I create Sites?

Problem
How do I create Sites?

Resolution
To create a new site, the best way is to login to QFM Desktop.

  1. Navigate to ‘Site’.
    Q13IMAGE1
  2. Click the ‘Add’ button in the bottom right corner (as is the standard in QFM Desktop).
  3. You will now be able to enter values for a new Site, when you have finished click ‘Save’ in the bottom right.
How do I create new Geography in the correct format?

Problem
How do I create new Geography in the correct format?

Resolution

The correct format for Geography differs from one client to the next there is no set standard across the board.

The most common approach however is to use one of four levels:

  1. Site – The complex/campus name e.g. The Olympic Park.
  2. Location – The building name e.g. The Olympic Stadium.
  3. Unit – The area or floor number e.g. Level 1.
  4. Partition – The room number or partition e.g. D45e.
How do I create new QFM user accounts?

Problem
How do I create new QFM user accounts? 

Resolution
To setup new user accounts you will need to log in to QFM Desktop with a user who has Administrator rights.

  1. First navigate to ‘Personnel’ and create a new personnel record for the new user to use.
  2. Now navigate to ‘Maintain Users’ from the Admin tab.
  3. Click the ‘Add’ button in the bottom right which will start the new user wizard:
    a. Enter a username.
    b. Select the personnel name which you have just created in the previous step.
    c. Create a password.
    d. Select your language.
    e. When you have added all of these fields you can now save the new User. There are additional fields such as Expiry date but these are optional.
How do I create a Schedule Planner Report?

Problem
How do I create a Schedule Planner Report?

Resolution

  1. You can create a Schedule Planner Report via the Report Centre.
    Q8IMAGE1
  2. You can then either :
    a. Generate an Event History Report and create a filter for PM Events (this process is explained in detail in ‘How do I create a report based on filters in QFM Web?’)
    b. Generate a ‘Year Planner Report’ which will be report version of the same thing you see on the Schedule Planner screen.

 

PPP Penalty Payment Calculation – The penalty deduction report does not appear to include the holiday dates when calculating deduction days. The dates in the QFM calendar are correct, so why does the report show the wrong data?

Problem
PPP Penalty Payment Calculation – The penalty deduction report does not appear to include the holiday dates when calculating deduction days. The dates in the QFM calendar are correct, so why does the report show the wrong data?

Explanation
One reason for this is when core periods are defined so that some areas of a building (school for example) are set up to be used during periods of holiday; the holiday being defined in the QFM calendar. This is controlled by a combination of Geography Usage and Day Type in the calendar.

In the example of a school, this issue can be caused when the Day Type in the calendar is set to ‘Holiday Weekday (Whole School)’ and not as ‘Holiday Weekday (Community)’.

I am unable to run existing reports held on the User Reports screen, as the execute (E) button is not enabled.

Problem
I am unable to run existing reports held on the User Reports screen, as the execute (E) button is not enabled.

Explanation
Although you can add new reports and maintain existing reports across all user classes, you can only generate reports that have been added to your user class. The ‘E’ button used to generate reports, situated at the end of the report row will only be enabled for the User Class associated with your user login.

I am unable to create a new report in the QFM User Reports screen, as the ‘Add’ button is disabled.

Problem
I want to create a new report in the QFM User Reports screen, but am unable to do this as the ‘Add’ button is disabled.

Cause
There is QFM system parameter which switches on/off the ability to add new reports. If this parameter is set to ‘Off’ then the ‘Add’ button will be disabled.

Resolution
To enable the ‘Add’ button in the User Reports screen follow the steps below:

Note; this procedure must be undertaken by a user with QFM administrator rights.

  1. Log in to QFM as an Administrator.
  2. Navigate to Applications > Admin > Maintain Classes.
  3. In the Permissions section, select System then the blue box next to User Reports. This opens the QFM Parameters section on the right-hand side of the screen.
  4. In the QFM Parameters section navigate to the sections named Allow Add/Update. Ensure the setting for Allow is Yes.
Unwanted duplicate events are automatically created, each with a different Work Type.

Problem
Unwanted duplicate events are automatically created after you enter a Work Type, whilst logging a legitimate event. Each duplicate event has a different Work Type.

Cause
This is most likely to occur after a QFM upgrade to a version that includes the new ‘Project Group’ field on the Service Work Type screen. Upgrade scripts are intended to make the upgrade transition seamless, however after the upgrade an issue has been identified whereby the character ‘0’ is included spuriously in the ‘Work Type Order’ field on the Service Work Type screen. This causes event grouping for projects functionality to be used, regardless of whether this was in use prior to the upgrade, which then generates unwanted duplicate events.

Resolution
A script to remove the spurious ‘0’ entries in the ‘Work Type Order’ field on the Service Work Type screen, is included below. This should be run in SQL against your database to resolve this issue.

update serviceworktype set Worktypeorder = null where Worktypeorder = 0

Error Message “Overflow Error 6” when adding data in the Event screen.

Problem
When adding data to an event you, may receive an error message that is similar to the following:

“Overflow Error 6”

Cause
This is likely to be caused by your computer running low on memory.

Resolution
A short term solution is to run fewer applications on your computer. A longer term solution is to have the memory on your computer increased.

Please refer to System Requirements QFM (Client).

Error Message in Crystal Reports “Failed to open the connection. Details: ADO Error Code: 0x80004005. Source: Microsoft OLE DB Provider for SQL Server. Description: [DBNETLIB][ConnectionOpen

Problem
When attempting to connect Crystal Reports to your QFM database, you may receive an error message that is similar to the following:

“Failed to open the connection. Details: ADO Error Code: 0x80004005. Source: Microsoft OLE DB Provider for SQL Server. Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SQL State: 08001. Native Error: 17 [Database Vendor Code: 17]”.

Resolution
Install Crystal Reports version 9 or later.

Error Message “QFM Error 94 – Invalid use of Null” when in the Event screen.

Problem
When in the Event screen, you may receive an error message that is similar to the following:

“QFM Error 94 – Invalid use of Null”

Cause
This issue is usually caused by having one or more events on your database with a blank Event Type. (This can sometimes occur when duplicating events and leaving the Event Type blank).

Resolution
Check your database to ensure there are no event records with a blank Event Type. If you find any such records, enter an appropriate Event Type value.

When I try to assign an operative to an event I receive the QFM message “No Operative records available”, despite having successfully assigned operatives from this contractor in the past.

Problem
When I try to assign an operative to an event (in the Event screen Contractor tab) I receive the QFM message “No Operative records available”, despite having successfully assigned operatives from this contractor in the past.

Cause
This message usually appears when:

  • No operative records have been created under the contractor assigned to the event.
  • The operative record(s) created under the contractor assigned to the event hold an end-date which is in the past and therefore the operative(s) is suppressed. If all operatives entered against a contractor have been end-dated then this message will appear.

If operatives have been successfully assigned from this contractor in the past then the most likely reason will be ‘2)’.

Resolution
Check the status of the operative records which belong to the contractor you are using on the event to see if they have been end-dated. If they have an end-date which is in the past, you may update this date with a new future date, if the operative are still valid.

I tried to login to QFM and it gave the message “Wrong password entered.”

Problem
tried to log into QFM and it gave the message “Wrong password entered.”

Resolution
If your Username and Password were set up for you by your system administrator then they will be able to retrieve the password for you or re-set it to a new password to enable you to log in.

If your Username and Password created automatically via the QFM Web Login screen then you can use the “Forgotten Password?” link to request your current password via email, or use the “Need More Help?” link to send an email to the administrator of your system.

Is QFM compatible with SQL Server 2005?

Question
My organisation is planning to migrate our SQL 2000 databases to SQL 2005. Is QFM compatible with SQL Server 2005?

Answer
Yes, QFM is compatible with SQL Server 2005, however the database should run in 2000 compatibility mode.

Please refer to System Requirements QFM (Client).

When running QFM graphical reports, the output screen displays but the entire graph area is blank.

Problem
When running QFM graphical reports, the output screen displays but the entire graph area is blank. This affects both event and booking graphical reports.

Cause
This issue relates to Crystal runtime installed on certain PCs.

Resolution
On the affected PC, locate the file named “SSCDK80.dll” in “C:Program FilesCommon FilesCrystal Decisions2.0bin

Copy the “SSCDK80.dll” file to the following location: C:WindowsSystem32

How can I change/update the text of the automated email notifications for events?

Problem
I would like to change/update the text of the automated email notifications produced for events. How can I do this?

Resolution
The Configure Text screen (Applications > Admin > Configure Text) allows administrators to add and maintain text for the configurable elements of email notifications. These include header/footer, subject, body text, etc.

Parameters which control the usage of email notifications are available on the Maintain Classes screen (Applications > Admin > Maintain Classes). Email Confirmation parameters are located in the FMFM EventEvent section.

Error Message “QFM error 429 – ActiveX component can’t create object” when you attempt to print event related documents or run Start of Day.

Problem
When you attempt to print event related documents or run Start of Day, you may receive an error message that is similar to the following:

“QFM error 429 – ActiveX component can’t create object”

The QFM system may also fail at this point.

Cause
This issue occurs because you do not have the Crystal application installed on your computer.

Resolution
Install either the “Crystal Runtime” or “Patch 145” application.

Error Message “Specific machine not found” when attempting to login.

Problem
When attempting to login to QFM, you are unable to do so and receive an error message that is similar to the following:

“Specific machine not found.”

Cause
It is likely that your QFM licence has expired.

Resolution
Contact your IT department and request that your QFM license is renewed, if it has expired.

Error message “QFM Error 0” when attempting to save a record.

Problem
When attempting to save a QFM record, you may receive an error message that is similar to the following:

“QFM Error 0”

Introduction
QFM requires specific permissions to execute. You should ensure you have the correct security access within your operating system folders, as detailed below.
Requirements

  • C:WINNT
    Ensure that the group ‘Users’ has Read/Execute permissions and that these are propagated to all of the child objects below the main directory.
  • C:PROGRAM FILESQFM40
    Ensure that the group ‘Users’ has Modify permissions and that these are propagated to all the child objects below the main directory.
  • C:PROGRAM FILESCOMMON FILES
    Ensure that the group ‘Users’ has Modify permissions and that these are propagated to all the child objects below the main directory.
How to apply security permissions for QFM access on a Client PC.

Introduction
QFM requires specific permissions to execute. You should ensure you have the correct security access within your operating system folders, as detailed below.
Requirements

  • C:WINNT
    Ensure that the group ‘Users’ has Read/Execute permissions and that these are propagated to all of the child objects below the main directory.
  • C:PROGRAM FILESQFM40
    Ensure that the group ‘Users’ has Modify permissions and that these are propagated to all the child objects below the main directory.
  • C:PROGRAM FILESCOMMON FILES
    Ensure that the group ‘Users’ has Modify permissions and that these are propagated to all the child objects below the main directory.
Error Message “Run-time error ‘429’: ActiveX component can’t create object.” when using Resource Scheduler.

Problem
When using QFM Resource Scheduler, you may receive an error message that is similar to the following:

“Run-time error ‘429’: ActiveX component can’t create object.”

Cause
This issue is due to a defect which has subsequently been fixed and is available in desktop QFM release 162.35.

Resolution
Please contact your SWG account manager to request a QFM upgrade to version 162.35 or later.

Error Message “QFM Error – 2147217904. Procedure ‘qfm_RptLinkedAssets’ expects parameter ‘@EventID’, which was not supplied.” when attempting to print an event worksheet.

Problem
When attempting to print an event worksheet, you may receive an error message that is similar to the following:

“QFM Error – 2147217904. Procedure ‘qfm_RptLinkedAssets’ expects parameter ‘@EventID’, which was not supplied.”

Cause
This issue is due to a defect which has subsequently been fixed and is available in desktop QFM release 162.33.00.05.

Resolution
Please contact your SWG account manager to request a QFM upgrade to version 162.33.00.05 or later.

Whenever I update an event with job progress, an automatic notification is sent to the Reported By/Requested By/Assigned To personnel. How can I stop these automatic notifications?

Problem
Whenever I make an update to an event regarding job progress, an automatic notification is sent to the Reported By/Requested By/Assigned To personnel. How can I stop these automatic notifications?

Cause
QFM configuration settings are switched on so that these personnel receive automatic notifications when events are updated.

Resolution
This procedure must be undertaken by a user with QFM administrator rights.

To disable the notifications when an event is updated:

  1. Log in to QFM as an Administrator.
  2. Navigate to Applications > Admin > Maintain Classes, then use the navigation arrows at top left to locate the Global User Class.
  3. In the Permissions section, select FM > FM Event then the blue box next to Event. This opens the QFM Parameters section on the right-hand side of the screen.
  4. In the QFM Parameters section navigate to the sections named Email Confirmation to Assigned To, Email Confirmation to Reported By and Email Confirmation to Requested By. Here you have the options to control when email notifications are sent/not sent, at different stages of the event cycle.
The Geography Search screen appears different to the usual format. How/why has this changed?

Problem
The Geography Search screen appears different to the usual format. How/why has this changed and can it be changed back to its previous format?

Cause
There are two available styles of Geography Search screen. The traditional default screen and a tree-view style alternative. The configuration for your User Class may have changed.

Resolution
To change the configuration setting for the Geography Search screen, follow the steps below. Note; this procedure must be undertaken by a user with QFM administrator rights.

  1. Log in to QFM as an Administrator.
  2. Navigate to Applications > Admin > Maintain Classes, then use the navigation arrows at top left to locate the User Class you wish to change.
  3. In the Permissions section, select QFM > Environment then the blue box next to Custom. This opens the QFM Parameters section on the right-hand side of the screen.
  4. In the QFM Parameters section navigate to the section named Geography. Here, the Use TreeView Search parameter allows you to choose which style of Geography Search screen is used.
Exporting QFM records.

Information
QFM provides the tools for you to produce output from records in many areas of the application. The output options are usually Export, Printer and Window.

Export functionality is provided by the standard Crystal export interface which offers a wide range of output options and formats. Being able to take advantage of these options depends on whether you are running the appropriate supporting software application. These are selectable from the Format drop down list.

The Destination selectable list provides the following options:

  • Application – Export to the application selected in the Format field.
  • Disk file – Export to a location of your choice
  • Exchange Folder – Attempts to connect to an exchange server, (which may not be applicable to you).
  • MAPI (Messaging Application Programming Interface) – Attempts to use a compatible email interface.
Error Message “QFM Error -2147221231 System Error &H80040111 (-2147221231)” when you attempt to print documents.

Problem
When you attempt to print documents, you may receive an error message that is similar to the following:

“QFM Error -2147221231 System Error &H80040111 (-2147221231)”

The QFM system may also fail at this point.

Cause
This issue occurs because you do not have the Crystal application installed/installed correctly, on your computer.

Resolution
Install/re-install either the “Crystal Runtime” or “Patch 145” application.

Error Message “Encryption key is incorrect. Please re-license database.” when attempting to login.

Problem
When attempting to login to QFM, you are unable to do so and receive an error message that is similar to the following:

“Encryption key is incorrect. Please re-license database.”

Cause
Your QFM licence has expired.

Resolution
Contact your IT department and request that your QFM license is renewed.

The time displayed in QFM is not accurate. How can I change it?

Problem
The time displayed in QFM is not accurate. How can I change it?

Cause
QFM uses both the time taken from the server and the time from your PC operating system.

Resolution
To be sure that all times displayed in, and used by, QFM are accurate you should ensure that the server time and your PC operating system time are accurate and synchronised.

How can I change/update the text of the automated email notifications for events?

Problem
I would like to change/update the text of the automated email notifications produced for events. How can I do this?

Resolution
Parameters which control the usage of email notifications are available on the Maintain Classes screen (Applications > Admin > Maintain Classes) as follows:

  1. Log in to QFM as an Administrator.
  2. Navigate to Applications > Admin > Maintain Classes, then use the navigation arrows at top left to locate the Global User Class.
  3. In the Permissions section, select FM > FM Event then the blue box next to Event. This opens the QFM Parameters section on the right-hand side of the screen.
  4. In the QFM Parameters section there are two main groups of notifications parameters; Standard parameters which control the sending of an event worksheet with a blank email, and Advanced parameters which allow you to set email confirmations to be sent to various recipients at different stages in the event process.
    Navigate to parameters beginning Notification To for Standard parameters, and to parameters beginning Email Confirmation for Advanced parameters.
When I run an Event History Report, events are reported outside of the date range specified.

Problem
When I run an Event History Report, events are reported outside of the date range specified.

Cause
This is due to a defect which has been subsequently fixed.

Resolution
To obtain the fix for this issue, upgrade to desktop QFM version 162.35.01.01 or later.

If I change a QFM record name, e.g. Contractor, Personnel, Department etc. what effect will this have on historical reporting?

Question
If I change a QFM record name, e.g. Contractor, Personnel, Department etc. what effect will this have on historical reporting?

Information
When a record name is changed in the QFM database, the change is immediately effective retrospectively as well as post name change. There are no historical records are kept in the ‘old’ name and so every trace of the ‘old’ name is replaced with the ‘new’ name.

For example, if a personnel name is changed from Sarah Smith to Sarah Green then every existing historical record of Sarah Smith held in the system (e.g. included on event records) will now become Sarah Green.

In summary, QFM regards the record as staying the same but recognises that just the name ‘label’ has changed.

When I make a long term Accommodation Booking, the Planner applies random gaps in the booking.

Problem
When I make a long term Accommodation Booking, the Planner applies random gaps in the booking.

Cause
This issue is due to a defect which is now subsequently fixed.

Resolution
To obtain the fix for this issue, upgrade to desktop QFM version 164.00.00.05.

Event worksheets are not being sent with notification emails.

Problem
Event worksheets are not being sent with notification emails.

Cause
This could be caused by one of several reasons, relating to system parameters or user permissions.

Resolution
Follow the steps below to resolve the problem:

Check System Parameters:

  1. Log in to QFM as an Administrator.
  2. Navigate to Applications > Admin > Maintain Classes, then use the navigation arrows at top left to locate the User Class you wish to change.
  3. In the Permissions section, select FM > FM Event then the blue box next to Event. This opens the QFM Parameters section on the right-hand side of the screen.
  4. In the QFM Parameters section navigate to the parameters beginning Email Confirmation. Here, check that Include Worksheet is set to Yes, for either/all of the Email Confirmation to Assigned To, Email Confirmation to Reported By and Email Confirmation to Requested By parameters, as appropriate.

If this does not resolve the problem then attempt to manually create the worksheet by clicking the Generate Report icon on the Event screen.

If you can create the worksheet manually, then the reason for the problem is that you do not have the correct system permissions. Contact your IT department to ensure you have ‘Modify’ rights to the following folder: “C:Program FilesQFM40System32ReportsWorkSheets”.

If you cannot create the worksheet manually, then contact the SWG Support Centre with a full description of the problem and the steps you have taken.

Why does a particular event not appear in Event Director?

Problem
A particular event record does not appear in Event Director.

Cause
There are several possible causes:

  1. No Priority is assigned to the event.
  2. The event has a Priority assigned, but the Priority has no calculation period and escalations set up.
  3. The event has a Priority assigned, but it is not currently in the active escalation range of the Priority.
  4. The event is a Scheduled Event with a Reported date set in the future, (i.e. the event has been generated by Start of Day to begin on a future date).

Resolution

  1. You may assign a Priority to the event retrospectively, so as to allow the event to move through the event cycle.
  2. You may change the Priority assigned to the event, or add a calculation period and escalations to the existing Priority (Applications > FM > FM Event > Priority > Priority Details).
  3. N/A
  4. N/A
Can I run QFM on two separate screens?

Question
Can I run QFM on two separate screens from the same PC?

Answer
There are two potential solutions:

  • Open QFM and enlarge the window to fit over both screens, by manually dragging the window border with the mouse in ‘arrow’ mode.
    Note:    This may not be the most practical way to use QFM and may give unpredictable results.
  • Open QFM, then open another QFM window (use Window > New Window), so that you are displaying a separate QFM window on each screen.
    Note:    This does not affect the number of licenses used, as licenses are counted by unique machine name.
How can I produce a report detailing forthcoming planned maintenance events?

Answer
Reports for all scheduled activities can be generated from both the QFM System Diary and Year Planner. These tools provide numerous filter options so you can specify the selection criteria of your choice. A specific Reports option enables you to specify a date range and select output options.

(Applications > System > System Diary/Year Planner)

How do I add QFM server and database details to the QFM Login lists?

Question
How do I add QFM server and database details to the QFM Login lists?

Answer
There are four potential methods of adding server and database details to the QFM Login selection lists. There is one method for QFM desktop versions up to and including 162.32, whilst the other methods are for QFM desktop versions including 162.33 and onwards.

Service Works Global recommends these procedures are carried out by, or under the supervision of, your IT department.

  • Method 1 – QFM desktop up to and inc. v 162.32
    This is applied to a single client PC running QFM.

    • From the Windows Start menu select Run. In the Open: field type regedit then click OK. The Registry Editor window opens.
    • Navigate to the following folder:
      My ComputerHKEY_LOCAL_MACHINESOFTWAREService WorksServers
    • In the Servers folder, create a new string (or rename an existing string, as appropriate). Name the string as follows:
      <server name>.<database name>
      e.g. “SW-TEST-IBM.QFM107”
      Note:  A data value of 1 makes the string the default value at QFM Login.
  • Method 2 – QFM desktop post v 162.32
    This is applied to a single QFM user.

    • Logon to QFM as an administrator.
    • Navigate to the Manage Database Connection screen (Applications>Admin>Manage Database Connection). Here, you can add server and database details and specify a default.
  • Method 3 – QFM desktop post v 162.32
    This is applied to a single QFM user.

    • Each QFM user is assigned their own QFM data source file when the application is installed. This is held at:
      C:Documents and Settings<windows username>Application DataServiceWorksQFMDataSources.xml
      This is a text file that can be amended manually.
    • Add a new entry to create a corresponding option at QFM Login. The information required is Server Name, Database Name and Default Number.
  • Method 4 – QFM desktop post v 162.32
    This is applied to a single QFM user.

    • At the QFM Login screen, click the Advanced button.
    • Manually type the server and database names in the appropriate fields. Following a successful connection these details will be added to the drop down lists for future selection.
How do I apply a new QFM license?

Question
How do I apply a new license to my QFM application?

Answer
Service Works Global recommends this procedure is undertaken by an experienced IT user.

You will have received an SQL license file from Service Works Global. The license file takes the following format:

<SQL server name>-<6 digit number>-<EncryptionsScript.sql>

It is normally appropriate to pass this file to your IT department, who will run this script on your QFM database within SQL Server. This can be done using the following applications:

  • MS SQL Server 2005 Management Studio
  • MS SQL Server 2000 Query Analyser
  • DbaManager
How should I change QFM to reflect a change in the rate of VAT (goods and services tax)?

Answer
The VAT Codes table in QFM4 is accessed via “Applications > General > Finance > Lookup Values”. Here you can maintain a set of different tax rates for use throughout QFM. If a rate that is in use changes, it is recommended that you create and start to use a new rate in order to preserve historical data (the old rate). If you change an existing rate then all instances of that rate throughout QFM will be changed to the new rate.

Where are the emails generated by QFM stored?

Answer
If your organisation sends the emails that are generated from QFM via an email client, e.g. MS Outlook, Lotus Notes etc. then they will be stored locally on the user’s PC.

If your organisation sends the emails that are generated from QFM via Simple Mail Transfer Protocol (SMTP) direct from the exchange email server, then copies will be stored on the server itself.
You should contact your IT department for storage information and details regarding specific records.

Error Message “Error 7. Out of memory” when adding data in the Event screen.

Problem
When adding data to an event you, may receive an error message that is similar to the following:

“Error 7. Out of memory.”

Cause
This is likely to be caused by your computer running low on memory.

Resolution
A short term solution is to run fewer applications on your computer. A longer term solution is to have the memory on your computer increased.

Please refer to System Requirements QFM (Client).

How do I add customised logos to QFM reports and worksheets?

Question
How do I add customised logos to QFM reports and worksheets?

Answer
Reports and worksheets in QFM carry ‘QFM’ and ‘Service Works Global’ logos in the header, as the default. These logos can be removed or replaced with other logs of your choice. To change the default images you need to store the new logos in the following location:

C:Program FilesQFM40System32ReportsLogos

You can place up to two files in this folder; one each for the logos on the right and left sides of the header.

  • Two files in this folder will replace the default logos used
  • One file in this folder will replace one side but the other side will remain as the default logo
  • No files in this folder will result in both default logos being used

One file should be named ‘LHSLogoHDR.jpg’ (for the left-hand-side) and the other named ‘RHSLogoHDR.jpg’ (for the right-hand-side). The existence of these files will automatically result in them being used to replace the default files.

If you wish to have only one or no logos displayed then you must include a file/s that is blank, where you wish to have no image.

It is important to note that the ‘LHSLogoHDR.jpg’ file is the image you wish to see on the right-hand-side of the document and the ‘RHSLogoHDR.jpg’ file is for the left-hand-side. However, Service Works Global has rectified this anomaly for some documents. In view of this, we strongly recommend that you test this process to ensure the logos appear as intended.

Customised logos must be a maximum of 2cm high and 4.28cm wide or 124 pixels high and 241 pixels wide.

Error Message “Error 6 Overflow” when adding a contractor to an event.

Problem
When attempting to add a contractor to an event, you may receive an error message that is similar to the following:

“Error 6 Overflow.”

Cause
This is usually due to the contractor name exceeding the character limit for the QFM field (Event screen), when the contractor details have been imported.

Resolution
In the Contractor screen, amend the contractor name so that the number of characters is reduced sufficiently, so as to allow it to be assigned to the event.

When creating an event, the Priority I select does not generate an event Due date and time. Why not?

Problem
When I create an event there is no Due date and time populated, despite a Priority being entered. Why?

Cause
This may be due to the Priority in question not having a calculation period set up. It could also happen if the event is at Reported stage (i.e. a contractor has not been notified) but the Priority applied to the event starts its Due period from Notified stage.

Resolution
You can establish the reason for this issue by viewing the Priority in question, in the Priority Details screen. In the Due Time section you can see whether the Priority calculates its Due period from Reported or Notified stage. You can also see whether a Calculation Period and Cover code are applied. A Calculation Period and Cover code must be applied in order for the Priority to function correctly.

Unable to add catering to a room booking.

Problem
You are unable to catering to a booking, via the Catering tab of the Room Booking screen. When selecting an item of catering from the drop-down list, the field does not populate.

Cause
Unknown.

Resolution
Contact the SWG Support Centre, as the following script will need to be run against your database.

 

ALTER PROCEDURE dbo.qfm_RoomCatering

@GeographyID  int,
@Date     DateTime = Null
AS

Declare @Catering Table(CateringID integer)

SET NOCOUNT ON

If @Date is Null
Begin
Insert @Catering
Select Distinct(a.CateringUseID)
From CateringUse a join CateringScope b
on a.CateringUseID = b.CateringUseID
Where (b.GeographyID in (Select GeographyID from dbo.GeogFamilyID(@GeographyID))
Or b.RegionID in (Select RegionID from dbo.RegionFamilyID(@GeographyID)))

Insert @Catering
Select Distinct(a.CateringUseID)
From CateringUse a
where a.CateringUseID not in
(Select Distinct CateringUseID from CateringScope)

Select CateringUseId, Code,

Description,Cost,Messages,CateringTypeID,
StartDate,EndDate,ExcludeFromDate,ExcludeToDate,

dbo.CateringRestrictionString(@GeographyID,CateringTypeID) as CatString,
vatid as initialvatcode –GJA
From CateringUse
— MBH 2003 To ensure that all services are shown even
— if the scope changes
— Where CateringUseID in (Select CateringID from @Catering)

End
Else
Begin
Insert @Catering
Select Distinct(a.CateringUseID)
From CateringUse a join CateringScope b
on a.CateringUseID = b.CateringUseID
Where (b.GeographyID in (Select GeographyID from dbo.GeogFamilyID(@GeographyID))
Or b.RegionID in (Select RegionID from dbo.RegionFamilyID(@GeographyID)))
And (@Date >= a.StartDate Or a.StartDate is Null)
And (@Date <= a.EndDate Or a.EndDate is Null)
And ((a.ExcludeFromDate is Null And a.ExcludeToDate is Null)
Or @Date Not between a.ExcludeFromDate And a.ExcludeToDate )

— This second part of the insert gets all of those Caterings
— that are available in all geographic locations excluded only
— by Include and Exclude Dates

Insert @Catering
Select Distinct(a.CateringUseID)
From CateringUse a
where (@Date >= a.StartDate Or a.StartDate is Null)
And (@Date <= a.EndDate Or a.EndDate is Null)
And ((a.ExcludeFromDate is Null And a.ExcludeToDate is Null)
Or @Date Not between a.ExcludeFromDate And a.ExcludeToDate )
And a.CateringUseID not in
(Select Distinct CateringUseID from CateringScope)

Select CateringUseId, Code,Description,Cost ,Messages, isnull(ShowMessages,0) as ShowMessages,
vatid as initialvatcode –GJA
From CateringUse
Where CateringUseID in (Select CateringID from @Catering)

End

SET NOCOUNT OFF

Error Message “Error – Validation of ViewState MAC Failed” when you click a postbacking control/link and the page hasn’t loaded completely in your web browser.

Problem
This error can occur when:

  1. You are not using a web farm
  2. You are using built-in databound controls such as GridView, DetailsView or FormView which utilise “DataKeyNames”.
  3. You have a large page which loads slowly for any reason

If one or more of the above conditions are met and you click a postbacking control/link and the page hasn’t loaded completely in your web browser, you may receive an error message that is similar to the following:

“Error – Validation of ViewState MAC Failed”

Cause
This is due to an issue with your server.

Resolution
Please review the following article:
http://blogs.msdn.com/tom/archive/2008/03/14/validation-of-viewstate-mac-failed-error.aspx

Event – QFM takes up large amounts of RAM when creating a worksheet.

Problem
When you create an event worksheet, QFM takes up a large amount of RAM on your computer. If you are creating many worksheets the application will eventually fail.

Cause
This is caused by QFM picking up customised worksheet logos from “c:program filesQFM40system32reportslogos”.

If customised logos are in use on your worksheets, QFM recreates the worksheet each time it needs to be run.

If default logos are in use, these are generated from inside the worksheet itself and so QFM caches the worksheet, subsequently not requiring it to be recreated each time.

Resolution

  1. Rename the files located in “c:program filesQFM40system32reportslogos”
    so that QFM does not pick them up.
  2. Place the customised logos into the worksheet itself (the worksheet will then need to be redistributed to all computers with a QFM installation).

Note that on each QFM upgrade the logos will need to be re-added to the worksheet.

Warning Message “Connection could not be established with the email server” when attempting to log an event that has email notifications.

Problem
When attempting to log an event that has email notifications, you receive a warning message that is similar to the following:

“Connection could not be established with the email server”.

Cause
This occurs when Lotus Notes is the email method. Confirmations are generated in HTML format which is not supported by Lotus Notes.

Resolution
In Lotus Notes you can set the format in which internet mail is sent, by navigating to “File > Preferences > User Preferences” then setting internet mail to Plain Text Only.

or

Remove any configured text relating to the confirmation so that it is not generated.

Error Message “Error 429 – You do not have an appropriate license to use this functionality” when attempting to navigate to a particular screen.

Problem
When attempting to navigate to a particular screen you receive an error message that is similar to the following:

“Error 429 – You do not have an appropriate license to use this functionality”.

Cause
Normally encountered when a new piece of functionality is added to your database via custom scripts. It can also be caused when your database is upgraded and licensing tables are changed.

Resolution
Request that the SWG Support Centre attempt to re-license your database correctly.

If the issue is not resolved, the SWG support Centre will need to take a backup copy of your database and test compare against an available database of the same version. It is possible that a code script may need to be created to resolve the issue.

No access to event records, when you are restricted to a specific contractor or site.

Problem
When you are restricted by a specific contractor or site, you find that you are able to search for events but are not able to access a specific event record, even if the correct contractor/site is assigned to the event.

Cause
This can occur when data is imported from QFM3.

Resolution
Check the data for spurious spaces after the Name or Description; delete if found.

Event worksheet not being attached to notification emails – hosted server

Problem
QFM does not attach worksheets to notification emails.

Cause
When Crystal Reports fails during an event (when QFM is running on a hosted server) it will continue to fail or not be available on subsequent events. The symptoms of this can be worksheets of file size 0kb found in the folder c:program filesqfm40system 32reportsworksheet. Note, however, that this symptom won’t necessarily appear each time.

Resolution

  1. Log out of QFM using File > Exit.
  2. Delete any 0kb worksheet files.
  3. Log back into QFM.
Error Message “Database Connection has been lost, please close and restart QFM” when attempting to run Start Of Day.

Problem
When you attempt to run Start Of Day, you may receive an error message that is similar to the following:

“Database Connection has been lost, please close and restart QFM.”

Cause
This could be caused by one of the following reasons:

  1. The server has insufficient memory
  2. Data has been lost on the network

Resolution

  1. Add more memory to the server
  2. Streamline the network
Event Screen – Priority field not being populated.

Problem
When you log an event, the Priority field is not being populated.

Cause
It is likely that you are using the unrestricted ellipsis button, as shown below elipsis to make selections for both the Service and Work Type. The Priority will not automatically populate as an unrestricted selection allows you to add a Priority of your choice.

Resolution
Use the restricted buttons, as shown below restricted only to select the Service and Work Type.

To activate restricted selections follow the steps below:

  1. Log on to QFM as an Admin user.
  2. Go to Applications > Admin > Maintain Classes.
  3. Navigate to the Standard user class.
  4. In the Permissions section (left side) navigate to FM > FM Event then click the blue square next to Event.
  5. In the QFM Parameters section (right side) scroll down until you find the Restricted Service / Service Groups parameter.
  6. In Update mode change the Active setting to On.
Error Message “The Visual Basic UFL that implements this function is missing (or u2lcom.dll is missing)” when you attempt to run a report.

Problem
When you attempt to run a report, you may receive an error message that is similar to the following:

“The Visual Basic UFL that implements this function is missing (or u2lcom.dll is missing)”

Cause
This is caused by a misplaced dll file within the operating system folder structure, specifically for the Crystal Reports installation.

Resolution
Add the file u2lcom.dll to the c:program filescommon filescrystal decisions2.0bin folder on the affected computer. This file does not require registration.

Refer to your IT department or the SWG Support Centre to receive this file.

More Information

You may also find the following two files in similar conditions:

  • u2lstrng.dll (This file does not require registration)
  • cryflccy.dll (This file requires registration)
Error Message “Error 713 – MSSTDFMT.DLL” when logging on or navigating to the Event screen.

Problem
When logging on to QFM or navigating to the Event screen, you may receive an error message that is similar to the following:

“Error 713 – MSSTDFMT.DLL”

Cause
This is caused by not having the file MSSTDFMT.DLL registered on your computer. This file belongs to the Crystal Reports Patch 145 that also needs to be installed alongside any QFM desktop installation. The most likely cause that this file is missing is that Patch 145 is not installed on your computer.

Resolution
Install or re-install Patch 145 on your computer.
Contact your IT department of the SWG Support Centre for the installation files.

Error Message “Error 91 – Invalid TLV Record” when attempting to print a worksheet from the Event screen.

Problem
When attempting to print a worksheet from the Event screen, you may receive an error message that is similar to the following:

“Error 91 – Invalid TLV Record”

Cause
Patch 145 (also known as Crystal Installation) has not been installed.

Resolution
Install Patch 145 on your computer.
Contact your IT department or the SWG Support Centre for the installation files.

Error Message “Error 13 Type Mismatch” when logging on or navigating to a screen.

Problem
When logging on to QFM or navigating to a particular screen, you may receive an error message that is similar to the following:

“Error 13 Type Mismatch”.

Cause
This is caused by the expected column types (on the client machine installation) and the actual column types (on the database) being different. The screen being loaded issues the error, rather than an actual comparison between the client and database versions.

For this reason the error is sometimes caused when attempting to use a client and database whose versions don’t match.

Resolution
Check that the version of QFM installed on the client machine and the database version are the same.

Error Message “Error 6 Overflow” when opening the Asset screen.

Problem
When attempting to open the Asset screen, you may receive an error message that is similar to the following:

“Error 6 Overflow.”

Cause
The InventoryID column on the database needs to be changed to accept larger numbers. This column has a default limit of 4 integer characters. As a result, if a database has more than 9999 assets then the 10000th asset will produce this error.

Resolution
It is recommended that Service Works Global personnel carry out the following procedure:

  1. Create a script that changes the InventoryID column within the database, so that it accepts more than 4 integer characters.
  2. Run the script against the database affected.
Error Message “Error 747 – Design Time License” when logging on to QFM or navigating to a particular screen.

Problem
When logging on to QFM or navigating to a particular screen, you may receive an error message that is similar to the following:

“Error 747 – Design Time License.”

Resolution
It is recommended that SWG personnel examine the following resolution options:

  1. Make sure the database and client versions match.
  2. Make sure the screen in question is correctly licensed.or
  3. Change the default QFM Startup screen to a screen that is correctly licensed.

More Information

This error can occur when the QFM Startup screen is set to a screen that is not licensed.

Error Message “Error 94 Invalid Use of Null” when navigation to an event or opening the Event screen.

Problem
When you try to open the Event screen or try to navigate to a particular event record, you may receive an error message that is similar to the following:

“Error 94 Invalid Use of Null”.

Resolution
It is recommended that SWG personnel carry out the following procedure:

  1. Use SQL Manager to run the following query on a copy of the affected database:
    select * from event where eventide is null 
  2. Ensure there are no null values in any required columns (not just eventid as above).
    These are generally:
    AgentID
    •  EventID
    •  EntryDate
    •  EntryTime
    •  EventStatusNo
  3. Create and run a script that changes the null value to the required value.

More Information
This error is most likely to occur after Start Of Day has been run and the relevant event created without a required column entry on the record. However, it has also occurred on standard reactive events.

Error Message “VEM Setting not Formatted Correctly” when you open the Event Director screen or attempt to select a view within Event Director.

Problem
When you try to open the Event Director screen, or attempt to select a view from the dropdown list, you may receive an error message that is similar to the following:

“VEM Setting not Formatted Correctly.”

Cause
This error only occurs on PCs which do not have MSXML 4.0 installed.

Resolution
MSXML 4.0 can be downloaded from the Microsoft website.

http://www.microsoft.com/downloads/en/resultsForProduct.aspx?displaylang=en&ProductID=6513d9c7-36d7-40d0-aad7-ba86e35e8332

Even if you have a later version of MSXML installed (e.g. 6.0), you will need to have v4.0 installed as well.

Event Worksheet – blank time values in Status fields.

Problem
When you create an Event Worksheet, either displayed in a window or generated automatically for sending with an email, the worksheet does not display the correct time values in the Status fields at the bottom of the first page. Instead, these fields are blank.

Cause
This can be caused when you have a customised worksheet installed but the script that accompanies the worksheet has not been run on the database.

Resolution
If the worksheet is a customised worksheet, make sure the script that accompanies the worksheet is run against the database you are using. For assistance, contact your IT department or the Service Works Global Support Centre.

Log a support request