Hotfix - HF1 for MachPanel build v6.0.38 (Updated May 3, 2019)


Summary
This article provides 6.0.38 HF1 and information about how to apply this fix on your servers.
Applies To
This article applies to MachPanel v6.0.38.
Important Notes
  • MachPanel Control Panel and all MachPanel Remote Servers need to be on Build v6.0.38 and then Hot-fix can be applied.
  • Please follow the steps given below in sequence and execute instructions in the KB articles to complete the update:
  1. Update to Latest MachPanel
  2. Update to Latest MachPanel Remote Server
Latest Issues Fixed
Build: 6.0.38 HF1 Updated: May 3, 2019

1. Fixed error in Azure login for Contact.
2. Fixed error in ProratedUnitCost calculation.
3. Fixed 2000 error in Azure Rate Cards processing when Profile Country is different then package Locale.
4. Fixed Add Exchange Mailbox Database is not listing all servers.
5. Fixed error in Move customer due to missing image file.
6. Exchange enhancement for ability to prepend disclaimer text added.
7. Fixed Office 365 CSP offer MS price list import problem when decimal point other than dot/period (.).
8. Fixed error in billing where invoice was not being generated for Defer bill subscription.
9. Fixed issue where logged-in as Customer contact takes user to Customer account on session resume.          
10.Fixed error faced when session times out, now on timeout user will see login screen.  
11.Fixed invoice detail display issue for invoices with 1 line item and wrong date handling.
12.Fixed error in ADSync due to service is re-directed to login page.
13.Fixed error in CSP import due to WebApp and Client Secret method used, it is reverted to Native App + Client credentials.
14.Updated CSP product pricing step, cost price is notcopied in sale price automatically on blur but on change.
15.Added SEPA profile generation for NetherLands using(PayIBAN) and manual payment processing.
16.Online Store is made available when Payment using 3rdparty is enabled.
17.Fixed removing a template from Exchange reseller subscription removes all templates for reseller.
18.Update Defer bill for customer, removed Roundto2 in Per day bill calculation and updated date handling to avoid 1 day offset problem.
19.Added functionality to return tax when issuing system generated credits.
20.Update functionality for O365 Reseller usage based bill handling and O365 defer bill handling. Round to 2 digits skipped in per day bill calculation.
21.Fixed error in Exchange Usage Report Export to Excel feature.
22.Fixed error in Exchange Disclaimer Sender Selection as group or a mailbox.
23.Updated CSP order form to add phone country code in phone number field from client profile.
24.Added common domain for all subscriptions in SFB module Server Group.
25.Fixed Schedule monthly report is being sent after 30 minute instead of once in month.
26.Fixed error in Exporting reports to Excel due to "#" in header, like for Phone #.
27.Mailbox email address sync issue fixed.
28.Added Audit logging for AD Security Group operations.
29.Fixed error in AD Security Group auto add members.
30.Fixed error in Export SFB Call Reports to Excel.
31.Active directory user group jobs processing for creating new users is improved.
32.Changed order of Year and Month inputs in credit card add/edit.
33.SFB addon edit updated to copy policies in sold addons if sync resources is enabled in edit addon.
34.Option added to change expiry of Credit Card only without changing details.
35.Credit card Declined/Expiry email body updated.
36.Added handling to avoid Authorize.net duplicate transaction because of same amount being charged for same customer within duplicate window timeframe.
37.Client side Pay page updated to show Transaction details on page after processing.
38.Fixed string conversion error from dbnull/guid in export excel for different reports.
39.Fixed bug where Lync jobs status was not getting updated.
40.Fixed error in expanding menu links by clicking in name when domain name contains .asp.
41.Fixed SIP address getting changed incorrectly.
42.Problem of provider bill percentage column shown in azure bill detail report when logged in as customer/reseller is fixed.
43.Fixed error in Recurring Invoice amount when Avalara is enabled.
44.Fixed problem of missing Microsoft agreement template id in CSP tenant order via API/WHMCS.
45.Fixed Avalara tax calculation problem in CSP subscription invoices.
46.Tenant import batch limit user input added to handle the page responsiveness problem in case of importing tenants in large numbers.
47.Fixed issue where Invocie status is not marked as Paid due fractional difference due to SQL float.
48.Missed Addon invoices generated.
49.Fixed error where addons are not added in invoice total.
50.ACL added for Guest OS to allow only allocated IP in NIC management.
51.Fixed bug where a customer can see PST exported files for another customer.

Procedure
  • Go to MachPanel configuration studio.
  • Shut down all the MachPanel services and also exit the configuration studio. Make sure no instance to MachPanel Configuration Studio is running under any user.

  • Download the hotfix 6038HF1May32019.zip file from the link at bottom of this page.
  • Stop IIS Admin Service, please make sure that all the services are STOPPED from MachPanel Configuration Studio. Verify from "Task Manager" that the following services are not running.
  1. MachSol.MachPanel Provisioning Service.
  2. MachSol.MachPanel.ConfigurationStudio.exe.
  3. MachPanel Billing Service.
  4. MachPanel Helpdesk Service.
  5. MachPanel Network Service.
  6. MachPanel License Service.
  7. MachPanel O365 Service.

  • Replace files from MachPanel folder on MachPanel control server (Path: C:\Program Files\MachSol\MachPanel Control Serverand Replace files from Remote server folder of hotfix folder on MachPanel remote server (C:\Program Files\MachSol\MachPanel Remote Serverkeeping the folder hierarchy same as it is in hotfix. (you should get message to overwrite files, if not you are not doing it right).

  • Execute script.txt from zip file on MachPanel_Db after logging in to SQL management studio as MachPanel_Db user. Password can be obtained from connection string in registry of MachPanel Control Server.

  • Once all files are replaced properly from hotfix folder Restart all services related to MachPanel on Control as well as Remote Servers.
Download Link
https://www.machsol.com/updates/6038/6038HF1May32019.zip

Note: Please Unblock the files before replacing in installation directory if the downloaded Zip folder is blocked.

 

Known Issue (required only in case you face error):

On latest build (when applied as auto update) there is a bug in MachPanel AD User Listing (Active Directory Users).

Error Message: Index was outside the bounds of the array 

To fix this error, please run script from link below on MachPanel_Db being logged in as MachPanel_Db user:

https://www.machsol.com/updates/6038/Script-ADUserListing-SearchOrgUser-SP.zip