Knowledgebase Search

Symptoms will be assignment service crashing or reports not running for some users after password change and login.

When using a user that is subject to advanced security the statement of Revenues and Expenditures returns an error when first running. Report runs but using drilldown returns multiple error messages.
 
 

ALS is set up with two segments checked and the Deny option selected.  One user will commit a transaction and tblUserAcctCode will build 2.5 million rows to get ALS correct while everyone waits.  The first user finishes processing their transaction and MIP clears the table and rebuilds it...

Any user with advanced security is unable to access report information after upgrade to 17.1.1.  Both Active Directory and Advanced Security is in Use and the user is assigned to multiple groups.

If unable to log in to Millennium after a server migration or restore of Millennium, it may be due to the SQL users not matching or permissions did not carry over properly.

When selecting a user ID with over fifteen characters in the ‘copy from’ field in Copy Account Level Security the system returns an error message stating: “Copy From ID <username> exceeds the maximum length of 15 characters. Enter Copy From ID equal to or less than 15 characters.”

Users can see document level information in accounts blocked by Advanced Security.

I have advanced security and have set up a GL code to not be accessible. But if I use Display balances, type the number of the code and hit display I can see document amounts. If I drill down into them the amounts are zero.

MIP returns error “The system is unable to access the keys used to encrypt your sensitive information. Go to Administration > Security > Set Up Database Encryption and select the Restore button. Please see the Help Documentation for more information.” after migrating an encrypted...

After encrypting an MIP Database and backing up the Service Master key, MIP software closes unexpectedly.

Attempting to disable database encryption results in error ‘NpsSMOError ExecuteNonQuery failed for Database ‘NpsSqlsys’. An exception occurred while executing a Transact-SQL statement or batch. The operation failed because an index or statistics with the name ‘idx_tblPREE_sSSN already exists...