SQL Query Consistently failing due to Syntax Error (Table: pegadata.pr_data_recents)
We are seeing this particular query consistently filing with the following error message:
Incorrect syntax near the keyword 'UPDATE'
The query in question is below. This is an query generated internally in Pega by web nodes. Please let us know what module this query is being called and if there is a fix.
Query attached.
Updated: 8 Nov 2022 9:11 EST
Pegasystems Inc.
GB
@max_null I am unable to see any attachments. Could you please attach again?
Can you also clarify: is the query failing?
Can you check the pegaALERT and RULES logs and find out what processes or activities you see in the logs before and after the 'update' error?
Updated: 9 Nov 2022 17:20 EST
CGI
US
@MarijeSchillern I cant attach the SQL because it keeps getting blocked as a SQL injection attack by this site. Here is a screenshot. I believe the query is failing due to the highlighted piece of code, causing syntax error. I talked to the developer and they informed me that this table is used to maintain the "recents" section in pega.
Pegasystems Inc.
GB
@max_null can you determine what activities were running when this SQL was traced at database level?
Please provide the pegaALERT and RULES log extract from that timestamp.