Archive Page 2

25
Nov
12

Unsupported Expression in InfoPath 2010

 

This is a weird one.

Situation:

Going back to a SharePoint 2007 site formerly published with InfoPath 2007.  Downloaded the form template and made some changes.  When I went to re-publish I encountered an “unsupported expression” error.

image

The actual long message was as follows.

The following expression could not be parsed because of a syntax error or because it uses an undefined namespace prefix or unsupported function:  pc:DisplayName

image

This appeared to have been coming from one of the people pickers (circa 2007 variety) but copying the Xpath on each of them yielded no easily identifiable pc:DisplayName.

/my:myFields/my:EmployeeManager/my:Person/my:DisplayName

/my:myFields/my:EmployeeGroup/my:TerminatingEmployee/my:Person/my:DisplayName

I went back to the original template with no changes and it didn’t throw the same error during publishing.

I changed the Form type from Web Browser Form (InfoPath 2007) to InfoPath 2007 Filler Form and attempted publishing.  The error went away.

image

So, I changed it back to Web Browser Form (InfoPath 2007) again…the way it originally was.  The error stayed away and I published the form. 

However, after publishing, the error came back.  Sad smile  So I decided to look “under the covers.”

I saved the XSN as source files and looked within all the files.  I was able to find where the pc: schema infiltrated my form template.  Within view1.xsl I found the offending pc:DisplayName, and all the other related pc: references. 

image

I’m not sure how this made its way into the form template, as I never specifically made this change, nor do I know how one would force this. 

</xsl:if>

                                        <param NAME="ButtonFont" VALUE="Verdana,12,0,400,0,0,0"/>

                                        <param NAME="ButtonText" VALUE=""/>

                                        <param NAME="DisplayNameXPath" VALUE="pc:DisplayName"/>

                                        <param NAME="ObjectIdXPath" VALUE="pc:AccountId"/>

                                        <param NAME="ObjectTypeXPath" VALUE="pc:AccountType"/>

                                        <param NAME="SiteUrlXPath" VALUE="/Context/@siteUrl"/>

                                        <param NAME="SiteUrlDataSource" VALUE="Context"/>

                                        <param NAME="NewNodeTemplate" VALUE="&lt;pc:Person xmlns:pc=&quot;http://schemas.microsoft.com/office/infopath/2007/PartnerControls&quot;&gt;
    &lt;pc:DisplayName&gt;&lt;/pc:DisplayName&gt;
    &lt;pc:AccountId&gt;&lt;/pc:AccountId&gt;
    &lt;pc:AccountType&gt;&lt;/pc:AccountType&gt;
&lt;/pc:Person&gt;"/>

                                        <param NAME="BackgroundColor" VALUE="2147483653"/>

                                        <param NAME="MaxLines" VALUE="4"/>

                                        <param NAME="Direction" VALUE="0"/>

I did a simple “find and replace” on all the pc: occurrences with my: and saved and tested my work.  All appears to be okay.

Sure would be nice to know how this happens!

21
Nov
12

InfoPath Blog Silent?

Is it just me, or has anyone noticed the InfoPath team blog at http://blogs.msdn.com/b/infopath/ has been silent for the last year and a half?  Did they move it somewhere else when I wasn’t looking?  Or, did I finally look up for a minute, only to find the world has passed me by…again?

21
Nov
12

Site Navigation Settings Missing in SharePoint 2007 Using IE9

So let’s say you are using IE9 and you go to the Site Navigation Settings page on a 2007 SharePoint site and see this:

image

And you scratch you head and wonder, “Where are all my navigation settings?”  Perhaps you did this many moons ago and you think it’s just old age setting in.  But a little Googling indicates you aren’t going crazy (or senile) and there’s some JavaScript issue with the page.

Try this.  Start IE9 without any add-ons by executing

iexplore –extoff

Then, navigate to the same page and voilà, your navigation editing area appears!

image

This must be due to some malcontent add-on.

Enabling and disabling add-ons and refreshing your page brings you to NameCtrl Class being the add-on that seems to be causing the problem.  Disabling this add-on fixes the issue…at least it did for me!

image

 

Search terms:

NameCtrl Class Microsoft Corporation

Add-on issues with IE9 and SharePoint 2007 navigation

10
Oct
12

Microsoft Project 2010 Sync with SharePoint 2010–Sorting It Out!

