call to rotate_events_json_partitions() not correct in events_json_partitions.sql
search cancel

call to rotate_events_json_partitions() not correct in events_json_partitions.sql

book

Article ID: 262614

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Error seen in the /opt/CA/MySql/data/<SYSTEM_NAME>.err

2023-03-20T00:00:00.636878Z 5106 [ERROR] [MY-010045] [Server] Event Scheduler: [netqos@%][em.e_rotate_events_json_partitions] PROCEDURE em.e_rotate_events_json_partitions does not exist

Environment

Release : 22.2

Cause

Syntax error in the /opt/CA/PerformanceCenter/EM/SQL/events_json_partitions.sql file on the NetQos Portal 

Resolution

1. Edit /opt/CA/PerformanceCenter/EM/SQL/events_json_partitions.sql
Change:
CALL em.e_rotate_events_json_partitions();

To:
CALL em.rotate_events_json_partitions();

2. Then run: 

mysql -unetqos -p em < /opt/CA/PerformanceCenter/EM/SQL/events_json_partitions.sql

 

Additional Information

DE561306 - Fixed in 22.2.8