Application Exception Error with ZENworks Import

  • 7023329
  • 05-Sep-2018
  • 06-Sep-2018

Environment

Service Desk 7.5 ZENworks Integration
ZENworks Configuration Management 2017 Update 3

Situation

Service Desk v7.5 attached to ZENworks 2017 Update 3 selecting Hardware link during the ZENworks Import resulting in and Application Exception Error.
  • Admin > Setup > Setup > ZENworks > ZENworks Import (tab)
  • Configure your ZENworks Server > Analyze
  • Select Hardware (tab)
  • Expand list and Select any Hardware link
Error Application Exception : QueryException: could not resolve property: ZDEVICE
And your session is logged out.



Resolution

Contact Micro Focus Customer Support for the FTF to fix this issue.

Cause

ZENworks Update 3 had some schema changes and was released after v7.5 was released.

Additional Information

Experienced only with the environment setup where Micro Focus Service Desk v7.5 is attached to ZENworks Configuration Management 2017 Update 3.

Application Exception Error:
Application Exception:
org.hibernate.QueryException: could not resolve property: ZDEVICE of: com.livetime.assetimport.NCWORKSTATION 
[select distinct new com.livetime.ui.ZenworksAMIEView(ncWorkstation.ZDEVICE.PROPZUID, ncWorkstation.PROPMACHINENAME, ncWorkstation
.PROPIPADDRESS, ncWorkstation.PROPOSPRODUCT) from com.livetime.assetimport.NCWORKSTATION ncWorkstation left
join ncWorkstation.ZDEVICE zDevice left join zDevice.ZZENOBJECT childObj left join childObj.ZZENOBJECT parentObj
where ncWorkstation.PROPMACHINENAME != 'Lost and Found' and ncWorkstation.PROPISDELETED is null and (parentObj.PROPZUID = :zuid)] could not resolve property: ZDEVICE of: com.livetime.assetimport.NCWORKSTATION [select distinct new com.livetime.
ui.ZenworksAMIEView(ncWorkstation.ZDEVICE.PROPZUID, ncWorkstation.PROPMACHINENAME, ncWorkstation.PROPIPADDRESS, ncWorkstation.PROPOSPRODUCT)
 from com.livetime.assetimport.NCWORKSTATION ncWorkstation left join ncWorkstation.ZDEVICE zDevice left join zDevice.ZZENOBJECT
childObj left join childObj.ZZENOBJECT parentObj where ncWorkstation.PROPMACHINENAME != 'Lost and Found' and ncWorkstation.PROPISDELETED
 is null and (parentObj.PROPZUID = :zuid)] Your session has ended. Please use the button below to login again.