ZSD AMIE Import Fails when connecting to ZENworks MSSQL database

  • Document ID:7025040
  • Creation Date:10-Mar-2021
  • Modified Date:11-Mar-2021
    • Micro Focus Products:
      Service Desk

Environment

Service Desk

Situation

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

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


Resolution

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

Cause

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.

Status

Reported to Engineering

Additional Information

Important:
   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)