WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6831

Unable to download excel file for records > 65k from SSRS Report

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Others
    • Module:
      ACA - Reports
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Unable to download excel file on Analysis report when record count exceeds from 65k on SSRS report

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          kumar.chhajed Kumar Chhajed (Inactive) created issue -
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 02/Dec/16 01:45 PM
          • Time Spent:
            3.5h
             

            Coding and Analysis

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 14h [ 50400 ] 10.5h [ 37800 ]
          Time Spent 3.5h [ 12600 ]
          Worklog Id 11347 [ 11347 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          Hide
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          3C's
          Concern - Unable to download excel file for records > 65k from SSRS Report
          Cause - this is a limitation of SSRS report through 2008 R2
          Correction - Added groups in RDL of 60k. Now if records exceed more than 60k, it will be added to new sheet.

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - 3C's Concern - Unable to download excel file for records > 65k from SSRS Report Cause - this is a limitation of SSRS report through 2008 R2 Correction - Added groups in RDL of 60k. Now if records exceed more than 60k, it will be added to new sheet.
          Permalink
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 05/Dec/16 12:58 PM
          • Time Spent:
            7h
             

            Coding
            Unit testing
            Internal discussion
            Check-ins

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 10.5h [ 37800 ] 7.5h [ 27000 ]
          Original Estimate 14h [ 50400 ] 11h [ 39600 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 7.5h [ 27000 ] 0.5h [ 1800 ]
          Time Spent 3.5h [ 12600 ] 10.5h [ 37800 ]
          Worklog Id 11588 [ 11588 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Sachin Hingole [ sachin.hingole ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 06/Dec/16 11:15 AM
          • Time Spent:
            0.5h
             

            Unit testing on Wheaton company on LB

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
          Time Spent 10.5h [ 37800 ] 11h [ 39600 ]
          Worklog Id 11713 [ 11713 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 11h [ 39600 ]
          Original Estimate 11h [ 39600 ] 25h [ 90000 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          Permalink
          sachin.hingole Sachin Hingole (Inactive) logged work - 07/Dec/16 11:28 AM
          • Time Spent:
            2h
             
            <No comment>
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on LB, working fine.

          NOTE - It takes time to download the report, took around 10 Min to download report in excel for wheaton LB copy.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on LB, working fine. NOTE - It takes time to download the report, took around 10 Min to download report in excel for wheaton LB copy.
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Remaining Estimate 11h [ 39600 ] 9h [ 32400 ]
          Time Spent 11h [ 39600 ] 13h [ 46800 ]
          Worklog Id 11914 [ 11914 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Permalink
          sachin.hingole Sachin Hingole (Inactive) logged work - 12/Dec/16 01:44 PM
          • Time Spent:
            1.5h
             
            <No comment>
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Remaining Estimate 9h [ 32400 ] 7.5h [ 27000 ]
          Time Spent 13h [ 46800 ] 14.5h [ 52200 ]
          Worklog Id 12548 [ 12548 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on Stage, working fine.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage, working fine.
          Permalink
          sachin.hingole Sachin Hingole (Inactive) logged work - 13/Dec/16 12:18 PM
          • Time Spent:
            1h
             
            <No comment>
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Remaining Estimate 7.5h [ 27000 ] 6.5h [ 23400 ]
          Time Spent 14.5h [ 52200 ] 15.5h [ 55800 ]
          Worklog Id 12748 [ 12748 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Production Complete(10222) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on production, working fine.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production, working fine.
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          Permalink
          sachin.hingole Sachin Hingole (Inactive) logged work - 16/Dec/16 09:32 AM
          • Time Spent:
            1h
             
            <No comment>
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Remaining Estimate 6.5h [ 23400 ] 5.5h [ 19800 ]
          Time Spent 15.5h [ 55800 ] 16.5h [ 59400 ]
          Worklog Id 13912 [ 13912 ]
          satyap Satya made changes -
          Environment_New Others [ 18445 ]
          Transition Time In Source Status Execution Times
          Kumar Chhajed (Inactive) made transition -
          Open In Development
          		2d 18h 10m 1
          Sachin Hingole (Inactive) made transition -
          In Development In LB Testing
          		1d 18m 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Stage Testing
          		6d 2h 36m 1
          Rakesh Roy (Inactive) made transition -
          Stage Testing In Production Testing
          		1d 23h 29m 1
          Sachin Hingole (Inactive) made transition -
          In Production Testing Production Complete
          		2d 1h 1m 1
          Sachin Hingole (Inactive) made transition -
          Production Complete Closed
          		6s 1

            People

            Assignee:
            sachin.hingole Sachin Hingole (Inactive)
            Reporter:
            kumar.chhajed Kumar Chhajed (Inactive)
            Developer:
            Kumar Chhajed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 25h
                25h
                Remaining:
                Time Spent - 16.5h Remaining Estimate - 5.5h
                5.5h
                Logged:
                Time Spent - 16.5h Remaining Estimate - 5.5h Time Not Required
                16.5h