[WT-1675] ACA - UI Submission - Getting server error on verify submission for 12K records - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: ACA
Labels:
None

Environment:

QA
Module:
ACA
Reported by:
Support
Issue Importance:
Must Have

Description

Nandkumar Prabhakar Karlekar Revansiddha Gaur

1] Log in to QA Environment (LB) as partner
2] Select windstream company
3] Go to BenAdmin -> Static Reports -> IRS Submission
4] Edit "Services" IRS submission records (This 1094C has total 12K 1095C)
5] Click on Verify submission date, make sure its session does not time out

Actual Result - It gives error after 25-26 Mins, refer attachments
Expected Result - It should create XML without error

It took 3 Min to create UI Submission XML for 1416 employees. We have verified for 12K records and getting server error, refer attachments.

Sachin Hingole (Inactive) created issue - 05/Apr/16 12:42 PM

Revansiddha Gaur (Inactive) made changes - 05/Apr/16 01:16 PM

Field	Original Value	New Value
Assignee	Revansiddha Gaur [ revansiddha.gaur ]	Kumar Chhajed [ kumar.chhajed ]

Hide

Permalink

Nandkumar Prabhakar Karlekar (Inactive) added a comment - 05/Apr/16 03:12 PM

Can you please provide error log of the server error.

Show

Nandkumar Prabhakar Karlekar (Inactive) added a comment - 05/Apr/16 03:12 PM Can you please provide error log of the server error.

Nandkumar Prabhakar Karlekar (Inactive) made changes - 05/Apr/16 03:12 PM

Assignee

Kumar Chhajed [ kumar.chhajed ]

Sachin Hingole [ sachin.hingole ]

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 05/Apr/16 04:58 PM

please refer Windstream_UISubmission.txt

Show

Sachin Hingole (Inactive) added a comment - 05/Apr/16 04:58 PM please refer Windstream_UISubmission.txt

Sachin Hingole (Inactive) made changes - 05/Apr/16 04:59 PM

Assignee

Sachin Hingole [ sachin.hingole ]

Nandkumar [ satyap ]

Kumar Chhajed (Inactive) made changes - 06/Apr/16 08:25 AM

Assignee

Nandkumar [ satyap ]

Kumar Chhajed [ kumar.chhajed ]

Kumar Chhajed (Inactive) made changes - 06/Apr/16 08:25 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Kumar Chhajed (Inactive) made changes - 06/Apr/16 08:25 AM

Item State

Parent values: Development(10200)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Kumar Chhajed (Inactive) made changes - 06/Apr/16 12:02 PM

Attachment

Services_1_20160406T170526694_PerformanceStatics.txt [ 15108 ]

Kumar Chhajed (Inactive) made changes - 06/Apr/16 12:12 PM

Attachment

Services_1_20160406T170526694_PerformanceStatics.txt [ 15108 ]

Kumar Chhajed (Inactive) made changes - 14/Apr/16 07:44 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: On Hold(10207)

Kumar Chhajed (Inactive) made changes - 04/May/16 08:57 AM

Assignee

Kumar Chhajed [ kumar.chhajed ]

Sachin Hingole [ sachin.hingole ]

Kumar Chhajed (Inactive) made changes - 04/May/16 09:01 AM

Attachment

Services_1_20160406T170526694_PerformanceStatics.txt [ 16864 ]

Hide

Permalink

Kumar Chhajed (Inactive) added a comment - 04/May/16 09:03 AM

As I tested this issue locally and was non-repro, therefore assigning it back to you. Refer Services_1_20160406T170526694_PerformanceStatics.txt for Performance statistic

Show

Kumar Chhajed (Inactive) added a comment - 04/May/16 09:03 AM As I tested this issue locally and was non-repro, therefore assigning it back to you. Refer Services_1_20160406T170526694_PerformanceStatics.txt for Performance statistic

Sachin Hingole (Inactive) made changes - 07/May/16 06:03 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 07/May/16 06:04 AM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Sachin Hingole (Inactive) made changes - 07/May/16 06:11 AM

Attachment

LogFiles_Timing.zip [ 17178 ]

Sachin Hingole (Inactive) made changes - 07/May/16 06:12 AM

Attachment

56201631146AM_3369_2038.txt [ 17179 ]

Sachin Hingole (Inactive) made changes - 07/May/16 06:12 AM

Attachment

Windstream_XMLError.png [ 17180 ]

Sachin Hingole (Inactive) made changes - 07/May/16 06:28 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 07/May/16 06:28 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Sachin Hingole (Inactive) made changes - 07/May/16 06:28 AM

Resolution		Unresolved [ 10200 ]
Status	Production Testing [ 10202 ]	Reopen in Production [ 10027 ]

Sachin Hingole (Inactive) made changes - 07/May/16 06:28 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: Development(10200)

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 07/May/16 06:29 AM

Nandkumar Prabhakar Karlekar Kumar Chhajed Revansiddha Gaur Sachin Khandge Rakesh Roy Smita Pawar Mahendra Mungase

Verified the performance of XML Generation on production companies (Windstream for HSPL and Austin for HSPL).
Below statistics are on Austin for HSPL copy from production.
Employee Count - 156, total time to generate XML - 19 Sec
Employee Count - 1016, total time to generate XML - 1:25 Sec
Employee Count - 2811, total time to generate XML - 4:32 Sec
Employee Count - 5368, total time to generate XML - 7:56 Sec
Employee Count - 8179, total time to generate XML - 13:18 Sec
Employee Count - 10115, total time to generate XML - 12:49 Sec
Employee Count - 15483, total time to generate XML - 20:36 Sec - For this particular record session time out message was displayed on screen, We have clicked on "Stay logged In".

