The following sections provide solutions to the problems you might encounter to ZENworks 11 SP2:
ZENworks Diagnostic Center reports database schema mismatch error
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.
Connect to the ZENworks database by using appropriate utility.
For example, use the DBISQL utility to connect to the external Sybase database:
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.
Enter dbisql.
In the
tab, specify the database credentials.Click the
tab, then specify the name of database service that is currently running.Click
.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);
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
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]
Connect to the ZENworks database by using appropriate utility such as the Microsoft SQL Server Management Studio utility.
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
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.
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.