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.
[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 EngineeringAdditional 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.Referenced in the ZSD Customization Cookbook - TID 7025033
Other References
Micro Focus ZENworks Service Desk v8.x Cookbook (TID 7023510)
Micro Focus ZENworks Service Desk v7.x Cookbook (TID 7021281)