ANS1 bad tag value met

Published: 2009-09-25

 

Last Updated: 2010-07-26

Applies To

Symptoms

When opening Client SE

-or-

When opening Rounds Tracker SE

-or-

When Attendant SE attempts to process a download (DL2) file

 

You receive the following error:

 

 

Followed by There was an error opening the configuration database.  If the error occurs when Attendant SE attempts to process a download file it will also be followed by There was an error trying to process download file...

 

Cause

The "Pwd=" section of the Config.ini file in the Guard1 Plus SE Server share has been manually edited. This prevents proper decryption of the SQL Login password.

 

 

Resolution

Reset the Configuration database connection parameters:

  1. On the PC where the Guard1 Plus SE Server share resides, open My Computer/Windows Explorer.
  2. Navigate to C:\Program Files\Guard1 Plus SE Server.
  3. Right-click the file Config.ini and select Copy.
  4. Paste the file in a convenient folder such as My Documents.
  5. Open a Command Window and navigate to C:\Program Files\Guard1 Plus SE Server.
  6. Type the following, then press Enter: G1Cfg 100;SQL Server;Database;SQL Server Login;SQL Server Password
    • Where:
      • SQL Server = the name of the SQL Server where the Guard1 Plus SE databases are located
      • Database = the name of the Guard1 Plus SE Configuration database (usually 'Guard1PlusConfig')
      • SQL Server Login = the SQL Login associated to Guard1 Plus SE (usually 'guard')
      • SQL Server Password = the password for the above Login.  This will be stored in a secure manner.
  7. Click Yes to confirm.
  8. Click OK.

 

You should retain the copy of the original Config.ini file from Step 4 to provide to Technical Support if requested.

 

Open the Client SE. If you receive the message "There are no configured data sources", delete and recreate your Guard1 Plus SE data sources:

  1. On the PC where the Guard1 Plus SE Server share resides, open a Command Window.
  2. Navigate to C:\Program Files\Guard1 Plus SE Server.
  3. Type the following, then press Enter: G1Cfg 0. This will display the Current Configuration. Under Data Sources and Connection Parameters, note the name, Type and Database name of each configured data source. (It will be helpful to leave this window open for reference.)
  4. At the Command Prompt, type the following for each Data Source, then press Enter: G1Cfg 201;Supervisor User;Supervisor Password;Data Source Name
    • Where:
      • Supervisor User = an application user that has Supervisor rights
      • Supervisor Password = the password for the above Supervisor user
      • Data Source Name = the name of the data source to delete
    • NOTE: this does NOT delete any data! It simply removes the database from Guard1 Plus SE's list of data sources.
  5. After deleting all Data Sources, type the following for each Data Source, then press Enter: G1Cfg 200;Supervisor User;Supervisor Password;Data Source Name;Data Source Type;SQL Server;Database;SQL Server Login;SQL Server Password
    • Where:
      • Supervisor User = an application user that has Supervisor rights
      • Supervisor Password = the password for the above Supervisor user
      • Data Source Name = the name you want to assign to the new data source (typically the same as the database name)
      • Data Source Type = Valid types are: 1 for Master, 3 for Backup and 4 for Archive (use the Type recorded in Step 3)
      • SQL Server = the name of the SQL Server where the Guard1 Plus SE databases are located
      • Database = the name of the Guard1 Plus SE database associated with this data source
      • SQL Server Login = the SQL Login associated to Guard1 Plus SE (usually 'guard')
      • SQL Server Password = the password for the above SQL Login. This will be stored in a secure manner.
  6. Click OK after adding each Data Source.
  7. When finished, type the following, then press Enter: G1Cfg 0.  Confirm that the Data Sources listed match those listed in Step 3.
  8. Click OK to close the Current Configuration window.
  9. At the Command Prompt, type the following for each Data Source, then press Enter: G1Cfg 401;Supervisor User;Supervisor Password;Data Source Name
    • Where
      • Supervisor User = an application user that has Supervisor rights
      • Supervisor Password = the password for the above Supervisor user
      • Data Source Name = the name of the data source
  10. Click Yes to confirm you want to reset the database pairing.
  11. Click OK.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.