topic Re: blue-prism-schedule-monitor in Digital Exchange

blue-prism-schedule-monitor

KarthikChandra2 — Wed, 30 Nov 2022 12:21:14 GMT

Greetings All,

We have tested "Function for Blue Prism Schedule Monitor - 1.1.0" in our environment but getting the below logs every time this executable triggers.

https://community.blueprism.com/communities/community-home?CommunityKey=1e516cfe-4d1f-4de9-a9eb-58d15bf38c81

Any help would be great

2022-11-30T12:00:51.1253898Z|INFO|---------------------------
2022-11-30T12:05:48.7294401Z|INFO|Initiating
2022-11-30T12:05:48.7584392Z|INFO|Opening connection to database
2022-11-30T12:05:48.8756103Z|INFO|Database connection opened
2022-11-30T12:05:48.9322559Z|INFO|Querying database for misfired schedules
2022-11-30T12:05:50.9389904Z|INFO|Query executed successfully
2022-11-30T12:05:51.0542937Z|FATAL|STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation.
2022-11-30T12:05:51.0562933Z|INFO|---------------------------
2022-11-30T12:10:48.8829154Z|INFO|Initiating
2022-11-30T12:10:48.9239178Z|INFO|Opening connection to database
2022-11-30T12:10:49.1528510Z|INFO|Database connection opened
2022-11-30T12:10:49.2558508Z|INFO|Querying database for misfired schedules
2022-11-30T12:10:51.6189812Z|INFO|Query executed successfully
2022-11-30T12:10:51.6915024Z|FATAL|STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation.
2022-11-30T12:10:51.6945014Z|INFO|---------------------------

Re: blue-prism-schedule-monitor

charliekovacs — Wed, 30 Nov 2022 20:27:12 GMT

Hi Karthik,

That is a bug in the Schedule Monitor that the STRING_AGG function is exceeding the 8,000 character limit in an unhandled way. I think the solution will be to truncate at that limit. I will look into providing an updated version of the Schedule Monitor and report back when I have this solved.

Re: blue-prism-schedule-monitor

Prathamesh_ — Thu, 01 Dec 2022 12:42:49 GMT

Hi karthik did you find any solution for this?

Re: blue-prism-schedule-monitor

charliekovacs — Thu, 01 Dec 2022 18:46:49 GMT

Hi Karthik,

Version 1.2.0 addresses this issue with the STRING_AGG function running over the 8,000 byte limit.
https://digitalexchange.blueprism.com/dx/entry/9648/solution/blue-prism-schedule-monitor

Let me know if the issue persists.

Re: blue-prism-schedule-monitor

yosuke — Tue, 14 Mar 2023 05:06:59 GMT

Hi Charlie,

We have received the following report related error messages using version 1.2.0 of this tool.
Could you please guide us as to the cause and solution?

Re: blue-prism-schedule-monitor

charliekovacs — Tue, 14 Mar 2023 16:33:01 GMT

@yosuke - The most likely reason for that error is that the STRING_AGG function is only available in SQL Server 2017 or later.

Re: blue-prism-schedule-monitor

lswain — Tue, 06 Jun 2023 17:53:00 GMT

Is that to say the Utility will only run on SQL 2017 or later? I'm getting the same error but I know we're running 2016.