SendSMSTreatment error and outbound SMS not working
Developer has noticed that SMS are not sent to the recipients when they run the program in NBAM 7.11.1
Error occurred in SendSMSTreatment - - Send SMS treatment aborted.
157 [fault (self-tuning)'] [ STANDARD] [ ] [ DEMO:01.01.01] (cessBatch.System_Queue_.Action) ERROR - ProcessBatch error on commit.
com.pega.pegarules.pub.database.BadTableMappingException: Database-BadTableMapping-TooManyProperties Data-BatchOutPR77 RT_AREA.BatchOutPR77 ExternalMKTData CustomerID
From: (BD287C45A5E3C0C1C8D19896DD35B2948:(Child Requestor))
Steps to Reproduce
- Create a Program.
- Map a Strategy which contains an Offer having Send SMS shape.
CustomerID property was missing from the Key mapping of the Customer class.
CustomerID must be mapped as the key in the Customer class and also in the external mappings of the Customer class. Developer did not have a CustomerID column and they were keeping the CustomerID data in the AccountID column. Developer is advised to make another column in the customer table which has AccountID data and then map the AccountID to CustomerID property.
Developer created another class inherited from the their current Customer class and mapped the CustomerID. This Local-change has resolved the issue.
0% found this useful