Orphaned Devices on Traveler HA SQL

Hi all,

Had a recent issue with a customer using Traveler 9.0.1.4 on Domino 9.0.1.4 where one user had three devices listed all with the same device ID (so essentially the same device). All devices were inactive and we wanted to clear them up. So, I issued the usual console commands:

1. Tell Traveler Delete * <username>
2. Tell Traveler Security Delete * <username>

but Traveler kept saying that no devices were found for the user. Issuing Tell Traveler User <username> confirmed that there were indeed no devices associated with the user. However, in the back-end SQL database i.e. https://lotustraveler.nsf the devices were still showing !

So that means that devices still have records within the SQL database itself and so I approached an SQL DBA (after reading an IBM technote suggesting this) and there were hundreds of tables in the Traveler SQL database so that line of investigation ended right there.

IBM came to the rescue though with a couple of very handy commands which my good friend Google search could not find which is why I’m sharing this with you:

To manually remove the orphaned users and devices from the SQL db, you
may execute the following command:
.
tell traveler sql delete * from USERS where username=’fully qualified name’
Note: The name has to be within single quote.
.
tell traveler sql delete * from DEVICE where username=’fully qualified name’
Note: The name has to be within single quote.

So as an example:

tell traveler sql delete * from USERS where username=’CN=Jo Bloggs/OU=Sales/O=Acme’

tell traveler sql delete * from DEVICE where username=’CN=Jo Bloggs/OU=Sales/O=Acme’

And there you have it…

This entry was posted in IBM Notes Traveler, IBM Notes Traveler 9, Lotus Traveler, Traveler 9. Bookmark the permalink.

One Response to Orphaned Devices on Traveler HA SQL

  1. Claude says:

    I have this issue, with Traveler 9.0.1.15, and the syntax is now invalid:
    Traveler: Command ‘sql delete * from USERS where username=’CN=John Doe/OU=People/O=organization” failed with error com.lotus.sync.db.PersistenceException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax nea
    r ‘*’. (SQLState: S0001 ErrorCode: 1
    01/20/2017 04:57:20 PM Traveler: 02)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>