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.
DF-M25242- Brackets in memory names lookup table value cause the Create Summaries utility error
Symptom
Special characters in memory names value field cause the Create Summaries utility to result in a Utility Error or Windows C0000005 error.
Steps to Reproduce:
Steps to Reproduce:
- Click on Tools>Profile Lookups
- Click on Memory Names
- Click Insert
- In the Value field enter F18) Open pledges to AF18
- Add a value for the Code field
- In Groups enter $ and ensure the code is Active and click Insert
- Insert a second memory name by clicking Insert
- Enter the Value as F19) Open pledges to AF19
- Repeat steps 5 & 6 above
- Insert a third memory name, entering F) Open pledges to Annual Fund in the Value field
- Repeat steps 5 & 6 above
- Log into the IIS machine
- Browse to inetpub\wwwroot\mill\tools
- Locate the Assign Summary Definition utility and right click to run as Administrator
- Select Machine Data Source tab and highlight WebSQL and click OK
- Enter the login ID as ‘sa’ account and enter the appropriate password and click OK
- Click File>New Definition
- In the Define Numeric Memories window choose the first value added in step 4 above - F18) Open pledges to AF18
- Highlight the value F18) Open pledges to AF18 and click Total 1, then click Add
- In the same Define Numeric Memories window choose the second value added in step 8 above - F19) Open pledges to AF19
- Highlight the value F19) Open pledges to AF19 and click Total 2, then click Add
- Next select the third value by highlighting in the Define Numeric Memories window, the F) Open pledges to Annual Fund and click Total 3, then click Add
- The screen memory names linked to the totals should look like below
- Click File>Save As and enter the following name for the summary definition“Open pledges to AF18, AF19, and AF” and click OK to save
- .
- Close the Summaries utility
26. Log into Millennium and go to Reporting
27. Click New Criteria>Financial
28. Choose Total Giving Abila1 report which uses summaries
29. Click Save As and save the report under a new name
30. Click on Criteria
31. Enter the following criteriaSelect all basic Data where Id from Basic Data is greater than ‘0’
And where the Id from the Basic Data is in the list of:
‘<a prompted reply>’
TOTAL 1 – Sum: Open AF18 (on the Total 1 page enter Open AF18, include Match Due, Calculation Amount of ‘Amount’, Calculation Type of ‘Sum’ and Include all Credits and Save)
Total all Giving Detail where Account # from Giving Detail is in the list of:
‘1’
‘2’
‘3’
‘4’
‘5’
‘6’
‘7’
and where the Campaign Year year from Giving Detail is equal to ‘2018’
and where the Type from Giving Detail is in the list of:
‘Pledge Credit Transaction’
‘Pledge Transaction’
Include match due
TOTAL 2 – Sum: Open AF19 (on the Total 2 page enter Open AF19, include Match Due, Calculation Amount of ‘Amount’, Calculation Type of ‘Sum’ and Include all Credits and Save)
Total all Giving Detail where Account # from Giving Detail is in the list of:
‘200’
‘202’
and where the Campaign Year from Giving Detail is iequal to ‘2019’
and where the Type from Giving Detail is in the list of:
‘Pledge Credit Transaction’
‘Pledge Transaction’
include match due
TOTAL 3 – Sum: Sum Open Pledges to Any Annual Fund (on the Total 3 page enter Sum Open Pledges to Any Annual Fund, include Match Due, Calculation Amount of ‘Amount’, Calculation Type of ‘Sum’ and Include all Credits and Save)
Total all Giving Detail where Type from Giving Detail is in the list of:
‘Pledge Credit Transaction’
‘Pledge Transaction’
and where the Account # from Giving Detail is in the list of:
‘7’
‘250’
include match due - 32. Click Run
- 33. Click OK to save the report criteria table successfully
34. Click OK on the Run page
35. Click Not applicable to this report when it prompts for the list of Ids in the prompt and parameter options screen and click OK
36. Select the saved definition of Open Pledges to AF18, AF19, and AF in the Memory Definition dropdown list
37. Click OK to run
38. A message will display that the report has been successfully added to the queue
39. In the Millennium Navigator click Q Management, then click the queue link to select the queue to display
40. The queue status should display the utility working through the data selection, totals and once completed will display 100% complete if successful
41. In our case the queue displayed a message “Utility Error” insteadThe resulting CreateSummariesOut.log file in the Queue folder on the IIS will display the following - :
- The customer site had an APPCRASH error in windows resulting in c0000005 error as well as the exact error experienced inhouse above in the createsummariesout.log file.
Product Line
DF-M16752-Run-time options not saving in Years Utility
Symptom
All other run-time options are being saved except the “Include current year in consecutive years giving” checkbox when reopening the years utility.
Product Line
Summaries and SetYearsParameters utilities do not update donor's records after Server migration
Symptom
The user can’t update donor’s Summaries records when running Summaries and SetYearsParameters utilities after their MILL Server migration
Product Line
Connection / Login Errors-login failed for user ‘millennium_admin’
Symptom
The following examples demonstrate a few of the various errors encountered:
- Millennium connection fails upon Log On or launching utilities
- Several different errors can be encountered depending on how the user is attempting to connect to Millennium (Client/Browser interface, utilities)
- Page Cannot be Displayed
- Page Cannot be Found
- Accessing Millennium via the Browser
- Login failed for user ‘millennium_admin’
- HTTP 500 – The website cannot display the page
- Error while trying to retrieve text for error ORA-01017 Driver’s SQLSetConnectAttr failed
- Log In Failure. ORA-01017: invalid username/password; logon denied Driver’s SQLSetConnectAttr failed
- Trying to run the SetYearsParameters.exe utility
- Unable to get system information as millennium_admin
- Log In Failure
Product Line
How To Update Payment Notification Email Address
Symptom
How to update or change who receives payment notifications when donors make donations
Product Line
Phonathon Utility error "Unhandled exception has occurred in your application"
Symptom
Phonathon Utility error "Unhandled exception has occurred in your application"
![](/sites/kb/files/1_21.png)
![](/sites/kb/files/1_21.png)
Product Line
SCR - File System Error Received When Logging into MIP
Symptom
This article applies to users logging into MIP Single or Multi Tenant hosting
When logging into MIP Classic the message "File system error (-2147219194) is returned
Product Line
The "Remote Desktop Connection" Application Cannot Be Started
Symptom
** Applies to Mac users who access the MIP private cloud **
When logging into portal.mip.com the message:
The "Remote Desktop Connection" Application Cannot Be Started is returned
Product Line
Microsoft Remote Desktop Quit Unexpectedly
Symptom
** Applies to Mac users **
When launching MIP Classic or Fundraising 50 from the MIP Portal the message ‘Microsoft Remote Desktop Quit Unexpectedly’ appears.
Product Line