DF-M23267-Prompting by Event code returns 0 records

Submitted by 181 on
Symptom
Reporting-Prompting by Event code returns 0 records

 
1. Select Reporting>New Criteria>Event
2. Select the Event Profile report
3. Run the report with the existing default criteria:
           Select all Event where Code from Event is equal to '<a prompted reply>'
4. When prompted select any Event code and click OK
4. In Q Management the report generated:
 
          Report Name: cj event code User: cj
Run Date: 01/26/2018 10:19 AM
Notes: Report completed, selecting 0 records.  Total Time: 00:00:03
Product Line

DF-M23259-Sporadic error “Incorrect syntax near ‘-‘” adding non-constituent guest to an event registrant

Submitted by 334 on
Symptom
Users experience the error message below when clicking Insert to add a Guest row onto an event registrant record after clicking on Create a Non-Constituent Guest link.

*SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attlnkkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select guestkey from event_guest_full where guestlnkky = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Media'.--37000 Statement: DSN=Web SQL;UID=tvt;==select gitemitmky from guest_items_full where gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0 or gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0
Product Line

DF-M23226- Excel output is not created when running express reports with the output type of Excel

Submitted by 334 on
Symptom
DF-M23226- Excel output is not created when running express reports with the output type of Excel. If the output type is html or pdf output is created and you can click on the thumbnail in express reports to view the report results.
Product Line

String or binary data would be truncated error in report.log

Submitted by 334 on
Symptom
Running a report the following error occurs in the report.log
 
 
Accounting Report payments only prompted by dates

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. Statement: update report_descripts set report_run_user = 'membber', report_run_date = '01/11/2018 09:53:39 AM', report_select_time = '00:00:16', report_format_time = '00:00:07', report_total_time = '00:00:23', report_records = '602', report_export_time = '00:00:00', report_format_name = 'JFYGHJ_ID_NAME_ADREESS_PAYMENTINFO_FOR ACCT WITHOUT PROMPTS FOR PLEDGES_WITH COMMENTS .RPT', report_export_owner = null, report_export_dbase = null, report_export_table = null where report_name='Accounting Report payments only prompted by dates' and report_type='U' and report_category='Financial & Giving' and report_groups='      ' Native Error: 8152.  Total Time: 00:00:23
 
 
Product Line

Header name display uses non-preferred name type value if the value of the code for the name type begins with uppercase characters

Submitted by 334 on
Symptom
When adding a name with a name type where the code has mixed case characters, example STMail, the name for this respective type is used in the header name information instead of the existing preferred name.  All reports, exports and locations where default preferred name is used will display the incorrect name type.



Product Line

DF-M23148-“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables

Submitted by 334 on
Symptom
“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables



The csv file contains relid, relkey and relnmy1 fields mapped to the Relation table


The identifier settings are as follows


The mapping is created for the two fields to the Relation table



After saving the mapping and we click File>Run import to pending tables, the error occurs.
“Conversion from string “N” to type ‘Date’ is not valid” 
Product Line