Purpose (problem description)

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).

Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x (tick) 
7.3.x(tick)
7.2.x(tick)
7.0.x(error)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(error)
Microsoft SQL Server(error)
CSS3(tick)
CSS2(tick)
CSS1(error)
Step by Step scenario
  1. Package the job and deliver
  2. Accept and set as current version
  3. Run the analysis
Action Plan

The error occurs because the encoding which is not supported is used in the files.

  1. To resolve the issue,convert all the files with UTF-8 Encoding and run the analysis again.
Related Pages
Ticket # 993