Archive for the 'SharePoint Errors' Category

13
Apr
16

unable to cast object of type microsoft.sharepoint.webcontrols.splinkbutton

By Russell Wright Leave a Comment
Categories: SharePoint Errors

Been a long time since the last post…at least it feels like it.

Just finished troubleshooting an issue where a default page wouldn’t load.  The correlation ID pointed to an Unexpected error in the SharePoint ULS logs stating:

unable to cast object of type microsoft.sharepoint.webcontrols.splinkbutton

The site settings page would load (modifying the URL manually) as would View All Site Content.  However, clicking on any of the lists or libraries would throw the error.  We initially thought this was an issue with the default.aspx page getting corrupted, as we could create a new blank web part page in SPD, place it in the root of the web, and it would load up okay. 

What fixed this:  IISRESET!

Again, the same lesson learned, all over again.

SharePoint troubleshooting steps:

  1. IISRESET
  2. Everything else
Advertisement
28
Feb
16

Web.config File Updating Automatically Every Night at 12:00 Midnight SharePoint 2013

By Russell Wright Leave a Comment
Categories: SharePoint Errors

We have a situation where we created a couple of SharePoint farms, QA and Production, that had some customized FBA implementations and implemented reversible encryption for the passwords.  Since the passwords are coming from a legacy system, we had to come up with a way to encrypt them and make them “decryptable” within SharePoint.  We were successful in doing this, but ended up having a couple of issues in production that would not allow users to log in.  Basically, their passwords were not being decrypted correctly.

This all begins in the <machineKey> section of the web.config.  The decryptionKey is used during the decryption process and, since this had to be supported across multiple machines, we made these sections the same across multiple machines and farms.  In fact, we had to use this on our legacy system so we could successfully encrypt and transfer the passwords from the AS400 (yes, mainframe).  This is what a <machineKey> section looks like.

<machineKey validationKey="8C3B5469A19FA84540F9B9E353679822934EF13EA0C26887B2AD4A6CA139BBBB" decryptionKey="634A6FD0D98D0A254D5E54F9D35287244C9DEB23A029BCAEA1C4FE21874C63AF" validation="HMACSHA256" />

When SharePoint is installed, it records some of the portions of the web.config file in the SharePoint configuration database.  These are located in the Objects table.

image

Allen Wang had a good blog post on the issue:  http://blogs.msdn.com/b/allenwang/archive/2012/03/23/sharepoint-2010-health-analyser-timer-job-changed-custom-web-config-machine-key.aspx.  Here he identifies how to find the keys in the Objects table.  Here is a select statement with a part of the offending decryption key in the WHERE clause. 

image

This returns exactly one record.  Copy and paste it in something like Notepad++ so you can see it more easily.

image

Apply some XML formatting to more easily wade through the XML.  Here you’ll find m_ViewStateValidationKey and m_ViewStateDecryptionKey that correspond to the validationKey and decryptionKey in the <machine.config>

image

These were initially set when SharePoint was installed and, to my knowledge, there is not a “supported” way to change them in the config database.  Of course, any of us could change these in the database, but if you do make a good backup in case you need to put it back!

I can reason through why they do this.  Since the view state data is being encrypted/decrypted and there could be multiple WFEs, you certainly don’t want these values to be different across WFEs, lest your requests bounce across WFEs, as different values would yield different results, i.e. reading the view state would break.  That would be a mess.  So, they created a Health Analyzer rule to insure these values remain the same across WFEs.  Health Analyzer rules are viewed within the Monitoring section of SCA.

image

Here is the rule in the Health Analyzer.  Web.config files are not identical on all machines in the farm.  You can see I have already disabled this rule. 

image

I actually disabled this rule using the PowerShell command.  Here the rule name is ViewStateKeysAreOutOfSync. 

Add-PSSnapin microsoft.sharepoint.powershell
Get-SPHealthAnalysisRule ViewStateKeysAreOutOfSync | Disable-SPHealthAnalysisRule

Here you can see the relationship between the Name of the rule and the Summary of the rule from the PowerShell command, Get-SPHealthAnalysisRule ViewStateKeysAreOutOfSync.

image

