AMIE import fails when importing software from ZENworks 11.3 Database

  • 7014966
  • 25-Apr-2014
  • 30-Apr-2014

Environment

Novell Service Desk 7.0, 7.0.1 and 7.0.2

Situation

AMIE import fails when importing assets from ZENworks 11.3 Database. ZENworks 11.3 schema is not compatible to existing Novell Service Desk AMIE drivers.

In the NSD Webconsole incorrect values in Item Details will be seen, and in some cases the below error is seen in the log file.

Error :

[2014-02-21 18:12:34,924]ERROR124644[LiveTimeScheduler_Worker-5] (DataSet.java:579) - An error occurred whilst fetching page 0 org.hibernate.QueryException: could not resolve property: PROPCOMPONENTOID of: com.livetime.assetimport.NCCOMPONENT [SELECT software.PROPCOMPONENTOID FROM com.livetime.assetimport.NCCOMPONENT software where software.PROPPRODUCTTYPE = 21 and software.PROPISDELETED is null ORDER BY software.PROPCOMPONENTOID ASC]

Resolution

Upgrade the environment to Novell Service Desk 7.0.3