Service Issues?
I have multiple users reporting pages not loading, spinning circles while pages trying to load, 502 errors, etc. Is anyone else experiencing issues?
@EvanMartinez ---------------------------...
Forum Discussion
This is impacting multiple apps. In fact I cannot even open apps from My Apps. I get a 502 Error when trying to open an app.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
Hi Paul,
You should definitely put in a case with our Tech Support team and let them know the apps impacted so they can dig into what you are experiencing. They can pull up more performance specifics.
------------------------------
Evan Martinez
------------------------------
You should definitely put in a case with our Tech Support team and let them know the apps impacted so they can dig into what you are experiencing. They can pull up more performance specifics.
------------------------------
Evan Martinez
------------------------------
- The issue was identified to be a formula query field in one app. Whenever I try to save the field every app on the realm goes down for several minutes. The code I used was presented in a workshop in the 2021 Empower. All I changed were the field names and numbers. It worries me that 1 field can take down an entire realm.
------------------------------
Paul Peterson
------------------------------- MarkShnier__You
Qrew Legend
Formula Queries on large data sets can take down an app. How many records were involved and what was the nature of the Query.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- I understand the possibility of taking down an APP, but am very concerned that it took down the entire realm. The table being queried has just over 263k records, 43 fields per record, taking up about 18 MB. In the same workshop that presented the code I used they queried a dataset of over 300k records in a fraction of a second.
The query was: SearchAndReplace(ToText(GetFieldValues(GetRecords("{'31'.GT.0}", $tableID), 77)), "> ; <", "><")
The overall function of the field is to generate a dynamic HTML table in a rich text field.
------------------------------
Paul Peterson
------------------------------
