Audit log shows success but row is not saved in Postgresql

AppSheet AppSheet Q&A
, ,
1

Hi,

I’m having an issue where my edited row is not updated on my table in Google Cloud’s Postrgresql but the audit log shows ‘success’ on that row. Has anyone experienced this? This problem occurs once or twice a day which is very annoying.

{ "UserId": "", "EventTableName": null, "EventTimeStamp": "2026-05-11T12:06:42.8207946+00:00", "Data": \[ "7641", "", "", "", "", "7", "N", "2", "", "", "S", "", "", "", "2", "2", "", "05/11/2026 19:06:24" \], "Operation": "Edit row", "Properties": { "TableName": "sale_order_line", "tzOffset": "-420", "apiLevel": "2", "isPreview": "false", "checkCache": "true", "locale": "th-TH", "appTemplateVersion": "1.001482", "localVersion": "1.001482", "timestamp": "2026-05-11T12:06:43.313Z", "requestStartTime": "2026-05-11T12:06:43.559Z", "lastSyncTime": "2026-05-11T12:06:36.6906966Z", "appStartTime": "2026-05-11T12:02:12.463Z", "dataStamp": "2026-05-11T12:06:43.369Z", "clientId": "", "build": "", "requestId": "48049009", "AppTemplateVersion": "1.001482", "RowSize": 289, "AppTemplateName": "", "Operation": "Edit row", "RecordType": "Start" }, "RecordType": "Start", "Result": "", "TableName": "sale_order_line", "Timestamp": "2026-05-11T12:06:42.8207946+00:00" }, { "UserId": "", "EventTableName": null, "EventTimeStamp": "2026-05-11T12:06:42.8207946+00:00", "Data": null, "Operation": "Edit row", "Properties": { "TableName": "sale_order_line", "tzOffset": "-420", "apiLevel": "2", "isPreview": "false", "checkCache": "true", "locale": "th-TH", "appTemplateVersion": "1.001482", "localVersion": "1.001482", "timestamp": "2026-05-11T12:06:43.313Z", "requestStartTime": "2026-05-11T12:06:43.559Z", "lastSyncTime": "2026-05-11T12:06:36.6906966Z", "appStartTime": "2026-05-11T12:02:12.463Z", "dataStamp": "2026-05-11T12:06:43.369Z", "clientId": "", "build": "", "requestId": "48049009", "AppTemplateVersion": "1.001482", "RowSize": 289, "AppTemplateName": "", "Operation": "Edit row", "RecordType": "Stop", "ReturnedFromCache": true, "Result": "Success" }, "RecordType": "Stop", "Result": "Success", "TableName": "sale_order_line", "Timestamp": "2026-05-11T12:06:42.8207946+00:00" }
2

I have not experienced such an issue in a Big Query database.

In your row example, which column was changed and from what old value to what new value?

You may need to check the database side for errors. Make sure the column types match well enough.

3

One of the columns were edited from 1 to 2. This issue randomly happens around 1-2 times per day. So I don’t think it’s about the column types (otherwise it’d happen with every row?). Last resort is the check database side for errors as you suggested, which I don’t know how. The Google Cloud console requires a lot of expertise in my opinion.

4

You definitely need to look at the database side.

5

I agree IF that column is being edited on every row change. But if the particular column is only edited a couple times a day, that could explain the problem!

Could you show your AppSheet table definitions and database side definitions just to rule out that as a potential issue???

6

Here’s my Appsheet table definitions:
_RowNumber
[Number]
uuid
[Text]
sale_order_uuid
[Ref]
product_uuid
[Enum]
lot_uuid
[Enum]
available_qty
[Decimal]
set
[Yes/No]
total_qty
[Decimal]
total_value_vat_in
[Price]
uom_uuid
[Enum]
size
[Text]
print_content
[Text]
sale_order_line_uuid
[Enum]
value_vat_in
[Price]
qty
[Decimal]
sequence
[Number]
state
[Text]
create_date_time
[DateTime]

And here’s my table definitions in Postgresql:

image
image1002×1094 63.8 KB

Btw, I also have this issue with Add operations on this table. And it happens randomly. Now I’m trying to figure out how to check the log in database as you and @Steve suggested (hoping the Gemini Cloud Assist could help me with this one).

7

How are you generating all the UUID’s in AppSheet? Be aware that UUID accommodates ONLY hexadecimal characters 0-9 and a-f (or A-F).

I assume your character varying types DO NOT specify maximum lengths?? If they do, it’s possible you are hitting “maximum length reached” errors.

I don’t see anything else inherently problematic as far as types. Your Qty columns should probably be Integer types (unless you can have partial counts) for efficiency sake but using Numeric is not likely an issue.

8

I’m using LOWER(UNIQUEID(“uuid”)) to generate the uuid.

I talked to the Appsheet support 2 days ago and he suggested I turned off ‘Quick Sync’. The issue hasn’t occurred since then. Not sure if this really fixes the problem or just coincidence. Will monitor for the next few days and update you guys.