Millennium

The date and timestamp is added to the unc path when the pathname includes .com and if the user omits the extension of the filename

If the user provides the file type extension, a typical path could look like
\\example.abila.com\folder\filename-2017-04-03-10-53-46.xls
If the user forgets the file type extension (.xls), Millennium will try to save the file to this path
\\example.abila-2017-04-03-10-53-46.com\folder\filename

Linked proposal propprgflag flag set to N on linked proposals

"Authorization has been denied for this request" message appears trying to login and run Millennium Drive.

Display ID Number in Header gets reset randomly after IIS recycling or application crash while users are logged in to Millennium
 
 

The Wealth Engine total years giving calculation returns a 0 value.

WealthEngineInfo.totalYearsGiving

Millennium does pass what I would think is total years giving, always passed as 0.  We do not calculate it.
       WealthEngineInfo.totalNumberGiving = 0;
       WealthEngineInfo.totalNumberGivingSpecified = false;
The WealthEngineInfo.totalYearsGiving comes from this select and additional logic, works like consecutive year in totals utility.
                                SELECT gifteffdat
                                                FROM (
                                                                SELECT gifteffdat
                                                                                FROM gifts
                                                                                WHERE giftid = 'xxxxxxxxxx' and (gifttype = 'p' or gifttype = 'e' or gifttype = 'sp')
                                                                UNION
                                                                SELECT gifteffdat
                                                                                FROM gifts
                                                                                WHERE giftid = 'xxxxxxxxxx' and gifttype = 'g')
                                                AS temp
                                                ORDER BY gifteffdat ASC
**If the current year is greater than or equal to year from the select above then current year – year retrieved otherwise set to 0.
 
gifteffdat
2011-12-20 00:00:00.000
2014-03-10 00:00:00.000
2014-10-30 00:00:00.000
2014-12-02 00:00:00.000
2014-12-11 00:00:00.000
2016-02-02 00:00:00.000
2016-02-26 00:00:00.000
2017-01-27 00:00:00.000
 
 

Wealth Engine Last giving amount and date are incorrect as the gifteffdat is converted to character which causes the dates to sort like text. This will sort on the month, not the date.

Wealth Engine largest gift is randomly selecting the largest amount in the case where there are two gifts of the same amount.  The date is converting to character and not sorting as a date field, therefore not returning the most recent largest gift.

 
The birthdate and age are not being displayed correctly in Wealth Engine ProspectLink and Age in Prospect>Demographics is updated as 0 value.