Jun 09, 2021
01:47 AM
Hi mfranz,
For the details of CU5, please find the document from Microsoft:
https://support.microsoft.com/en-us/topic/kb4552255-cumulative-update-5-for-sql-server-2019-084c602b-dc4a-d599-c857-5f18cec950fa
I didn't test on each revision but I believe the memory optimized tempdb has to be switch off no matter which revision of SQL Server 2019 is.
Regards,
Cemson
... View more
Feb 07, 2021
05:54 AM
6 Kudos
Symptoms:
When FNMS is working with Microsoft Server SQL Server 2019 version, they might receive the follow error message:
System.InvalidOperationException: Memory optimized tables and natively compiled modules cannot be accessed from within SQLCLR stored procedures.
Analysis:
SQL Server 2019 (15.x) introduces a new feature that's part of the in-memory database feature family: memory-optimized tempdb metadata. When this feature is enabled, the system tables involved in managing temporary table metadata can be moved into latch-free, non-durable, memory-optimized tables. However any memory optimized tables and natively compiled modules cannot be accessed from within SQL CLR stored procedure, and therefore causing compatible issue with FNMS.
User may see the error message listed above during some data activities such as during data warehouse export process.
Solution:
When using SQL Server 2019, please ensure the cumulative update package 5 for SQL Server 2019 or later is installed.
Disable TempDB_Metadata using any of the following commands and then restart the SQL Server.
--Option 1: ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA = OFF
GO --Option 2:
EXEC sp_configure 'tempdb metadata memory-optimized' , 0
GO
RECONFIGURE
GO
... View more
Nov 15, 2020
05:53 AM
3 Kudos
Symptoms:
This KB article will provide a way to help customers who experiences the following error message after they restored a VM to a previous check point where the Business Adapter Studio was running on it with encryption option ticked.
ERROR: MGSBI.XML has not been successfully encrypted. The type initializer for 'ManageSoft.CryptographerSelector' threw an exception.
Cause:
VM restoration sometimes caused changes of some characteristic of the underlying VM hardware that the VM is bound to, so it generates different crypto info.
Solution:
Open up the Windows Registry at the following path:
HKLM\Software\Wow6432Node\ManageSoft Corp\ManageSoft
There is a value name called MGSBI, rename it to “MGSBI_Backup”
Then next time when MGSBI runs, a new key at the same path will be created, and should resolve the error, however the user may have to recreate the import profile with encryption option due to the key changed.
... View more
Nov 14, 2020
08:19 PM
9 Kudos
Symptoms:
This KB article will provide an alternative to help customer who has a lot of child beacons and discovery rules, which may generate a massive amount of activity log files waiting for upload, and holds up inventory upload.
Workaround:
Open Windows task scheduler, click on Flexera Inventory Beacon folder on the left panel.
Duplicate the existing task called “Upload Flexera logs and inventories” with a new task name, so now we have two upload tasks.
In the newly created task, right click and choose property, find the Actions tab, edit the action, in the Add arguments textbox, change it to “-o uploadRule=ActivityStatus -t machine”, so from now on this task will only upload Activity logs.
Open up the existing “Upload Flexera logs and inventories” task, edit the argument to “-o uploadRule=Inventory -t machine”, this set the task to only perform inventory files upload.
Additional Information
The above change will result as two scheduled task which only uploads Inventory files and Activity log files, and both can run in parallel and not holding up each other.
The default setting in the argument “-a -t Machine” is doing everything by a single task.
Extra rule names can be viewed in the following registry path:
HKLM\Software\WOW6432Node\ManageSoft Corp\ManageSoft\Common\Rules
... View more
Nov 13, 2020
04:28 AM
Hi,
On the 4th record, you have 3040 maintenance count starting from 2014-06-01 and expired on 2017-05-31. And then on the 3rd record, you only have 32 maintenance count covering between 2017-06-01 to 2020-05-31, that's not enough comparing to the original value of 3040. And then on the first record, you have 3040 maintenance count from 2020-06-01 to 2025-05-31, so there are 3008(3040-32) maintenance count that have maintenance gap between 2017-06-01 to 2020-05-31.
The alerts for purchase orders linking to the license are tend to show any potential gap in maintenance, the alert indicator(In this case the red indicator on the first row) may not be pointing to the purchase order that caused the gap alert.
Regards,
Cemson
... View more
Jun 12, 2020
12:30 AM
2 Kudos
Hi Msutharh,
We have recently done some work in the ManageSoft reader which increased the version visibility for different OS names.
You can reach out our support engineer with your current version of Computer.xml attached, we can then send you an updated version, most likely it should work with most of the recent FNMS versions.
Hope this helps,
Cemson
... View more
Latest posts by Cemson
Subject | Views | Posted |
---|---|---|
1140 | Jun 09, 2021 01:47 AM | |
1425 | Feb 07, 2021 05:54 AM | |
809 | Nov 15, 2020 05:53 AM | |
1291 | Nov 14, 2020 08:19 PM | |
1330 | Nov 13, 2020 04:28 AM | |
715 | Jun 12, 2020 12:30 AM |
Activity Feed
- Posted Re: SQL Server 2019 feature: Memory optimized tables compatible issue with FNMS on FlexNet Manager Knowledge Base. Jun 09, 2021 01:47 AM
- Tagged Business Adapter Studio stops working with encryption option after VM restoration on FlexNet Manager Knowledge Base. Feb 07, 2021 06:02 AM
- Tagged Business Adapter Studio stops working with encryption option after VM restoration on FlexNet Manager Knowledge Base. Feb 07, 2021 06:02 AM
- Tagged SQL Server 2019 feature: Memory optimized tables compatible issue with FNMS on FlexNet Manager Knowledge Base. Feb 07, 2021 06:01 AM
- Tagged SQL Server 2019 feature: Memory optimized tables compatible issue with FNMS on FlexNet Manager Knowledge Base. Feb 07, 2021 06:00 AM
- Tagged SQL Server 2019 feature: Memory optimized tables compatible issue with FNMS on FlexNet Manager Knowledge Base. Feb 07, 2021 06:00 AM
- Tagged SQL Server 2019 feature: Memory optimized tables compatible issue with FNMS on FlexNet Manager Knowledge Base. Feb 07, 2021 05:59 AM
- Tagged SQL Server 2019 feature: Memory optimized tables compatible issue with FNMS on FlexNet Manager Knowledge Base. Feb 07, 2021 05:58 AM
- Posted SQL Server 2019 feature: Memory optimized tables compatible issue with FNMS on FlexNet Manager Knowledge Base. Feb 07, 2021 05:54 AM
- Posted Business Adapter Studio stops working with encryption option after VM restoration on FlexNet Manager Knowledge Base. Nov 15, 2020 05:53 AM
- Posted Alternative way to manage uploading for Flexera logs and inventories on FlexNet Manager Knowledge Base. Nov 14, 2020 08:19 PM
- Posted Re: Gap In Maintenance on FlexNet Manager Forum. Nov 13, 2020 04:28 AM
- Kudoed Ultimate SSO / SAML configuration guide in FlexNet Manager Suite for kent-au. Aug 06, 2020 05:11 AM
- Got a Kudo for Re: OS Version. Jun 12, 2020 10:04 AM
- Got a Kudo for Re: OS Version. Jun 12, 2020 06:11 AM
- Posted Re: OS Version on FlexNet Manager Forum. Jun 12, 2020 12:30 AM