- Created by MatthewW, last modified by NeilM on Mar 02, 2022
https://help.myob.com/wiki/x/NIbeAw
How satisfied are you with our online help?*
Just these help pages, not phone support or the product itself
Why did you give this rating?
Anything else you want to tell us about the help?
If you use Self-Service, then you may need to complete the procedures in this section for all your live company databases. We recommend that you request a consultant to run these processes for you, if required.
If you are using any version of Self-Service, then you must complete the Check Database Name, Install Self-Service Components and Run Integrity Checker for Self-Service procedures.
Check database name
If the name of the database that you are using was changed during the upgrade procedure, then you need to use Config Editor to update your database name when your upgraded database goes live. Changing the database name in Config Editor will log out all Self-Service users, so update the configuration files outside normal business hours.
Install self-service components
If you use Self-Service, you need to install the appropriate Self-Service Components. The Self- Service Components allow Self-Service to retrieve information about an employee's work schedule.
For example, profiled hours and roster information that is used when an employee applies for leave or reviews My Roster or Employee Roster. You need to install the components that are the same version as your PayGlobal version.
To download the Self-Service Components, log on to your PayGlobal website and navigate to the Software Releases section.
- Ensure that you have exclusive access to PayGlobal and Self-Service.
If anyone accesses Self-Service while you complete this procedure, then file locking will stop you from copying the files successfully. - Extract the contents of the Self-Service Components.zip.
- Copy and paste the files to the bin folder in your Self-Service installation folder
Run the 'ConfigUpdater' executable.
You must run the 'ConfigUpdater' executable included in the Self-Service Components shipped with this release build to ensure that ESS functions
Run Integrity Checker for Self-Service
You should run the Integrity Checker for Self-Service each time you upgrade PayGlobal. When you installed the Self-Service Components, the Integrity Checker was copied to the bin folder in your Self-Service directory.
When you run the Integrity Checker for Self-Service, it checks only the tables that affect Self-Service. It does not display the company database selection page because the Integrity Checker automatically uses the database specified in the Config Editor. If the connection string specifies the use of integrated security, then the current Windows user must have read/write permissions for the required SQL Server database.
You must fix any errors that the Integrity Checker finds before you use Self-Service. If the Integrity Checker finds errors that it cannot correct, then contact Customer Support who may need to book a consultant to fix your database errors.
This topic explains how to run the Integrity Checker for Self-Service.
- Back up the database that you want to check.
You should take a backup of your database before you run any major database processes. - Navigate to the bin folder in your Self-Service directory.
Double-click IntegrityChecker.exe.
The Integrity Checker automatically uses the database specified in the Config Editor.
The Select the tables page appears.
Ensure that all tables are selected.
Only the tables that affect Self-Service are checked so you should select all tables and all rules to ensure that PayGlobal will work with Self-Service.Click Next. The Select the rules page appears.
Ensure that all rules are selected. See Integrity Checker Rules.
The Keys valid rule has options that you can configure in the Options for rule section.When you have selected a rule that may update your database, the following message appears:
"One or more of the rules you have selected may alter your data. It is recommended that you backup your database before continuing. Do you want to continue?"
- Click Yes to go to the next page.
- Click No to return to the rule’s selection page.
- Click Next. The Begin integrity checking page appears.
Click Start.
A two-stage progress bar and status messages are displayed while the tables are checked by each rule. You can click the Cancel button to cancel the process, which allows the rule that is currently running to complete before the integrity check is terminated. If you cancel the process, then any changes that have already been made to the database are not rolled back.The Displaying database integrity check results page appears, which displays a summarised list of violations.
To view more information about the integrity check, click the View audit log button.
The audit log shows which tables and records have problems, which rules were violated, and the errors that were corrected. The audit log is saved in the ...HRSS\bin folder and has the prefix "Database_Integrity_Check".Click Finish.
You must fix any errors that the Integrity Checker finds before you use Self- Service. If the Integrity Checker finds errors that it cannot correct, then contact Customer Support who may need to book a consultant to fix your database errors.
What's next?