AMIE Import fails with: "Item import failed An error occurred whilst reverse engineering the remote schema"

  • 7016939
  • 22-Oct-2015
  • 22-Oct-2015

Environment

Novell Service Desk 7.0.3 AMIE
Novell Service Desk 7.1 AMIE
Microsoft SQL Server

Situation

  • AMIE import fails with an error about database connection
  • Connecting to a Microsoft SQL Server database
  • Database connection test is successful
  • Database name has a hyphen in it like '-'
    ex: This would happen with ZENworks database name of "ZCM-DB"

The following error could be seen in the AMIE import report:

ERROR:
Item import failed An error occurred whilst reverse engineering the remote schema Check the database connection details, and refer to the log file for further information

The following or similar could be seen in the LiveTime.log for version 7.0.3:

ERROR:
(DynamicDbComms.java:300) - An error occurred whilst initializing Comms: Error while reading column meta data for `ZCM-DB`.dbo.LC_TallyProdReconcileMap
org.hibernate.exception.JDBCConnectionException: Error while reading column meta data for `ZCM-DB`.dbo.LC_TallyProdReconcileMap
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99)
...
Caused by: java.sql.SQLException: Database '`ZCM-DB`' does not exist. Make sure that the name is entered correctly.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)


The following or similar could be seen in the LiveTime.log for version 7.1:

ERROR:
(DynamicDbComms.java:303) - An error occurred whilst initializing Comms: Error while reading column meta data for `ZCM-DB`.dbo.NC_CPU
org.hibernate.exception.JDBCConnectionException: Error while reading column meta data for `ZCM-DB`.dbo.NC_CPU
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99)
...
Caused by: java.sql.SQLException: Database '`ZCM-DB`' does not exist. Make sure that the name is entered correctly.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

Cause

The AMIE source database has a hyphen in the name such as: "ZCM-DB".

Status

Reported to Engineering