AnsweredAssumed Answered

Database Login failed. Need to do connection pooling

Question asked by ameka944022 on Jul 2, 2018

Hi Team,


Test execution of CMS Claims Flow(COPY) completed with errors. Embedded message: [Function: Get record based on cms, Sql Lookup (Step 2)]: Unable to open database connection. Cannot open database "Table_Name" requested by the login. Caused by: Unable to open database connection. 


I used Sql lookup in my process and I know that I need to enable SQL Lookup but I'm not sure how to calculate "Maximum Connections", "Minimum Connections", "Maximum Idle Time", "Maximum wait time", "When Exhausted Action".

Could you please help me.