NpsSMOError ExecuteQuery failed for Database ‘NpsSqlSys’. An exception occurred while executing a Transact-SQL statement or batch.
After installing MIP server 2020.2, I receive the error message "NpsSMOError ExecuteQuery failed for Database ‘NpsSqlSys’. An exception occurred while executing a Transact-SQL statement or batch. Incorrect syntax near ‘=’. Must declare the scalar variable “@sTargetContext”"
March 2020 Release Notes
New for Community Brands netFORUM Pro in March, 2020
General Updates - March 2020 Release
These are the general updates and improvements to netFORUM Pro for March, 2020 There are seven updates in total for this release under the topics: Report Performance, Security Enhancements, Registration Enhancements, and Bug Fixes.
Report Performance
Cash Flow Report
Enhancement: Updates to the indexes and temporary tables were done to improve the performance of the baseline cash flow report.
Security Enhancements
Include Password Complexity Instructions on User Account
Enhancement: Password complexity instructions have been added to the user account form under the Administration module -> User Management group.
User Lockout
Enhancement: After six failed attempts, users will be locked out of their account. The account will be locked for 30 minutes. The user can either immediately contact a staff member with administrator rights to unlock the account or wait 30 minutes for the account to automatically unlock.
Registration Enhancements
Addition of a Guest Registration Capacity Message
Enhancement: If the event capacity for an event has been reached, a message stating "This Event if Full" is displayed and the "Add Guest' button is disabled. If the event capacity has not been reached but the number of allowed guest registrants (system option) has been reached, the message "You have reached your limit of guest registrations" is displayed and the Add Guest button is disabled.
Bug Fixes
Issue #19155 "Open Credits" and "Open Credits as of Date" Reports
Bug Fix: The "Open Credits" and "Open Credits as of Date" reports have been updated to ensure all credits are accounted for.
Issue #24754 Incorrect Column Names for Custom Event Demographic Flag Fields in Excel Report
Bug Fix: Previously if more than one event used the demographic check flag field, any report that included registrations from multiple events would display the incorrect column name. Now, the report will display the default caption value, ex. Flag_01 on reports that contain registrants for multiple events. If all the registrants displayed on the report are from the same event, the updated caption value, ex., Vegetarian Meal, will be displayed
Issue #25304 Accounting Module Add Payment Feature is Not Processing Credit Card Payments
Bug Fix: The Add Payment feature in the Accounting module will now successfully process credit card payments.
January 2020 Release Notes
General Updates - January 2020 Release
These are the general updates and improvements to netFORUM Pro for January, 2020 There are updates in total for this relase under the topics: Data Security, New Event Wizard Update, Data Import Enhancements, Troubleshooting Enhancements and Demographics and Bug Fixes
New Event Wizard
Add Sort Order to Event Demographics for Registrations
Enhancement: When adding demographics to the event, the event creator can opt to sort the registrant demographics alphabetically(default) or numerically(sort order). If the Demographic Sort Order field is null, the sort order is alphabetical. If the Sort Order field is populated the sort order will be honored. If you opt to populate sort order, the sort order for all demographics field should be populated.
Add Sort Order to Event Demographics for Guest Registrations
Enhancement: When adding demographics to the event, the event creator can opt to sort the guest page registrant demographics alphabetically(default) or numerically(sort order). If the Demographic Sort Order field is null, the sort order is alphabetical. If the Sort Order field is populated the sort order will be honored. If you opt to populate sort order, the sort order for all demographics field should be populated.
Security Enhancements
Add Enhanced Password Complexity (iWeb)
Enhancement: Password complexity has been updated to require the following password format: Between 8-32 characters long. Contain one upper case letter, one lower case letter, one number and one special character. The password must also be different than the last four passwords. Pro will validate password complexity for iWeb accounts when a new iWeb account is created, a password is forgotten, or changed.
Add Enhanced Password Complexity (eWeb)
Enhancement: Password complexity has been updated to require the following password format: Between 8-32 characters long. Contain one upper case letter, one lower case letter, one number and one special character. The password must also be different than the last four passwords. Pro will validate password complexity for eWeb accounts when a new customee record is created in eWeb or if customer uses the forgot password functionality to retrieve a password. An error message is displayed with the password complexity requirements if the customer tries to save a password that does not meet the requirements.
Automatic Password Creation on Adding an Individual in iWeb
Enhancement: As part of the manual creation of an individual record, on add, the Web Site Password field is populated with a random unique password that meets the enhanced password complexity requirements. The password value is defaulted only. Staff members may change the generated password, but the new password must also meet the enhanced password complexity requirements.
Data Import Enhancements
Validate Gender During Data Import Process
Enhancement: When importing (insert/update)individual gender data, if the database gender values do not include the gender value on the importing file, the row will not be imported and an error message will be displayed in the exception report.
Add Deleted Individual Parameter to Data Import Process
Enhancement: When importing a row with an individual type that has been deleted, if that row matches an existing non-deleted record, the individual type for that row will be re-added to the individual type list.
Reports
Report Optimization
Enhancement: The following reports were optimized to enhance performance: A/R Transaction by Charge Code, Cash Receipts Report
Bug Fixes
Issue #23130 Free session with Education Credits is Not Reflecting Earned Date
Bug Fix: Education Credits on free sessions will not reflect the earned date on the individual's profile.
Issue #25411 Education Credit Value Displays as Currency
Bug Fix: Education Credits will display as a decimal value.