SCCM vNext 1511 SQL Error - Invalid object name 'sys.availability_replicas'.

[pembertj]

Update went pretty smoothly for us, but I am seeing this error pop up many times in the logs and haven't found much online...

any ideas?

Component:

SMS_HIERARCHY_MANAGER

Microsoft SQL Server reported SQL message 208, severity 16: [42S02][208][Microsoft]

[sql Server]Invalid object name 'sys.availability_replicas'.

Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

Thanks

[pembertj]

For those that are curious...

I put a ticket in to Microsoft to see what was up with that error. They said it is coming up because it has to do with SQL Clustering that only exists in SQL 2012 and newer (We are on SQL 2008 R2).

They said they are working on a fix and/or upgrading to SQL Server 2012 would fix the error

Microsoft: "the view was not created and so that is why it is erroring".

[anyweb]

good info, i wonder if you do an in-place upgrade of SQL Server will it remove the error, backup the DB first !

[freeman]

Hello,

 

any news? Is a fix out now?

 

 

Thanks