...

• CPU Time Limit in TAPSS-891

• What is a CPU timeout error? Salesforce limits CPU usage to 10 seconds for synchronous transactions and 60 seconds for asynchronous transactions. Seeing the error “Apex CPU time limit exceeded” means your transaction is taking too long and can't be completed. Salesforce platform imposes a CPU usage governor limit to any given execution context, which is approximately 10 seconds. It means that Apex Code, declarative tools or a combination in a transaction, must not exceed a ~10-second limit. It is non-negotiable. This means we cannot increase the 10-second threshold by tweaking settings, buying more allocations from Salesforce or work around it by other means. It is an absolute hard limit.

891-002 Payment batch creation Create a single batch record to create a payment across all created transactions under all the gift records in all the accounts from the intial batch created Confirm that the batch successfully closes confirm to see that all gift records' balances are 0 and transactions are created to act as payment to the intial transaction records created if the batch fails, Utility log log record will be created Record Involved: 1 Batch record 11 Batch Items 36 - 45 Transaction records per Batch Item

All steps should be executed successfully

Status colour Red title FAIL Batch 0076229 | Batch | Salesforce 20230529-2338 | UtilityLog | Salesforce

...

• Current Batch class by AQ (Managed packaged), code is hidden, thus, we cannot control the default size of the batch which is 10

• There are Process Builder and Flow by AQ which design is are also hidden - LIST DOWN NAME HERE anderson.pagtabunan Aldrin Rasdas (UofSyd) :

  • Contact Default CAE Category

  • tbc--

• One Usyd flow that were disabled to isolate testing

  • USYD_Transactions_afterInsertUpdate

...

SIMULATIONS/REPLICATIONS DONE:

...

1. MS tried to replicate the batch processing in SIT with lower batch size parameter of 1 in this record:

...

2nd Testing using the script with 1 batch size via execute anonymous in developer console, the Batch was closed successfully

3. Testing in UAT:

Unit Testing Variables:

• 10 Batch Items of different accounts

• 36 Transactions each Batch Item with payments, 2 of which no payments

Unit Testing Steps: Test User - Ana Simic

1. Created Batch record with Batch items and transaction records comparable to original related Production record.

2. Closed batch and received error on Utility Log (CPU limit not indicated on Details as UAT has different AQ package version).

   Image Added

3. Close the batch record via execute anonymous in developer console

String smartBatchId = 'a0ZBm000000AdT7MAK';
AQB.ProcessBatchItems aqSmartBatch = new AQB.ProcessBatchItems(smartBatchId);
Database.executeBatch(aqSmartBatch, 1);

4. Received a successful log.

5. Batch Record was closed successfully

...

CONCLUSION & RECOMMENDATION

The CPU time limit is a known error from Affinaquest as they don't have a configuration to adjust the Batch Size. This is still encountered during the test in RommelTest sandbox (Affinaquest version 24)

Completed Testing in SIT: SIT Testing Result

• Gift/ Pledge Unit Testing

• Gift Implementation Unit Testing

• Transaction Unit Testing

Open Items for Testing: TAP-1200/1222/1219 Issues Unit Testing

• Bug in Join utility which blocks accounts being joined

Recommendation:

Do not deploy the optimization as part of May R2 Release since it’s not fully tested in SIT. MS team and Yeng Sembrano will get more information from Affinaquest about how the batch process works on the background so we can do a Customized

Close Batch button that can be run whenever CPU time limit happens in PROD as an interim fix.