Hello, I've been facing this same problem in ...

(Account Team) #1

Hello, I’ve been facing this same problem in a week. My app doesn’t load successfully and it keeps saying “Server Error”. I try to figure out on the Communities and also on Appsheet Documentation but I still can’t find any solution. Every time both I and my users press the sync button It appears the same. I don’t know what if I configure it wrong or about the Appsheet server or about Google Drive server. Could please anyone help me, please? Thank in advance.

(Philip Garrett) #2

+Bunthy Poch

I searched the Audit History for this app for the past 7 days.

I found a large number of successful syncs.

I found the following 10 errors over the past 7 days. All times are in UTC.

UserId: 746736, EventTimeStamp: 10/13/2018 6:33:53 AM +00:00 Failed to read data ‘Officetask-745033:1.000134:ព្រីកុងតាក់’ because: File not found: 10uRSVxlrlOQLQU-IC6L0cXz2MyCDHwE_

UserId: 746736, EventTimeStamp: 10/13/2018 6:25:25 AM +00 00 Failed to read data ‘Officetask-745033:1.000134:ទម្រង់ស្នើរសុំ’ because: File not found: 1vnxqa1ppMnrkspUkAO1xW4_8fS3xXHek

UserId: 746736, EventTimeStamp: 10/13/2018 6:22:47 AM Failed to read data ‘Officetask-745033:1.000134:ទម្រង់ស្នើរសុំ’ because: File not found: 1vnxqa1ppMnrkspUkAO1xW4_8fS3xXHek

UserId: 745033, EventTimeStamp: 10/12/2018 10:55:42 AM +00:00 The spreadsheet for ‘Officetask-745033:1.000095:បញ្ជីបើកប្រាក់ មុនៗ’ cannot be read due to error: Expected worksheet ‘បញ្ជីបើកប្រាក់ មុនៗ’ not found. Error: The table Officetask-745033:1.000095:បញ្ជីបើកប្រាក់ មុនៗ is not available Error: Data table ‘បញ្ជីបើកប្រាក់ មុនៗ’ is either inaccessible or empty.’

UserId: 745033, EventTimeStamp: 10/12/2018 10:55:12 AM +00 00 The spreadsheet for ‘Officetask-745033:1.000095:បញ្ជីបើកប្រាក់ មុនៗ’ cannot be read due to error: Expected worksheet ‘បញ្ជីបើកប្រាក់ មុនៗ’ not found. Error: The table Officetask-745033:1.000095:បញ្ជីបើកប្រាក់ មុនៗ is not available Error: Data table ‘បញ្ជីបើកប្រាក់ មុនៗ’ is either inaccessible or empty.’

UserId: 745033, EventTimeStamp: 10/12/2018 10:25:27 AM +00:00 The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ មហ’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករសំណង់ មហ’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ មហ is not available Error: Data table ‘បញ្ជីកម្មករសំណង់ មហ’ is either inaccessible or empty.’

UserId: 745033, EventTimeStamp: 10/12/2018 10:25:26 AM +00 00 The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង មហ’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករទឹកភ្លើង មហ’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង មហ is not available Error: Data table ‘បញ្ជីកម្មករទឹកភ្លើង មហ’ is either inaccessible or empty.’

UserId: 745033, EventTimeStamp: 10/12/2018 10:25:26 AM +00 00 The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ សម’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករសំណង់ សម’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ សម is not available Error: Data table ‘បញ្ជីកម្មករសំណង់ សម’ is either inaccessible or empty.’

UserId: 745033, EventTimeStamp: 10/12/2018 10:25:25 AM +00 00 ‘Error: The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង សម’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករទឹកភ្លើង សម’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង សម is not available Error: Data table ‘បញ្ជីកម្មករទឹកភ្លើង សម’ is either inaccessible or empty.’

UserId: 745033, EventTimeStamp: 10/12/2018 10:24:43 AM +00 00 ‘Error: The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ មហ’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករសំណង់ មហ’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ មហ is not available Error: Data table ‘បញ្ជីកម្មករសំណង់ មហ’ is either inaccessible or empty. Error: The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង មហ’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករទឹកភ្លើង មហ’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង មហ is not available Error: Data table ‘បញ្ជីកម្មករទឹកភ្លើង មហ’ is either inaccessible or empty. Error: The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ សម’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករសំណង់ សម’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករសំណង់ សម is not available Error: Data table ‘បញ្ជីកម្មករសំណង់ សម’ is either inaccessible or empty. Error: The spreadsheet for ‘Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង សម’ cannot be read due to error: Expected worksheet ‘បញ្ជីកម្មករទឹកភ្លើង សម’ not found. Error: The table Officetask-745033:1.000089:បញ្ជីកម្មករទឹកភ្លើង សម is not available Error: Data table ‘បញ្ជីកម្មករទឹកភ្លើង សម’ is either inaccessible or empty.’

Several of the error messages indicate that worksheet could not be found. This seems to be happening intermittently, which is hard to explain. Are you doing anything to the Google worksheet directly that might be affecting it?

I ask because the problem seems to be very intermittent and limited to your app. No other customer is reporting a similar error with Google sheets. Goole is by far the most popular data store, so I think if this were a common problem other would be reporting it.

Translate

(Aleksi Alkio) #3

What is the account ID and the app name if I check the app?

(Account Team) #4

Ohh thank godness for the help. My account ID: 745033 App Name: Officetask745033

(Account Team) #5
(Account Team) #6
(Account Team) #7
(Account Team) #8

Could you give me more advice?

(Aleksi Alkio) #9

Does this happen every time when you press “sync” or just now and then? Does this happen for all users or just for you?

(Account Team) #10

This happens around a week for me and my users. After we press the sync button it say Server Error and when I hold long press down on some pages it appears a dot-circle and then it show the last image I sent you.

(Aleksi Alkio) #11

Is it possible that the XLS-file is open (someone hasn’t closed it)

(Account Team) #12

Excuse me, have you found any problem or info? Please tell me. Thanks.

(Aleksi Alkio) #13

Do you mean that the sync error will happen every time when you said “Every time both I and my users press the sync button It appears the same.”?

(Account Team) #14

It says “Server Error”.

(Aleksi Alkio) #15

But does this happen every time when you press “Sync”?

(Account Team) #16

What about the app version?

(Account Team) #17

Do I have to change it every time I update any columns structures in any tables?

(Account Team) #18

If I never update the version of the app after changing many time, what happens?

(Aleksi Alkio) #19

Please answer this question first…

But does this happen every time when you press “Sync”?