Smart Materials Database Setup - Intergraph Smart Materials - 5.1 - Installation & Upgrade - Hexagon

If you have Oracle client installed on the application server, execute the installation or upgrade scripts on the application server. Else, you must execute the script on the database server.

1. Open a Command Prompt window.

2. Navigate to the <MobileScanInstallationFolder>\tools\sql\FreshInstall folder.

3. Launch a SQL*Plus session and connect to Smart Materials database as M_SYS.

4. If you are installing MobileScan for the first time, run the MobileScanInitialLoad.sql script.

5. If you already have an older version of MobileScan, based on the version in your environment, you must run the following scripts to upgrade MobileScan application to the latest version:

   

   1. To get a list of duplicate/mixed case barcode mappings, run the following query on the Smart Materials database and then you must update or remove duplicate entries before upgrading to MobileScan version 5.1:

      select map1.* from m_mobile_map map1, m_mobile_map map2

      where upper(map1.code_name) = upper(map2.code_name)

      and map1.mobile_id != map2.mobile_id

      order by upper(map1.code_name);

      If you do not update/delete the duplicate barcodes, the upgrade/installation process fails.

   2. If you are upgrading from a lower version of MobileScan to version 5.1, to work with Initiate Issue tile, assign the following privileges to the existing users after running the upgrade scripts:

      • MOBILE_ISSUE_BD (see Assign User Privileges)

      • MOBILE_ISSUE_RPT (see Assign User Privileges)

   • Upgrade from version 4.2 to version 5.1

     1. Execute the MobileScanUpgrade421.sql script.

     2. Execute the MobileScanUpgrade43.sql script.

     3. Execute the MobileScanUpgrade4.3.0.1.sql script.

     4. Execute the MobileScanUpgrade44.sql script.

     5. Execute the MobileScanUpgrade45.sql script.

     6. Execute the MobileScanUpgrade4.5.0.1.sql script.

     7. Execute the MobileScanUpgrade4.5.1.sql script.

     8. Execute the MobileScanUpgrade.sql script.

• Upgrade from version 4.2.1 to version 5.1

  1. Execute the MobileScanUpgrade43.sql script.

  2. Execute the MobileScanUpgrade4.3.0.1.sql script.

  3. Execute the MobileScanUpgrade44.sql script.

  4. Execute the MobileScanUpgrade45.sql script.

  5. Execute the MobileScanUpgrade4.5.0.1.sql script.

  6. Execute the MobileScanUpgrade4.5.1.sql script.

  7. Execute the MobileScanUpgrade.sql script.

• Upgrade from version 4.3 to version 5.1

  1. Execute the MobileScanUpgrade4.3.0.1.sql script.

  2. Execute the MobileScanUpgrade44.sql script.

  3. Execute the MobileScanUpgrade45.sql script.

  4. Execute the MobileScanUpgrade4.5.0.1.sql script.

  5. Execute the MobileScanUpgrade4.5.1.sql script.

  6. Execute the MobileScanUpgrade.sql script.

• Upgrade from version 4.3.0.1 to version 5.1

  1. Execute the MobileScanUpgrade44.sql script.

  2. Execute the MobileScanUpgrade45.sql script.

  3. Execute the MobileScanUpgrade4.5.0.1.sql script.

  4. Execute the MobileScanUpgrade4.5.1.sql script.

  5. Execute the MobileScanUpgrade.sql script.

• Upgrade from version 4.4 to version 5.1

  1. Execute the MobileScanUpgrade45.sql script.

  2. Execute the MobileScanUpgrade4.5.0.1.sql script.

  3. Execute the MobileScanUpgrade4.5.1.sql script.

  4. Execute the MobileScanUpgrade.sql script.

• Upgrade from version 4.5 to version 5.1

  1. Execute the MobileScanUpgrade4.5.0.1.sql script.

  2. Execute the MobileScanUpgrade4.5.1.sql script.

  3. Execute the MobileScanUpgrade.sql script.

• Upgrade from version 4.5.0.1 to version 5.1

  1. Execute the MobileScanUpgrade4.5.1.sql script.

  2. Execute the MobileScanUpgrade.sql script.

• Upgrade from version 4.5.1 to version 5.1

  1. Execute the MobileScanUpgrade.sql script.

• The MobileScanUpgrade.sql script checks for duplicate barcodes, with same name but in different text case, in the m_mobile_map database table. In case of duplicate barcodes, the upgrade/installation process fails. You must update/delete the duplicate barcodes manually. You can find the duplicate entries in the DuplicateMappings_LOGFILE. You must re-run the MobileScanUpgrade.sql script after updating/deleting the duplicate barcodes.

• Moving forward, Barcode Manager/MobileScan does not support lower case barcodes. The MobileScanUpgrade.sql script also automatically converts the lower/mixed case barcode text to upper case text.

• For a fresh install or an upgrade, the installer creates a log file in the location from where you invoke SQL Plus to execute the scripts and not at the location where the sql scripts are saved.

• The log files are created using the naming convention <SQLScriptname_LOGFILE.TXT>.