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

Account_Team · 10-12-2018 05:00 PM

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.

Phil

+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

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

Account_Team

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

Account_Team

Account_Team

Account_Team

Account_Team

Could you give me more advice?

Aleksi_Alkio

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

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

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

Account_Team

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

Aleksi_Alkio

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

It says “Server Error”.

Aleksi_Alkio

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

Account_Team

What about the app version?

Account_Team

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

Account_Team

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

Aleksi_Alkio

Please answer this question first…

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