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

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


Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2


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#..."


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.