Environment
Novell Service Desk 7.0.3 AMIE
Novell Service Desk 7.1 AMIE
Microsoft SQL Server
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".