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

(John Henry Joseph) #1

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.

(Reza Raoofi) #2

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

(Praveen Seshadri (AppSheet)) #3

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.

(Praveen Seshadri (AppSheet)) #4

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 Joseph) #5

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

(Praveen Seshadri (AppSheet)) #6

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.

(Praveen Seshadri (AppSheet)) #7

“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?

(Praveen Seshadri (AppSheet)) #8

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 Joseph) #9

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

(Philip Garrett) #10

@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 Joseph) #11

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

(Philip Garrett) #12

@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 Joseph) #13

@praveen My App detail AccountPlus-562817-542402

  • Kindly check and let me know please… Sample mobile apps for common scenarios appsheet.com
(Oscar Vila) #14

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

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

(Philip Garrett) #15

@Oscar_Vila

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

(Praveen Seshadri (AppSheet)) #16

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 Joseph) #17

@praveen Yes please…

(Praveen Seshadri (AppSheet)) #18

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 Joseph) #19

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

(John Henry Joseph) #20

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