Now, most of the solutions to this issue I’ve read employ PowerShell to disable this Health Analyzer rule, as shown previously.  However, you can also manage rules in the web interface.  The rules are in a SharePoint list, so simply click on the rule and edit it.

image

Here you can see there is another setting, Repair Automatically.  This is likely the culprit that is changing the web.config.  A Health Analyzer rule can be set to report the issue and/or attempt to repair the issue.  So, instead of disabling the rule completely, you can simply stop it from attempting to repair the issue.

image

 

References:

http://blogs.technet.com/b/sushrao/archive/2013/01/29/sharepoint-2013-machinekey-configuration-net-4-0-conflicting-with-web-config-configuration.aspx

http://blogs.msdn.com/b/mutaz/archive/2012/05/30/keep-your-own-machinekey-values-in-sharepoint-2010-web-config.aspx

https://technet.microsoft.com/en-us/library/gg982996.aspx

https://technet.microsoft.com/en-us/library/ee663484.aspx

http://thesharepointfarm.com/2014/02/what-is-the-sharepoint-configuration-cache/

10
Jan
16

An error has Occurred with the Data Fetch. Please refresh the page and retry.

By Russell Wright 7 Comments
Categories: SharePoint Errors

An error has occurred with the data fetch.  Please refresh the page and retry.

I’ve seen this error multiple times with SharePoint 2013.  Seems like one time in the past it was related to some updates that needed to be installed on the server to fix the problem.  Most recently, I was working on one of our 2012 servers and this popped up again while attempting to access the site settings icon (you know, the "gear" icon).

image

 

image

I did some more searching and came upon a fix that worked for me.

https://social.msdn.microsoft.com/Forums/sharepoint/en-US/47b874ac-abc4-47a6-b7b7-939edee8d8b2/error-on-site-actions-menu

In Sharepoint 2013 integrated SSRS 2012, on clicking on action in IE 10 some users were getting error:
an error has occurred with the data fetch. please refresh the page and retry.

On doing F12 we saw:
SCRIPT3: The system cannot find the path specified.
core.js, line 1 character 6957

On unchecking Tools => Internet options => Advanced => “Enable DOM storage” settings, it starts working.

  • Proposed as answer by SaurabhMathur Monday, August 31, 2015 4:05 AM

Monday, August 31, 2015 4:04 AM

So I gave it a try.  Go into Internet Options, select the Advanced tab and scroll down under Security and you’ll find "Enable DOM Storage."  Uncheck it.

image

And voila’!  It works for me!

image

Funny thing is, my Windows 7 machine has "Enable DOM Storage" checked, and it works fine.  So it must be something about the Windows Server and some update that is or is not installed.  I’ll update our server and see what happens next.

27
Oct
15

403 Forbidden Error on Custom FBA Login Page

By Russell Wright Leave a Comment
Categories: SharePoint Customization and SharePoint Errors

We wrote a custom FBA login page and had it working in our QA system and were in the process of setting it up in our production system when we encountered a "403 Forbidden" error.  The page was written as a modification to the FBA pack on CodePlex and thus was located in the /15/template/layouts/FBA/OurCustomFolder directory.  After struggling with this for quite some time we finally realized we had set anonymous access on the site permissions in QA to "lists and libraries" (for another reason) and had not made that same change to production.

image

Making this change fixed our "forbidden" error. 

Interestingly, when using the out-of-the-box FBA login page, there was no issue.

22
Aug
14

SharePoint 2013: The server was unable to save the form at this time. Please try again.

By Russell Wright Leave a Comment
Categories: SharePoint Errors and SharePoint Infrastructure

I got this message, “The server was unable to save the form at this time. Please try again.” when trying to create a folder on a document library.  A quick search found this article where I found that restarting the "Sharepoint Search Hosting Controller" service fixed the problem.  That was weird!

image

19
May
14

Create MS Access View Missing after Installing Hotfix KB2553170

By Russell Wright Leave a Comment
Categories: SharePoint Designer, SharePoint Errors and SharePoint/Office Integration

Windows 7 SP1, Office 2010, accessing SharePoint 2013 on both Office 365 and on-premises.

