Predefined reports may timeout

Document ID:7007606
Creation Date:19-Jan-2011
Modified Date:27-Apr-2012
- Micro Focus Products:
  ZENworks Configuration Management

Environment

Novell ZENworks 10 Configuration Management

Situation

Note: This TID does not apply to ZENworks 11.

Some ZRS predefined reports may timeout in large environments.

ERROR:

'No data to retrieve in Query 1'

Resolution

Several reports of this problem have been seen for the 'Bundle Deployment Status' Report. Workaround is below. For other reports, contact Novell Technical Support to determine whether a workaround can be produced.

Workaround for 'Bundle Deployment Status' Report:

Copy the 'Bundle Deployment Status' Report into custom reports for editing.
Select the following in Infoview preferences: Preferences > Web Intelligence > Select a default creation/editing tool > Advanced (Java 2 required) and save the preferences.
Inside 'Custom Report' folder, right click the newly copied 'Bundle Deployment Status' report and select Modify.
Click on 'Edit Query' button, then SQL button.
Click on 'Use custom SQL' radio button, delete the query that appears in the window, copy the new query given below.
Click on Validate button to validate the syntax and the save the query.
Run the Report and save if it runs sucessfully.

Note: This will not populate any data in 'Failure Event ID' and 'Failure Message' columns of the report, but rest of the columns should have the correct data.

SELECT
DerivedBnPConsumerTable.Name,
DerivedBnPConsumerTable.Path,
DerivedzBundle.Name,
DerivedzBundle.Path,
case when DerivedzBundle.SubType='Preboot Bundle' then 'Imaging Bundle' when
DerivedzBundle.SubType='File Bundle' then 'File Bundle' when
DerivedzBundle.SubType='Directive Bundle' then 'Directive Bundle' when
DerivedzBundle.SubType='Windows Bundle' then 'Windows Bundle' else
cast(DerivedzBundle.SubType as char(50)) end,
DerivedzBundle.Version,
zObjectInfo1.LastSuccessfulExecutionTime,
formatDeploymentStatus(zObjectInfo1.status) as status,
'',''
FROM
(
   select
   DeviceParentFolders.anc, ZOG.*
   from
   (
      select
      zGroupings.groupUID, ZO.*
      from
      (
         select
         zZenObject.*
         from zZenObject
         where zZenObject.PrimaryType='Device' OR
zZenObject.PrimaryType='External Reference'
      )
      ZO
      left outer join zGroupings on zGroupings.memberUID=ZO.ZUID
   )
   ZOG
   left outer join DeviceParentFolders on ZOG.ZUID=DeviceParentFolders.ZUID
)
DerivedBnPConsumerTable
INNER JOIN zAssignment zAssignment1 ON
(
   (
       zAssignment1.ConsumerUID=DerivedBnPConsumerTable.groupUID OR
zAssignment1.ConsumerUID=DerivedBnPConsumerTable.ZUID OR
zAssignment1.ConsumerUID=DerivedBnPConsumerTable.anc
   )
)
RIGHT OUTER JOIN
(
   select
   BG.groupUID, ZB.*, ZACO.Version, ZACO.Platform, ZACO.IsEnabled
   from zGroupings BG
   right outer join
   (
      select
      zZENObject.*
      from zZENObject
      where zZENObject.PrimaryType='Bundle' OR zZENObject.PrimaryType='Policy'
   )
   ZB ON ZB.ZUID=BG.memberUID
   left outer join zAssignableContentObject ZACO on ZB.ZUID=ZACO.ZUID
)
DerivedzZENObjectContent ON
(
   (
      zAssignment1.ContentUID=DerivedzZENObjectContent.ZUID OR
zAssignment1.ContentUID=DerivedzZENObjectContent.groupUID
   )
)
INNER JOIN zObjectInfo zObjectInfo1 ON
(
   zObjectInfo1.objectUID=DerivedzZENObjectContent.ZUID
)
INNER JOIN
(
   select
   BG.groupUID, ZB.*, ZACO.Version, ZACO.Platform, ZACO.IsEnabled
   from zGroupings BG
   right outer join
   (
      select
      zZENObject.*,
      zBundle.DisplayName,
      zBundle.CreationDate,
      zBundle.Category,
      zBundle.Data
      from zBundle, zZENObject
      where zZENObject.ZUID=zBundle.ZUID
      AND zZENObject.Path LIKE '/~bundles~/%'
   )
   ZB ON ZB.ZUID=BG.memberUID
   left outer join zAssignableContentObject ZACO on ZB.ZUID=ZACO.ZUID
)
DerivedzBundle ON (DerivedzZENObjectContent.ZUID=DerivedzBundle.ZUID)
WHERE ( DerivedBnPConsumerTable.ZUID=zObjectInfo1.targetDeviceUID )
AND DerivedBnPConsumerTable.Name <> 'null'

Status

Reported to Engineering