Qdabra qRules

Re: Error loading form code assembly

Hilary Stoupa — Wed, 14 Feb 2018 16:37:46 GMT

Hey, that's great news! Glad that fixed it.

Re: Error loading form code assembly

Arthur.Avanesyan — Wed, 14 Feb 2018 10:03:14 GMT

It really helped and forms started to load multiple times faster. Thank you, Hilary!

Re: Error loading form code assembly

Hilary Stoupa — Tue, 13 Feb 2018 23:45:51 GMT

In your repeating table, where you currently have your text boxes bound to the fields with the defaults, put a calculated value instead. For the XPath for the calculated value, use the formula editor to select the secondary data source & add the same filtering. XPath will look something like this (for example): xdXDocument:GetDOM("Countries for Business Trip")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:_x0554__x0561__x0572__x0561__x05[../d:City = current()/my:ActualPerDiemCity]

It is actually very similar to the default values you currently have! Just remove "../" between current() and the field name. :)

Re: Error loading form code assembly

Arthur.Avanesyan — Tue, 13 Feb 2018 19:54:09 GMT

Can you please tell me how I can add expression box for each row of repeating table and filter values for each row with corresponding field from the same row?

Re: Error loading form code assembly

Hilary Stoupa — Tue, 13 Feb 2018 17:16:06 GMT

I don't see anything in the form - as you said, there aren't any rules or other defaults that use these values. So - what happens if instead of having defaults in these fields, you just use an expression box to display the info from the secondary data source? Do you still get an error with that approach?

Re: Error loading form code assembly

Arthur.Avanesyan — Tue, 13 Feb 2018 16:33:11 GMT

Actually I changed form yesterday. "View Report" button was set to run rule, that is now under QdabraRules -> finishedLoading: "Query Countries if ActualCostsStatus is Paid". This rule runs 2 queries and especially "Countries for Business Trip" query is causing this issue. If I don't run this query, "CostCountryArm_BT", "CostCityArm_BT", "ActualPerDiemCountryArm_BT" and "ActualPerDiemCityArm_BT" fields will not be updated. These queries run only, if entire form is filled already and users just need to view report on another view. Forms, where "ActualCostsRepeating" table contains up to 4 rows, open normally. If it contains 6 rows, I receive error.

Re: Error loading form code assembly

Hilary Stoupa — Tue, 13 Feb 2018 16:14:48 GMT

Which button causes the issue?

Re: Error loading form code assembly

Arthur.Avanesyan — Tue, 13 Feb 2018 15:53:35 GMT

I've sent you by private message. Thanks.

Re: Error loading form code assembly

Hilary Stoupa — Tue, 13 Feb 2018 15:35:42 GMT

I'd be happy to take a look at your form, see if I can see something. If it were my form, I'd try to repro the issue in a test form - does it persist if the form doesn't have code (or qRules)?

Re: Error loading form code assembly

Arthur.Avanesyan — Mon, 12 Feb 2018 19:16:05 GMT

I tried all possible scenarios, but no luck. If I remove query rule, form loads without issues, but in this case I don't get needed data. If I uncheck "Refresh value if formula is recalculated" checkbox from 4 fields default values, then also forms work, but in this case these fields don't get data again. There are no rules on these default values.

Re: Error loading form code assembly

Hilary Stoupa — Mon, 12 Feb 2018 16:50:11 GMT

My guess would be something in your rules / defaults is causing a loop that wasn't getting caught in 2013 but is in 2016. Do the fields with default values that are getting updated have rules on them?

Re: Error loading form code assembly

Arthur.Avanesyan — Mon, 12 Feb 2018 16:34:40 GMT

I'd like to mention, that I've 9 repeating fields in my form, that are getting default values from data connections filtered by another fields in form. So when switching view, I need to query 2 data connections, so these fields data will get updated. If my form contains 3-4 repeating table rows, it successfully switches view, but if rows are more, I get this issue.

Re: Error loading form code assembly

Arthur.Avanesyan — Mon, 12 Feb 2018 16:28:10 GMT

I've already checked this. It does query from a list, that contains about 2000 rows. In this case I need to query all rows without any limitation. When I disable this query, form has no issues. The same query is running successfully on SP 2013.In logs I receive multiple "RequestUsageProvider.WriteUsageData: Logging usage for Location: 'CalculatedField'. Operation: 'Calculate'. ... " , "RequestUsageProvider.WriteUsageData: Writing log usage failed" messages, then the following error: "Calculations exceeded the maximum stack depth. (User: 30000, Form Name: urn:schemas-microsoft-com:office:infopath:Business-Trip-Request-Template:-myXSD-2014-01-08T23-55-55, ...... " .

Re: Error loading form code assembly

Hilary Stoupa — Mon, 12 Feb 2018 16:09:55 GMT

I'd probably see if one specific query was causing the issue by disabling all rules on the button and re-enabling one at at time. Do you get any additional messages in your logs when the error occurs?

Re: Error loading form code assembly

Arthur.Avanesyan — Mon, 12 Feb 2018 16:06:34 GMT

Here are InfoPath Forms Services settings from SharePoint 2013 "DefaultDataConnectionTimeout : 10000 MemoryCacheSize : 250 MaxDataConnectionTimeout : 20000 MaxDataConnectionResponseSize : 1500 MaxDataConnectionRoundTrip : 20000 MaxFormLoadTime : 40000 RequireSslForDataConnections : True AllowEmbeddedSqlForDataConnections : True AllowUdcAuthenticationForDataConnections : True AllowUserFormCrossDomainDataConnections : True AllowUserFormBrowserEnabling : True MaxSizeOfFormSessionState : 41943040 MaxSizeOfUserFormState : 41943040 MaxPostbacksPerSession : 75 MaxUserActionsPerPostback : 200 ActiveSessionsTimeout : 1440 AllowUserFormBrowserRendering : True AllowViewState : False ViewStateThreshold : 40960 DataConnectionFiles : {} ExemptUserAgents : {crawler, googlebot, ms search, msnbot...} Instances : {} Applications : {} Required : False JobDefinitions : {} RunningJobs : {} JobHistoryEntries : {} CanUpgrade : True IsBackwardsCompatible : True NeedsUpgradeIncludeChildren : False NeedsUpgrade : False UpgradeContext : Microsoft.SharePoint.Upgrade.SPUpgradeContext Version : 10814975 Properties : {} UpgradedPersistedProperties : {} CanBackupRestoreAsConfiguration : True CanSelectForBackup : True DiskSizeRequired : 0 CanSelectForRestore : True CanRenameOnRestore : False". I copied all settings one by one to SharePoint 2016, but this didn't help. After this I even increased all numeric values in SP 2016 like this: "DefaultDataConnectionTimeout : 100000 MemoryCacheSize : 250 MaxDataConnectionTimeout : 200000 MaxDataConnectionResponseSize : 15000 MaxDataConnectionRoundTrip : 200000 MaxFormLoadTime : 40000 MaxPostbacksPerSession : 7500 MaxUserActionsPerPostback : 20000" But this also didn't help. If I set "Properties.Add(“AllowEventPropagation”, $false)", then form can switch view successfully, but it doesn't do queries, so data is not updating on that view.