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
          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
          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
          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
          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 !
          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
          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.

            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