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'.
The teamcity instance is running properly so not sure why this is coming up There is a table named sys.trace_xe_action_map |
Please sign in to leave a comment.
What database system are you using?
Microsoft SQL Server 2014
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?