2.9 Troubleshooting

The following sections provide solutions to the problems you might encounter to ZENworks 11 SP2:

ZENworks Diagnostic Center reports database schema mismatch error

Source: ZENworks 11; Upgrade.
Explanation: If you want to upgrade a Primary Server on which ZENworks 10 Configuration Management SP3 was freshly installed and you created the database schema before installing ZENworks 10 Configuration Management SP3, you encounter the following error when you run the ZENworks Diagnostic Center Database Schema Verifier:
Mismatch in table 'zInstallationPackage' structure. 
Object type: [Column] , Object name: [Platform] 
Expected: [Name: Platform, Size: 255, Type: VARCHAR, Nullable: true] 
Found: [Name: Platform, Size: 32, Type: VARCHAR, Nullable: true]

If you do not resolve the issue, you can still choose to upgrade to ZENworks 11SP2 but ZENworks 11SP2 Imaging operations will fail.

Possible Cause: The SQL sets contained in the database schema of ZENworks Diagnostic Center are different from the SQL sets contained in the database schema that is created during the installation of ZENworks 10 Configuration Management SP3.
Action: Before upgrading to ZENworks 11SP2, do the following from any one of the ZENworks 10 Configuration Management SP3 Primary Server:
  1. Connect to the ZENworks database by using appropriate utility.

    For example, use the DBISQL utility to connect to the external Sybase database:

    1. At the command prompt of the device that has the external Sybase database installed and running, go to the %ZENWORKS_HOME%\share\ASA\win32 directory on Windows or to the /opt/novell/zenworks/share/sybase/bin32s directory on Linux.

    2. Enter dbisql.

    3. In the Identification tab, specify the database credentials.

    4. Click the Database tab, then specify the name of database service that is currently running.

    5. Click OK.

  2. Run the appropriate query:

    • For Sybase:

      alter table zInstallationPackage modify Platform nvarchar(255);
      
    • For Oracle:

      alter table zInstallationPackage modify Platform varchar2(255 char);
      
    • For MS SQL:

      alter table zInstallationPackage alter column Platform nvarchar(255);
      
  3. From the Primary Server’s console prompt, run the following command:

    novell-zenworks-configure -c ZoneConfigUpdateConfigureAction

ZENworks Diagnostic Center reports a mismatch error in the database table structure

Source: ZENworks 11SP2; Upgrade.
Explanation: If your ZENworks 10 Configuration Management SP3 Primary Server resides in a zone configured to MS SQL Server database that was set up prior to ZENworks 10 Configuration Management SP2, you encounter the following error when you run the ZENworks Diagnostic Center Database Schema Verifier before upgrading the server to ZENworks 11SP2:
Mismatch in table 'zPolicyDef' structure. 
Object type: [Column] , Object name: [ComponentName 
Expected: [Name: ComponentName, Size: 64, Type: VARCHAR, Nullable: true]
Found: [Name: ComponentName, Size: 64, Type: VARCHAR, Nullable: false]
Possible Cause: The SQL sets contained in the database schema of a zone set up prior to ZENworks 10 Configuration Management SP2 are different from the SQL sets contained in the database schema of ZENworks Diagnostic Center.
Action: Before upgrading to ZENworks 11SP2, do the following from any one of the ZENworks 10 Configuration Management SP3 Primary Server residing in the zone configured to MS SQL Server database that was set up prior to ZENworks 10 Configuration Management SP2:
  1. Connect to the ZENworks database by using appropriate utility such as the Microsoft SQL Server Management Studio utility.

  2. Run the following query:

    alter table zPolicyDef alter column ComponentName nvarchar(64) null;
    

Back up of ZENworks Reporting Server reports using the zman command (zman rpsv) fails

Source: ZENworks 11SP2; Upgrade.
Explanation: To upgrade the ZENworks Reporting Server from ZENworks Configuration Management 10.3.0/10.3.1 to ZENworks 11SP2, you need to first back up all the reports. When you run the zman command (zman rpsv) to back up the reports and reports data, you receive an error.
Action: Before you upgrade from ZENworks Configuration Management 10.3.0/10.3.1 to ZENworks 11SP2 perform the following steps:
  1. Download and install the ZCM 10.3.0/10.3.1 - ZRS report backup patch. For more information about the patch, see TID 7007852 in the Novell Support Knowledgebase.

  2. Back up the reports and the reports data by running the zman report-save command.

    For more information about the zman command, see the Report Commands in the ZENworks 11 SP2 Command Line Utilities Reference.