Cards malfunction after Watchdoc update - Cards in unusable status

Jully 2020

Context

After updating Watchdoc (from a version prior to the v5.0), user's authentication by cards no longer works. Furthermore this cards are not found in the Watchdoc Supervision Consol (WSC).

This problem occurs when the update is applied on a Watchdoc version prior to the v5.0.

Cause

This malfunction may be caused by the change of a field name in the SQL table of the cards. The value "badges" of the field crdDOMAIN has been changed in "cards". As a result, the badge ID (that contains) this value becomes invalid in the new version of Watchdoc.

Resolution

To solve this issue, it's necessary to launch a SQL query that updates the cards identifiers. This update replaces the old table ID (BADGES, as a rule) with the ID of the new CARDS table:

  1. log in as administrator in the server that hosts the Watchdoc databases;

  2. enable SQL Manager ;

  3. run the following query on the CARDS table:

  • UPDATE cards SET crdDOMAIN='NEW_CARDS_DIRECTORY_NAME' WHERE crdDOMAIN='OLD_CARDS_DIRECTORY_NAME'

  • in most cases, the query will therefore be as follows:

  • UPDATE cards SET crdDOMAIN='CARDS' WHERE crdDOMAIN='BADGES'

  1. delete the CARDS's directory cache.

  2. check that the cards are working again.

If the cards table (CARDS, by default in recent versions of Watchdoc) has been renamed for specific project needs, enter this name in place of NEW_DIRECTORY_NAME