The specified schema name "ReadTrace" either does not exist

May 18, 2011 at 8:54 AM

Hi,

I have downloaded the SQLNexus3.0.0.0" and using this with SQL 2008 R2 . while I am trying to import the trace logs getting the below error in log file.If any body having idea regarding this, kindly update.

SQLNexus Information: 0 : Import failed. (0 sec, 0 rows inserted)
    DateTime=2011-05-18T07:21:38.1462181Z
SQLNexus Information: 0 : Executing post-mortem analysis scripts...
    DateTime=2011-05-18T07:21:38.1492181Z
SQLNexus Information: 0 : Executing ReadTracePostProcessing.sql...
    DateTime=2011-05-18T07:21:38.1532181Z
SQLNexus Information: 0 : db name = sqlnexus
   DateTime=2011-05-18T07:21:38.1552181Z

SQLNexus Error: 0 : System.Data.SqlClient.SqlException: The specified schema name "ReadTrace" either does not exist or you do not have permission to use it.
   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 NexusInterfaces.CSql.ExecuteBatches(String[] batches) in C:\temp\nexus\sqlnexus_codeplex\NexusInterfaces\CSql.cs:line 102
System.Data.SqlClient.SqlException: The specified schema name "ReadTrace" either does not exist or you do not have permission to use it.
   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 NexusInterfaces.CSql.ExecuteBatches(String[] batches) in C:\temp\nexus\sqlnexus_codeplex\NexusInterfaces\CSql.cs:line 102
System.Data.SqlClient.SqlException: The specified schema name "ReadTrace" either does not exist or you do not have permission to use it.
   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)

Coordinator
May 18, 2011 at 7:10 PM

What is your version of ReadTrace? If you are below the version mentioned in http://blogs.msdn.com/b/psssql/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx, then please upgrade to the version mentioned in the blog. And then try the import again.

May 19, 2011 at 4:52 AM

@amitban thanks for the solution.