Prism_Update_Instructions_28

Installation Instructions for PrismCore Version Update

These instructions are for upgrading your PrismCore SQL Server, WinPOS Distributed SQL Server and/or Comm/Admin server, along with associated WPConsole, PrismCore, PrismCore Admin, and WPPOSReg applications. It is assumed that the computer being updated is one you have also used for running the WPConsole program. The update does not need to be loaded at month end, but can be loaded at any time during the month.

IMPORTANT NOTES:

  • ALL users must be logged out of PrismCore, PrismCore Admin and/or WPPOSReg (the WinPOS register program) before the update can be loaded on any of your SQL server computers or another computer running WPConsole. If the update is not able to complete correctly and the installation program needs to restore your data back to your current version, it will not be able to do the restore if any users are logged into any of these applications.

  • Since ALL users must be logged out of PrismCore, PrismCore Admin and/or WPPOSReg before the update can be done, you will need to do the update after hours, after the registers have been closed for the day, or the next morning before you begin using PrismCore functions. Be aware that the update can take up to 3 hours to complete, so plan appropriately.

Before starting the update, check to make sure you have:

  • Current Version installed (to update to PrismCore 28.X, you MUST be on a version of PrismCore 27 or higher).

  • The PrismCore version files from the portal and your login information.

  • These loading instructions.

  • All applicable documentation pertaining to the update.

  • Customer Support's telephone number (800) 510-3911

  • The length of time it will take to install PrismCore on any given server will be 30 minutes to 3 hours, depending on the speed of the server and the size of the databases.

For PrismPOS –

If you have more than one SQL server computer (e.g. a Main SQL Server computer and a Distributed SQL Server computer), you must install the update first on the MAIN SQL Server computer. Immediately after that, install it on any Distributed SQL Server computers and/or Comm/Admin computers you have in your store(s). If you attempt to install it on a Distributed SQL Server computer before the Main SQL Server computer has been updated, a message will display, telling you that you must update the Main computer first, and the installation on the Distributed SQL Server computer will be stopped. Registers will not function until the Distributed SQL Server computers and/or Comm/Admin computers have been updated.

Update Workflow

  1. PrismCore System Requirements

  2. Backup

  3. Load the update

  4. Update all PrismPOS servers repeating steps 3-5 above.

  5. Update all clients (workstations, registers)

  6. Fax NBC

  7. In Case of ERRORS, see end of this document.

  8. Follow these steps for each version update.

PrismCore System Requirements – PrismCore 28

SQL 2012/2016 Required

A prerequisite is SQL2012, or SQL2016. For those users that are enrolled in our ISV program, this upgrade doesn't cost anything, and in most cases is a simple process. For those users who want to go from 32bit to 64bit, it will require additional efforts so please contact support for more details.

Requires PrismCore 27

In order to load PrismCore 28, your store needs to have already had NBC update your servers to PrismCore 27. If you are NOT already on a version of PrismCore 27, you will need to contact IT Support, and they can assist you in scheduling your update.

XP Not Supported

Please note, PrismCore 28 does NOT support Windows XP. If your workstations or registers have XP, you will need to upgrade them prior to installing PrismCore 28.

Update Workflow

Backup

Make sure your backup is being done and that it is current. While a backup is created during the update process, you should always make sure you also have a recent backup before starting.

Download Update Files

  1. You will be able to download the update file from the support portal. Log into the IT Support Portal from there, navigate to the PrismCore page, and download the necessary files.
    The file can be found here: PrismCore V28.2.7.27 . You will need the update file for each server you have (WPUpdateSSU_28.X), and any patch files.

  2. In case your workstations and WinPOS registers cannot update due to security limitations on your campus, you should download the proper installation files for those, as well. For the PrismCore workstations, that file is (WinPRISM_28.X), and for the WinPOS registers, that file is (WPPosReg_28.X).

Load the Update on All Servers (ICS Main Server First)

  1. Once the file is on the server, double click the WPUpdateSSU_xx.xbx.exe file. A "Setup – WPUpdate" window opens

     

  2. Click "Next". A "Database Information" screen displays. Fill in the following fields, as shown above.
    - User Name: enter "wpadmin".
    - Password: enter the appropriate password.
    - DSN: select "(Local)".
    - The Drive combo box: choose the appropriate drive from the dropdown list. The installation program uses the drive specified in the combo box for installing temporary update files and for doing a database backup before it updates your databases.
    - Use Trusted Connection – This is only to be checked if your store uses Windows Active Directory within PrismCore.
    - Restore Database: DO NOT check the checkbox.

  3. Click "Next". A "Select Components" screen displays. NOTE: The installation will tell you how much space is needed in the lower left. If there is not enough room on the drive for a backup, the installation will fail when it tries to do the backup. If that happens, an error will appear and you will cancel the installation. In that case, simply start the installation again and on this screen select another drive on your server from the Drive combo box. If you only have a single drive and that drive is full, click "Cancel" to stop the installation and contact IT Support to help you clear space on your C:\ drive.

  4. Select "Full Installation" in the dropdown box. Click "Next". A "Ready to Install" screen displays.

     

  5. Click "Install". An installing screen displays, and shows that it is extracting files.

  6. The installer program displays "Step 1 of x". NOTE: This is where the process does a backup of your data.

  7. When the backup has completed successfully, the program goes to step 2.

  8. The system uninstalls WPServer and WPConsole, if installed on your server.


    10. The system will then continue to update with steps for the training database.

IN CASE OF UPDATE ERRORS:

