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' )
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' )