Upgrading the PDXpert Application Server

Your system must be using a valid license for the upgraded release. You must have administrator rights to your computer and be the only logged-in Windows user.

Before upgrading: Upgrades may add or modify features and settings. Read all release notes published between your current release and this new release.

If your system is older than PDXpert 10.0: First upgrade server and all clients to PDXpert 10.0, then upgrade again to the current release. If you're upgrading to a release that's older than PDXpert 8.0, then refer to Upgrade to PDXpert 7.5 or earlier.

All updates are cumulative and may be applied to any PDXpert system. No other updates are required to obtain the most current features.

We recommend validating your upgrade in a test environment prior to upgrading your production system.

A system upgrade is applied to your server computer.

  • In a single-user system, you may be using a single PC that acts as the server computer and contains the PDXpert client application.

  • If you use more than one computer for your PDXpert system, upgrade the PDXpert system on your server computer before upgrading the PDXpert client application on each workstation computer.

  1. Download and save the new PDXpert System installer.

    Obtain the PDXpert System installer using your previous release's download page; registering to receive a new download link via email; or requesting the download from your application support engineer.

    Save the PDXpert System installer to your server computer. Do not run the installer directly from your browser. An interrupted connection may cause the installation process to fail.

  2. Confirm that:

    • You have administrator rights to your server computer.

    • You are the only logged-in Windows user on your server computer.

      To confirm: (1) use the Windows command query user or (2) open Task Manager, click More Details and then the Users tab.

    • Your PDXpert system has a current license loaded.

    • You've reviewed the installation guidelines.
    • You've reviewed any special instructions in the related release notes.
    • Your system has all important Microsoft updates, and you've recently restarted your computer.
  3. Close all PDXpert client applications to ensure that all work has been saved.

  4. Stop access from any applications, utilities or services that rely on the PDXpert database (CAD part look-up, MRP transfers, database backup services, etc.).

  5. Back up your data as described in the help file: Contents > PDXpert Application Server > How to... > Back up the database or in on-line help. If you have a large number of files, you may use the Database without Library (.bak) option. The upgrade will not affect any library files.

  6. Run the PDXpert System installer on your current server computer. This also updates the PDXpert client on the same computer. An upgrade usually takes just a few minutes. Exceptions will be described in the release notes.

    A PDXpert System upgrade normally won't install a new SQL Server LocalDB or database instance (see note below).

    During an upgrade, the PDXpert installer may display the message: Warning 1910. Could not remove Shortcut {PDXpert app}.lnk Verify that the shortcut file exists and that you can access it. You can safely ignore this warning.

Users may log in after the server displays the Database upgraded successfully status message.

Indexing may take significant time for a large database and library. While the database is being indexed, search results may be incomplete and server computer performance will be reduced. Server performance and search results will return to normal after the indexing is complete.

Validating your database & library upgrade §

Use the following steps to confirm that all database services are operational, and that your database and library file pointers have been successfully updated.

  1. On the server computer, start the PDXpert Server. Click on the Information tab:

    • Confirm that the Application: Application release displays the expected PDXpert upgrade.

    • Confirm that the Application: SQL Server displays the current SQL Server version and edition; for example, SQL Server 2014 SP1 Standard Edition (64-bit) (12.0.4487.0).

      If you do not see any SQL Server information, then the SQL Server service may not be started. Restart the SQL Server service by rebooting the server computer.

      If rebooting the server computer still doesn't show SQL Server, then check Is the firewall allowing communications? and Is your anti-virus software allowing communications?.

  2. Start the PDXpert client using an account with normal or analyst role permissions:

    • Enter account name and password, and
    • Click the OK button.

    If you see the log in message The server could not be contacted, then the PDXpert client communications service did not automatically restart after the upgrade. Restart the service by rebooting the server computer. Or, to avoid rebooting, use the Windows Control Panel > Administrative Tools > Services tool to Stop, then Start, the PDXpert Server service.

  3. Search for a known part or document that has a file attachment. Open the item and confirm that the file attachment can be copied from PDXpert to your computer's Desktop. View the file to ensure the file appears as expected. You may want to test both recent and older items.

    A large database may require significant time before all items are searchable. You can monitor indexing progress within the PDXpert client: Tools | Index Status...

  4. Verify that each Data Transformations member (custom reports, imports and exports) performs as expected.

  5. If you have defined any Views collection members for sharing data with CAD, MRP or similar applications, verify that each view result contains expected data.

  6. Restart/restore any custom applications, utilities or services that rely on the PDXpert database and verify proper operation.

When upgrading, you can ignore changes to the database file sizes and dates.

After an upgrade, the next database backup may be smaller than before the upgrade. This is normal and temporary. The pre-upgrade backup (BAK) contains cached transactions from the LDF file. During the upgrade, SQL Server may merge the LDF into the MDF, which results in a more compact LDF and smaller BAK file.

An upgrade sends normal database commands to SQL Server, and doesn't restart the database. Unless SQL Server is restarted, the MDF/LDF file dates usually won't show the upgrade date.


Note on SQL Server installation during upgrades

When upgrading, the PDXpertSystemSetup.exe does not install SQL Server Express LocalDB (x86 or x64) when any of these conditions is true:

  • Install is invoked using the command line parameter db=0 (literally, where the supplied parameter overrides the default 1)

  • A SQL Server instance named PDXPERT exists

  • LocalDB 2012, 2014 or 2016 exists

The PDXpert server attempts to use an existing PDXpertDB database when

  • HKEY_LOCAL_MACHINE\SOFTWARE\PDXpert\Server\ConnectionString exists in the registry

  • An instance named PDXPERT exists

  • A LocalDB default instance exists (the instance name is defined by LocalDB, which will usually be MsSqlLocalDb)

  • A LocalDB instance named (localdb)\MsSqlLocalDb exists

These rules are shown in order of precedence.

Learn More
Install Guide Contents