Below statistics are on windstream for HSPL copy from production. These stats are for 12K+ employees
We have run same IRS Submission for 6 times out of 6, 2 times application was throw server error, refer image , and error log file is 56201631146AM_3369_2038.txt

XML Creation time - 14:07 Sec (Successfully created XML)
XML Creation threw server error after - 9:30 Min
XML Creation threw server error after - 5:18 Min
XML Creation time - 14:15 Min (Successfully created XML)
XML Creation time - 14:10 Min (Successfully created XML)

As we got server error intermittently we are reopening this JIRA and assigning to Development team

Show

Sachin Hingole (Inactive) added a comment - 07/May/16 06:29 AM Nandkumar Prabhakar Karlekar Kumar Chhajed Revansiddha Gaur Sachin Khandge Rakesh Roy Smita Pawar Mahendra Mungase Verified the performance of XML Generation on production companies (Windstream for HSPL and Austin for HSPL). Below statistics are on Austin for HSPL copy from production. Employee Count - 156, total time to generate XML - 19 Sec Employee Count - 1016, total time to generate XML - 1:25 Sec Employee Count - 2811, total time to generate XML - 4:32 Sec Employee Count - 5368, total time to generate XML - 7:56 Sec Employee Count - 8179, total time to generate XML - 13:18 Sec Employee Count - 10115, total time to generate XML - 12:49 Sec Employee Count - 15483, total time to generate XML - 20:36 Sec - For this particular record session time out message was displayed on screen, We have clicked on "Stay logged In". Below statistics are on windstream for HSPL copy from production. These stats are for 12K+ employees We have run same IRS Submission for 6 times out of 6, 2 times application was throw server error, refer image , and error log file is 56201631146AM_3369_2038.txt XML Creation time - 14:07 Sec (Successfully created XML) XML Creation threw server error after - 9:30 Min XML Creation threw server error after - 5:18 Min XML Creation time - 14:15 Min (Successfully created XML) XML Creation time - 14:10 Min (Successfully created XML) As we got server error intermittently we are reopening this JIRA and assigning to Development team

Sachin Hingole (Inactive) made changes - 07/May/16 06:29 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Kumar Chhajed [ kumar.chhajed ]

Kumar Chhajed (Inactive) made changes - 09/May/16 06:08 AM

Assignee

Kumar Chhajed [ kumar.chhajed ]

Revansiddha Gaur [ revansiddha.gaur ]

Revansiddha Gaur (Inactive) made changes - 10/May/16 09:56 AM

Status

Reopen in Production [ 10027 ]

In Development [ 10007 ]

Rakesh Roy (Inactive) made changes - 01/Jul/16 09:22 AM

Issue Importance

Must Have [ 11800 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 01/Jul/16 11:01 AM

Resolution	Unresolved [ 10200 ]	Fixed [ 1 ]
Status	In Development [ 10007 ]	Rejected [ 10004 ]

Rakesh Roy (Inactive) made changes - 04/Jul/16 05:01 AM

Item State

Parent values: Development(10200)

Hide

Permalink

Nandkumar Prabhakar Karlekar (Inactive) added a comment - 04/Jul/16 06:06 AM

Sachin Hingole

we have retribed the 12k for windstream. so please close. this one

Show

Nandkumar Prabhakar Karlekar (Inactive) added a comment - 04/Jul/16 06:06 AM Sachin Hingole we have retribed the 12k for windstream. so please close. this one

Satya made changes - 02/Aug/16 09:20 AM

Status

Rejected [ 10004 ]

Closed [ 6 ]

Satya made changes - 04/Nov/17 06:20 AM

Environment_New

LB [ 18444 ]

Transition	Time In Source Status	Execution Times

Kumar Chhajed (Inactive) made transition - 06/Apr/16 08:25 AM

Open

In Development

19h 43m

Sachin Hingole (Inactive) made transition - 07/May/16 06:03 AM

In Development

In LB Testing

30d 21h 38m

Sachin Hingole (Inactive) made transition - 07/May/16 06:28 AM

In LB Testing

Stage Testing

24m 24s

Sachin Hingole (Inactive) made transition - 07/May/16 06:28 AM

Stage Testing

In Production Testing

Sachin Hingole (Inactive) made transition - 07/May/16 06:28 AM

In Production Testing

Reopen in Production

Revansiddha Gaur (Inactive) made transition - 10/May/16 09:56 AM

Reopen in Production

In Development

3d 3h 27m

Nandkumar Prabhakar Karlekar (Inactive) made transition - 01/Jul/16 11:01 AM

In Development

Rejected

52d 1h 5m

Satya made transition - 02/Aug/16 09:20 AM

Rejected

Closed

31d 22h 18m

People

Assignee:: Revansiddha Gaur (Inactive)

Reporter:: Sachin Hingole (Inactive)

Developer:: Revansiddha Gaur (Inactive)

QA:: Sachin Hingole (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 05/Apr/16 12:42 PM

Updated:: 04/Nov/17 06:20 AM

Resolved:: 01/Jul/16 11:01 AM

Details

Description

Attachments

Attachments

Activity

People

Dates