We are facing an intermittent SAP Login issue with one of our production Bot, that performs monitoring activity on SAP BW system. The error message thrown here is "Maximum number of sessions have been reached for this connection. Please retry after sometime".
This Bot runs daily in every 30 minutes of interval starting from 00:05 to 06:05 hours. And on an average 2 to 3 runs out of 13 runs are impacted due to this error every day.
We have added multiple retries to SAP login and are closing SAP sessions in each retry. In addition to that, in each retry we are generating a new SAP session name by concatenating "SAP" text with a Random Number being generated at runtime by providing a range 'Beginning of Range' as '0' & 'End of Range' as '99999999'.
Also, we have all server side client scripting enabled by default in all our bot runners.
Please help in providing some insights on the issue and any suggestion to resolve the same. Also, if anyone has faced this issue anytime earlier and was able to find any working solution to the same?
Thanks in advance!