Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Getting the error "java.sql.SQLException: Invalid object name 'STATION_NAME.dbo.sysobjects'." when attempting the convert a Cloudscape database to SQL 2005 in t...

Issue

Getting the following error when attempting the 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.

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
3 weeks ago
Updated by: