Duplicate handheld devices show in Access 2000 database

After deleting handheld devices from ConsoleOne, those devices are still listed in device reports.

1. Stop ConsoleOne and also any remote ConsoleOne which may access the database.
2. Stop ZHM Services (Server, Proxy, Access Point) on the ZHM Server installation machine.
3. Take a backup of the database: ServerData.mdb, ProxyData.mdb.
4. Open the ServerData.mdb database (in the ZHM Server installation folder).
5. Open the Handhelds table.
6.  Identify the non-active duplicate handheld records such as DeviceGuid, SerialNumber, Username, DisplayName, LastSyncTime, etc.
7. Start ZHM Services (Server, Proxy, Access Point) on the ZHM Server installation machine. Start ConsoleOne.  Delete eDirectory duplicate handheld objects (delete the Non-active objects).
   Run: "Scan Now" from the properties page of the ZHM Server Service Object or by double-clicking the ZHM Server Service Object which opens the properties page of ZHM Server Service Object.
   Wait for 15-20 minutes (depending upon the number of objects in eDirectory, it may vary)
8. Delete the Identified Non-active duplicate handheld records from the Handheld's table, identified in step 6 above.
9. Then run dbtool.exe using the /compact option.
   To compact the server database, from the ZHM Server installation directory (eg: C:\Program Files\Novell\ZHM) run:
   dbtool /server /compact
   (it is also possible to run: "dbtool"  or  "dbtool /server"  or "dbtool server"  or "dbtool /compact" or "dbtool compact")
10. From the ZHM Access Point installation directory (eg: C:\Program Files\Novell\ZHMAP) run:
    dbtool /proxy /compact
    to compact the Access Point database.
11. run dbtool.exe using the /verify option. You can run
    dbtool /server /verify
    from the ZHM Server installation directory and
    dbtool /proxy /verify
    from the ZHM Access Point  installation directory.
     
    Server installation machine.
     
    This is to verify the integrity of the data All the information above is for Server DB correction:
     
    For Proxy database correction the steps are provided below
     
    If more than one Access Point is installed, stop the "ZENworks Handheld Management Proxy" Service, "ZENworks Handheld Management Access Point" Service from the service control panel for the other Access Points and perform the following steps for the other Access Points. (By default perform the steps below for a Proxy database correction on ZHM Server installation machine which also installs the Access Point by default)

1. Take a backup of ProxyData.mdb. (default folder) "C:\Program Files\Novell\ZHMAP")
2. Open the "Client Handhelds" table.
3. Identify the Non-active duplicate handheld records such as DeviceGuid, SerialNumber, Username, DisplayName, LastSyncTime etc.
4. Delete the Identified Non-active duplicate handheld records from the "Client Handhelds" table.
    
   Note all these timings are on the higher side for a rough estimate.
   
5. Stop ConsoleOne and any remote ConsoleOne which may access the database.
6. Stop ZHM Services (Server, Proxy, Access Point) on the ZHM Server installation machine.
7. Then run dbtool.exe using the "/compact" option. 
   To compact the Server database, from the ZHM Server installation directory (eg C:\Program Files\Novell\ZHM : is the default installation directory) run:
   dbtool  /server  /compact
   (it is also possible to run: "dbtool"  OR  "dbtool /server"  OR "dbtool /server"   OR "dbtool /compact" OR "dbtool compact")
   
   From the ZHM Access Point installation directory (eg C:\Program Files\Novell\ZHMAP : is the default installation directory) run:
   dbtool /proxy /compact
   to compact the Access Point database. 
   
   The steps above are to be followed on the ZHM Server installation machine.
   
8. run dbtool.exe using the /verify option. You can run:
   dbtool /server /verify
   from the ZHM Server installation directory) and
   dbtool /proxy /verify
   from the ZHM Access Point  installation directory
    
   This is to verify the integrity of the data
   
9. Start ZHM Services (Server, Proxy, Access Point) on the ZHM Server installation machine.
10. Start ConsoleOne , run "Scan Now" from the properties page of the ZHM Server Service Object (or by double-clicking FHA Server Service Object which opens the properties page of the ZHM Server Service Object).
     
    Verify that the duplicates are not shown.