We are in the process of upgrading a content database from SharePoint 2010 to 2013. I have resolved all initial errors from the Test-SPContentDatabase, but receive an error during mount which I cannot find any information on.

Error running SQL DDL Script:   IF EXISTS  (      SELECT 1       FROM mssqlrbs.rbs_columns AS rc       INNER JOIN sys.syscolumns A.... System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'mssqlrbs.rbs_columns'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPLog log)  ClientConnectionId:406b745a-7ff9-4abf-9a79-a1eddbea780bceadf807-1c73-4a0f-b3ee-ba5243b8aab5

Any help to resolve this would be greatly appreciated.

It looks like you've enabled RBS. Is that the case?

RBS was previously configured, but has since been removed. As far as I can tell it has been uninstalled correctly. In the content DB there are currently two tables remaining from the RBS setup, rbs_filestream_configuration and rbs_filestream_pools. 

The only possible information I could find on RBS and upgrade on technet is the following:

If you are using remote blog storage (RBS) in your environment, you must be running Service Pack 1 for SharePoint 2010 Products in your environment before you start the upgrade process.

The farm has the August 2012 cumulative update, so this shouldn't be a problem either.

I'm thinking you could likely just drop those tables (but what I would do is take a backup copy, drop the tables, then upgrade that backup copy).

That was my instinct as well, but I tried that today without any luck, it still fails with the same error. I am unable to find any more rbs remnants in the database.

as you already have a copy of the Database, i would try to remove the RBS one more time. follow the instruction from this blog for completely remove it from content db.

http://alipka.wordpress.com/2010/06/19/how-to-disable-rbs-in-sharepoint-2010/

"

Uninstall from add/remove SQL Remote Blob Storage.

I found that there were still filestream references in my DB, so run this on your content DB:

ALTER TABLE [mssqlrbs_filestream_data_1].[rbs_filestream_configuration] DROP column [filestream_value]

ALTER TABLE [mssqlrbs_filestream_data_1].[rbs_filestream_configuration] SET (FILESTREAM_ON = "NULL")

Now you can remove the file and filegroup for filestream:

ALTER DATABASE yourdbname Remove file RBSFilestreamFile;

ALTER DATABASE yourdbname REMOVE FILEGROUP RBSFilestreamProvider;"

once operation successful, try to upgrade again.

Thanks for the suggestions, but unfortunately I have not come closer to resolving this.

ALTER TABLE [mssqlrbs_filestream_data_1].[rbs_filestream_configuration] DROP column [filestream_value]

This column is already dropped.

ALTER TABLE [mssqlrbs_filestream_data_1].[rbs_filestream_configuration] SET (FILESTREAM_ON = "NULL")

This executed, but I believe it was already null.

ALTER DATABASE yourdbname Remove file RBSFilestreamFile;
ALTER DATABASE yourdbname REMOVE FILEGROUP RBSFilestreamProvider;

These do not exist.

what I am thinking, as RBS is not properly removed from DBs(even you follow the steps). As i am sure, you have a backup copy before deleting the table, i will make another copy and try to remove accordingly to the blog post and then will try to upgrade.

also if you like, share us the complete log trace during the upgrade.

Hi,

I am also convinced that RBS is not properly removed, but the steps from the blog post have not been of much help. Some of the rbs stored procedures do not exist, and neither does file and filegroup for filestream.

The problem I am facing that the SQL server on which RBS was initially installed and configured no longer exist. RBS was uninstalled prior to a migration to a dedicated SQL server, therefore it seems further cleaning up is not possible using the method of the blog post.

This is the error log from the upgrade:

12.20.2013 13:18:56.54 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPContentDatabaseSequence al2pi ERROR Error running SQL DDL Script:   IF EXISTS  (      SELECT 1       FROM mssqlrbs.rbs_columns AS rc       INNER JOIN sys.syscolumns A.... System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'mssqlrbs.rbs_columns'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPLog log)  ClientConnectionId:b3eda583-ee4f-428f-87f9-585d2e04fcc0 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:18:56.61 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPContentDatabaseSequence ajywk INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:18:56.61 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPContentDatabaseSequence ajywk ERROR Action 15.0.19.1 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed. 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:18:56.68 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPContentDatabaseSequence ajywk INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:18:56.68 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPContentDatabaseSequence ajywk ERROR Exception: Invalid object name 'mssqlrbs.rbs_columns'. 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:18:56.74 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPContentDatabaseSequence ajywk INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:18:56.74 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPContentDatabaseSequence ajywk ERROR   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPLog log)     at Microsoft.SharePoint.Upgrade.ShreddedStore.Upgrade()     at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrad 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:14.93 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:14.93 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR Upgrade [SPContentDatabase Name=] failed. 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.01 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.01 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR Inner Exception: Invalid object name 'mssqlrbs.rbs_columns'. 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.10 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.10 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPLog log)     at Microsoft.SharePoint.Upgrade.ShreddedStore.Upgrade()     at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrad 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.19 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.19 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR Exception: Action 15.0.19.1 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed. 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.30 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm INFO SPContentDatabase Name= 8aa0e052-274d-4f9c-9290-ff9730865c67
12.20.2013 13:19:15.30 powershell (0x295C) 0x3208 SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR   at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.Upgrade()     at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.Upgrade()     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecur 8aa0e052-274d-4f9c-9290-ff9730865c67