Getting ready for a Teamcity upgrade and backing up our data using the UI backup, I get this error. SQL exception: Invalid object name 'trace_xe_action_map'.

Getting ready for a Teamcity upgrade and backing up our data using the UI backup, I get this error. SQL exception: Invalid object name 'trace_xe_action_map'.

 

  failed

UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Querying for a single value SQL query: select count(*) from trace_xe_action_map SQL exception: Invalid object name 'trace_xe_action_map'.
    caused by SQLException: Invalid object name 'trace_xe_action_map'.

 

The teamcity instance is running properly so not sure why this is coming up

 There is a table named   sys.trace_xe_action_map

0
3 comments

What database system are you using?

0
Avatar
Permanently deleted user

Microsoft SQL Server 2014

0
Avatar
Permanently deleted user

I ran across this as well in the upgrade process when trying to backup the data using maintainDB.sh.

 

 

[teamcity@TEAMCITY01 bin]$ ./maintainDB.sh backup
../webapps/ROOT/WEB-INF/lib
TeamCity maintenance tool. Copyright 2011 JetBrains s.r.o. All Rights Reserved.

Command line arguments: backup
Using TeamCity data directory: /data/teamcity
Using database settings from the TeamCity data directory for source database: /data/teamcity/config/database.properties
Using source database
        database type: MSSQL
        database driver: <not specified>
        connection: jdbc:jtds:sqlserver://sqlserver:55405/TeamCity
        login as: TeamCity
Software metadata version: 2
Source database metadata version: 2
Software schema version: 514
Source database schema version: 514
Connected to the Source DB successfully.
Saving backup to file: /data/teamcity/backup/TeamCity_Backup_20180327_125650.zip
Starting backup
Initializing...
Will export all builds.
Listing tables...
Unexpected exception SQLException: SQL error when doing: Querying for a single value
SQL query: select count(*) from trace_xe_action_map
SQL exception: Invalid object name 'trace_xe_action_map'.
jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Querying for a single value
SQL query: select count(*) from trace_xe_action_map
SQL exception: Invalid object name 'trace_xe_action_map'.
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2886)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2328)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:943)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
        at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:453)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:979)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at jetbrains.buildServer.serverSide.db.DBFunctions.executeQuery(DBFunctions.java:486)
        at jetbrains.buildServer.serverSide.db.DBFunctions.queryForSingleValue(DBFunctions.java:436)
        at jetbrains.buildServer.serverSide.db.DBFunctions.queryForSingleInt(DBFunctions.java:309)
        at jetbrains.buildServer.serverSide.db.DatabaseUtil.countTableRows(DatabaseUtil.java:1130)
        at jetbrains.buildServer.serverSide.db.DatabaseUtil$3.apply(DatabaseUtil.java:1112)
        at jetbrains.buildServer.serverSide.db.DatabaseUtil$3.apply(DatabaseUtil.java:1109)
        at jetbrains.buildServer.serverSide.db.DBFunctions.withDB(DBFunctions.java:2269)
        at jetbrains.buildServer.serverSide.db.DatabaseUtil.countTableRows(DatabaseUtil.java:1109)
        at jetbrains.buildServer.serverSide.db.DatabaseUtil.countTablesRows(DatabaseUtil.java:1179)
        at jetbrains.buildServer.serverSide.db.DatabaseUtil.estimateTablesRows(DatabaseUtil.java:1153)
        at jetbrains.buildServer.serverSide.maintenance.BackupProcessor.estimateTableRows(BackupProcessor.java:342)
        at jetbrains.buildServer.serverSide.maintenance.BackupProcessor.perfromBackup(BackupProcessor.java:262)
        at jetbrains.buildServer.serverSide.maintenance.BackupProcessor.access$000(BackupProcessor.java:45)
        at jetbrains.buildServer.serverSide.maintenance.BackupProcessor$1.run(BackupProcessor.java:213)
        at jetbrains.buildServer.serverSide.maintenance.BackupProcessor$1.run(BackupProcessor.java:206)
        at jetbrains.buildServer.serverSide.db.DBFacade.withDB(DBFacade.java:324)
        at jetbrains.buildServer.serverSide.maintenance.BackupProcessor.runProcessWithDatabaseAndFiles(BackupProcessor.java:206)
        at jetbrains.buildServer.serverSide.maintenance.BackupProcessor.runProcess(BackupProcessor.java:168)
        at jetbrains.buildServer.serverSide.maintenance.AbstractMaintenanceProcess.run(AbstractMaintenanceProcess.java:152)
        at jetbrains.buildServer.serverSide.maintenance.MaintenanceProcessManagerImpl$ProcessProxy.run(MaintenanceProcessManagerImpl.java:159)
        at java.lang.Thread.run(Thread.java:701)
Caused by: java.sql.SQLException: Invalid object name 'trace_xe_action_map'.
        ... 32 more
Cannot proceed with 'backup' command: Backup failed.
Error: jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Querying for a single value
SQL query: select count(*) from trace_xe_action_map
SQL exception: Invalid object name 'trace_xe_action_map'.
Critical error has occurred during command execution.

 

 

 

 

I am getting ready to upgrade from v 7.0.3 to the latest and I am worried this error will come out and bite us.

Again,  There is a table named   sys.trace_xe_action_map

Any ideas?

0

Please sign in to leave a comment.