SMS records not getting deleted from PR_DATA_CORR_SMS table
User has tried to insert the data for OutboundSMS in PR_DATA_CORR_SMS table while running a Program by using “write now” in “PrepareSMS” Activity to test it temporarily as the commit was not happening currently. The SMS record was written in the PR_DATA_CORR_SMS table. It’s getting picked up and sent, but the record was not getting deleted from PR_DATA_CORR_SMS table as a result its sending the same SMS continuously. May be the status was not getting updated in the PR_DATA_CORR_SMS table for the records to be deleted.
There were no error messages, same SMS were being sent by the agent infinite times.
Steps to Reproduce
Create a Split schema setup for Pega 7.1.6 with NBAM v7.1.1 with Oracle database and Weblogic application server
Configure for the SMS server and create an Offer flow with send SMS shape
Run the Offer flow
The entry under the table PR_DATA_CORR_SMS was not getting deleted due to the delete query from sendSMSBatch activity was being failed to execute on the DATA schema.
User have a local change in place under SendSMSBatch by explicitly mentioning the PegaDATA schema alias to the DB queries (delete and update) being triggered.
0% found this useful