The sync with Project 2010 is great, but there are some "issues" you might run in to.  One of these is sorting the SharePoint task list so it matches up with Project.  I’ve found the key to this is to add the WBS (Work Breakdown Structure) column to the sync columns and sort by the WBS column.  For those not familiar with WBS, it is a hierarchical numbering scheme used for tasks in a project plan, similar to legal numbering of paragraphs, i.e. 1, 1.1, 1.1.1, 1.1.2, 2, 2.1, 2.2, 2.2.1, 2.2.2, etc.  Using the WBS as a sort field allows you to keep the tasks in the project plan order.

Add a simple text column called WBS to your SharePoint task list.

image

Using the Sync feature on Project Professional 2010, add the WBS column to the list of sync’d fields.

image

image

Sync your project to SharePoint (that can have its own set of issues).

Add the column as a primary sort column to your view.

image

Voilà!  You are sorted by WBS!

image

As you drill through the tasks, you’ll notice they are all in WBS order.

image

If you create a view that excludes folders, you’ll see something like this.  The important thing to note is, since this view is excluding folders, the summary tasks are not shown, as they are implemented as folders in SharePoint.

image

02
Oct
12

Launch form in a dialog doesn’t work correctly when displaying a list in datasheet view

This was driving me nuts.  I had a custom list in SharePoint 2010 and I wanted the new item form to NOT open in a dialog.  No matter what I did, it kept opening in a dialog.

image

Then I stumbled upon what was causing my issue!  Whenever the list was displayed in a datasheet view (which was my default), the new item form would always display in a modal dialog.

List displayed in datasheet view.

image

 

 

 

 

 

 

 

 

 

 

Create a new entry…

 

image

 

…and modal dialog is displayed (notice no master page "chrome”).

 

image

 

Change to standard view…

 

image

 

…and the form is opened up in single page mode (notice master page “chrome”).

 

image

What’s up with that?

An interesting thing to note is this problem also exists with Calendar lists.  If you display a calendar list in anything other than a normal list view, the “Launch forms in a dialog” will not be respected when set to “No.” 

Again, if we set “Launch forms in a dialog” to “no” and view the calendar in “Calendar” view…

 

image

 

…and attempt to create a new event while in this view…

 

image

 

…the form opens in a dialog.

 

image

 

If we change to the “All Events” view and attempt the same thing…

 

image

 

The form is opened in a new page (no dialog).

 

image

 

Perhaps this is the designed behavior, but if it is, I would recommend renaming the option to “Launch forms in a dialog when showing items in standard view.”

The description of the option would lead one to believe there might be times when a dialog would not be displayed when you would expect it to be displayed…not the other way around.

 

image

 

I guess I shouldn’t be disappointed when I get “free” dialog forms.

 

Keywords:

Launch form in a dialog broken

Launch form in a dialog doesn’t work for custom list

List view affects dialog form

30
Jul
12

Mystery Meat Navigation in SharePoint Designer 2010

One of my favorite topics is how Microsoft have forgotten to design user interfaces over the years, even though they published some books early on which defined the correct way to create a UI.

When I really feel “in the mood,” I go back and browse Vincent Flanders’ Web Pages That Suck site.  I’m constantly reminded from MS about some of their stupid interface design, usually executed for the sake of marketing flair, is not necessarily confined only to web UIs.  It’s prevalent throughout all their products, if one simply looks for five minutes.

Here’s one that always gets me, and it’s possible I’ve written about it in the past. 

This is an innocent tool ribbon (don’t get me started…) in SPD 2010 that has three items in a group called Manage, that don’t operate the same.  Can you tell, “which one of these things is not like the others…which one of these things just doesn’t belong?”

image

I’ll give you a hint.  It’s the one in the middle, which is an action button, while the ones on the outside are push buttons. 

image

This is what happens when programmers grow up without the benefit of ever having used a pushbutton car radio (not exactly, but you get the point).

image

22
Jul
12

The Workbook Cannot be Opened–Excel Services SharePoint 2010

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




Asif Rehmani’s SharePoint Videos

SharePoint-Videos

Click to access a wealth of SharePoint videos

SharePoint Rx

SharePoint Rx Home

Categories

Posts by Date

April 2014
M T W T F S S
« Mar    
 123456
78910111213
14151617181920
21222324252627
282930  
Support Wikipedia

Follow

Get every new post delivered to your Inbox.