ASA Error - 141: Table "TAB_DIST_VERSION" not found

ZENWorks 7 Server Management creates, by default, two database objects.
By default these objects are called Inventory Database and Server Management Database

The first of these two points to the mgmtdb.db which is used to store hardware and software information while the second object points to the zfslog.db, which stores Policy and Distribution Services data.

ConsoleOne would report the following error message:

ASA Error - 141: Table "TAB_DIST_VERSION" not found

when trying to read the distribution related reports.

The Server Management Database object does not exist in eDirectory.

Configure a new database object as follows:

1. Create a new ZENworks database object in the container where the distributor object resides. The name of the new object does not matter (the default name we use during the install is "Server Management Database_”).
2. In the properties of the new object select the server DN and after you've selected the right server check to see if the "Server IP Address" is correct.
3. The default database user name is dba and the default password is sql
4. Select the "Jdbc Driver Information" tab, at the Database Service Name enter the following: ?SERVICENAME=ZFSLOG&JCONNECTVERSION=4.
5. Click "Apply / OK"
6. Open the "Service Location Package", then select ZENworks Database / properties.
7. Finally, select the "ZFS Database" tab and use the browser to point to the newly created database object.
   

It maybe necessary to restart ZENworks 7 Server Management after configuring these services for the changes to take effect.