ZRS error "Not a Valid Month" with Oracle

  • 7006784
  • 03-Sep-2010
  • 30-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Business Objects Reporting

Situation

After creating a custom report with a filter on date, ZRS installed for Oracle database fails.
 
ERROR (In InfoView report):
 
ORA-01843: Not a valid month (WIS 10901)
 
 

Resolution

For ZENworks 10.3.x:  This is fixed in version 10.3.3 - see KB 7007641 "ZENworks Configuration Management 10.3.3 - update information and list of fixes" which can be found at https://www.novell.com/support
 
For ZENworks 11:  Reported to Engineering.
 
Workaround:
 
Modify the SQL by "View SQL "  Then select "Use Custom SQL "
Use the to_date function for any hard coded date query.
 
For example (note bold):
 
SELECT
  zDevice1.Hostname,
  zDevice1.LastContact
FROM
  zDevice  zDevice1 INNER JOIN zZENObject  zZENObject1 ON (zDevice1.ZUID=zZENObject1.ZUID)
 
WHERE
( zZENObject1.ZUID=zDevice1.ZUID and zZENObject1.Path like '/~dev%'   )
  AND 
  zDevice1.LastContact  In  to_date ( '03-09-2010 00:00:00'  )

Status

Reported to Engineering