hey all - What would be a possible reason for a s...
# generalj
Jessica Bickis
05/30/2023, 2:52 PMhey all - What would be a possible reason for a saved search that is used multiple times a day for the last 4 months to suddenly just spin and never load?
t
Tim Chapman
05/30/2023, 2:54 PMHave you re-created the search and ran that one?
j
Jessica Bickis
05/30/2023, 2:56 PMWe have, some result. Just spinning and not loading. I have also tried SAVE & EMAIL, but still haven't received the email. It has been about 6 minutes.
Jessica Bickis
05/30/2023, 2:57 PMNo changes to the search since Feb, but just starting last Friday it just won't load.
j
James Morris
05/30/2023, 3:02 PMI have one other user reporting similar FWIW. Possibly a larger issues.
James Morris
05/30/2023, 3:02 PMmight want to post in #C29GDT351 and see if anyone else is getting the same, along with logging a support case
👍 1
James Morris
05/30/2023, 3:04 PMseems to be okay for me though, so 🤷♂️
j
Jessica Bickis
05/30/2023, 3:04 PMYeah, I can load the search -- sometimes! Just not today so I can get a load breakdown from the Oracle logo
k
KevinJ of Kansas
05/30/2023, 3:11 PMIt's possible you've got a record that's triggering the time out - some criteria/results that cause it to spin
KevinJ of Kansas
05/30/2023, 3:12 PMSomething that is causing a divide by zero error in the middle of the process somewhere for example
KevinJ of Kansas
05/30/2023, 3:13 PMYou also could have exceeded the volume threshold where it's just finally struggling to return results effectively. I'd try narrowing down what records should be returned to see if you can identify any of those issues
r
RJMNS
05/30/2023, 4:00 PMDoes it have a lot of columns? I'm not aware of a stated limited anywhere, but I've noticed that at a certain point, searches with a lot of columns will sometimes not load properly, even if there's not a high number of lines.
r
raghav
05/30/2023, 4:22 PMOne time i updated either the field name or field internal id don't remember exactly.
The search was giving a similar type of issue.
k
KevinJ of Kansas
05/30/2023, 7:31 PMYeah, updates to field internal IDs cause bad juju for searches
KevinJ of Kansas
05/30/2023, 7:32 PMWhat's really fun is when you fix a field ID for a spelling error and then still have to rebuild the whole search because it just won't recognize that the internal ID of a field was changed
👀 1