WORKTERRAProject Type: software

WORKTERRA

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

Production_Import_Getting error while creating Global level template.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      LB QA - On Hold
    • Sprint:
      WT Sprint 39 - Bugs

      Description

      1.Login to Production with Partner.
      2.Navigate to Home >> Benadmin Home >> Template Management
      3.Create Global level ACA template.
      4.Add Template information.
      5.Add Header Trailer information.
      6.Add Sub Template.

      Actual: Received server error when clicked on Subtemplate.
      Expected: No error should receive, user should able to add subtemplate.

      Error log is as follows:

      ErrorID : 0
      ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->ImportExportSettings.GetData->ImportExportSettings.GetImportExportTemplateFieldMappingForGivenName
      ErrorMessage: Could not find stored procedure 'OES_SP_Import_GetMandatoryFieldsListForImport'.
      StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
      TargetSite: System.String GetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          smita.pawar Smita Pawar (Inactive) created issue -
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Field Original Value New Value
          Assignee Suraj Sokasane [ suraj.sokasane ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Vishal Bajad [ vishal.bajad ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Sprint WT Sprint 39 - Bugs [ 90 ]
          Jennifer.Reed Jennifer Reed (Inactive) made changes -
          Labels Kindercare
          Jennifer.Reed Jennifer Reed (Inactive) made changes -
          Labels Kindercare
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          Hide
          Permalink
          vishal.bajad Vishal Bajad (Inactive) added a comment -

          Hi Jayshree Nagpure ,

          This issues has been resolved and deployed on Production, Please verify.

          Thanks !

          CC : Jaideep Vinchurkar

          Show
          vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Jayshree Nagpure , This issues has been resolved and deployed on Production, Please verify. Thanks ! CC : Jaideep Vinchurkar
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Assignee Vishal Bajad [ vishal.bajad ] Jayshree Nagpure [ jayshree.nagpure ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Attachment SubTemplate.jpg [ 64862 ]
          Hide
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi Vishal Bajad,

          Verified on Production
          Created new template - Pass for all fields
          When we click on sub template for exiting template - system throws error

          ErrorID : 0
          ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->ImportExportSettings.GetData->ImportExportSettings.GetImportExportSubTemplateForGivenName
          ErrorMessage: MappedFieldValueID
          StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
          at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
          TargetSite: System.String GetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

          Hence re-opening this jira

          Thanks,
          Jayshree

          cc : Rakesh Roy Prasad Pise

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Vishal Bajad , Verified on Production Created new template - Pass for all fields When we click on sub template for exiting template - system throws error ErrorID : 0 ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->ImportExportSettings.GetData->ImportExportSettings.GetImportExportSubTemplateForGivenName ErrorMessage: MappedFieldValueID StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput) TargetSite: System.String GetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity) Hence re-opening this jira Thanks, Jayshree cc : Rakesh Roy Prasad Pise
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Re-open(10220)
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Assignee Jayshree Nagpure [ jayshree.nagpure ] Vishal Bajad [ vishal.bajad ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Production Testing [ 10202 ] Reopen in Production [ 10027 ]
          Permalink
          vishal.bajad Vishal Bajad (Inactive) logged work - 18/Oct/17 01:42 PM
          • Time Spent:
            0.5h
             
            <No comment>
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 85611 [ 85611 ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Status Reopen in Production [ 10027 ] In Development [ 10007 ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Re-open(10220) Parent values: Development(10200)Level 1 values: In Analysis(10204)
          Permalink
          vishal.bajad Vishal Bajad (Inactive) logged work - 24/Oct/17 01:20 PM
          • Time Spent:
            4h
             
            <No comment>
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Time Spent 0.5h [ 1800 ] 4.5h [ 16200 ]
          Worklog Id 86107 [ 86107 ]
          Hide
          Permalink
          vishal.bajad Vishal Bajad (Inactive) added a comment -

          Hi Jaideep Vinchurkar,

          With the initial analysis , we found that there were two duplicate script with huge diff in script at "WT\branches\Production\Database Objects\OnlineEnrollment\04_Stored Procedures" Named and order as belows ,

          • dbo.OES_SP_Export_GetGlobalSubtemplateFieldsMappingData
          • dbo.OES_SP_Export_GetGlobalSubtemplateFieldsMappingData.StoredProcedure
            First script is latest and updated but while build updated script getting overwrite by old script and its causes an error in global level sub template.

          Please suggest , which one should be deleted.

          Thanks !

          CC : Jaideep Vinchurkar Satya Ankur Deshpande

          Show
          vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Jaideep Vinchurkar , With the initial analysis , we found that there were two duplicate script with huge diff in script at "WT\branches\Production\Database Objects\OnlineEnrollment\04_Stored Procedures" Named and order as belows , dbo.OES_SP_Export_GetGlobalSubtemplateFieldsMappingData dbo.OES_SP_Export_GetGlobalSubtemplateFieldsMappingData.StoredProcedure First script is latest and updated but while build updated script getting overwrite by old script and its causes an error in global level sub template. Please suggest , which one should be deleted. Thanks ! CC : Jaideep Vinchurkar Satya Ankur Deshpande
          Permalink
          vishal.bajad Vishal Bajad (Inactive) logged work - 25/Oct/17 12:59 PM
          • Time Spent:
            2h
             
            <No comment>
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Time Spent 4.5h [ 16200 ] 6.5h [ 23400 ]
          Worklog Id 86373 [ 86373 ]
          Hide
          Permalink
          vishal.bajad Vishal Bajad (Inactive) added a comment -

          Hi All ,

          As discussed with Vinayak Kulkarni , will remove "dbo.OES_SP_Export_GetGlobalSubtemplateFieldsMappingData" script and move LB script to Stage and Production with next build.

          Thanks !

          Show
          vishal.bajad Vishal Bajad (Inactive) added a comment - Hi All , As discussed with Vinayak Kulkarni , will remove "dbo.OES_SP_Export_GetGlobalSubtemplateFieldsMappingData" script and move LB script to Stage and Production with next build. Thanks !
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 25/Oct/17 03:24 PM
          • Time Spent:
            1h
             
            <No comment>
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 6.5h [ 23400 ] 7.5h [ 27000 ]
          Worklog Id 87930 [ 87930 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Labels Manual_import
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Vishal Bajad [ vishal.bajad ] Suraj Sokasane [ suraj.sokasane ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          Hide
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

          Hi Smita Pawar,

          This issue is not exists in production. Please check and close this.

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi Smita Pawar , This issue is not exists in production. Please check and close this. Thanks, Ganesh
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Suraj Sokasane [ suraj.sokasane ] Smita Pawar [ smita.pawar ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified, not getting server error while creating Global level template.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified, not getting server error while creating Global level template.
          smita.pawar Smita Pawar (Inactive) made changes -
          Status In LB Testing [ 10200 ] Stage Testing [ 10201 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Stage Testing [ 10201 ] In Production Testing [ 10202 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Unresolved [ 10200 ] Bug Fixed [ 10402 ]
          Status In Production Testing [ 10202 ] Production Complete [ 10028 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 04/Apr/18 01:39 AM
          • Time Spent:
            20m
             

            Jira updates
            verification

          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 7.5h [ 27000 ] 7h 50m [ 28200 ]
          Worklog Id 111336 [ 111336 ]
          Transition Time In Source Status Execution Times
          Vishal Bajad (Inactive) made transition -
          Open In Development
          		13d 20h 47m 1
          Jayshree Nagpure (Inactive) made transition -
          In Production Testing Reopen in Production
          		16m 59s 1
          Vishal Bajad (Inactive) made transition -
          Reopen in Production In Development
          		5d 23h 11m 1
          Vishal Bajad (Inactive) made transition -
          In Development In LB Testing
          		2d 2h 3m 2
          Smita Pawar (Inactive) made transition -
          In LB Testing Stage Testing
          		159d 17h 51m 2
          Smita Pawar (Inactive) made transition -
          Stage Testing In Production Testing
          		10s 2
          Smita Pawar (Inactive) made transition -
          In Production Testing Production Complete
          		13s 1
          Smita Pawar (Inactive) made transition -
          Production Complete Closed
          		3s 1

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            smita.pawar Smita Pawar (Inactive)
            Developer:
            Suraj Sokasane (Inactive)
            QA:
            Jayshree Nagpure (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 7h 50m
                7h 50m