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

LB - Add Company - Getting server error while add new company

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Customization
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 31-Bugs

      Description

      Getting server error when we add new company on LB.

      ErrorID : 0
      ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.AddCompany->Company.UploadStandardsReports->RDLGenerator.UploadRDL
      ErrorMessage: Invalid URI: The format of the URI could not be determined.

      Due to this we cannot test WT-715

        Attachments

          Issue Links

            Activity

            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) created issue -
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Field Original Value New Value
            Link This issue blocks WT-715 [ WT-715 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Prasanna Karlekar [ prasanna ]
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            This is report issue.Please check.
            CC:Satya

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - This is report issue.Please check. CC: Satya
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Harshada Borole [ harshada.borole ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue is caused by WT-9223 [ WT-9223 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)
            prasanna Prasanna Karlekar (Inactive) logged work - 16/Jun/17 09:00 PM
            • Time Spent:
              0.5h
               

              Discussion on Parallel Reporting Server issue while Add company

            harshada.borole Harshada Borole (Inactive) logged work - 17/Jun/17 04:19 AM
            • Time Spent:
              7h
               

              Analysis,Coding and Testing

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 7h [ 25200 ]
            Worklog Id 55985 [ 55985 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Due Date 22/Jun/2017
            Developer Harshada Borole [ harshada.borole ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Sprint WT Sprint 31-Bugs [ 71 ]
            Original Estimate 0h [ 0 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 19/Jun/17 09:30 PM
            • Time Spent:
              0.5h
               

              Changes go through for Add company error resolution
              Discussion to add function to fetch ReportServerAddress in RDLGenerator

            harshada.borole Harshada Borole (Inactive) logged work - 19/Jun/17 09:42 PM
            • Time Spent:
              8h
               

              Discussion,Coding,testing

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 7h [ 25200 ] 15h [ 54000 ]
            Worklog Id 56648 [ 56648 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 15h [ 54000 ] 15.5h [ 55800 ]
            Worklog Id 56845 [ 56845 ]
            harshada.borole Harshada Borole (Inactive) logged work - 20/Jun/17 04:16 PM
            • Time Spent:
              5h
               

              Sent code for review and unit testing.

            prasanna Prasanna Karlekar (Inactive) logged work - 20/Jun/17 07:30 PM
            • Time Spent:
              0.5h
               

              Reports related error resolution when company created using Add Company

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 15.5h [ 55800 ] 20.5h [ 73800 ]
            Worklog Id 56877 [ 56877 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 20.5h [ 73800 ] 21h [ 75600 ]
            Worklog Id 57023 [ 57023 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 21h [ 75600 ] 21.5h [ 77400 ]
            Worklog Id 57034 [ 57034 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Code Review Date 21/Jun/2017
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            harshada.borole Harshada Borole (Inactive) logged work - 21/Jun/17 03:56 PM
            • Time Spent:
              5h
               

              Coding,Testing,send code for review,LB commit,created document

            prasanna Prasanna Karlekar (Inactive) logged work - 21/Jun/17 07:30 PM - edited
            • Time Spent:
              1.5h
               

              Code Review - Changes suggested and made
              Functionality review and scenario verification
              Document go through

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 21.5h [ 77400 ] 26.5h [ 95400 ]
            Worklog Id 57288 [ 57288 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 26.5h [ 95400 ] 28h [ 100800 ]
            Worklog Id 57307 [ 57307 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Worklog Id 57307 [ 57307 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 23/Jun/17 12:30 AM
            • Time Spent:
              1h
               

              Document Review, changes and discussion

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 28h [ 100800 ] 29h [ 104400 ]
            Worklog Id 57782 [ 57782 ]
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are the 3C's:

            Concern:- LB - Add Company - Getting server error while add new company
            Cause:- This bug is because WT-9377 was pending.
            Correction:- WT-9377 has been implemented.

            Files Affected:

            • Company.vb
            • dbo.OES_SP_CloneCompany.StoredProcedure.sql
            • RDLGenerator.vb
            • Company.dll.config
            • WORKTERRAControllerAppTier.cs
            • Company.dll.config

            Scenarios Verified:
            Created new company. Tested all reports for newly created company.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's : Concern :- LB - Add Company - Getting server error while add new company Cause :- This bug is because WT-9377 was pending. Correction :- WT-9377 has been implemented. Files Affected : Company.vb dbo.OES_SP_CloneCompany.StoredProcedure.sql RDLGenerator.vb Company.dll.config WORKTERRAControllerAppTier.cs Company.dll.config Scenarios Verified : Created new company. Tested all reports for newly created company.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Sachin Hingole [ sachin.hingole ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (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)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 23/Jun/17 08:45 AM
            • Time Spent:
              0.25h
               
              <No comment>
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Harshada Borole,

            Still getting error while adding new company on LB.
            Reopening this JIRA .

            Thanks,
            Hrishikesh

            Prasanna Karlekar

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Harshada Borole , Still getting error while adding new company on LB. Reopening this JIRA . Thanks, Hrishikesh Prasanna Karlekar
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Harshada Borole [ harshada.borole ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 29h [ 104400 ] 29.25h [ 105300 ]
            Worklog Id 57801 [ 57801 ]
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Could you please provide error log..?

            Thank you.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Hrishikesh Deshpande , Could you please provide error log..? Thank you.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            ErrorID : 0
            ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.AddCompany->Company.BackupAndRestoreNewCompany
            ErrorMessage: Cannot open backup device '\\WORKTERRASQL\DatabaseBackup\CloneCompany\MasterCompanyDB_20170623.BAK'. Operating system error 67(The network name cannot be found.).
            BACKUP DATABASE is terminating abnormally.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - ErrorID : 0 ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.AddCompany->Company.BackupAndRestoreNewCompany ErrorMessage: Cannot open backup device '\\WORKTERRASQL\DatabaseBackup\CloneCompany\MasterCompanyDB_20170623.BAK'. Operating system error 67(The network name cannot be found.). BACKUP DATABASE is terminating abnormally.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Harshada Borole [ harshada.borole ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Khandu Kshirsagar [ khandu.kshirsagar ]
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Khandu Kshirsagar,

            Please resolve above error mentioned by Hrishikesh regarding path sharing for MasterCompanyDB used while adding company.

            cc: Ashwin Wankhede, Jyoti Agrawal, Prasanna Karlekar

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Khandu Kshirsagar , Please resolve above error mentioned by Hrishikesh regarding path sharing for MasterCompanyDB used while adding company. cc: Ashwin Wankhede , Jyoti Agrawal , Prasanna Karlekar
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Khandu Kshirsagar,

            Please resolve above error mentioned by Hrishikesh regarding path sharing for MasterCompanyDB used while adding company.

            cc: Ashwin Wankhede, Jyoti Agrawal, Prasanna Karlekar

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Khandu Kshirsagar , Please resolve above error mentioned by Hrishikesh regarding path sharing for MasterCompanyDB used while adding company. cc: Ashwin Wankhede , Jyoti Agrawal , Prasanna Karlekar
            Show
            khandu.kshirsagar Khandu Kshirsagar (Inactive) added a comment - Hi Harshada Borole , Please check now. Ashwin Wankhede , Jyoti Agrawal , Prasanna Karlekar
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Assignee Khandu Kshirsagar [ khandu.kshirsagar ] Harshada Borole [ harshada.borole ]
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            The issue has been resolved now.
            Please check.

            Thank you.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Hrishikesh Deshpande , The issue has been resolved now. Please check. Thank you.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            harshada.borole Harshada Borole (Inactive) logged work - 23/Jun/17 12:51 PM
            • Time Spent:
              1.5h
               

              Analysis and discussion

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 29.25h [ 105300 ] 30.75h [ 110700 ]
            Worklog Id 57960 [ 57960 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Following are the 3C's for reopening of issue:
            Concern:
            ErrorMessage: Cannot open backup device '\\WORKTERRASQL\DatabaseBackup\CloneCompany\MasterCompanyDB_20170623.BAK'.

            Cause:
            Folder sharing and access rights were improper on LB environment.

            Correction:
            Appropriate rights have been given by deployment engineer.

            Please note that folder access / rights related issues for any environment are not caused because of code fixes.

            As no code fix is required, have changed the item state to LB Deployed.
            Please verify at your end once.

            Thank you!

            cc: Gaurav Sodani, Satya, Rakesh Roy

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Hrishikesh Deshpande , Following are the 3C's for reopening of issue: Concern: ErrorMessage: Cannot open backup device '\\WORKTERRASQL\DatabaseBackup\CloneCompany\MasterCompanyDB_20170623.BAK'. Cause: Folder sharing and access rights were improper on LB environment. Correction: Appropriate rights have been given by deployment engineer. Please note that folder access / rights related issues for any environment are not caused because of code fixes. As no code fix is required, have changed the item state to LB Deployed. Please verify at your end once. Thank you! cc: Gaurav Sodani , Satya , Rakesh Roy
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This issues is Fixed on LB, Ready for Stage.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issues is Fixed on LB, Ready for Stage.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 30.75h [ 110700 ] 31.25h [ 112500 ]
            Worklog Id 59128 [ 59128 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 29/Jun/17 06:29 PM
            • Time Spent:
              0.5h
               
              <No comment>
            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)
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            harshada.borole Harshada Borole (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)
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment - - edited

            This issue was deployed on Stage on July 6,2017.

            Thank you.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - - edited This issue was deployed on Stage on July 6,2017. Thank you.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This issues is Fixed on Stage, Ready for Production.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issues is Fixed on Stage, Ready for Production.
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Could you please mark this JIRA as OnHold. We can move this on Production once WT-9223 is made Ready for Production.

            cc: Satya, Harshada Borole, Jyoti Agrawal

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Hrishikesh Deshpande , Could you please mark this JIRA as OnHold. We can move this on Production once WT-9223 is made Ready for Production. cc: Satya , Harshada Borole , Jyoti Agrawal
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129, WT-9377 and WT-9223 move at same time on Production. So, We will move all enhancement on 09/19/2017

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129 , WT-9377 and WT-9223 move at same time on Production. So, We will move all enhancement on 09/19/2017 CC - Sachin Hingole
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Code Review Date 21/Jun/2017 21/Jun/2017
            Dev Due Date 22/Jun/2017 22/Jun/2017
            Production Due Date 19/Sep/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This Fix is deployed on Production.

            Closing this JIRA as ADD Company testing is not in testing scope.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This Fix is deployed on Production. Closing this JIRA as ADD Company testing is not in testing scope.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            9d 21h 9m 1
            Hrishikesh Deshpande (Inactive) made transition -
            In LB Testing Reopen in Local
            24m 18s 1
            Prasanna Karlekar (Inactive) made transition -
            Reopen in Local In Development
            4d 23h 35m 1
            Hrishikesh Deshpande (Inactive) made transition -
            In Development In LB Testing
            7d 20h 56m 2
            Hrishikesh Deshpande (Inactive) made transition -
            In LB Testing Stage Testing
            12d 21h 44m 1
            Hrishikesh Deshpande (Inactive) made transition -
            Stage Testing In Production Testing
            69d 8h 27m 1
            Hrishikesh Deshpande (Inactive) made transition -
            In Production Testing Production Complete
            48s 1
            Hrishikesh Deshpande (Inactive) made transition -
            Production Complete Closed
            5s 1

              People

              Assignee:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Reporter:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Developer:
              Harshada Borole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 31.25h
                  31.25h