On analysis of a C/C++ job,SQL errors are found-Invalid byte sequence for encoding "UTF8": 0xed 0xb1 0xb8
Starting External Link processing
Ending External Link processing
SQL Error: ERROR: invalid byte sequence for encoding "UTF8": 0xed 0xb1 0xb8.
SQL Error: CONTEXT: COPY in_char_properties, line 4284 (Severity 1, Msg No 1).
Database BCP operation dbbcp_done failed on table test_local.IN_CHAR_PROPERTIES(session_id,object_id,property_type_id,property_offset,char_block,property_char)
New Job status
Execution date=2015/02/04 09:38
Execution duration=0 days, 00 hours, 38 mins, 51 secs
Execution result=error
0 fatal error(s); 20370 error(s); 6678 warning(s); 27228 information message(s).
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 | |
CSS1 |
- Package the job and deliver
- Accept and set as current version
- Run the analysis
The error occurs because the encoding which is not supported is used in the files.
- To resolve the issue,convert all the files with UTF-8 Encoding and run the analysis again.