InfoPath Dev

 I hoping that there is solution for this, I am uploading InfoPath template with Qrules it publish fine since I have site administrator privilege however I am getting this error- The custom code in the form cannot be run. This functionality may be deactivated on the server. For more information, contact the server farm administrator. I really don't won't to upload as admin approved form as I would have to have site admin approve every time I make change. Is there some feature that I can have the administrator activate or change to make it run as sandbox

Hi-

In order to publish a form that contains qRules (or code) to a SharePoint form library, two requirements must be met:

1. You must be a site collection administrator.

2. The Sandbox service must be active on the server. To do this:
a. On the home page of the Central Administration Web site, in the System Settings section, click Manage services on server.
b. On the Services on Server page, in the Server box, select the server on which you want to enable sandboxed solutions.
c. In the Microsoft SharePoint Foundation Sandboxed Code Service row, in the Action column, click Start.

For more info, see this article: http://technet.microsoft.com/en-us/library/ff535780(v=office.14).aspx

Please let us know if the information above helps to resolve the publishing issue.

 1. Sanbox enabled

2. I am the site collection administrator

any thing else I can check 

I would check the Design Checker in InfoPath, but the error message does seem to point out a server issue and not a form issue. Worth checking though, just to make sure.

You could have the server admin check the SharePoint logs for the time you were trying to publish, see if there is more info there.

I have posted log issue from below. I have connections to the user information list and disabled them just to test as it said something about cannot access user information list. 

 Unhandled exception was thrown by the sandboxed code wrapper's Execute method in the partial trust app domain: An unexpected error has occurred. - userCodeWrapperType = "Microsoft.Office.InfoPath.Server.Host.FormServerUserCodeWrapper", userAssemblyGroupId = "76930AA769A04670A36D8C07A35B0D77-gzRqCCyQsMIbZlJ9voftODP59JjissYXbba6nPJw4Ac=", siteCollectionId = "ef92b8b6-a263-4bcb-8340-9111a729f321" - Inner Exception: Microsoft.SharePoint.UserCode.SPUserCodeSolutionProxiedException: Could not load type 'Microsoft.SharePoint.Administration.Claims.SPClaimProviderManager' from assembly 'Microsoft.SharePoint, Version=14.900.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'.    Server stack trace:      at Microsoft.Office.InfoPath.Server.SolutionLifetime.UserHost.GetCurrentUserAccountName(... a41b2351-d95b-4c97-914c-c491d46f16e2
