Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Show Filter Choice : Render Failed

  Asked By: Dianna    Date: May 14    Category: Sharepoint    Views: 2890

I have a large list and item created into subfolder. Total item count is more than 9500 and also crossed 2000 inside some of sub folders.

Some of our users get error when they trying to Filer out on any column though it was working 3 days back.

When end user click "Show Filter Choice" it gives error i.e "<Render Failed>". I have examine Event Viewer where captures many errors related to database error (Unknown SQL Exception 1087 occured. Additional error information from SQL Server is included below.

Must declare the table variable "@_scopeTbl".
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.).

Surprisingly system account is still able to filter any views on any column.

Please provide solution ...I am really frustrated..

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Tonia Franco     Answered On: May 14

I saved my life by installing on hotfix: hotfix 957691 ...

 
Didn't find what you were looking for? Find more on Show Filter Choice : Render Failed Or get search suggestion and latest updates.




Tagged: