The error "Character reference "" is an invalid XML character" appears when transferring data from Empower to NuGenesis LMS - WKB101646
Article number: 101646
SYMPTOMS
- The following error message appears when trying to transfer one or more results or result sets to NuGenesis LMS through the LMS-Empower Interface:
- Select null from user_tab_columns where TABLE_NAME = 'TESTRESULT' and COLUMN_NAME = 'ORIGINALRESULTID': org.xml.sax.SAXParseException: Character reference "" is an invalid XML character.
- The following message appears in the ResultSender.log file for the LMS-Empower Interface:
- ERROR Emp2ELNInterface [(null)] - select null from user_tab_columns where TABLE_NAME = 'TESTRESULT' and COLUMN_NAME = 'ORIGINALRESULTID': [com.ctc.wstx.exc.WstxLazyException] Illegal character entity: expansion character (code 0x1f
at [row,col {unknown-source}]: [3,16401]
- ERROR Emp2ELNInterface [(null)] - select null from user_tab_columns where TABLE_NAME = 'TESTRESULT' and COLUMN_NAME = 'ORIGINALRESULTID': [com.ctc.wstx.exc.WstxLazyException] Illegal character entity: expansion character (code 0x1f
ENVIRONMENT
- NuGenesis 9
- NuGenesis 8
- Empower 3
CAUSE
One or more results or result sets in Empower contain a non-printing character at code point x001F (decimal: 0031), and this character, even though it is escaped in the XML message, is flagged as an invalid character by the XML parser.
FIX or WORKAROUND
- Use a SQL script to find the projects/tables/columns with this invalid character. Because code point x001F is by definition non-printing, it will not be visible in the Empower client.
- When a sample set with the invalid character is found by the SQL script, select the sample set in Empower, right-click, and select "Create Process Only Sample Set". Specify a new name for the sample set and process the set.
- The existing sample sets, results, and result sets with this invalid character cannot be renamed and cannot be transferred to LMS.
ADDITIONAL INFORMATION
id101646, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, NGLMS, NGLMSLIC, NGLMSOPT, SUP, SUPNG