Query Export Failing with Date Fields Included
Multiple query exports of different types have been consistently getting errors over the past week. When Date To and Date From fields are removed, they start working again. All of the queries we had issues with were resolved when the Date To and Date From fields were removed. Does anyone know why these critical fields are not supported? Has anyone had similar experiences? Failed query exports include Address, Assigned Solicitor, Constituent Code, Fund Relationship, Individual Relationship, Non-Constituent Individual Address, Organization Relationship.
Comments
-
@Amelia Ketzle
are you talking about using database view Query to export, or Export to export?1 -
@Amelia Ketzle
I just tried Query to exportconstituent query, constituent code from date not blank and output the code, from and to date, no problem.
maybe a few screenshot will help and the error message
1 -
@Amelia Ketzle Do you have any of the wordings from the error messages that you're seeing? That might help.
1 -
@Amelia Ketzle have you checked if those Date fields have to do with Birthdates? I think I remember when they encrypted those fields that they would fail depending on what information was used in those filters.
0 -
@Lee Grisham - No, they were start and stop dates, I believe. Date To and Date From in Addresses, for example.
0 -
@Alex Wong - I'm talking about running existing queries (from db view) in web view query. They've been working fine and all of a sudden they went kaput. But, then all of a sudden, they started working again yesterday.
0 -
@Alex Wong - And sorry, exporting directly from the query, not using Export.
0 -
@Amelia Ketzle - This issue self-resolved yesterday. We don't know what changed, but it's working now, so I can't replicate the error message. I'll revisit this post if it happens again. THanks to everyone for your efforts to help!
1
Categories
- All Categories
- 6 Blackbaud Community Help
- 213 bbcon®
- 1.4K Blackbaud Altru®
- 401 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 655 Blackbaud Grantmaking™
- 576 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 939 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.6K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 119 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 241 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 34 PowerUp Challenges
- 3 (Open) 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
- 791 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)