EntropyZero Blogging Server

Welcome to EntropyZero Blogging Server Sign in | Join | Help
in Search

Datafresh - Invalid object name exception

Last post 05-16-2007, 9:47 AM by Anonymous. 0 replies.
Sort Posts: Previous Next
  •  05-16-2007, 9:47 AM 201

    Datafresh - Invalid object name exception

    Hi guys,

    I'm getting the following error when trying to call the PrepareDatabaseforDataFresh method (also get the error when trying to use the console):

     System.Data.SqlClient.SqlException: Invalid object name 'email_email304cannosis_exp'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at DataFresh.SqlDataFresh.ExecuteNonQuery(String sql)
       at DataFresh.SqlDataFresh.PrepareDatabaseforDataFresh(Boolean createSnapshot)
       at DataFresh.SqlDataFresh.PrepareDatabaseforDataFresh()

     I assume ths is due to the table name being too long? There are many long table names in the system being tested and I am unable to change the table names. Is there a fix available for this?

     Cheers,

    Dale

    Filed under:
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems