MyAssistant tasks fails (ISD services require domain admin credential)
Description

When you review the Application Event Viewer on the server, it may show these error variations: 
 

  • ISD.DataLayer.SqlManager.ReadDataSetException: Unable to open table
  • ERROR 42S02 SimbaSimbaEngine ODBC DriverDRM File LibraryNo such table or object
  • Error: DataDriverException Unable to open table
Cause
The MyAssistant ISDAdminTaskService and ISDAdminSenderService services do not have proper permissions to read Pervasive/Actian data.The ISD services may need to be restarted.
Resolution

Add an administrator credential to the ISDAdminTaskService and ISDAdminSenderService services.

  1. Log on the MyAssistant server as an administrator.
  2. Click Start, Run (or Search programs and files for newer operating systems), and type: services.msc
  3. Press Enter to open the Windows services.
  4. Locate ISDAdminTaskService and ISDAdminSenderService and double-click on each to open the properties window.
  5. Stop and start the 2 services. Test the condition if it fails then.
  6. Click the Log On tab.
  7. In the This account field, if you know the domain, type in the domain administrator account, such as MyDomain\Administrator where MyDomain is whatever your network domain is. This account cannot be a local administrator account, and must belong to the domain. If you know the domain and type in the correct [domain]\[username] account, skip the remaining steps and simply click OK and restart both ISD services.
  8. If you do not know what the domain is, check with your IT contact. If you have an idea of what it might be, click Browse.
  9. In the next window, click Locations, Entire Directory, and click to highlight your domain, and then click OK.
  10. In the Enter the object name to select window, type in the domain administrator username and click Check Names. Select the correct username if prompted.
  11. Click OK and type in the correct password. Click OK again.
  12. Restart both ISD services.
Steps to duplicate
Related Solutions

MyAssistant Required Permissions.
Required permissions for Windows account assigned to MyAssistant services.
Sage MyAssistant and MyCommunicator anti-virus and firewall exceptions.