You might find you have an issue when attempting to create an Access view from SharePoint 2013.  In this case I was getting an error when I clicked on Access View, "Export to database failed. To export a list, you must have a Microsoft SharePoint Foundation-compatible application."

image

I found an article where this error was being discussed.  There was a hotfix issued in December 2013 that addressed the issue.  However, after installing the hotfix, I found the Access View link on the create view page was missing.  This required performing an Office 2010 repair (from Programs and Features) by selecting Change on Office 2010.

image

After doing this and rebooting, the link was back…and it worked!  This is the 2nd time in the last week I’ve had to perform an Office 2010 repair.  I think it all started when I installed SharePoint Designer 2013 on this machine (it already has SPD2007 and SPD2010).

Hey Microsoft, stop breaking your software!

05
Feb
14

Deleting List or Library Fields Breaks Data View Web Part in SharePoint 2007

By Russell Wright Leave a Comment
Categories: SharePoint Designer and SharePoint Errors

Okay, I know this is OLD 2007, but some folks are still running it!

This is actually a two-part fix. 

  1. Fix the data source so it isn’t referencing the deleted fields
  2. Fix the web part so it isn’t referencing deleted fields from the data source

Here’s the web part that is showing an error because field(s) were deleted from the underlying list (library).

image

The data source will not return any data because it is also messed up due to the deleted list fields.

image

You can find the datasource in the _fpdatasources folder.

image

Then you can edit it in XML or Text mode.  You probably need to check it out first, or you won’t be able to save it!

image

Fix the data source.  This involves finding the field in the data source XML that has been deleted.  In this example, we have found <FieldRef Name="Scorecard"> that has been encoded (e.g. &lt;).  Delete it, and be sure you get all the correct text deleted. 

image

Now you can see the data in the data source once again!

image

You need to fix the web part by finding the extra field(s) that are being referenced and remove them from the data source reference.

image

In the code view, find the <DataSources> tag and you can then locate the <datafields> section where the deleted list fields are still present.  You need to remove them as shown above.

image

 

 

References:

The server returned a non-specific error when trying to get data from the data source.  Check the format and content of your query and try again.  If the problem persists, contact the server administrator.

22
Jul
13

KB2844286 on SharePoint 2010 Breaks Web Parts

By Russell Wright Leave a Comment
Categories: SharePoint Errors and SharePoint Infrastructure

 

Came in to our project management site only to find several pages with data views (DVWP) throwing an error.

image

The logs have an error for each web part.

07/22/2013 10:20:26.95    w3wp.exe (0x2634)    0x2730    SharePoint Foundation    Web Parts    89a1    High    Error while executing web part: System.NullReferenceException: Object reference not set to an instance of an object.     at System.Xml.Xsl.XslCompiledTransform.Load(MethodInfo executeMethod, Byte[] queryData, Type[] earlyBoundTypes)     at Microsoft.Xslt.STransform.GetCompiledTransform()     at Microsoft.SharePoint.WebPartPages.BaseXsltListWebPart.LoadXslCompiledTransform(WSSXmlUrlResolver someXmlResolver)     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXslCompiledTransform()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)    3b2167ff-b5ed-4e4d-9797-87f715418136

Some googling turned up several articles about KB2844286 and SharePoint 2010.

http://techchucker.wordpress.com/2013/07/16/issue-kb2844286-security-update-on-sharepoint-2010/

http://social.msdn.microsoft.com/Forums/wpapps/en-US/871a0661-05d0-4f3a-b66d-2504552142bd/error-while-executing-web-part-systemnullreferenceexception-object-reference-not-set-to-an

http://social.technet.microsoft.com/Forums/sharepoint/en-US/6f5e2e94-e756-436f-af8e-68b5ca8a9290/error-while-executing-web-part-systeminvalidprogramexception-common-language-runtime-detected-an

http://sharepointeric.blogspot.com/2013/07/kb2844286-security-update-on-sharepoint.html

We are currently checking this out to see if it really fixes our issue…

…and the answer is "YES!"

22
Jul
12

The Workbook Cannot be Opened–Excel Services SharePoint 2010

By Russell Wright 1 Comment
Categories: Excel Services, SharePoint Errors and SharePoint Infrastructure

