SQL Server based on problem tracking database
Bugzero one-for-all problem tracking database
 
Q: SQL Server error when upgrading:

   java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'bugzero_db.dbo.UpdateLog'.
        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
        at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
        at com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown Source)
        .............

A: The error is caused by the system created UpdateLog table.
   If you changed the user for the bugzero_db database, you might also need change the owner of this table.

* Reference brought to you by Bugzero, it's more than just bug tracking software!

Home - FAQs