Submitted by 334 on Fri, 08/30/2019 - 13:41
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:   
  1. Click on Tools>Profile Lookups
  2. Click on Memory Names
  3. Click Insert
  4. In the Value field enter F18) Open pledges to AF18
  5. Add a value for the Code field
  6. In Groups enter $ and ensure the code is Active and click Insert
  7. Insert a second memory name by clicking Insert
  8. Enter the Value as F19) Open pledges to AF19
  9. Repeat steps 5 & 6 above
  10. Insert a third memory name, entering F) Open pledges to Annual Fund in the Value field
  11. Repeat steps 5 & 6 above
  12. Log into the IIS machine
  13. Browse to inetpub\wwwroot\mill\tools
  14. Locate the Assign Summary Definition utility and right click to run as Administrator
  15. Select Machine Data Source tab and highlight WebSQL and click OK
  16. Enter the login ID as ‘sa’ account and enter the appropriate password and click OK
  17. Click File>New Definition
  18. In the Define Numeric Memories window choose the first value added in step 4 above - F18) Open pledges to AF18
  19. Highlight the value F18) Open pledges to AF18 and click Total 1, then click Add
  20. In the same Define Numeric Memories window choose the second value added in step 8 above - F19) Open pledges to AF19
  21. Highlight the value F19) Open pledges to AF19 and click Total 2, then click Add
  22. 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
  23. The screen memory names linked to the totals should look like below
  24. 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
  25. .
  26.  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
  27. 32. Click Run
  28. 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
  29. :
  30. 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.
Resolution
Removing the brackets in the memory names lookup table and recreating a new definition with the memory names without brackets in the memory name value runs the summaries to completion. You can view summaries then and the three memories have been added to Summaries.

Fixed in 2017.1.2
Article Type
Product Defect
Product Line
Millennium
Product Module/Feature
Utilities
Product Version
2016.1.4
Ranking
No votes yet