I had recently applied Service Pack 1 to my SharePoint instance and was trying to open a workbook with Excel Services and was getting the error “the workbook cannot be opened.”

The SharePoint logs were filled with this, the main issue being the message “Cannot open database “WSS_Content_SPRX2010” requested by the login.  The login failed.  Login failed for user ‘RX\spservice’.  Continue reading after all the log messages.

 

07/22/2012 17:02:53.56     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880i    High        System.Data.SqlClient.SqlException: Cannot open database "WSS_Content_SPRX2010" requested by the login. The login failed.  Login failed for user ‘RX\spservice’.     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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire,…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.56*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880i    High        … SqlConnection owningObject)     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)     at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, D…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.56*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880i    High        …bConnectionPool pool, DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)     at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)     at System.Data.SqlClient.SqlConnection.Open()     at Microsoft.SharePoint.Utilit…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.56*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880i    High        …ies.SqlSession.OpenConnection()    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High           at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.GetVersion(SPDatabase database, Guid id, Version defaultVersion, SqlSession session, SPDatabaseSequence sequence)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.get_SchemaVersion()     at Microsoft.SharePoint.Upgrade.SPSequence.get_IsBackwardsCompatible()     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.IsBackwardsCompatible(Object o, Boolean bRecurse)     at Microsoft.ShareP…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …oint.Administration.SPPersistedUpgradableObject.get_IsBackwardsCompatible()     at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.ValidateBackwardsCompatibility()     at Microsoft.SharePoint.SPSite.PreinitializeServer(SPRequest request)     at Microsoft.SharePoint.SPSite.GetSPRequest()     at Microsoft.SharePoint.SPSite.get_Request()     at Microsoft.SharePoint.SPSite.SetAllowUnsafeUpdates(Boolean allowUnsafeUpdates)     at Microsoft.Office.Excel.Server.MossHost.SharePointHelperMethods.GetSite(String fileLocation, IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity)     at …    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.<TryExecuteWithUserContext>b__2()     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action)     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.TryExecuteWithUserContext(IIdentity userIdentity, Action`1 method)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.Init(Uri uri, Guid requestSiteId, IIdentity currentIdentity, IExcelServerDocumentContext documentContext, FileLoaderHostInfo& outFileLoaderHostInfo)     at Microsoft.Office.Excel.Server.CalculationServer.SharePointFileLoader.Init(Uri uri, Guid requestSiteId, IExcelServerDocumentContext documentContext)     at Microsoft.Office.Ex…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …cel.Server.CalculationServer.FileLoader.CreateFromTrustedLocationAndInit(Uri uri, TrustedLocation trustedLocationSettings, Guid requestSiteId, IExcelServerDocumentContext documentContext)     at Microsoft.Office.Excel.Server.CalculationServer.BaseWorkbookManager.GetBaseWorkbookAndMarkUsedAsync(AsyncHandler`1 callback, Object userState, Request request, Uri uri, Boolean newWorkbook, Boolean useCollection, Boolean loadedOnDemand)     at Microsoft.Office.Excel.Server.CalculationServer.Session.OpenWorkbookAsync(AsyncHandler`1 callback, Object userState, Request request, Uri url, Boolean loadedOnDemand)     at Microsoft.Office.Excel.Server.CalculationServer.Operations.OpenWorkbookOperation.StartExecution()     at Microsoft.Office.Excel.Server.CalculationServer.Operations.Operation.RunOperationA…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …sync()     at Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.PrepareComplete(PrepareAsyncArgs args)     at Microsoft.Office.Excel.Server.AsyncArgsWithCallback`1.OneTimeCallback(T args)     at Microsoft.Office.Excel.Server.CalculationServer.Session.FinalizePrepare(PrepareAsyncArgs args)     at Microsoft.Office.Excel.Server.CalculationServer.Session.HandleTrimmedWorkbookReloading(UserOperation userOperation, PrepareAsyncArgs args)     at Microsoft.Office.Excel.Server.CalculationServer.Session.PrepareAsync(UserOperation userOperation, AsyncHandler`1 callback, Object userState)     at Microsoft.Office.Excel.Server.CalculationServer.Operations.OperationSite.ExecuteContainedOperationAsync(Object userState)     at Microsoft.Office.Excel.Server.CalculationServer.Operation…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …s.OperationQueue.QueueOperationAsync(AsyncHandler`1 callback, Object userState, Operation[] operations, QueueOperationFlags flags, Int32 departureTimeout)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceBase.BeginProcessOperation(CommandParameter parameter, WebMethodBehaviorAttribute webMethodBehavior, WebMethodType webMethodType, AsyncCallback callback, Object state, UserOperation operation)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceSoap.BeginOpenWorkbook(CommandParameter parameter, OpenWorkbookInParameters inParameters, AsyncCallback callback, Object state)     at AsyncInvokeBeginBeginOpenWorkbook(Object , Object[] , AsyncCallback , Object )     at System.ServiceModel.Dispatcher.AsyncMethodInvoker.InvokeBegin(Object instance, Object[] inputs, A…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …syncCallback callback, Object state)     at Microsoft.Office.Excel.Server.CalculationServer.ExcelServiceHostFactory.OperationInvokerExceptionWrapper.InvokeBegin(Object instance, Object[] inputs, AsyncCallback callback, Object state)     at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)     at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)     at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)     at System.ServiceModel.Dispatcher.ChannelHandler.DispatchAndReleasePump(RequestContext request, Boolean cleanThread, OperationContext currentOperationContext)     at System.ServiceModel.Dispa…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …tcher.ChannelHandler.HandleRequest(RequestContext request, OperationContext currentOperationContext)     at System.ServiceModel.Dispatcher.ChannelHandler.AsyncMessagePump(IAsyncResult result)     at System.ServiceModel.Diagnostics.Utility.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)     at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)     at System.ServiceModel.Channels.SecurityChannelListener`1.ReceiveItemAndVerifySecurityAsyncResult`2.InnerTryReceiveCompletedCallback(IAsyncResult result)     at System.ServiceModel.Diagnostics.Utility.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)     at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)     at System.ServiceModel.Channels.InputQueue`1.AsyncQueueReader.Set(Item item)    …    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        … at System.ServiceModel.Channels.InputQueue`1.EnqueueAndDispatch(Item item, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.InputQueue`1.EnqueueAndDispatch(T item, ItemDequeuedCallback dequeuedCallback, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.InputQueueChannel`1.EnqueueAndDispatch(TDisposable item, ItemDequeuedCallback dequeuedCallback, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.SingletonChannelAcceptor`3.Enqueue(QueueItemType item, ItemDequeuedCallback dequeuedCallback, Boolean canDispatchOnThisThread)     at System.ServiceModel.Channels.SingletonChannelAcceptor`3.Enqueue(QueueItemType item, ItemDequeuedCallback dequeuedCallback)     at System.ServiceModel.Channels.HttpChannelListener.HttpContextReceived(HttpReque…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …stContext context, ItemDequeuedCallback callback)     at System.ServiceModel.Activation.HostedHttpTransportManager.HttpContextReceived(HostedHttpRequestAsyncResult result)     at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.BeginRequest()     at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequest(Object state)     at System.ServiceModel.PartialTrustHelpers.PartialTrustInvoke(ContextCallback callback, Object state)     at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequestWithFlow(Object state)     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.WorkItem.Invoke2()     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.WorkItem.Invoke()     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHel…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880k    High        …per.ProcessCallbacks()     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.CompletionCallback(Object state)     at System.ServiceModel.Channels.IOThreadScheduler.CriticalHelper.ScheduledOverlapped.IOCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)     at System.ServiceModel.Diagnostics.Utility.IOCompletionThunk.UnhandledExceptionFrame(UInt32 error, UInt32 bytesRead, NativeOverlapped* nativeOverlapped)     at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)      61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880j    High        SqlError: ‘Cannot open database "WSS_Content_SPRX2010" requested by the login. The login failed.’    Source: ‘.Net SqlClient Data Provider’ Number: 4060 State: 1 Class: 11 Procedure: ” LineNumber: 65536 Server: ‘rxdb’    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          880j    High        SqlError: ‘Login failed for user ‘RX\spservice’.’    Source: ‘.Net SqlClient Data Provider’ Number: 18456 State: 1 Class: 14 Procedure: ” LineNumber: 65536 Server: ‘rxdb’    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          3760    Critical    SQL Database ‘WSS_Content_SPRX2010’ on SQL Server instance ‘rxdb’ not found. Additional error information from SQL Server is included below.  Cannot open database "WSS_Content_SPRX2010" requested by the login. The login failed.  Login failed for user ‘RX\spservice’.    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Database                          tzku    High        ConnectionString: ‘Data Source=rxdb;Initial Catalog=WSS_Content_SPRX2010;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15’    ConnectionState: Closed ConnectionTimeout: 15    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Upgrade                           fbv7    Unexpected    [w3wp] [SPUpgradeSession] [ERROR] [7/22/2012 5:02:53 PM]: IsBackwardsCompatible [SPContentDatabase Name=WSS_Content_SPRX2010] failed.    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Upgrade                           fbv7    Unexpected    [w3wp] [SPUpgradeSession] [ERROR] [7/22/2012 5:02:53 PM]: Exception: Cannot open database "WSS_Content_SPRX2010" requested by the login. The login failed.  Login failed for user ‘RX\spservice’.    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57     w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Upgrade                           fbv7    Unexpected    [w3wp] [SPUpgradeSession] [ERROR] [7/22/2012 5:02:53 PM]:    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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(Strin…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Upgrade                           fbv7    Unexpected    …g host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)     at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionFactory…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Upgrade                           fbv7    Unexpected    ….CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)     at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)     at System.Data.SqlClient.SqlConnection.Open()     at Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlComman…    61486a15-6606-4f31-b9f1-385c24e303d6
07/22/2012 17:02:53.57*    w3wp.exe (0x0E74)                           0x09C8    SharePoint Foundation             Upgrade                           fbv7    Unexpected    …d command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.GetVersion(SPDatabase database, Guid id, Version defaultVersion, SqlSession session, SPDatabaseSequence sequence)     at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.get_SchemaVersion()     at Microsoft.SharePoint.Upgrade.SPSequence.get_IsBackwardsCompatible()     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.IsBackwardsCompatible(Object o, Boolean bRecurse)    61486a15-6606-4f31-b9f1-385c24e303d6

