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

Column wise import is getting failed when adding Line item name with special characters.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Sprint:
      WT Sprint 31-Bugs

      Description

      Column wise import is getting failed when line item name is the combination of special characters refer below error log:

      : ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidationColumnWise.ImportData->ImportValidationColumnWise.ProcessImportDataFile->ImportValidationColumnWise.ValidateAndInsertData->ImportValidationColumnWise.ExecuteAllQueries
      ErrorMessage: Incorrect syntax near ','.
      Incorrect syntax near ','.
      Incorrect syntax near ','.
      Incorrect syntax near ','.
      Incorrect syntax near ','.

        Attachments

          Issue Links

            Activity

            rashmita.dudhe Rashmita Dudhe (Inactive) created issue -
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-7661 [ WT-7661 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Suraj Sokasane [ suraj.sokasane ]
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Ankur Deshpande [ ankur.deshpande ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 15/Jun/2017
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] snehal katkar [ snehal.katkar ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 15/Jun/2017 16/Jun/2017
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 56083 [ 56083 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 4h [ 14400 ] 5.5h [ 19800 ]
            Worklog Id 56085 [ 56085 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 6.5h [ 23400 ]
            Worklog Id 56086 [ 56086 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1.5h [ 5400 ]
            Time Spent 6.5h [ 23400 ] 5h [ 18000 ]
            Worklog Id 56085 [ 56085 ]
            Worklog Time Spent 1.5h [ 5400 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 5h [ 18000 ] 7h [ 25200 ]
            Worklog Id 56083 [ 56083 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 7h [ 25200 ] 8h [ 28800 ]
            Worklog Id 56103 [ 56103 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Worklog Id 56103 [ 56103 ]
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ]
            admin01 admin made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: On Hold(10207)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 8h [ 28800 ] 13h [ 46800 ]
            Worklog Id 56783 [ 56783 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1.5h [ 5400 ]
            Time Spent 13h [ 46800 ] 11.5h [ 41400 ]
            Worklog Id 56783 [ 56783 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 11.5h [ 41400 ] 16.5h [ 59400 ]
            Worklog Id 56785 [ 56785 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 16/Jun/2017 22/Jun/2017
            Developer snehal katkar [ snehal.katkar ]
            QA Rashmita Dudhe [ rashmita.dudhe ]
            Sprint WT Sprint 31-Bugs [ 71 ]
            Original Estimate 0h [ 0 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 17h [ 61200 ]
            Worklog Id 56832 [ 56832 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Resolution Cannot Reproduce [ 5 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Rashmita Dudhe [ rashmita.dudhe ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 17h [ 61200 ] 19.5h [ 70200 ]
            Worklog Id 58807 [ 58807 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 19.5h [ 70200 ] 21.5h [ 77400 ]
            Worklog Id 60436 [ 60436 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Original Estimate 0h [ 0 ] 22h [ 79200 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Developer:
              Snehal Katkar (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 22h
                  22h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 21.5h Time Not Required
                  21.5h