Qdabra qRules

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Fri, 20 Jun 2014 16:09:52 GMT

Not a stupid question at all - the snippet of logs you posted said "For more information, turn off customErrors in the server's .config file." From what Jim said, I'm guessing that is the web.config for the SharePoint server? Is this a farm or a single server?

Re: uploading InfoPath 2010 sandbox browser form

Catharine — Fri, 20 Jun 2014 15:01:40 GMT

Hi,

This is in production environment.

"Turn off custom errors" where should I do that - Sorry probably a stupid question?

No recent updates applied - we are behind with updates - I think I remember us having a problem last year with the form which Jimmy developed for us - and we ended up having to publish it as an admin form. I cannot guarantee - but my feeling is that that was the same issue.

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Fri, 20 Jun 2014 14:54:29 GMT

Here's what Jim suggested (and a question):

I would do as the exception notes and turn off custom errors to get more details in the logs. Unfortunately, you need to know which site is being called so the appropriate SharePoint web.config can be modified. An iisreset will be needed after the change.

If it is a test environment, no problems, but in a production environment it should be done during a maintenance window.

Were any recent updates applied?

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Thu, 19 Jun 2014 18:15:44 GMT

Oh interesting - thanks for checking that. I'm going to ask Jim if he's run into this before.

Re: uploading InfoPath 2010 sandbox browser form

Catharine — Thu, 19 Jun 2014 10:42:18 GMT

Ok, so I have taken my base form - no qrules and no Username() and added some code which sets a field to "newvalue" - boy was I rusty at that ! It is 2.5 years since i have written any code.

I published the form and it works fine.

I then included the username() function in one of the fields and re-published. Again it publishes successfully but when you try and run it it gives a correlation error.

So in our set up it seems that if you use the username() function in conjunction with code (qrules or other) it fails.

The code on its own is fine.

The username() on its own is fine.

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Wed, 18 Jun 2014 15:40:21 GMT

So, what I was wondering is if a code DLL that is NOT qRules also would cause the issue? That's why I suggested adding a little custom code to the form instead of injecting with qRules? Your original form that would not sandbox on your server would sandbox on our server, so it seems like it is a server difference of some kind, I'm just not certain what it might be.

Re: uploading InfoPath 2010 sandbox browser form

Catharine — Wed, 18 Jun 2014 15:03:12 GMT

Hi Hilary

I have a completely blank form - with two fields - I have set two rules on form load. One to put "fred" in the first field, the second to put username() in the FormName field - that publishes to sharepoint and works in the browser.

I have made a copy of that form, and injected it with q- rules - I have not made any other changes. I have publised to sharepoint successfully and I get the correlation error when I open the form.

I can send you the two forms if you want.

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Wed, 18 Jun 2014 14:40:00 GMT

I would take a new blank form, add some simple code to it (just set a field's value on load or something) and verify you can sandbox it. Then I'd add a rule to it to set another field to the username function - does it still sandbox? Just trying to see if we can narrow the issue down further.

Re: uploading InfoPath 2010 sandbox browser form

Catharine — Wed, 18 Jun 2014 09:35:20 GMT

I have a field called FormName - and this concat(xdUser:get-UserName(), " ", translate(xdDate:Now(), "T:-", "")) is setting the value of that Field. - It doesn't seem to be connected to QRules fields at all. I have exported the source files and searched the manifest - the only place I am using Get-UserName is in this button.

Could it be something to do with permissions ?

I am using the Qrules GetUserProfileByName on load so I have replaced the xdUser:get-UserName(), with xdXDocument:GetDOM("Get Current User")/dfs:myFields/dfs:dataFields/ns2:GetUserProfileByNameResponse/ns2:GetUserProfileByNameResult/ns2:PropertyData/ns2:Values/ns2:ValueData/ns2:Value[(../../../ns2:Name = "UserName") and (. != "")], and re-published and it works fine .

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Tue, 17 Jun 2014 19:21:12 GMT

I should add - do you have any other rules that are using the username function?

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Tue, 17 Jun 2014 19:07:29 GMT

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.

Re: uploading InfoPath 2010 sandbox browser form

Catharine — Tue, 17 Jun 2014 15:01:01 GMT

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

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Mon, 16 Jun 2014 16:57:29 GMT

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

Re: uploading InfoPath 2010 sandbox browser form

Catharine — Mon, 16 Jun 2014 09:44:39 GMT

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).

Re: uploading InfoPath 2010 sandbox browser form

Hilary Stoupa — Fri, 13 Jun 2014 17:48:08 GMT

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?