Question

49
Views
vijay raghava (vijayr10)
Prime Therapeutics Inc

Prime Therapeutics Inc
US
vijayr10 Member since 2019 1 post
Prime Therapeutics Inc
Posted: February 23, 2020
Last activity: February 24, 2020
Posted: 23 Feb 2020 13:29 EST
Last activity: 24 Feb 2020 3:02 EST
Closed

Multiple excel Uploads are happening on a single attempt

Brief Description

Multiple excel Uploads are happening on a single attempt

Detailed Description

  • We are using MSOFileTransferButtons, Pega provided functionility to import the data via an excel file. During that we configured an activity to parse the content of the excel file to pagelist and loop through the results to save to db. 
  • We are maintianing 10 previous import copies in the same table by tracking each file version related data using a column value named audit ID
  • When user is trying to individually upload an excel file, it is uploading the same file multiple numbers of times and there by proprogating the same previous file as multiple back ups

Steps to Reproduce

>Upload an excel file using MSOFileTransferButtons

>When uploaded once, the file is getting overwritten multiple number of times

Error Message

After uploading the file, the system will hang up for a conisderable amount of time before showing the techincal problem error. For techincal assitance contact admin

Attempted Solutions

Suspecting db lock errors because of the ineffciences in saving the records to DB, for that finetuned the code. Still seeing the errors once in a while.

 

Please let me know if you need any other info. Appreciate someone's help on this.

SR-D77123

***Moderator Edit-Vidyaranjan: Updated SR details***  

Pega Platform Data Integration Java and Activities Healthcare and Life Sciences Lead System Architect Senior System Architect Support Case Exists
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.