Although rare, there are cases where an update can fail. If at some point in the installation an error displays, DO NOT TRY AGAIN. If you attempt to update again, you may lose valuable log data. Write down the error completely or do a screen-print. The programmers will need to know what it said. Once you have recorded the error, click OK. The "Completing the WPUpdate Setup Wizard" window displays (see below). Click "Finish". If there is any problem with the installation, the process automatically restores the backup that was done in Step 2 of the installation. THIS MAY TAKE CONSIDERABLE TIME. Do NOT kill the process!!! When finished, your system will then be the same as it was before you began the update process and you will be able to use your system with it still on the current version.
If you have problems and are doing this update during regular support hours (7am-6pm, Central Time, Monday-Friday), call PrismCore ICS or POS Customer Support. If you have a problem at any other time, call the ICS or POS Support number, 1-800-510-3911. Follow the options for after-hours support, and you will be connected with a support representative. Let them know exactly what the error was.

  1. If no errors occur, after the last step of the WPUpdate process has successfully completed, a "Completing the WPUpdate Setup Wizard" screen displays.

  1. To update WPServer/WPConsole, leave the checkbox checked and click "Finish". If you do not run WPServer/WPConsole on this particular computer, you will not see an option to run WPServerSetup. Just click "Finish". The installation process will skip the WPServer installation and be complete at this step.

  2. If you are updating WPServer, a "WPServer and WPConsole" screen displays.

  1. Click "Next". A "Select Components" screen displays. Select "Full Installation" from the combo box.

  1. Click "Next". A "Ready to Install" screen displays.

  1. Click "Install". Messages display, showing that WPServer is being uninstalled and reinstalled. If a file already exists, the system will prompt. Any time this occurs, choose YES to overwrite.

  1. When the files have been successfully extracted and installed, a "Completing the WPServer and WPConsole" screen displays.

  1. Click "Finish".

Repeat update instructions for every WinPOS Server.

  1. Start the WPServer service on every server, if needed. To do this, open Administrative Tools > Services. Locate the 'WPServer' line. Right click the line, and choose 'Start'.

After the Update

  1. You will need to update each workstation and each register that runs PrismCore to the new version of PrismCore. For details, see below.

  2. You will need to update each register running WPPOSREG to the new version. For details, see below.

PrismCore and PrismCore Admin Client Updates

Updating PrismCore and PrismCore Admin:

  1. The first time you log into PrismCore on each client (a workstation or cash register) after the update has been done, you will see the following message: "The database and application versions do not match. Do you want to update PrismCore at this time?" You will simply need to answer "Yes" to this question.

  2. Your workstation will pull the update from the server, pull the CAB (update) file from the server, and extract the new software.

  1. Once the file is obtained, you will see the following dialog:

  1. You will see the following as components for Crystal Reports are installed:

  1. When finished, you will see the following. Click NO, as a restart is not necessary.



Be aware that this process will take several minutes (possibly up to 30). If you think the update has "hung up", please do NOT end the task. Instead, call Support at 800-510-3911.
Also, be aware that in order to update the WPPosReg clients on your cash registers, you will need to open the store for the day in PrismCore Admin. This means that at least one client has to have PrismCore updated on it before you update the register program, so you can log into PrismCore Admin to open the store, prior to updating WPPosReg on the registers. Also note that WPPOSReg does not require the Crystal Reports components, so you will not see that box.
In some cases, the auto-update portion may fail due to the user not having the proper rights to update certain files. In that case, please follow the instructions below.

If the Client Auto-Update Does Not Work

In some cases, workstations and WinPOS registers cannot update due to security limitations on campus. If that happens, you will need the workstation files you downloaded in step 2 on page 7. Please note that you may need administrator rights in order to update the clients.
There are two options:

  1. Manually place the cab files in the PrismCore (for workstations) or WPPOSReg (for registers) folder on each workstation and register.

    1. For workstations, place the 1_x.cab file in the PrismCore folder located in C:\Program Files (x86) if running 64-bit Windows, or in C:\Program Files if running 32-bit Windows.

    2. Log into PrismCore and follow the steps on page 20.

    3. For registers, place the 5_x.cab file in the WPPOSReg folder located in C:\Program Files (x86) if running 64-bit Windows, or in C:\Program Files if running 32-bit Windows.

    4. Log into WPPOSReg and follow the steps on page 24.



  1. Uninstall the PrismCore and/or WPPOSReg client on each workstation and register and reinstall using the version 28 client installers.

    1. Go to Control Panel\Programs and Features and locate PrismCore and/or WPPOSReg in the list (note: the version listed may not be the same as the version you are currently on – this is ok).

    2. Choose to uninstall.

    3. Place the installer files on each workstation and register.

    4. On a workstation, run the PrismCore_28.2.X.X installer, choosing all of the defaults.

    5. On a register, run the WPPosReg_28.2.X.X installer, choosing all of the defaults. If the register also runs PrismCore, run the PrismCore_28.2b35 installer as well.

If you need assistance, please contact Support at 800-510-3911.

WPPOSReg Update

  1. The first time you log into WPPOSReg on each client after the update has been done, you will see the following message: "The database and application versions do not match. Do you want to update WPPOSReg at this time?" You will simply need to answer "Yes" to this question.

  2. Your workstation will FTP your store's server, pull the CAB (update) file from the server, and extract the new software.

  3. When finished, you will see the login screen again. Log in normally.

  4. Be aware that this process will take several minutes (possibly up to 20). If you think the update has "hung up", please do NOT end the task. Instead, call Support at 800-510-3911.

PrismCore/WinPOS FaxBack Sheet Post-Update