Posted: 31 Oct 2019 9:08 EDT Last activity: 31 Oct 2019 9:53 EDT
Agile Studio Import Slowness Question
I installed a Pega Platform 8.1 instance a few months back with Agile Studio and while doing the import for Agile studio it took a deathly amount of hours to finish. This instance was configured with Tomcat Apache 8 & Sql Server DB. Recently one of my colleagues performed the same import for another Pega 8.3 instance which utilizes Tomcat Apache 8 & Oracle DB. In the catalina logs he was able to locate some errors which pointed to an attribute/value named MaxOpenCursors which was set to around 60 but once he ran the following command: ALTER SYSTEM SET open_cursors = 800 SCOPE=BOTH; He noticed the import sped up intensely. So I did some digging in the logs from when I initially created the 8.1 instance but found no such attribute/value or any errors even remotely close.
I am wondering if anyone has any idea on if there is a similar attribute/value which can be configured to speed up the Agile studio import for Sql Server? Or anything that can be configured to accelerate the import process?
To start with, make sure you only have single node running when importing, sync up among multiple nodes can be very slow you should avoid that if possible. We have been importing apps on sqlserver tomcat without any issues. Can you share your context.xml? I would like to check your settings.
Thanks for the reply. Yes single node was running when I initially did the import a few months back. We weren't having any "issues" it just took a very very long time for the import. I have attached the context.xml file. Thanks.