I have a synced record with a database table. I can successfully write new data to the table using the "import excel to database" within a process model. Unfortunately, after uploading new data the synced record is not updating. If I manually sync the record it will update correctly. How do I ensure the data is synced when I upload new data?
According to Appian Documentation the record is suppose to automatically sync: "To keep your synced data up-to-date with the source, an immediate sync occurs whenever Appian writes to the source of your data."
https://docs.appian.com/suite/help/21.2/Records_Monitoring_Details.html
Additionally, I've confirmed that Sync is enabled:
Any thoughts or suggestions is appreciated.
Thanks!
Discussion posts and replies are publicly visible
Please try Activity chaining in the process models. Maybe the data is not reflected due to asynchronous processes. This also happens with me sometimes. try it
Records get automatically updated when using the write to data store nodes/functions. That plugin is going directly to DB by-passing this mechanism.
Is it possible to NOT sync that record?
we can turn off the sync from the record type settings. if we don't want to sync it automatically
Confirmed Activity chaining is turned on. No luck so far. thanks for the quick reply!
I know that. My question is: Why is that records synced and would that chosen design work without it.
Got it, thanks! fortunately I can re-work the design to not depend on the table updated by the "import excel to database". Earlier in the process we use the "Write to Datastore" function and I was able to use this as the record source.