Application Exception Error with ZENworks Import

  • Document ID:7023329
  • Creation Date:05-Sep-2018
  • Modified Date:02-Dec-2019
    • Micro Focus Products:
      Service Desk

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
This same error is also seen when running the ZENworks import without making any changes to it.
Error Application Exception : QueryException: could not resolve property: ZDEVICE
And your session is logged out.



Resolution

This issue is fixed in ZENworks Service Desk 8.0.

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.