ZSD AMIE Import Fails when connecting to ZENworks MSSQL database

  • 7025040
  • 10-Mar-2021
  • 11-Mar-2021


Service Desk


Connecting ZSD AMIE integrations to a ZENworks database on the MSSQL platform, AMIE Import Fails.

ZENworks Zone: Micro_Focus-ZONE using a MSSQL database, connecting via ZSD AMIE Import Integration.


Special Character '-' (dash) is in the Zone Name and not a supported character for AMIE Integrations.


System Logs may show this error:
[2019-11-14 10:33:01,867]ERROR441750[LiveTimeScheduler_Worker-1] null(ZenworksAmieDbComms.java:311) - An error occurred whilst initializing Comms: Error while reading column meta data for `zenworks_Micro_Focus-ZONE`.dbo.NC_CPU
org.hibernate.exception.JDBCConnectionException: Error while reading column meta data for `zenworks_Micro_Focus-ZONE`.dbo.NC_CPU
Caused by: java.sql.SQLException: Database '`zenworks_Micro_Focus-ZONE`' does not exist. Make sure that the name is entered correctly.


Reported to Engineering

Additional Information

   Take a backup/snapshot of the files, system and database before any changes.
   Record what changes or customization was done in your Corporate ZSD Documentation.
   Some File modifications may not carry forward for the subsequent Side-By-Side upgrades.
   Referenced Documentation in Additional Information below.

Other References
Micro Focus ZENworks Service Desk v8.x Cookbook (TID 7023510)
Micro Focus ZENworks Service Desk v7.x Cookbook (TID 7021281)