The results of your search are shown below. To refine your search, revise your keywords, and/or select the appropriate check boxes to the right.
Updating IIS file path in saved custom report formats after renaming or moving to a new IIS.
Symptom
Unable to run previously functional custom reports after migrating to new IIS Server
Product Line
SQL Users Out of Synch with Database
Symptom
Symptom 1:
You receive the error `Cannot open database requested in login `xxx`. Login fails` when logging into Millennium.
Symptom 2:
Error: ‘An error occurred attempting to save the report’ received when running or saving new reports
Product Line
Emailing Reports after 2017.X generates “Could not find a part of the path” Error
Symptom
Emailing a report with special characters, including but not limited to / \ produces an error:
Product Line
DF-M22438-Unable to copy Millennium group, insert group or insert user
Symptom
Unable to Copy Millennium Group
Unable to insert Millennium Group
Unable to insert Millennium User
Drop user error
Unable to insert Millennium Group
Unable to insert Millennium User
Drop user error
Product Line
DF-M22586-Search Reports returns partial list of matches
Symptom
Search Reports returns partial list of matches
Product Line
DF-FA-22961-Process time for R&E Report using Group is excessive
Symptom
Statement of R and E using report groups takes more than 22 minutes to complete.
Product Line
DF-M23125-Error converting data type varchar to numeric when chart_nm12 is added to lookup tables for chart of accounts
Symptom
Error “Error converting data type varchar to numeric, Error code 8114” occurs when adding values to Tools>Profile Lookups>Lookup Tables>Chart of Accounts if field chart_nm12 is in Maintenance form in Display Design>Lookups>Chart of Accounts for Lookup Type Maintenance Form
![](/sites/kb/files/error.png)
![](/sites/kb/files/error.png)
Product Line
DF-M23148-“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables
Symptom
“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables
![](/sites/kb/files/little_window.png)
The csv file contains relid, relkey and relnmy1 fields mapped to the Relation table
![](/sites/kb/files/keys.png)
The identifier settings are as follows
![](/sites/kb/files/identifier.png)
The mapping is created for the two fields to the Relation table
![](/sites/kb/files/setting.png)
![](/sites/kb/files/relation_unhandled_exception.png)
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”
![](/sites/kb/files/little_window.png)
The csv file contains relid, relkey and relnmy1 fields mapped to the Relation table
![](/sites/kb/files/keys.png)
The identifier settings are as follows
![](/sites/kb/files/identifier.png)
The mapping is created for the two fields to the Relation table
![](/sites/kb/files/setting.png)
![](/sites/kb/files/relation_unhandled_exception.png)
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
DF-M23221-“Please enter a valid email address” message when entering a non-standard email address in Internet Address
Symptom
“Please enter a valid email address” message when entering a non-standard email address in Internet Address
![](/sites/kb/files/new_screen.jpg)
![](/sites/kb/files/new_screen.jpg)
Product Line
DF-M23226- Excel output is not created when running express reports with the output type of Excel
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
DF-M22615-Match ratios 0.00 or 0.000 incorrectly sets jobsmflag on UPDATE
Symptom
Match ratios 0.00 or 0.000 incorrectly sets jobsmflag on UPDATE
Product Line
DF-M22730-Report Returns 0 Records When Values in the Values Drop Down Are Single Clicked
Symptom
When a value in the Value field is single clicked the report returns no records
![](/sites/kb/files/single_click.png)
![](/sites/kb/files/single_click_ii.png)
![](/sites/kb/files/single_click.png)
![](/sites/kb/files/single_click_ii.png)
Product Line
DF-M23267-The Change_Date_User_ ID field is not displaying the changed date and user Id field in Profiles>Event Log>Registration
Symptom
The Change_Date_User_ ID field is not displaying the changed date and user Id field in Profiles>Event Log>Registration
![](/sites/kb/files/guest_and_reg_change_date_user_id.jpg)
![](/sites/kb/files/guest_and_reg_change_date_user_id.jpg)
Product Line
DF-M23267-Prompting by Event code returns 0 records
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
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-M23411-Split allocation gifts not split in credited gift
Symptom
Split allocation gifts not split on spouse’s credited gift
![](/sites/kb/files/2017_credit_with_allocation.jpg)
![](/sites/kb/files/2017_credit_with_allocation.jpg)
Product Line