Auditya Kalapatapu (AudityaK9892)
Standard Chartered Bank

Standard Chartered Bank
AudityaK9892 Member since 2017 2 posts
Standard Chartered Bank
Posted: June 15, 2020
Last activity: June 15, 2020
Posted: 15 Jun 2020 14:55 EDT
Last activity: 15 Jun 2020 17:09 EDT

File upload issue while committing in DB

We are uploading 3 files and data is inserting into database. While uploading the file, it's taking very long time. As per checking, it's taking time while committing in database. We have not faced similar issue in lower environments. When we deployed into production, when we are trying to upload the files, it's taking very long time in production environment only. 


Earlier version of database, these columns are not available like pzInsKey, pxCreateDateTime, pxCommitDateTime, pxInsName, pxSavedDateTime and pxUpdateDateTime. Once we deployed the package into production, data is inserting for the above columns into database. Only latest data is inserting which we are trying to upload and older data are having null values. 

Can you please help me why only in production once we deployed, it's taking time to upload the files. To insert 369 records, it's taking almost 30-40mins. In lower environments, data used to upload within 2-3 seconds. 

Kindly help in in this regards to resolve the issue. Thank you.


***Edited by Moderator Marissa to update Content Type from Discussion to Question***

Pega Platform 7.3.1 User Experience Financial Services Front-End Developer
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.