Getting the Error using Execute Stored Procedure multiple time in the batching process.

Hello All,

We are using 1 PM in which we are using the smart service "Execute Stored Procedure", We are having 10K+ data in the staging table and we are using the batching logic to trigger the stored procedure for 1000 batch. Th stored procedure function is to get that batch start and end index as parameter and fetch that much data from the staging table and run different sql queries , insert data in the different table.

The same sub process I am using multiple time but when 1 is ending I am triggering another one, not running all parallel. I am getting wired error in some batch running after 7000 or 8000 data.

The error: "An error occurred in executing an Activity Class." Not getting anything in logs as well.

Sharing the screenshot of the error aslo.

Let me know how to resolve this issue.

Thanks in advance.