Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQLException 0x80131904 Invalid Object Name

質問 SQLException 0x80131904 Invalid Object Name

  • Thursday, February 23, 2012 1:08 AM
     
      Has Code
    Sign In to Vote
    0

    I'm getting the error below and run out of things to check.  I'm migrating from DEV -> STAGE and recreated the database using SSMS.  I verified the permissions are the same between DEV and STAGE and I can access (select and insert) into various tables but when I try to access one I get the error below.  I've verified the table exists and has the same permissions.  I've verified it's getting written to from a previous process.  I'm not sure where else to look, any ideas?

    Server Error in '/SiteShutdown' Application.

    Invalid object name 'WSSO.dbo.CHANGEDETAILS'.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'WSSO.dbo.CHANGEDETAILS'.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace: 

    [SqlException (0x80131904): Invalid object name 'WSSO.dbo.CHANGEDETAILS'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2054990
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5042332
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +144
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +166
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +115
   SiteShutdown.DataSet1TableAdapters.ChangeInfoTableAdapter.GetData(String CN) in C:\Documents and Settings\slippi\my documents\visual studio 2010\Projects\SiteShutdown\SiteShutdown\DataSet1.Designer.cs:7425
   SiteShutdown.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Documents and Settings\slippi\my documents\visual studio 2010\Projects\SiteShutdown\SiteShutdown\Run.aspx.cs:50
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.225

     

All Replies

  • Thursday, February 23, 2012 1:10 AM
     
     
    Sign In to Vote
    0
    I should also note searching this site and google yielded no answers.
     
  • Monday, February 27, 2012 6:41 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    I hope you will excuse me for my late reply.

    Please, could tell us what is wsso ? ( a database )

    dbo is well-known ( default owner of the object changedetails )

    changedetails : what is it ? ( a table,a stored procedure, a trigger, a function ?)

    Please, could you provide the Transact-SQL statement using wsso.dbo.changedetails ? or the code around the SqlCommand and the SqlDataReader ?

    We are waiting for your feedback to try to help you more efficiently

    Have a nice day

    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.