Environment

Situation

After ZENworks System Update, viewing the details of the devices in pending system update, or viewing the System Update details in ZCC throws an error. 

zcc.log:

[ZENServer] [34629] [zenworks] [ZCC] [UpdateDescription: error getting update] [javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1514)
com.novell.zenworks.datamodel.session.hibernate.SQLQueryAdapter.list(SQLQueryAdapter.java:103)
com.novell.zenworks.datamodel.services.systemupdate.SystemUpdateAdminImpl2.getActiveSupercedingUpdate(SystemUpdateAdminImpl2.java:1677)
com.novell.zenworks.datamodel.services.systemupdate.SystemUpdateAdminImpl2.getActiveSupercedingUpdate(SystemUpdateAdminImpl2.java:1687)
com.novell.zenworks.datamodel.services.systemupdate.SystemUpdateAdminImpl2.getUpdate(SystemUpdateAdminImpl2.java:1732)
com.novell.zenworks.datamodel.services.systemupdate.SystemUpdateAdminImpl2.getUpdate(SystemUpdateAdminImpl2.java:1658)

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
	
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 101

Cause