LS One License Activation Errors

 Related Errors:

License will expire

License Activation Failed

Issue:

An old or demo license may get stuck in the local windows folder, and is unable to be automatically deleted.

Manually deleting the license file allows a new license to be downloaded to the machine.

Standard procedure:

1. Go to the licensing portal
1. Disable then enable the licence
2. On the local machine, navigate to C:\ProgramData\LS Retail\LS POS
1. Delete the License file
3. Launch the POS
1. Enable the license from the POS
2. https://help.ls-one.com/Content/HelpTopics/General/POSLicenses.htm
4. Select License>Next

Enable RCSI on BC SQL to improve database locking issues (ADR and Optimized Locking)

Advice here

https://demiliani.com/2023/11/23/dynamics-365-business-central-sql-server-and-read-committed-snapshot-isolation-impact/

Check if RCSI is enabled

SELECT name,

       is_read_committed_snapshot_on

FROM sys.databases

WHERE name = DB_NAME();

 Enable RCSI 

ALTER DATABASE YOURDATABASE SET READ_COMMITTED_SNAPSHOT ON GO 

 

Do a full index rebuild on everything after enabling it 

--------------------------------------

Related

------------------------------------

Also consider enabling ADR, and Optimized locking if you are on SQL 2019+

https://learn.microsoft.com/en-us/sql/relational-databases/performance/optimized-locking?view=azuresqldb-current&viewFallbackFrom=sql-server-ver16#is-optimized-locking-enabled

SSRS Add parameter to Data Set

 Create your parameter @MyParameter

add it to Text data source as Select * from Mytable where myvalue = (@MyParameter)