-
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
Rate > Import Rates > Update Rates > Browse > Select File > Upload > Import > Server Error
AH for HSPL
- relates to
-
-
- Production Complete
-
| Issue Importance | Must Have [ 11800 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
Hi Alankar Chavan,
Please find the 3C's for the issue:
| Concern | Server error on rate import (Update) |
| Cause | Server error occurs because of inconsistent data in table "Rates_ImportExcel". |
| Correction | Need to correct the meta data from table "Rates_ImportExcel". |
Thanks and Regards,
Harshawrdhan.
Hi Alankar Chavan,
This issue is on stage and production environment so need to commit environment specific scripts to stage and production so marking this JIRA as ready for stage.
Thanks and Regards,
Harhsawardhan.
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Assignee | Harshawardhan Phalake [ harshawardhan ] | Rakesh Roy [ rakeshr ] |
Gokul Sonawane (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) |
Hi Alankar Chavan,
Please test the functionality it is deployed on Stage.
While checking import rates please note that if rate contains an '&' it will not be imported as this is technical difficulty and "&" is used internally during import processing while xml to excel formation.
Please revert back if you need any help.
Thanks,
Harshawardhan.
| Assignee | Rakesh Roy [ rakeshr ] | Kunal Kedari [ kunal.kedari ] |
Kunal Kedari (Inactive)
made changes -
| Assignee | Kunal Kedari [ kunal.kedari ] | Priya Dhamande [ priya.dhamande ] |
Khandu Kshirsagar (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) |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Assignee | Priya Dhamande [ priya.dhamande ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
This issue is fixed now . Not getting server error while Rates Import.
Observation - If Rate name or Sub rate name or anywhere in Rate '&' sign is added then rate throws serer error while import.
Now We are adding validation on Rate itself where we can not insert '&' character on Rate or Sub rate .
| 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) |
Import rate after exporting rate with some updates. Worked fine.
| Attachment | corrected rates city of irvine.xlsb [ 27332 ] |
I took out all the & and I am still getting a se corrected rates city of irvine.xlsb
rver error for City of Irvine - please see attached I am trying to import.
| Developer | Harshawardhan Phalake [ harshawardhan ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
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.
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | peggy fiedler [ pfiedler ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Attachment | Doc3.docx [ 27386 ] |
Doc3.docx now I am getting this error it uploads but wont import - I need to get these rates in ASAP!!!!!
Swapnil Pandhare can you see why this is error now - I really need these rates in as I have been waiting. THANK YOU
| Assignee | peggy fiedler [ pfiedler ] | Swapnil Pandhare [ swapnil.pandhare ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Status | Closed [ 6 ] | Reopen in Production [ 10027 ] |
| Item State | Parent values: Production Complete(10222)Level 1 values: Closed(10223) | Parent values: Production QA(10203)Level 1 values: Re-open(10220) |
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Harshawardhan Phalake [ harshawardhan ] |
| Attachment | corrected rates city of irvine.xlsx [ 27419 ] |
| Attachment | highlightedfields.png [ 27435 ] |
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.
| Assignee | Harshawardhan Phalake [ harshawardhan ] | peggy fiedler [ pfiedler ] |
| Status | Reopen in Production [ 10027 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Re-open(10220) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
got it thank you closed
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
14d 21h 28m | 1 |
|
6s | 1 |
|
19h 57m | 1 |
|
1h 16m | 2 |
|
1d 18h 51m | 2 |
|
1d 4h 13m | 2 |
|
4h 4m | 2 |
|
4h 39m | 2 |
CC: Vijay Siddha, Amruta Lohiya
Hi,
Will update the due date once WT- 4642 JIRA get fixed, as this JIRA is depend on WT- 4642.
Thanks.