Environment
Novell ZENworks Configuration Management 11.3
Situation
Soft Deleted objects never cleaned up on Sybase database. zman ql -t soft.deleted.objects.cleanup all show F Failed status.
ERROR (in loader-messages.log):
[Loader.SoftDeletedObjectsCleanupHandler] [org.hibernate.exception.DataException: ((Sybase()((JDBC Driver()((SQL Anywhere()Right truncation of string data
Resolution
This is fixed in version 11.4 - see KB 7016614 "ZENworks Configuration Management 11 SP4 (11.4.0) - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7016614
Workaround for prior versions: Contact ZENworks support for a workaround.
Additional Information
Troubleshooting: select * from zzendelete_log query and get loader-messages.* showing the errors.