IBM Support

Unable to connect to admin database with IBM Datacap Taskmaster Capture

Troubleshooting


Problem

When attempting to login using Taskmaster Web or another Datacap executable, and error occurs stating that the user is unable to connect to the admin database.

Cause

The application is not correctly configured.

Resolving The Problem

To resolve, do the following:
  • Ensure the application name is the same and each character is of the same case in all locations.
    • On the shared drive, usually the Taskmaster Server - \datacap\Datacap.xml, \datacap\appName\appName.app. Use a text editor to view these files.
  • Ensure \datacap\datacap.xml has the retry attribute <k name="tms" ip="127.0.0.1" port="2402" retry="3"/>.
  • On the web server check \datacap\tmweb.net\apps.ini.
    • In the following example, ensure the DateTimeSeparator is set to an apostrophe (') for SQL or Oracle, and that Oracle=1 for Oracle. It should not include connection strings. Also ensure the application name is correct and each character has the correct case.
      [1040EZ]
      	DateTimeSeparator=#
      	Delay=20
      	Retries=3
      	BatchSelectionCustomFields=
      	Debug=0
      	Oracle=0
  • Ensure the Taskmaster Application Manager’s Service tab points to the shared \datacap.xml unless the Datacap.xml and appName.xml files are duplicated locally on the web server.
  • If using Datacap.xml on a shared drive, ensure the user set as the identity of the Application Pool has permission to the share and to read the files.
  • Taskmaster Client and Quattro
    • Ensure the user set as the identity of the Application Pool has permission to the share and to read the files.
  • Taskmaster Server
    • The Windows user specified to run the Datacap Taskmaster Server Service is generally the only user that connects to the admin and engine databases. The clients read the connection strings from appName.app and pass them to Taskmaster Server.

When the error occurs when you apply fixpacks for V8.1.0:

  • The following fix is confirmed when updating from V8.1.0.0 to V8.1.0.4 and might work when updating to other fix pack levels.

    Complete the following steps:

    1. Stop the Datacap server.
    2. Delete the existing file dc_KTF.xml in the C:\Datacap\Taskmaster folder.
    3. From a DOS prompt execute the command: C:\Datacap\Taskmaster\dcskey.exe gnk e
    4. Start the Datacap server.

If the problem persists after attempting all of the suggestions:

  • Create a Taskmaster Server log. Look for the connection string that was used. See if there are errors explaining why the connection failed. Test a thick client application on the Taskmaster Server machine using a local Administrator account.
  • Use the included demo applications e.g. APT, that use Microsoft Access databases to identify the problem as related to connecting to the admin and engine databases.
  • Applications such as APT store additional connection strings and file locations in the following files. These paths and connection strings will not be used for the admin, or engine databases when logging into a client. The best practice is to store connection strings and file locations using the Taskmaster Application Manager.
    • \datacap\appName\dco_appName\paths.ini
    • \datacap\appName\dco_appName\settings.ini

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZRWV","label":"IBM Datacap"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.0.0;8.0.1;8.1.0","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
12 March 2020

UID

swg21503322