Troubleshooting
Problem
Unable to login to two applications simultaneously with Rulerunner in IBM Datacap Taskmaster Capture. Logging into the second application generates the error: Unable to connect to the Engine DB.
Symptom
Depending on the version, the Taskmaster Server log may show one of the following:
- 12/16/13 15:14:37.862 2 12dc Database ID 'Admin' is duplicated for 'PROVIDER=MSSQL;DSN=sqlserver;CATALOG=FlexAdm;UID=myuser;PWD=******;DBNTA=;' and 'PROVIDER=MSSQL;DSN=sqlserver;CATALOG=APTAdm;UID=myuser;PWD=******;DBNTA=;'. Thread: 12dc
- Database index 156 is the same for 'C:\Datacap\Flex\FlexAdm.mdb' and 'C:\Datacap\APT\APTAdm.mdb'. Thread: 8dc
Cause
Taskmaster Server tracks database connections to the server using the db_index column stored inside the admin and engine databases. If creating a new application or deploying a configuration such that the db_index values are not unique across all applications, login issues may result.
Resolving The Problem
To resolve, do the following for each application running on the Taskmaster Server.
- Open the admin database.
- In the admininfo table, note the value of db_index.
- If the value is a duplicate of the value used in a different admin database, change the value to any other random 3-digit number such that it is unique for this database.
- Close the admin database and open the engine database.
- In the enginfo table, check the value of db_index and change it if necessary, so that it is the same as the value in the adminfo table. In older versions these two values had to match. They no longer need to match within an application, but the requirement that they be unique across applications still applies. So it is still good practice to match the adminfo and enginfo values to minimize the possibility of conflicts.
- If the value of db_index is changed, edit the queue table in the engine database and change the value of qu_admDB to the new value for all records.
[{"Product":{"code":"SSZRWV","label":"IBM Datacap"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1.0;8.0.1;8.0.0;7.6","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Business Unit":{"code":"BU051","label":"N\/A"},"Component":" ","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.0.1;9.0.0.3;9.0.0.2;9.0.0.1;9.0.0","Edition":"All Editions","Line of Business":{"code":"LOB33","label":"N\/A"}}]
Was this topic helpful?
Document Information
Modified date:
19 August 2022
UID
swg21599801