Error while Executing : sp_LicenseUtilisation

chaitanyakrishn — Fri, 03 Nov 2023 06:09:48 GMT

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...

Re: Error while Executing : sp_LicenseUtilisation

bruce.liu — Thu, 09 Nov 2023 05:50:29 GMT

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

topic Error while Executing : sp_LicenseUtilisation in Product Forum

Error while Executing : sp_LicenseUtilisation

Re: Error while Executing : sp_LicenseUtilisation