Hello,

I will upgrade from ZCM11SP1a to ZCM11SP2 on SLES10SP3. The base is a
remote Sybase runing on her own server SLES10SP3.

From the primary server I run zdc_verifyDB from mounted cd
ZENworks11SP2.iso and I have one error in procedure getExcluded.

I have found in TID 7007204, that "this error can be can safely be
ignored when the report is from a ZCM 10.3.x appliance, or if the zone
is using an external Sybase database."

Is this true with ZCM 11.1?

Thank's

CM

************************************************** *****************************
[ERROR] [DBObjectComparer] Mismatch in Procedure 'getExcluded' structure!!!
Expected: [Name: getExcluded, Definition hash: a407265b]
Found : [Name: getExcluded, Definition hash: d82f265b]
[DEBUG] [DBObjectComparer] Additional Information:
create function -- gets the excluded status of a promotion test base
product. Presumably the local we create

should also have
-- the same status.
zenadmin.getExcluded(in @mfg nvarchar(35),in @productname
nvarchar(100),in @ver nvarchar(32),in @plat integer)
returns integer begin
declare @majorversion nvarchar(32);
declare @idx integer;
declare @excluded integer;
set @excluded=0;
-- get the major version number, used to search for CTP's of
promotion test base products
-- it is possible to have a version w/out a '.' for example some
Microsoft applications will
-- have the year (2000, 2002, etc.)
set @idx=CHARINDEX('.',@ver);
if @idx <> 0 then
set @majorversion=SUBSTRING(@ver,1,(@idx-1));
-- Look for the base product. Possabilites for the version number
are X, X. or -
-- TOP 1 is used because there may be more than one row returned
if @plat in( 1,2,3,4,5,6,8,10,11,14) then
select top 1 Excluded into @excluded from LC_TallyProduct
where Manufacturer = @mfg and Product = @productname and
Platform in( 1,2,3,4,5,6,8,10,11,14)
and Version in( @majorversion,@majorversion+'.','-') order by
Version asc
else
select top 1 Excluded into @excluded from LC_TallyProduct
where Manufacturer = @mfg and Product = @productname and
Platform = @plat
and Version in( @majorversion,@majorversion+'.','-') order by
Version asc
end if;
if @excluded is null then
set @excluded=0
end if
end if;
return @excluded
end
................
.................

[ERROR] [ProcedureHelper]
[!] 1 error(s) found while verifying database Procedures
[INFO ] [DBVerifier]
+ ZCM Database metadata verification complete.
[INFO ] [ReportManager]
+ Reports have been saved in
'/var/opt/novell/log/zenworks/zdcreports/20130111_152439'.
[INFO ] [DiagnoseZen]
+ System verification complete.
[DEBUG] [DiagnoseZen] ZDC finished at 2013.01.11 AD at 15:24:49 CET
************************************************** ****************************