A.0 Troubleshooting ZENworks Reporting

The following sections provide solutions to the issues that you might encounter while using ZENworks Reporting:

An Exception Is Displayed While Creating Crosstab View

Explanation: While creating Crosstab ad-hoc view the following exception is displayed if the field object is of COLB datatype:

Error Msg = ORA-00932: inconsistent datatypes: expected - got CLOB

Possible Cause: This is a limitation observed only when you are using the Oracle database.
Action: None

Ad hoc chart reports are corrupted when exported in the CSV format

Source: ZENworks Reporting
Explanation: Since CSV supports only text format, a corrupt report is generated when an ad hoc chart report is exported in the CSV format.
Action: Export the ad hoc chart in any other format

While creating an Ad Hoc view with the Sample Data or Full Data feature it might take several minutes

Source: ZENworks Reporting.
Explanation: If you use the Sample Data or Full Data feature while creating an Ad Hoc View, for every addition of the field to the view (Column, Groups, and Filters) a database query is executed and it might take several minutes.
Action: Use the No Data feature, to create an Ad Hoc View for better performance. After designing the View, you can switch to Sample Data or Full Data feature to view the results as expected.

ZENworks scheduled report displays an error message

Source: ZENworks Reporting.
Explanation: Unable to send an email, if length of the message is more than 1000 characters.
Action: Increase the default length of a mailNotification.messageText in the security.properties file as follows:

  1. Go to the following path:

    • For Windows: %ZRS_HOME%\js\apache-tomcat\webapps\jasperserver-pro\WEB-INF\classes\esapi

    • For Linux: /opt/novell/zenworks-reporting/js/apache-tomcat/webapps/jasperserver-pro/WEB-INF/classes/espai

  2. Backup the security.properties file.

  3. Open the security.properties file.

  4. Search for mailNotification.messageText=AlphaDot,AlphaNumPunctuation,1000,true,mailNotification.messageText-ViewRepository_Schedule_OutputSettings_contextand replace with required value. After changing the default text value for example, 1000 to 5000, then from the next search specify with the changed value and search.

  5. Restart the ZENworks Reporting Services.

When you export a report in the RTF file format, the report might not work as expected

Source: ZENworks Reporting
Explanation: When you export a report in the RTF file format, the report might not be exported as expected.
Action: Use the PDF or Excel file formats to export a report.

Reports are not getting generated while upgrading ZENworks

Source: ZENworks Reporting
Explanation: After upgrading ZENworks, migration processes will be running in the background and if you execute a report at that time, then the report related to those particular table (for example, status related reports) will utilize 100% CPU and report will not be generated.
Action: Generate reports after completing data migration.

To check the data migration status, use the following queries:

  1. select data from zopaquedata where name= 'com.microfocus.contentsync.pending.records.created'

    if DATA = "TRUE"

  2. select data from zopaquedata where name= 'migrate.old.status.data.execution.status'

    if DATA = "S" If the queries are DATA = "TRUE" and DATA = "S" then data migration is successful.