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]
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