3.2 Troubleshooting the Inventory Service Manager

Inventory Service Manager exits with -1 status

Source: ZENworks Server Management; Server Inventory; Inventory Service Manager
Explanation: On the Inventory server, the “Unable to connect to the database. Retrying...” message is displayed and the Service Manager eventually exits. The Inventory Service Manager logs this error in the Inventory server's status log with error code 622.
Possible Cause: The Database server is down.
Action: Ensure that the Database server is up and running.
Possible Cause: This problem can also occur on a Novell NetWare® Inventory server with the Native File Access Pack installed. This NetWare server has one or more volumes of the server exposed as CIFS shares and does not have a DNS name configured.

If the NetWare server does not have a DNS name configured, the CIFS service is given a NetBIOS name, so during installation the database object assigns the NetBIOS name as the host name. This error occurs if the Inventory service on the NetWare server fails to resolve the NetBIOS name to an IP address.

Action: Choose an IP address instead of the NetBIOS name in the database object property page. For more information, see Setting Up the Inventory Database in Server Inventory in the Novell ZENworks 7 Server Management Administration Guide.

You are unable to access the database server across NAT

Source: ZENworks Server Management; Server Inventory; Inventory Service Manager
Explanation: If you install the database server on a private network and the database object is configured with the private address, you cannot access this database from the public network (for example, through Novell ConsoleOne®).
Action: Configure the database object with the public address of the database server.

  1. In ConsoleOne, right-click the database object, then click Properties.

  2. Click the ZENworks Database tab.

  3. In the Server IP address or DNS Name field, specify the public address of the database server.

  4. Click Apply, then click Close.

Could not connect to the database due to invalid NLS data files

Source: ZENworks Server Management 7 with Support Pack 1 ; Server Inventory; Inventory Service Manager.
Explanation: If you install the inventory server on a Netware machine with English Language and Chinese code page, and try to connect to an Oracle 10g R2 database running on a windows machine with English Locale, the following exception is encountered:

ZENInv - Server Config: Unable to connect to the database: NOT CONNECTED ZENInv - Server Config: checkVersion: DB URL: jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:orcl ZENInv - Server Config: exception java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified

Possible Cause: This is due to a bug in the Oracle 10g R2 jdbc driver (10.2.0.1.0). Refer Oracle Discussion Forum
Action: Oracle 10g R1 driver is interoperable with 10g R2 database. To resolve this issue, do the following:

  1. Replace the Oracle 10g R2 jdbc driver (10.2.0.1.0) with Oracle 10g R1 jdbc driver (10.1.0.4.0).

  2. Download Oracle 10g R1 jdbc driver (classes12.jar), and replace the classes12.jar (Oracle 10g R2 driver version 10.2.0.1.0) in zenworks\inv\server\lib and consoleone\1.2\ConsoleOneExt directories.

    NOTE:If you have ZENworks 7 setup without Support Pack 1 installed, you can use the classes12.jar from it for the replacement.