Issue
The following error asserts when attempting to convert a Cloudscape database to SQL 2005 in the Niagara R2 console window:
java.sql.SQLException: Invalid object name STATION_NAME.dbo.sysobjects'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at tridium.util.MSSqlServer.doesTableExist(MSSqlServer.java:341)
at tridium.util.MSSqlServer.checkTableWithKey(MSSqlServer.java:316)
at tridium.datax.sql.DxSqlUtil.checkTableWithKey(DxSqlUtil.java:190)
at tridium.datax.sql.DxSqlUtil.checkTable(DxSqlUtil.java:173)
at tridium.tools.DbAdmin.migrateData(DbAdmin.java:1007)
at tridium.tools.DbAdmin.main(DbAdmin.java:198)
at tridium.tools.DbAdmin.main(DbAdmin.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at tridium.nre.Nre.mainImpl(Nre.java:663)
at tridium.nre.Nre.main(Nre.java:603)
Environment
- Niagara R2
- WorkPlace Pro version 529 and higher
- Windows SQL 2005
Cause
The Enterprise Server and SQL 2005 database names do not match. The Enterprise Server and SQL 2005 database names have to be the same when migrating the Cloudscape database to a SQL 2005 database.
Resolution
Rename either the Enterprise Server station or SQL Server database so that the names are the same. Once the names are the same, the migration should go without issues.
