Skip to Content (Press Enter)
2022-12-29 17-06-22
Sunil Mane
23Views
2Comments
Update Master Data during users are working on the Live application
Question
Cache
Architecture
Best Practices
Component
Data
Traditional Web
Service
Application Type
Traditional Web, Service
Service Studio Version
11.54.52 (Build 63199)
Platform Version
11.27.0 (Build 42539)

Hi,

We need to update master data when actual users are using the application due to limited downtime in the application. 


Please help to suggest the approach.

1
1
26 Mar 2024
Copy Link
2019-10-24 21-01-44
Jay Parnau
Staff

Can you please elaborate on the use case and what the ideal outcome would be?

0
0
27 Mar 2024
Copy Link
2019-10-24 21-01-44
Jay Parnau
Staff

This is a database problem that is not unique to OutSystems. 

Inserts should not be a problem, but updates can be. 

Without using advanced SQL, the only thing you can do in OutSystems is to utilize the GetForUpdate operation with error handling. 

This will ensure that you have a record that is not being updated, and lock it during the transaction.

This is explained in detail in this article:

https://success.outsystems.com/documentation/how_to_guides/data/how_to_handle_concurrent_updates_on_application_data_records/?_gl=1*n0v392*_ga*MTk3MzU3NDE3NC4xNjk1OTE3NjQ0*_ga_ZD4DTMHWR2*MTcxMTYzOTE4Mi4xMy4xLjE3MTE2MzkyMzIuMTAuMC4w


0
0
28 Mar 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.