Is there an Issue with POST requests to start queries and subsequently with GET requests to check when the query is finished?
Hi everyone,
I'm building an internal app to score records for data hygiene. My process involves sending a POST request to start a query and then polling for the result every 30 seconds.
The Issue: Up until last week, this worked fine. Now, the queries are getting stuck. When I run the same query manually in Database View or Web View, it finishes in about a minute. However, via the API, I've waited over 29 minutes (58+ checks) only to keep receiving a "status": "Running" response.
Troubleshooting done:
- Isolated the API call into a standalone test script; the issue persists.
- Confirmed the query size hasn't changed significantly.
Has anyone else experienced the SKY API "hanging" on queries lately, or is there a known issue with the asynchronous processing queue?
Any insight would be appreciated!
Best,
Matthew
Edits:
Im working with the RE endpoints.
Im checking for pending, running and completed status, any other status printed into the console as is.
Edit 2:
I believe its query complexity, Im going to split them into a couple and see how it goes givent the fact that the other 2 queries are running just fine but the main one i need ran for 50 minutes of checks every 30 secconds before i cancelled it.
Ill figure it out thanks guys
Answers
-
Hi @Matt Woodward I moved this over to Sky Developer for more eyes! Thanks!
1 -
Hey Matt. What's the query size you are working with? Does it happen with any other queries? I wonder if you were to recreate it if it would continue to have an issue? Any chance you are hitting any quota limits? Happy to help out if you want to reach out.
0 -
The query is on the larger side, but it’s nothing the system hasn't handled before. I’ve already tried recreating it, and I've got checks in place for rate limits and quotas, so I’m definitely not hitting a wall there. Two weeks ago, my system was knocking out both queries, similar sizes in 5 minutes flat. Now, one of them just sits there for 30 minutes before failing.
Since the code hasn't changed, I'm wondering if something shifted on the backend.
0 -
@Matt Woodward Hmmm. I figured as much. Have you tried it exclusively in the Try It pages?
I'm not seeing any breaking changes and I haven't experienced the same issue myself.
Tagging @Stephen Boyle
0 -
@Nick Marchese, Is this the Education Core API List endpoints, or the RE endpoints?
0 -
the question is really about how "complex" your query is. Understands that API querying is similiar to webview/dbview querying logic. a complex query that cross many different many-to-many relationship can take a long time and that long time can "cause" an abort.
That said, do you have the query's critiera, output, and sort screenshot?
Also, are you only checking for completed status or you are checking for these too?
- Pending - The job has been queued but has not yet started running.
- Running - The job is running.
- Completed - The job successfully completed.
- Failed - The job failed.
- Cancelling - Job cancellation has been requested. The job may still complete successfully from this state.
- Cancelled - The job was cancelled.
- Throttled - The job has been throttled. The job will run when space is available.
0 -
It sounds to me like @Matt Woodward is working with the RE Endpoints.
0 -
I have done and i get the same issue. Ive tried rebuilding the test code to see if ive made made an error. Im also glad to find the Preview cancel jobi endpoint.
0 -
What is the request body? Are you using Synchronous? If not you should try that ux_mode instead and poll under 10 seconds to troubleshoot.
0
Categories
- All Categories
- 1 Blackbaud Agents for Good™
- Raiser's Edge NXT test
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 403 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 16 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 661 Blackbaud Grantmaking™
- 583 Blackbaud Education Management Solutions for Higher Education
- 3.3K Blackbaud Education Management Solutions for K-12 Schools
- 947 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.8K Blackbaud Raiser's Edge NXT®
- 3.8K SKY Developer
- 251 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 243 Member Lounge (Just for Fun)
- 37 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Closed) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 804 Community News
- 3K Jobs Board
- 57 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)