01/30/2014 06:20:43.59* SPUCWorkerProcess.exe (0x1E04)           0x2728 SharePoint Foundation          Sandboxed Code Service         fe8s Medium   ...)     at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.CreateDocument(HttpContext context, SPSite contextSite, String editingSessionId, Solution solution, String webUrl)     at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.LoadFromRemoteContext(Boolean firstOpened, String editingSessionId, Solution solution, Byte[] serializedState, Byte[] serializedVersionState, Dictionary`2 inputParams, OpenParameters openParameters)     at Microsoft.Office.InfoPath.Server.Controls.XmlFormView..ctor(Solution solution, RemoteExecutionContext remoteExecutionContext)     at Microsoft.Office.InfoPath.Server.Host.FormServerUserCodeWrapper.Execute(SPUserCodeExecutionContext executionContext)     at Microsoft.SharePoint.UserCode.SPUserCodeApplicationHostAppDomainRef.ExecuteWrapper(SPUse... a41b2351-d95b-4c97-914c-c491d46f16e2
01/30/2014 06:20:43.59* SPUCWorkerProcess.exe (0x1E04)           0x2728 SharePoint Foundation          Sandboxed Code Service         fe8s Medium   ...rCodeWrapper wrapper, SPUserCodeExecutionContext executionContext)     at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)     at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)    Exception rethrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)     at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)     at Microsoft.SharePoint.UserCode.SPUserCodeApplicationHostAppDomainRef.CodeToExecuteWrapper.EndInvoke(IAsyncResult result)     at Microsoft.SharePoint.UserCode.SPUserCodeApplicationHostAppDomainRef.... a41b2351-d95b-4c97-914c-c491d46f16e2
01/30/2014 06:20:43.59* SPUCWorkerProcess.exe (0x1E04)           0x2728 SharePoint Foundation          Sandboxed Code Service         fe8s Medium   ...Execute(Type userCodeWrapperType, SPUserCodeCachedAssemblyGroup userAssemblyGroup, Guid siteCollectionId, Byte[] binaryUserCodeToken, Byte[] proxyOperationToken, SPUserCodeExecutionContext executionContext, Boolean shouldUsageLog, Int32 currentProcessId) a41b2351-d95b-4c97-914c-c491d46f16e2
01/30/2014 06:20:43.67  SPUCHostService.exe (0x08D0)             0x0DD8 SharePoint Foundation          Sandboxed Code Service         0000 Medium    -  - Could not load type 'Microsoft.SharePoint.Administration.Claims.SPClaimProviderManager' from assembly 'Microsoft.SharePoint, Version=14.900.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. - Request executing userSolution Id "76930aa7-69a0-4670-a36d-8c07a35b0d77" for site collection id " ef92b8b6-a263-4bcb-8340-9111a729f321" has encountered an unhandled exception while executing user code. a41b2351-d95b-4c97-914c-c491d46f16e2
01/30/2014 06:20:43.81  w3wp.exe (0x2520)                        0x1770 SharePoint Foundation          Sandboxed Code Service         0000 High      - UserCodeExecutionProxy call failed. Microsoft.SharePoint.UserCode.SPUserCodeSolutionExecutionFailedException: Unhandled exception was thrown by the sandboxed code wrapper's Execute method in the partial trust app domain: An unexpected error has occurred. ---> Microsoft.SharePoint.UserCode.SPUserCodeSolutionProxiedException: Could not load type 'Microsoft.SharePoint.Administration.Claims.SPClaimProviderManager' from assembly 'Microsoft.SharePoint, Version=14.900.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'.    Server stack trace:      at Microsoft.Office.InfoPath.Server.SolutionLifetime.UserHost.GetCurrentUserAccountName()     at Microsoft.Office.InfoPath.Server.DocumentLifetime.Document.CreateDocument(HttpContext context, SPSite contextSite, String editingSessionId, Solution s... a41b2351-d95b-4c97-914c-c491d46f16e2

Hi,

Can you attach your XSN? (if you'd prefer to email it, you can send it to support at qdabra dot com)

This error may come up if you're publishing directly to a form library (sandbox) but have injected using the Admin-deploy option in the qRules injector.

We'll check your form if you can send it. Thanks!

Hi Ernesto,

I am having the same issue - an InfoPath form injected with Q-rules 5.1 for sandbox 2010.   It publishes fine.  It is published to a document library.  It runs in the client fine.  When running in the browser I get the same error as shown above.

I am the Site collection administrator.  I have other browser based sandboxed forms running on the server.  I have stopped and started the sandboxed code service on all of the servers in the farm.

I get the error on opening the form.  the Form then displays and appears to work correctly until I visit a field which has rules which access Q-rules command line.

Do you have any other ideas for things that I can check ?

Catharine

Hi Catharine,

My only hunch is that the form was injected with the Admin deploy option then sandboxed, or vice-versa (injected with the sandbox option, then admin-deployed).

If you can, please contact us via our support email and we can take a closer look at your form.

Thank you.

Hi Ernesto 

Would that involve cost ?  If so I would need to get approval from my manager first.  If I export the source files is there anything I could be looking for ?

Catharine

Hi, Catharine -

I tried your form on one of our servers, and it sandboxed w/out an issue. I took a look at the log you sent and see the same errors - have you tried this with just any command? Like GenerateGuid?

Hi Hilary,

I have tried creating a blank form with just GenerateGuid in the on loading.  I have published that to the same location and that works fine.

On the form which is having the problems, I have disabled all the "finishedLoading" rules and re-published.  I am still getting errors - fewer of them...

-  - Sandboxed code execution request failed. - Inner Exception: System.Runtime.Remoting.RemotingException: Server encountered an internal error. For more information, turn off customErrors in the server's .config file.    Server stack trace:       Exception rethrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.SharePoint.Administration.ISPUserCodeExecutionHostProxy.Execute(Type userCodeWrapperType, Guid siteCollectionId, SPUserToken userToken, String affinityBucketName, SPUserCodeExecutionContext executionContext)     at Microsoft.SharePoint.UserCode.SPUserCodeExecutionManager.Execute(Type userCodeWrapperType, SPSite site, SPUserCodeExecutionContext executionContext)

FormServer Partial Trust - remote execution for solution 82ac8447-4860-45a3-a46c-91b487b5666d from site c02e2c04-12b1-4d9b-aec3-1f61ec8a6f95 failed with exception Microsoft.SharePoint.UserCode.SPUserCodeExecutionPipelineFailedException: Sandboxed code execution request failed. ---> System.Runtime.Remoting.RemotingException: Server encountered an internal error. For more information, turn off customErrors in the server's .config file.    Server stack trace:       Exception rethrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.SharePoint.Administration.ISPUserCodeExecutionHostProxy.Execute(Type userCodeWrapperType, Guid siteCollectionId, SPUserToken userToken, String affinityBucketName, SPUserCodeExecutionContext executionContext)     at Microsoft.SharePoint.UserCode.SPUserCodeExecutionManager.Execute(Type userCodeWrapperType, SPSite site, SPUserCodeExecutionContext executionContext)     --- End of inner exception stack trace ---     at Microsoft.SharePoint.UserCode.SPUserCodeExecutionManager.Execute(Type userCodeWrapperType, SPSite site, SPUserCodeExecutionContext executionContext)     at Microsoft.Office.InfoPath.Server.DocumentLifetime.PartialTrustExecutorHelper.<>c__DisplayClass1.<PlayEventLogInRemote>b__0(), inner exception System.Runtime.Remoting.RemotingException: Server encountered an internal error. For more information, turn off customErrors in the server's .config file.    Server stack trace:       Exception rethrown at [0]:      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)     at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)     at Microsoft.SharePoint.Administration.ISPUserCodeExecutionHostProxy.Execute(Type userCodeWrapperType, Guid siteCollectionId, SPUserToken userToken, String affinityBucketName, SPUserCodeExecutionContext executionContext)     at Microsoft.SharePoint.UserCode.SPUserCodeExecutionManager.Execute(Type userCodeWrapperType, SPSite site, SPUserCodeExecutionContext executionContext).

I guess what I was trying to find out was what qRules command is being executed when you get the error?

I have disabled all the q-rules that are based on finished loading.  I have also removed all the default values.

I have looked at the  rules inspector and checked that any rules that may change the QdabraRules/Command field are disabled- i.e. I have tried to eliminate commands firing on opening of the form.  I have disabled any rules on buttons. My theory was that if I switch everything off - the form would hopefully load without error and each item could be added and the form tested - to analyse the source of the error. 

I have also loaded Q-rules 6.1 so I have history of commands run (love that feature !)

I have managed to load open the sandboxed form and run it from the server.

I have enabled the rules a couple at a time and re-published.  After 20+ versions I have discovered that the "straw that breaks the camels' back" is a rule on a picture button which has the following command concat(xdUser:get-UserName(), " ", translate(xdDate:Now(), "T:-", ""))

This button is obviously not clicked on open... so the rule is not fired by the button - so I guess there is something wrong with the format ? 

I can reproducably activate and deactivate this one rule and cause the sand boxed form to fail.

Any ideas ?

Thank you

Catharine

So - the rule is setting another field? What field? I ask because you say it has the command, but it doesn't appear that the rule is setting the command field in qRules.... We had a form the other day that would not sandbox because a rule had an XPath in it that was malformed - even though it would validate, the form wouldn't sandbox.