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

WT -> Production Build Issue -> Getting Server error on Import Rate

    Details

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

      Description

      Rate > Import Rates > Update Rates > Browse > Select File > Upload > Import > Server Error
      AH for HSPL

        Attachments

          Issue Links

            Activity

            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            peggy fiedler,

            This issue is Fixed on Stage and on production.
            The file you have attached is in .xlsb format. On Rates import only xls & xlsx format are supported.

            Please Import file with xls or xlsx format and let us know if you have any issue while import.

            Note - "&" character should not be there in import file.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - peggy fiedler , This issue is Fixed on Stage and on production. The file you have attached is in .xlsb format. On Rates import only xls & xlsx format are supported. Please Import file with xls or xlsx format and let us know if you have any issue while import. Note - "&" character should not be there in import file. Thanks, Hrishikesh.
            Hide
            pfiedler peggy fiedler (Inactive) added a comment -

            Doc3.docx now I am getting this error it uploads but wont import - I need to get these rates in ASAP!!!!!

            Show
            pfiedler peggy fiedler (Inactive) added a comment - Doc3.docx now I am getting this error it uploads but wont import - I need to get these rates in ASAP!!!!!
            Hide
            pfiedler peggy fiedler (Inactive) added a comment -

            Swapnil Pandhare can you see why this is error now - I really need these rates in as I have been waiting. THANK YOU

            Show
            pfiedler peggy fiedler (Inactive) added a comment - Swapnil Pandhare can you see why this is error now - I really need these rates in as I have been waiting. THANK YOU
            Hide
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - - edited

            Hi peggy fiedler,
            We looked into the file that you were trying to import.
            We have list of findings below for the file:
            1. Currently system is of 32 bit and .xlsx import is worked only in 62 bit environment. Once the production environment will become 64 bit you will able to import .xlsx rate file. For now you need to import rates through .xls file only.(This change will overcomes server error.)

            2. We found that file contains new rate ids which are not present in system.
            You can only update rate thorough this functionality you will not able to add new rate through this.
            one more option for this you can clone current rates and export those rates and then update them by import.
            please find attached screen shot, you can not change yellow colored highlighted fields as they are used while updating those rates.

            If you need any help please revert back. Or we will schedule a call for the same.

            Thanks,
            Harshawardhan.

            CC: Swapnil Pandhare, Saurabh Sablaka, Satya, Rakesh Roy

            Show
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - - edited Hi peggy fiedler , We looked into the file that you were trying to import. We have list of findings below for the file: 1. Currently system is of 32 bit and .xlsx import is worked only in 62 bit environment. Once the production environment will become 64 bit you will able to import .xlsx rate file. For now you need to import rates through .xls file only.(This change will overcomes server error.) 2. We found that file contains new rate ids which are not present in system. You can only update rate thorough this functionality you will not able to add new rate through this. one more option for this you can clone current rates and export those rates and then update them by import. please find attached screen shot, you can not change yellow colored highlighted fields as they are used while updating those rates. If you need any help please revert back. Or we will schedule a call for the same. Thanks, Harshawardhan. CC: Swapnil Pandhare , Saurabh Sablaka , Satya , Rakesh Roy
            Hide
            pfiedler peggy fiedler (Inactive) added a comment -

            got it thank you closed

            Show
            pfiedler peggy fiedler (Inactive) added a comment - got it thank you closed

              People

              Assignee:
              pfiedler peggy fiedler (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Harshawardhan Phalake (Inactive)
              QA:
              Priya Dhamande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: