Link to home
Start Free TrialLog in
Avatar of Andrew Cleaver
Andrew Cleaver

asked on

Sharepoint 2013 foundation server 500 Internal server error

Hi

Every since we had an issue with our SQL server getting larger than 10gb we have had the problem that we can no longer connect to the data volume on the foundation server - the SQL server has been upgraded to Std edition and is loading, how ever the sharepoint sites are reporting 500 internale server error, the event log is showing a number of errors the most frequent is.

The Execute method of job definition Microsoft.SharePoint.Administration.SPStorageMetricsProcessingJobDefinition (ID 91d71906-1e19-46b5-8b14-d87e44155e2c) threw an exception. More information is included below.

Invalid object name 'TVF_Sites_IdGEQ'.

In conjunction with database error

Unknown SQL Exception 208 occurred. Additional error information from SQL Server is included below.

Invalid object name 'TVF_Sites_NoLock_Id'.

Does anyone have any ideas on what is going wrong ?
Avatar of Manju
Manju
Flag of India image

The upgrade process should have kept the SQL role on the SharePoint Server intact. However, if you had upgraded from express edition, you need toc reate a new Database server and move the databases into new.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.