Question
PT Kynerja Abadi Solusindo
ID
Last activity: 6 Nov 2024 8:28 EST
Stored Procedure on RDB-List Error for many data
So I have a stored procedure that has a cursor in it, to select and insert data into some tables.
I call the procedure with RDB-List on the activity and it works fine but if my case has many rows of data, the process stops and the rest of the data is not inserted (data entered may vary each time run sometimes 20+, 30+ then stops). After that the activity still executes the next steps.
Is it because it takes a long time to process the RDB-List? and is there a way to extend the RDB-List timeout threshold?
Thank you
Pegasystems Inc.
GB
@FerdinandAlvisK It sounds like the issue might be related to the timeout threshold for the RDB List method. When dealing with large datasets the processing time can exceed the default timeout settings causing the process to stop prematurely. To address this you can try increasing the timeout threshold for the RDB List method. This can be done by adjusting the timeout settings in the Connect SQL rule associated with your RDB List method. Ensure that the timeout value is sufficient to handle the processing of large datasets.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
PT Kynerja Abadi Solusindo
ID
@MarijeSchillern I can't find settings tab on Connect-SQL rule, can you provide screenshot where can i adjust the timeout? Thank you.
Pegasystems Inc.
GB
@FerdinandAlvisK from our genAI documentation search:
To adjust the timeout settings for the RDB List method in the Connect SQL rule you will need to configure the SQL connection to the external database. This involves using an activity that references the RDB List method which matches the names of the tabs in the connector rule. You can set the timeout by modifying the appropriate dynamic system settings or properties that control the timeout behavior for the RDB List method. If you are unable to find the settings tab ensure you are looking in the correct area of the application where the Connect SQL rules are managed.
--> please log a support ticket for this to get further help.