Problem Note 69732: SAS® Event Stream Processing metering server summary requests fail with a 500 error
 |  |  |  |  |
The following requests to the SAS Event Stream Processing metering server fail with a 500 error:
- /eventStreamProcessing/v1/meterYearlySummary
- /eventStreamProcessing/v1/meterMonthlySummary
As a result, the metering log shows an error similar to the following for each request:
[*]MONTH,PROPERTIES,SUM(NUM_EVENTS) AS EVENTS FROM EVENT_COUNTS GROUP BY LICENSE,YEAR,MONTH,PROPERTIES
ORDER BY LICENSE,YEAR ASC,MONTH ASC"; expected "("; SQL statement:
select license,year,month,properties,sum(num_events) as events from event_counts group by
license,year,month,properties order by license,year asc,month asc [42001-206]
The SAS® Event Stream Manager Metering tab does not show any metering events.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Event Stream Processing Engine | Microsoft® Windows® for x64 | 6.2 | |||
| Linux for x64 | 6.2 | |||||
Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinAn update for this issue is available for SAS Event Stream Processing 6.2. For instructions on how to access and apply this software update see the SAS Event Stream Processing 6.2 Deployment Guide links on
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_ESP_6_2_home.html#69732| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2024-01-10 17:55:28 |
| Date Created: | 2022-12-01 11:46:39 |