| Issue Number | 3928 |
|---|---|
| Summary | Unable to add some Spanish terms/phrases with accents to the external mapping table as variants |
| Created | 2015-06-18 11:38:41 |
| Issue Type | Bug |
| Submitted By | Osei-Poku, William (NIH/NCI) [C] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2015-11-17 16:52:13 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.163585 |
When adding some Spanish terms or phases with accents to the external mapping table in the summary document using the context menu item, "Add Glossary Phrase", the following error message is displayed and the term or phrase is not added to the external mapping table as expected.
"Missing closing tag for Err element"
Here are some of the terms/phrases that could not be added and produced errors:
Glóbulos rojos
Calorías
Vómitos
Células
Síntomas
Náuseas
antihistamínicos
This does not happen to all terms or phrases with accents. Some terms with accents have been added without any problems. Here are a few examples.
Sustancias tóxicas
Reacciones alérgicas
cápsulas
This is happening on Prod but I tested some of the terms on QA and they behave the same as on Prod. On QA, you can use CDR0000256661 to troubleshoot or test
This won't happen if the variant isn't already in the mapping table. The reason you're seeing this message instead of the one you normally get when you try to put a duplicate value in the table is that SQL Server is for some reason embedding NUL bytes in the error message it sends back for the duplicate key violation if the value contains non-ASCII characters. There are several ways we could address this problem. The most general would be to modify the cdr::entConvert() method to replace NUL bytes with the string "\0" (or "\x0" or "\x00"). I'd like to discuss the options with Alan and Volker. Put this in the Darwin pile. In the meantime your workaround is to check and see if the value's already in the mapping table when you get this error (or check before trying to add the variant).
Modification to the CDR server installed on DEV. You now get the SQL Server error message explaining that you've tried to create a duplicate index entry when you encounter the conditions describe above. It's not a pretty error message, but it's much better than what you were getting, which didn't tell you anything useful.
This does not appear to be working. We're still getting the "Missing closing tag Err element" error.
Could you give it another try? Looks like another (non-Darwin) build of the CDR server had gotten installed somehow.
It is working now. Thanks!
Verified on DEV.
Verified on QA (per Amy).
Verified on PROD. Thanks!
| File Name | Posted | User |
|---|---|---|
| Variants.JPG | 2015-06-18 11:40:13 | Osei-Poku, William (NIH/NCI) [C] |
Elapsed: 0:00:00.001540