When attempting to access the Millennium logon screen, you receive an HTTP 401.1 error message:
‘You are not authorized to view this page’


 

System disables ‘Change Password’ option if user name starts with ‘sa’

No Option to save multiple sorts or filters while logged in as a user with System Administrator privileges.

The Queue generated the error 1536
"​Report Name: Gift All Transaction: JOHNSMITH 
Run Date: 04/08/2015 10:03 AM 
Notes: [Oracle][ODBC][Ora]ORA-01536: space quota exceeded for tablespace 'MILLREPORTS' 
Statement: Create table wrk1F8E100333_2 as select gift1.giftid id_number, gift1.giftkey timekey, gift1.giftfnum keyfileno, ' ' column_decrypt, 'A' grouptag from gifts_full gift1 where (gift1.giftbatch='07APR1501' and (gift1.gifttype='b' or gift1.gifttype='g' or gift1.gifttype='y')) Native Error: 1536 "

When copying an existing Millennium group or user, the new group does not show up in groups nor user maintenance.
When you click copy, the system indicates copy is in progress but the copy is not successful.
This is occurring in version 2015.x-2016.1.2 of Millennium but fixed for 2016.1.3 with a new millsys.dll and millsys.pdb file.
Turning on a SQL Profiler Trace results in the following user error:  ​  Could not find stored procedure 'sp_addgroup' 
 

“Invalid column name ‘updateaddr’” error occurs when SoftEdit users update addresses.

The ‘sa’ account is able to change a user’s password in the user interface but the change password log indicates the following:  "'Username’ is not a valid login or you do not have permissions when ‘sa’ account changes user passwords in Millennium user interface"

Resetting IUSR_Millennium password – IUSR account locked out

If you'll change the  IUSR_Millennium password it must me done in several places in IIS Manager: local users, IIS default website, Mill drive website, IIS server level, and both applications pools but...I think the locked out issue... is not related to the password/authentication...
try resetting the password...
If there are additional queue boxes, the same - IUSR_Millennium must be updated on those boxes as well

If IUSR_Millennium account is locked out, it may mean password is not matching at all sites as per above.

 

The 'sa' account is trying to change a user's password in the Millennium user interface.
The password is changed successfully but the change password log file indicates the following message:

2016/5/5 14:16:03==Password Change Attempt for User: abcdefg
Attempt Password Change on Primary Server for User: abcdefg
[Microsoft][ODBC SQL Server Driver][SQL Server] 'abcdefg' is not a valid login or you do not have permission
*SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'userlist'.--S002 Statement: DSN=Web SQL;UID=millennium_admin

2016/05/05 14:16:03==Password Change for User: abcdefg has failed.

 

When you delete a user in Millennium, if that user owns objects in SQL, the objects must be transferred to another user.  When you delete the user in Tools>System Upkeep>User Security>User Maintenance, if the user owns objects in SQL there will be a message that the owned objects must be transferred to another user.  There is a dropdown of users presented once Delete is clicked but not all of the users are listed in the dropdown.

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

Change Password process did not update the stored passwords in reporting qqq files for scheduled reports 

• user password
• millennuim_admin password

If a site is using https, passwords are not encrypted in the database when users change them.

Manually accepting a SoftEdit user’s insert via default generates 5004 - No Name Found for ID 5004 in the section header and generates the following error when accepting the pending records: 
 

Error Message -- Insert
INSERT INTO attribute_full(attrstrt, attrstop, attrsource, attrdescr1, attrdescr2, attrpositn, attrcomm, attrtypenm, attrtype, attrlnkfil, attrdate1, attrdate2, attrlook1, attrlook2, attrlook3, attrtext, attrdate3, attrdate4, attrdate5, attrdate6, attrdate7, attrdate8, attrdate9, attrdte10, attrdte11, attrdte12, attrtxt1, attrtxt2, attrtxt3, attrtxt4, attrtxt5, attrlook4, attrlook5, attrlook6, attradesrc, attrid) VALUES ('Jun 29, 2012', null, 'self ', ' ', ' ', '', 'test soft edit users insert via default', 'Cancer Research', 'can', '', null, null, ' ', ' ', ' ', '', null, null, null, null, null, null, null, null, null, null, '', '', '', '', '', ' ', ' ', ' ', 'Soft Edit', '5004')

SQL_ERROR
[Microsoft][ODBC SQL Server Driver][SQL Server] The INSERT statement conflicted with the FOREIGN KEY constraint "fk_attrid". The conflict occurred in database "millsample", table "dbo.corebio", column 'coreid'.
Error Code 547

When creating a custom view using view generator customer receives an error message when using a custom where statement:
 

String or binary data would be truncated.--22001.