Skip to main content
Kofax

How to reinstall the ShareScan v5.x - v6.1 Database tables

Information:

There may be cases where the ShareScan v5.x - v6.1 database must be deleted and recreated. This should be done as a last resort if all other troubleshooting options have been exhausted.

Please note that by doing so, all profile, configuration, license information, etc. will be deleted.  It is strongly recommended to make a backup of the database and server, as well as exporting and profiles and licenses as appropriate, before doing the following.

Note: The following process destroys the key-device linking in the database.

Preparation (best practice):

  1. Back up the database
  2. Back up the server
  3. Restore the backups to ensure that they contain good data
  4. Export the Profile
  5. Export the Licenses

NOTES

After the ShareScan v5.4 - v6.1 - tables are created, the license key can be added back to the database using the Manager.  If the key was previously activated on that SQL Database and the SQL Database Hardware has not changed, the key will be loaded in an activated state.  The key can then be used to register another device.

VERSION v5.4 - v6.1 (for earlier versions, see below)

Step 1 - Remove the ShareScan v5.4 - v6.1 tables from the SQL database:

  1. Open a Command Console "admin mode" (start menu CMD.exe)
  2. Navigate to the following folder:
    • C:\Program Files\Nuance\ShareScan5.4\Server\Tools\Database (ShareScan 5.4 default on 32-bit OS).
    • C:\Program Files (x86)\Nuance\ShareScan5.4\Server\Tools\Database (ShareScan 5.4 default on 64-bit OS).
  3. Run "db_uninst.cmd" eg:
  4. db_uninst.cmd /sqlsrv=. /dbname=eCopyShareScan /saauth=sql /sausr=sa /sapw=e+C0py2007_@x

If you work with Sql Express you can skip to step 2. If you you have local DB read on the next steps:

For local database np:\\.\pipe\LOCALDB#%ValueLocalDBid%\tsql\query where the name of Local DB can be found in registry under the following hive:

32bit

HKEY_LOCAL_MACHINE\SOFTWARE\Nuance\ShareScan\ShareScanAdmin

64bit

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Nuance\ShareScan\ShareScanAdmin

/dbname = name of the database in the database server

/saauth = typ of credential (sql or windows

/sausr = sa user

/sapw = password for sa user - the default is: e+C0py2007_@x

Step 2 - Create new ShareScan v5.4 - v6.1 tables in an existing SQL database:

  1. Navigate to the following folder:
    • C:\Program Files\Nuance\ShareScan5.4\Server\Tools\Database (ShareScan 5.4 default on 32-bit OS).
    • C:\Program Files (x86)\Nuance\ShareScan5.4\Server\Tools\Database (ShareScan 5.4 default on 64-bit OS).
  2. Run the "db_inst.cmd" command with the following parameters:

db_inst.cmd /sqlsrv=. /dbname=eCopyShareScan2 /saauth=sql /sausr=sa /sapw=e+C0py2007_@x /dbauth=sql /dbusr=eCopy /dbusrpw=e+C0py2007_@x

Note:  - If you have SQL express db installation the {/sqlsrv=.} is a right value. 

           - In case of locaDB2012(4) {/sqlsrv= (localdb)\.\eCopyShareScan} or {np:\\.\pipe\LOCALDB#%ValueLocalDBid%\tsql\query --> AnswerID

                                          

Once you created the new database you need to change at ShareScan Administration Console --> Advanced--> Database --> Configuration the db name to eCopyShareScan2

In case you were not able to open the Administration console you can user eCopyShareScan TroubleShoter application --> Database --> test/set connection --> read from configuration --> change the database name to eCopyShareScan2 --> test connection --> if it was succesfull --> set connection. After restart ShareScan Administration Console ShareScan will connect the newly created eCopyShareScan2 db.

VERSION 5.2 and earlier

Step 1 - Remove the ShareScan 5.x tables from the SQL database:

  1. Navigate to the following folder:
    • C:\Program files\Nuance\ShareScan5\Server\Tools\Database (ShareScan 5.0 default on 32-bit OS).
    • C:\Program Files (x86)\Nuance\ShareScan5.2\Server\Tools\Database (ShareScan 5.2 default on 64-bit OS).
  2. Open a Command Prompt then run "db_uninst.cmd" file specifying the appropriate database location and credentials.

Step 2 - Create new ShareScan 5.x tables in an existing SQL database:

  1. Navigate to the following folder:
    • C:\Program files\Nuance\ShareScan5\Server\Tools\Database (ShareScan 5.0 default on 32-bit OS).
    • C:\Program Files (x86)\Nuance\ShareScan5.2\Server\Tools\Database (ShareScan 5.2 default on 64-bit OS).
  2. Run the "db_inst.cmd" command with the following parameters:
    • db_inst.cmd [SQLSERVER\Instance] [eCopyUser] [eCopyPassword] [saUser] [saPassword]

      Examples:
       
    • db_inst.cmd 10.140.26.212\ecopy sa Yah@gs61 db_inst.cmd 10.140.26.212 sa Yah@gs61 db_inst.cmd mn-dbserver01 sa Yah@gs61

      If the SQL Database was installed by 5.0 defaultlocal installer, then this is the correct command:
       
    • db_inst.cmd .\SQLEXPRESS sa e+C0py2007_@x

For ShareScan 5.2 with LocalDB 2012:

  • db_inst (localdb)\.\eCopyShareScan eCopy e+C0py2007_@x sa e+C0py2007_@x