After updating ZCM to 10.2, SQLGrammarException error is seen in the ZCC

  • 7003456
  • 05-Jun-2009
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2

Situation

After updating ZCM to 10.2, the following error was seen in the ZCC when clicking on devices:
 
"Attempt to forward user to object details page failed.: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.novell.zenworks.datamodel.objects.Device#..."

Resolution

This problem is caused by the fact that in some cases the Database Schema was not properly updated during the 10.2 upgrade process.
TID#7003451 should be followed to reinstall the 10.2 update.
 
The updates to the database will only need be applied once and not performed for every Primary Server in the Zone.
If related issues persists after updating the database, proceed with additional steps for reapplying the update on any server that continues to exhibit related problems.