Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Audit log sync error

We have one app that continues to receive a similar sync error over the past two days. Is this an issue with our app, AppSheet, or our data source (Microsoft Office 365 - Excel)? See error log example below. I couldn’t upload the entire log, because it is too many characters. So if needed, I can send via some other method. Thanks.

Kevin

Audit Log Details

Error:

“Error: Error code: BadRequest\nError message: Unable to retrieve tenant service info.\nStack trace: at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)\r\n at Nirvana.Data.MicrosoftProvider.<>c__DisplayClass22_0.b__0() in d:\a\1\s\V2API\Providers\MicrosoftProvider\MicrosoftProvider.cs:line 721\r\n at V2API.Providers.MSGraphUtilities.ExecuteWithRetry(Action operation, String accessToken, Exception& fatalException, Int32 userId, Int32 maxRetryCount, String debugInfo) in d:\a\1\s\V2API\Providers\MicrosoftProvider\MSGraphUtilities.cs:line 895\nDebug information:\nMethod: GetDriveItem\nDrive item path: SHAREPOINT_SITE_ID_rockinghamgroup.sharepoint.com_f7d03497-75fb-411a-a3fe-047858d78aa4_4821a462-171e-4c8e-a797-c86cb0b11ce0//Specialty Claims//Specialty Claims.xlsx\nDrive item relative path: Specialty Claims/Specialty Claims.xlsx\nUser Id: -1\nRequest Url: https://graph.microsoft.com:443/v1.0/sites/rockinghamgroup.sharepoint.com,f7d03497-75fb-411a-a3fe-04... Error: Data table ‘SpecialtyClaims2-655816:1.001225:Authority Log’ is not available Error: Data table ‘Authority Log’ is either inaccessible or empty.”

Properties:

{

“IfModifiedSinceDate”: “2020-04-24T15:07:06.361974Z”,

“getAllTables”: “True”,

“syncsOnConsent”: “True”,

“isPreview”: “False”,

“apiLevel”: “2”,

“tzOffset”: “240”,

“locale”: “en-US”,

“tableTimestamps”: “{\r\n “Claim”: “2020-04-30T17:11:47.1522193Z”,\r\n “_Per User Settings”: “2020-04-30T17:11:51.9020476Z”,\r\n “Policy”: “2020-04-30T17:11:44.6298144Z”,\r\n “Risk”: “2020-04-30T17:11:47.1522193Z”,\r\n “Parties”: “2020-04-30T17:11:49.5610087Z”,\r\n “Coverage”: “2020-04-30T17:11:49.5610087Z”,\r\n “Activities”: “2020-04-30T17:11:44.6298144Z”,\r\n “Notes”: “2020-04-30T17:11:51.707044Z”,\r\n “Documents”: “2020-04-30T17:11:51.6008997Z”,\r\n “Task”: “2020-04-30T17:11:47.1522193Z”,\r\n “Authority”: “2020-04-30T17:11:49.5610087Z”,\r\n “Checks”: “2020-04-30T17:11:49.5610087Z”,\r\n “Report Request”: “2020-04-30T17:11:47.1472215Z”,\r\n “Activities Log”: “2020-04-30T17:11:49.3760576Z”,\r\n “State”: “2020-04-30T17:11:51.7020457Z”,\r\n “Authority Log”: “2020-04-30T17:11:51.6920462Z”,\r\n “Coverage List”: “2020-04-30T17:11:53.6271604Z”\r\n}”,

“lastSyncTime”: “4/30/2020 5:11:55 PM”,

“appStartTime”: “4/30/2020 3:00:26 PM”,

“dataStamp”: “4/30/2020 5:11:55 PM”,

“clientId”: “005cf152-e3e4-406b-a472-002e1139c832”,

“build”: “8f77348cd84cb540c36f-1588099347784-222ea7c2bd”,

“hasValidPlan”: “True”,

“userConsentedScopes”: “data_input,device_identity,device_io,profile,usage”,

“localVersion”: “1.001225”,

“isBackgroundSync”: “True”,

“AppTemplateName”: “d8ad2340-5278-4c3f-aea3-0533dffd8914”,

“Operation”: “App sync”,

“RecordType”: “Stop”,

“AppTemplateVersion”: “”,

“AppDefinitionChanged”: true,

“Performance”: "{“Version”:1,“Time”:“00:00:18.9480708”,“PerformanceTimingRoot”:{“Mid”:130,“Timer”:{“Time”:“00:00:18.9480708”},“Children”:[{“Mid”:63,“Timer”:{“Time”:“00:00:18.9480422”},“Children”:[{“Mid”:62,“Timer”:{“Time”:“00:00:00.8116850”}},{“Mid”:244,“Timer”:{“Time”:“00:00:00.1140254”}},{“Mid”:155,“Timer”:{“Time”:“00:00:00.1807637”}},{“Mid”:117,“Params”:{“ParamList”:[{“Pid”:5,“Value”:“5”}]},“Timer”:{“Time”:“00:00:16.5703445”},“Children”:[{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Report Request”},{“Pid”:21,“Value”:“06.12.35.072962”}]},“Timer”:{“Time”:“00:00:07.4988443”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:07.4986410”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Report Request”}]},“Timer”:{“Time”:“00:00:07.4985786”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:00.6519076”},“Children”:[{“Mid”:25,“Timer”:{“Time”:“00:00:00.0596431”}},{“Mid”:29,“Timer”:{“Time”:“00:00:00.5316223”}},{“Mid”:34,“Timer”:{“Time”:“00:00:00.0591289”}}]},{“Mid”:241,“Timer”:{“Time”:“00:00:04.1532460”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:04.1448534”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Policy”}]},“Timer”:{“Time”:“00:00:04.1448244”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“209”}]},“Timer”:{“Time”:“00:00:04.1445276”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:03.4932041”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.5112922”}},{“Mid”:278,“Timer”:{“Time”:“00:00:02.9760843”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:02.9759527”},“Children”:}]}]}]}]}]}]},{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“77”}]},“Timer”:{“Time”:“00:00:02.6929918”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:02.6315768”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.5242179”}},{“Mid”:278,“Timer”:{“Time”:“00:00:02.1048033”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:02.1046699”},“Children”:}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Risk”},{“Pid”:21,“Value”:“06.12.35.072962”}]},“Timer”:{“Time”:“00:00:07.6155117”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:07.6147946”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Risk”}]},“Timer”:{“Time”:“00:00:07.6147325”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:01.1357570”},“Children”:[{“Mid”:25,“Timer”:{“Time”:“00:00:01.0758566”}},{“Mid”:34,“Timer”:{“Time”:“00:00:00.0588848”}}]},{“Mid”:241,“Timer”:{“Time”:“00:00:03.6699058”}},{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“147”}]},“Timer”:{“Time”:“00:00:02.7403861”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:02.6774648”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.6225023”}},{“Mid”:278,“Timer”:{“Time”:“00:00:02.0518373”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:02.0516977”},“Children”:}]}]}]},{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Risk_Schema”}]},“Timer”:{“Time”:“00:00:00.0683784”},“Children”:[{“Mid”:61,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Risk Address”}]},“Timer”:{“Time”:“00:00:00.0669316”}}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Task”},{“Pid”:21,“Value”:“06.12.35.072962”}]},“Timer”:{“Time”:“00:00:08.5216072”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:08.5205065”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Task”}]},“Timer”:{“Time”:“00:00:08.5204462”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:00.8014936”},“Children”:[{“Mid”:25,“Timer”:{“Time”:“00:00:00.7410518”}},{“Mid”:34,“Timer”:{“Time”:“00:00:00.0594052”}}]},{“Mid”:241,“Timer”:{“Time”:“00:00:04.0038368”}},{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“246”}]},“Timer”:{“Time”:“00:00:03.7099334”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:03.6482426”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.9155212”}},{“Mid”:278,“Timer”:{“Time”:“00:00:02.7283033”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:02.7281632”},“Children”:}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Parties”},{“Pid”:21,“Value”:“06.12.42.688046”}]},“Timer”:{“Time”:“00:00:01.7890782”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:01.7881775”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Parties”}]},“Timer”:{“Time”:“00:00:01.7881222”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“263”}]},“Timer”:{“Time”:“00:00:01.7837591”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:01.7205926”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.4979399”}},{“Mid”:278,“Timer”:{“Time”:“00:00:01.2174216”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:01.2172777”},“Children”:}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Activities Log”},{“Pid”:21,“Value”:“06.12.42.573037”}]},“Timer”:{“Time”:“00:00:03.4245686”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:03.4214625”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Activities Log”}]},“Timer”:{“Time”:“00:00:03.4214047”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“467”}]},“Timer”:{“Time”:“00:00:03.3577184”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:03.2947858”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.4946824”}},{“Mid”:278,“Timer”:{“Time”:“00:00:02.7811090”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:02.7809390”},“Children”:}]}]}]},{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Activities Log_Schema”}]},“Timer”:{“Time”:“00:00:00.0632483”},“Children”:[{“Mid”:61,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Payee Address”}]},“Timer”:{“Time”:“00:00:00.0618532”}}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Authority”},{“Pid”:21,“Value”:“06.12.43.598411”}]},“Timer”:{“Time”:“00:00:02.6144121”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:02.6143453”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Authority”}]},“Timer”:{“Time”:“00:00:02.6142812”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“15”}]},“Timer”:{“Time”:“00:00:02.6139297”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:02.5541188”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.6755275”}},{“Mid”:278,“Timer”:{“Time”:“00:00:01.8779640”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:01.8778141”},“Children”:}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Checks”},{“Pid”:21,“Value”:“06.12.46.210184”}]},“Timer”:{“Time”:“00:00:00.2609997”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:00.2595759”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Checks”}]},“Timer”:{“Time”:“00:00:00.2595122”},“Children”:[{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Checks_Schema”}]},“Timer”:{“Time”:“00:00:00.2578897”},“Children”:[{“Mid”:61,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Payee Address”}]},“Timer”:{“Time”:“00:00:00.2575447”}}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Activities”},{“Pid”:21,“Value”:“06.12.35.072962”}]},“Timer”:{“Time”:“00:00:11.3994508”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:11.3957571”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Activities”}]},“Timer”:{“Time”:“00:00:11.3956893”},“Children”:[{“Mid”:28,“Timer”:{“Time”:“00:00:01.7755385”},“Children”:[{“Mid”:25,“Timer”:{“Time”:“00:00:01.7155401”}},{“Mid”:34,“Timer”:{“Time”:“00:00:00.0591312”}}]},{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“412”}]},“Timer”:{“Time”:“00:00:03.4881179”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:03.4208192”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.8081617”}},{“Mid”:278,“Timer”:{“Time”:“00:00:02.5941524”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:02.5939759”},“Children”:}]}]},{“Mid”:15,“Timer”:{“Time”:“00:00:00.0075716”}}]},{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Activities_Schema”}]},“Timer”:{“Time”:“00:00:06.1315982”},“Children”:[{“Mid”:221,“Timer”:{“Time”:“00:00:05.8822561”},“Children”:[{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Claim Link”}]},“Timer”:{“Time”:“00:00:02.8446808”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Claim Link”}]},“Timer”:{“Time”:“00:00:02.8446418”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:02.8445537”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Claim Link”}]},“Timer”:{“Time”:“00:00:02.8445219”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:02.8337111”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Claim”}]},“Timer”:{“Time”:“00:00:02.8336816”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“197”}]},“Timer”:{“Time”:“00:00:02.8305900”},“Children”:[{“Mid”:217,“Timer”:{“Time”:“00:00:02.8234388”}}]}]}]}]}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Company”}]},“Timer”:{“Time”:“00:00:00.0094229”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Company”}]},“Timer”:{“Time”:“00:00:00.0093866”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0093081”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Company”}]},“Timer”:{“Time”:“00:00:00.0092819”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Insured”}]},“Timer”:{“Time”:“00:00:00.0062034”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Insured”}]},“Timer”:{“Time”:“00:00:00.0061683”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0061072”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Insured”}]},“Timer”:{“Time”:“00:00:00.0060803”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Checks”}]},“Timer”:{“Time”:“00:00:02.6001605”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Checks”}]},“Timer”:{“Time”:“00:00:02.6001248”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:02.6000618”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Checks”}]},“Timer”:{“Time”:“00:00:02.6000284”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:02.5943024”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Checks”}]},“Timer”:{“Time”:“00:00:02.5942749”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“202”}]},“Timer”:{“Time”:“00:00:02.5940627”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:02.5331283”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.4799735”}},{“Mid”:278,“Timer”:{“Time”:“00:00:02.0490621”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:02.0489256”},“Children”:}]}]}]}]}]}]}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Role”}]},“Timer”:{“Time”:“00:00:00.4179246”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Role”}]},“Timer”:{“Time”:“00:00:00.4178836”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.4178152”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Role”}]},“Timer”:{“Time”:“00:00:00.4177761”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:00.4067934”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Authority”}]},“Timer”:{“Time”:“00:00:00.4067630”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“15”}]},“Timer”:{“Time”:“00:00:00.4065678”},“Children”:[{“Mid”:217,“Timer”:{“Time”:“00:00:00.4059333”}}]}]}]}]}]}]}]}]},{“Mid”:61,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Payee Address”}]},“Timer”:{“Time”:“00:00:00.2480032”}}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Coverage”},{“Pid”:21,“Value”:“06.12.44.479130”}]},“Timer”:{“Time”:“00:00:02.0143311”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:02.0130292”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Coverage”}]},“Timer”:{“Time”:“00:00:02.0129733”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“157”}]},“Timer”:{“Time”:“00:00:01.6469455”},“Children”:[{“Mid”:217,“Timer”:{“Time”:“00:00:01.6365650”}}]},{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Coverage_Schema”}]},“Timer”:{“Time”:“00:00:00.3630779”},“Children”:[{“Mid”:221,“Timer”:{“Time”:“00:00:00.3626672”},“Children”:[{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Exp Payment”}]},“Timer”:{“Time”:“00:00:00.0151494”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Exp Payment”}]},“Timer”:{“Time”:“00:00:00.0151187”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0150390”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Exp Payment”}]},“Timer”:{“Time”:“00:00:00.0150041”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:00.0089993”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Activities”}]},“Timer”:{“Time”:“00:00:00.0089673”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“412”}]},“Timer”:{“Time”:“00:00:00.0085799”},“Children”:}]}]}]}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Exp Reserve”}]},“Timer”:{“Time”:“00:00:00.0167861”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Exp Reserve”}]},“Timer”:{“Time”:“00:00:00.0167501”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0166580”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Exp Reserve”}]},“Timer”:{“Time”:“00:00:00.0166292”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Ind Payment”}]},“Timer”:{“Time”:“00:00:00.0056683”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Ind Payment”}]},“Timer”:{“Time”:“00:00:00.0056379”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0055666”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Ind Payment”}]},“Timer”:{“Time”:“00:00:00.0055388”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Ind Reserve”}]},“Timer”:{“Time”:“00:00:00.0170361”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Ind Reserve”}]},“Timer”:{“Time”:“00:00:00.0169996”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0169172”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Ind Reserve”}]},“Timer”:{“Time”:“00:00:00.0168876”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Leg Reserve”}]},“Timer”:{“Time”:“00:00:00.0204505”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Leg Reserve”}]},“Timer”:{“Time”:“00:00:00.0204170”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0203432”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Leg Reserve”}]},“Timer”:{“Time”:“00:00:00.0203112”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Rec Payment”}]},“Timer”:{“Time”:“00:00:00.0071097”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Rec Payment”}]},“Timer”:{“Time”:“00:00:00.0070764”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0069907”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Rec Payment”}]},“Timer”:{“Time”:“00:00:00.0069646”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Rec Reserve”}]},“Timer”:{“Time”:“00:00:00.2443734”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Rec Reserve”}]},“Timer”:{“Time”:“00:00:00.2443368”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.2442615”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Rec Reserve”}]},“Timer”:{“Time”:“00:00:00.2442290”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Reserves”}]},“Timer”:{“Time”:“00:00:00.0125238”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Reserves”}]},“Timer”:{“Time”:“00:00:00.0124919”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0124229”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Reserves”}]},“Timer”:{“Time”:“00:00:00.0123958”}}]}]}]},{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Activities”}]},“Timer”:{“Time”:“00:00:00.0051176”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Activities”}]},“Timer”:{“Time”:“00:00:00.0050872”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0050338”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Activities”}]},“Timer”:{“Time”:“00:00:00.0050081”},“Children”:}]}]}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Policy”},{“Pid”:21,“Value”:“06.12.46.495204”}]},“Timer”:{“Time”:“00:00:00.0829426”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:00.0816327”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Policy”}]},“Timer”:{“Time”:“00:00:00.0815828”},“Children”:[{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“Policy_Schema”}]},“Timer”:{“Time”:“00:00:00.0776412”},“Children”:[{“Mid”:221,“Timer”:{“Time”:“00:00:00.0105018”},“Children”:[{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Risks”}]},“Timer”:{“Time”:“00:00:00.0096526”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Risks”}]},“Timer”:{“Time”:“00:00:00.0096212”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0095678”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Risks”}]},“Timer”:{“Time”:“00:00:00.0095399”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:},“Timer”:{“Time”:“00:00:00.0059298”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Risk”}]},“Timer”:{“Time”:“00:00:00.0059054”},“Children”:}]}]}]}]}]}]},{“Mid”:61,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Address”}]},“Timer”:{“Time”:“00:00:00.0662974”}}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Authority Log”},{“Pid”:21,“Value”:“06.12.46.470152”}]},“Timer”:{“Time”:“00:00:00.4379831”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:00.4379455”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Authority Log”}]},“Timer”:{“Time”:“00:00:00.4378609”},“Children”:[{“Mid”:33,“Timer”:{“Time”:“00:00:00.4374304”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:00.3781395”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.3776741”}}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“State”},{“Pid”:21,“Value”:“06.12.46.001063”}]},“Timer”:{“Time”:“00:00:02.3607741”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:02.3606267”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“State”}]},“Timer”:{“Time”:“00:00:02.3605669”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“51”}]},“Timer”:{“Time”:“00:00:02.3512846”},“Children”:[{“Mid”:133,“Timer”:{“Time”:“00:00:02.2912436”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.4990853”}},{“Mid”:278,“Timer”:{“Time”:“00:00:01.7917801”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:01.7916650”},“Children”:}]}]}]},{“Mid”:24,“Params”:{“ParamList”:[{“Pid”:10,“Value”:“State_Schema”}]},“Timer”:{“Time”:“00:00:00.0090520”},“Children”:[{“Mid”:221,“Timer”:{“Time”:“00:00:00.0089509”},“Children”:[{“Mid”:222,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Report Requests”}]},“Timer”:{“Time”:“00:00:00.0058147”},“Children”:[{“Mid”:18,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Report Requests”}]},“Timer”:{“Time”:“00:00:00.0057837”},“Children”:[{“Mid”:253,“Timer”:{“Time”:“00:00:00.0057267”},“Children”:[{“Mid”:380,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“Related Report Requests”}]},“Timer”:{“Time”:“00:00:00.0056973”},“Children”:}]}]}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Coverage List”},{“Pid”:21,“Value”:“06.12.46.910184”}]},“Timer”:{“Time”:“00:00:02.6166256”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:02.6164438”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Coverage List”}]},“Timer”:{“Time”:“00:00:02.6163640”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“89”}]},“Timer”:{“Time”:“00:00:02.6160292”},“Children”:[{“Mid”:30,“Params”:{“ParamList”:[{“Pid”:12,“Value”:“Absent”},{“Pid”:11,“Value”:“SpecialtyClaims2-655816:1.001225:Coverage ListSHAREPOINT_SITE_ID_rockinghamgroup.sharepoint.com_f7d03497-75fb-411a-a3fe-047858d78aa4_4821a462-171e-4c8e-a797-c86cb0b11ce0//Specialty Claims//Specialty Claims.xlsxCoverage List-655816”}]},“Timer”:{“Time”:“00:00:00.0597638”}},{“Mid”:133,“Timer”:{“Time”:“00:00:02.4962162”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getDriveItem”}]},“Timer”:{“Time”:“00:00:00.4997607”}},{“Mid”:278,“Timer”:{“Time”:“00:00:01.9959190”},“Children”:[{“Mid”:282,“Params”:{“ParamList”:[{“Pid”:16,“Value”:“getSheetUsedRange”}]},“Timer”:{“Time”:“00:00:01.9958008”},“Children”:}]}]}]}]}]}]},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Notes”},{“Pid”:21,“Value”:“06.12.46.475155”}]},“Timer”:{“Time”:“00:00:04.9045891”},“Children”:[{“Mid”:66,“Timer”:{“Time”:“00:00:04.8863247”},“Children”:[{“Mid”:32,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Notes”}]},“Timer”:{“Time”:“00:00:04.8862690”},“Children”:[{“Mid”:33,“Params”:{“ParamList”:[{“Pid”:9,“Value”:“2982”}]},“Timer”:{“Time”:“00:00:04.8722865”},“Children”:[{“Mid”:133,“Timer”:

0 2 427
2 REPLIES 2

Steve
Platinum 5
Platinum 5

You’ll probably want to engage support@appsheet.com directly for help with this.

The only thing I can offer is to note that if AppSheet is using an Excel file, nobody else may also be using it:

With Office 365, if a user has the spreadsheet open for editing, other users and third-party apps like AppSheet can’t make updates to the spreadsheet. Consequently, if you intend to build an app that updates the data (as most apps do!), please make sure to close the spreadsheet first. Otherwise, you’ll see conflict (“409”) error messages and the app won’t be able to save changes to the spreadsheet.

Thanks for the help Steve. I will work with AppSheet Support. Interesting documentation about the spreadsheet being open for editing and other users not being able to update, because I have seen it work while open and others using the app, including myself doing both. In fact, that is how I did a lot of testing of the app early on. We are working to get the data moved to a SQL Server database, but need to figure out the SSL piece first. Thanks.

Kevin

Top Labels in this Space