What is this error about? My app was working...

[John_Henry_Jose]

What is this error about?

My app was working great. however, today morning, this error appears

“There are multiple root elements. Line 1, Position 28”

It doesn’t refer any table or column.

Please help me out in this regard.

[RezaRaoofi]

Do you get any more details if you click on more info?

[pravse]

That looks like a corrupt spreadsheet file error. If you give us the name of the app (with the user id suffix), we can try to see if the problem reproduces.

Assuming you are using a Google Sheet, open it directly, use the menu to export it into Excel (xlsx) format and see if it does that correctly. I suspect this may be a bug in the way Google Sheets does that export. We utilize that mechanism to extract the column structure, etc.

We have seen a few such errors in the last couple of days — I think Google may have done a software release. Each time that happens, a few edge-case bugs are detected.

[pravse]

It’s not bugs in your data. I had a response earlier in this thread where I requested that you try to export your Google sheet into Excel format to see if that exports correctly.

In your app’s security -> security filters tab, change all the tables to be accessed ‘As App Creator’. That will let me check it. I still cannot directly open your spreadsheet, so it will just help me confirm that the problem is in your Google sheet.

[John_Henry_Jose]

@praveen Yes. I exported the data into excel format and went successfully. Besides, I changed all tables as “As App Creator”.

[pravse]

ok, it looks like the problem is with the email template document used as the attachment template in one of your workflow rules. It only shows when you “Save & Verify Data” — this is a clue that the problem is not in the spreadsheet but in one of the auxillary inputs. The error message is misleading and we will put in a better message to help with this in the future. In your case, the error message should be: Workflow rule ‘Detailed Balance Sheet’ field ‘Attachment’ template could not be loaded due to exception: There are multiple root elements. Line 1, position 28.

[pravse]

“Multiple root elements” is still an arcane error message. It means there is something wrong with that attachment template. Perhaps it isn’t a valid Google Doc?

[pravse]

Actually, here are all the errors: Workflow rule ‘Detailed Balance Sheet’ field ‘Attachment’ template could not be loaded due to exception: There are multiple root elements. Line 1, position 28.MORE INFO Workflow rule ‘Detailed Balance Sheet’ field ‘Body’ template could not be loaded due to exception: There are multiple root elements. Line 1, position 27.MORE INFO Workflow rule ‘Ledger’ field ‘Attachment’ template could not be loaded due to exception: There are multiple root elements. Line 1, position 27.MORE INFO Workflow rule ‘Ledger’ field ‘Body’ template could not be loaded due to exception: There are multiple root elements. Line 1, position 27.MORE INFO Workflow rule ‘Income & Expenses Account’ field ‘Body’ template could not be loaded due to exception: There are multiple root elements. Line 1, position 29.MORE INFO

[John_Henry_Jose]

@praveen Thanks lot Mr. Praveen. What I understand is that my Google Doc template having some errors. Let me work on it. Thanks once again.

[Phil]

@Oscar_Vila

The problem that Oscar reported was the result of a change that I made recently to fix a problem reported by another user. When I attempted to fix that user’s problem, I introduced the problem Oscar reported.

I have attempted to fix the problem Oscar reported. If testing goes well, that change will be released on Wednesday afternoon Jan 16, 2019.

@John_Henry_Joseph

I think it is very likely that you are seeing the same problem that Oscar reported. I attempted to test your app but I was not successful in reproducing the problem using your app. As a result,

I am not certain if my fix will resolve the problem that you reported.

If you can get your application into the state where the problem occurs, I am happy to test it for you. Please let me know the app name and the workflow rule name that is having the problem. Alternatively, you can wait until my change is deployed on Wednesday afternoon and see if that change resolves the problem.

[John_Henry_Jose]

@Philip_Garrett_Appsh @praveen @Oscar_Vila As advised by Mr. Praveen, i removed all my workflow and its templates, then i dont find that error. Now i am creating workflows one by one. Fortunately i haven’t come across that error state yet.

But i doubt is that since we have 10+ applications and all apps are having numerous workflows, I got this error in this app only. Still i need to add few more workflow templates, let me check.

[Phil]

@John_Henry_Joseph

I strongly suspect that all of your workflow rules and templates were correct and remain correct. The bug I introduced was reporting a spurious error.

[John_Henry_Jose]

@praveen My App detail AccountPlus-562817-542402

• Kindly check and let me know please… Sample mobile apps for common scenarios appsheet.com

[Oscar_Vila]

Philip Garrett, Thanks for having identified and fixed the issue so quickly.

FYI, my reports are back again as usual Great job!

[Phil]

@Oscar_Vila

Thanks for letting me know your reports are working again. Sorry for the disruption.

[pravse]

Because the app is using “Run as App User” in the security filters section, I cannot read the data. Are you sure you want to enable that option? It is very rarely used

[John_Henry_Jose]

@praveen Yes please…

[pravse]

Well, the problem in that case is that I am denied access before I can hit the problem you are seeing. Please see my earlier response about exporting the sheet to Excel format and testing to see if there are errors. That is likely to be the root of the problem. It is past midnight here, so I’m off to bed. Will check this thread in the morning.

[John_Henry_Jose]

My apologies Mr. Praveen. Thanks for your prompt response.

[John_Henry_Jose]

@praveen Can you find the problem in my app please?

[pravse]

Did you check if it is a Google spreadsheet bug, as I suggested?

Because of your security settings, I am unable to open and check your app

[John_Henry_Jose]

@praveen Sorry. I dont find any bugs in my data…please guide me to change my security settings so that you can check my app.

[Oscar_Vila]

Hi Praveen Seshadri

You are doing an excellent with Appsheet!

Following the “multiple root elements” error reported by John Henry Joseph a few days ago, I can confirm that some portion of my workflow reports (i.e.: “ExpensesReport_Submited”) have stopped working too.

It happened less than a week ago on several of my test apps such as the “Service-91404”.

Is there any work around on recommendation on what is wrong and how to fix it on our side?

This is the error message I can recover at the “Audit history records” after the issue arises and tries to fill the fields on my template doc within google drive:

Error: Workflow rule ‘ExpensesReport_Submited’ field ‘Body’ template could not be loaded due to exception:

There are multiple root elements.

Line 1, position 33."

FYI, I’ve followed your recommendations in regard to “Security Filter” for all tables set “as app creator”.