Continue reading here…

Turns out the spservice account was missing on the content database.  I’m not sure why this occurred and whether is was related to the SP1 installation (I could’ve sworn it worked before). 

Here are some blogs that pointed me in the right direction. 

http://stepbistep.net/2012/06/29/the-workbook-cannot-be-opened-excel-services-error-on-sharepoint-2010/

http://blogs.msdn.com/b/jjameson/archive/2010/05/04/the-workbook-cannot-be-opened-error-with-sharepoint-server-2010-and-tfs-2010.aspx

Basically, you can use PowerShell on your Web App on which Excel Services is not working.  image

$webApp = Get-SPWebApplication “http://YourWebApp”

$webApp.GrantAccessToProcessIdentity(“DOMAIN\ServiceAccount”)

After doing this I noticed by spservice account had been granted access in SQL to the database, as shown in the screenshot.

image

30
Dec
10

Can’t update record in datasheet view

By Russell Wright 2 Comments
Categories: SharePoint Errors

Here’s a simple one, but it underscores how important good error messages are.

You are in SharePoint 2010 on a task list and you are attempting to update the task status and other columns using the datasheet view.  You get an error:

“An unexpected error has occurred.  Changes to your data cannot be saved.  For this error, you can retry or discard your changes.”

You are presented with the following dialog.

image

Not very helpful, huh?

No matter how many times you retry your changes, you get the same general error. 

So you try to update the item using a standard SharePoint form and you receive an error with a little more meat.

“This item cannot be updated because it is locked as read-only.”

image 

Now you are suddenly reminded that in-place records management is enabled!

image

You check the Compliance Details for the item and find that you declared it as a record before Christmas and that has put a read-only lock on the item.

image

You also find your memory is mush from the holidays.  There is no solution for that.

Asif Rehmani’s SharePoint Videos

SharePoint-Videos

Click to access a wealth of SharePoint videos

SharePoint Rx

SharePoint Rx Home

Categories

Posts by Date

March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
Support Wikipedia