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-M24212-Users logged out of Millennium posting payment to multiple allocated pledge containing percent sign in comments
Symptom
All users are exited out of Millennium when posting a payment to a multiply allocated pledge that has % sign in the comments field.
Product Line
Error generating temporary filename using Advanced Search
Symptom
When running Advanced Search there is an error at the bottom left of the screen that indicates "Error generating temporary filename".
The Advanced Search is not working for any user nor the 'sa' account. Advanced Search was working previously.
The Advanced Search is not working for any user nor the 'sa' account. Advanced Search was working previously.
Product Line
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
Purging Audit Logs
Symptom
Error generated updating the NAMES table: Could not allocate space for object ‘audit_name’ because the PRIMARY filegroup is full. Create disk space by deleting unneeded files.
Product Line