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.
-
Open a Command Prompt window.
-
Navigate to the <MobileScanInstallationFolder>\tools\sql\FreshInstall folder.
-
Launch a SQL*Plus session and connect to Smart Materials database as M_SYS.
-
If you are installing MobileScan for the first time, run the MobileScanInitialLoad.sql script.
-
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:
-
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.0:
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.
-
If you are upgrading from a lower version of MobileScan to version 5.0, 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.0.1
-
Execute the MobileScanUpgrade421.sql script.
-
Execute the MobileScanUpgrade43.sql script.
-
Execute the MobileScanUpgrade4.3.0.1.sql script.
-
Execute the MobileScanUpgrade44.sql script.
-
Execute the MobileScanUpgrade45.sql script.
-
Execute the MobileScanUpgrade4.5.0.1.sql script.
-
Execute the MobileScanUpgrade4.5.1.sql script.
-
Execute the MobileScanUpgrade.sql script.
-
-
-
Upgrade from version 4.2.1 to version 5.0.1
-
Execute the MobileScanUpgrade43.sql script.
-
Execute the MobileScanUpgrade4.3.0.1.sql script.
-
Execute the MobileScanUpgrade44.sql script.
-
Execute the MobileScanUpgrade45.sql script.
-
Execute the MobileScanUpgrade4.5.0.1.sql script.
-
Execute the MobileScanUpgrade4.5.1.sql script.
-
Execute the MobileScanUpgrade.sql script.
-
-
Upgrade from version 4.3 to version 5.0.1
-
Execute the MobileScanUpgrade4.3.0.1.sql script.
-
Execute the MobileScanUpgrade44.sql script.
-
Execute the MobileScanUpgrade45.sql script.
-
Execute the MobileScanUpgrade4.5.0.1.sql script.
-
Execute the MobileScanUpgrade4.5.1.sql script.
-
Execute the MobileScanUpgrade.sql script.
-
-
Upgrade from version 4.3.0.1 to version 5.0.1
-
Execute the MobileScanUpgrade44.sql script.
-
Execute the MobileScanUpgrade45.sql script.
-
Execute the MobileScanUpgrade4.5.0.1.sql script.
-
Execute the MobileScanUpgrade4.5.1.sql script.
-
Execute the MobileScanUpgrade.sql script.
-
-
Upgrade from version 4.4 to version 5.0.1
-
Execute the MobileScanUpgrade45.sql script.
-
Execute the MobileScanUpgrade4.5.0.1.sql script.
-
Execute the MobileScanUpgrade4.5.1.sql script.
-
Execute the MobileScanUpgrade.sql script.
-
-
Upgrade from version 4.5 to version 5.0.1
-
Execute the MobileScanUpgrade4.5.0.1.sql script.
-
Execute the MobileScanUpgrade4.5.1.sql script.
-
Execute the MobileScanUpgrade.sql script.
-
-
Upgrade from version 4.5.0.1 to version 5.0.1
-
Execute the MobileScanUpgrade4.5.1.sql script.
-
Execute the MobileScanUpgrade.sql script.
-
-
Upgrade from version 4.5.1 to version 5.0.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>.