Error while Executing : sp_LicenseUtilisation

[chaitanyakrishn]

Hi Experts...

We are facing issues while Executing the Stored Proc "sp_LicenseUtilisation" to retrieve the license utilization information. it was working fine prior to Clean up of BPASessionLog_NonUnicode Table. 

EXEC sp_LicenseUtilisation '2023-08-01 12:00:00', '2023-08-31 23:59:00' HH;

Error : Msg 127, Level 15, State 1, Procedure sp_licenseutilisation, Line 130 [Batch Start Line 0]
A TOP N or FETCH rowcount value may not be negative.

i have verified there are no Negative Values in BPASession Table. 

Could you assist me to fix this issue ? 

Thanks In advance...

[bruce.liu]

Hi Chaitanya,

Did you put a comma after the EndDateTime (2023-08-31 23:59:00) and before the UnitOfTime (HH)? Also, did you use single quotes around HH?

You can set the EndDateTime to 2023-09-01 if you wish to cover the entirety of August 2023. The query in the stored procedure excludes the EndDateTime.

Regards,

Bruce Liu