View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002257SymmetricDSBugpublic2015-04-07 17:392023-09-13 17:25
Reporterondrejhala Assigned To 
Priorityhigh 
Status closedResolutionopen 
Product Version3.7.11 
Summary0002257: Loading TEXT field with postgres_bulk loader: invalid byte sequence for encoding "UTF8": 0x00
DescriptionError during load of data via posgres_bulk loader:
2015-04-07 14:49:37,803 ERROR [node-mssql-pilsen] [AcknowledgeService] [qtp422250493-22] The outgoing batch node-postgre-pilsen-867 failed. ERROR: invalid byte sequence for encoding "UTF8": 0x00
  Where: COPY testdata, line 44389
Steps To ReproduceRun initial load from SQL server 2014 to PostgresSQL 9.4.1 of table containing TEXT field with NULL. Reload channel loader must be set to postgres_bulk.
Additional InformationIf i tried to load the initial load file via default loader, the exception was not been thrown. Data are correctly inserted.

SQL table:
CREATE TABLE table
(
  id bigint NOT NULL,
  author character varying(100),
  date_time timestamp without time zone,
  date_creation timestamp without time zone,
  date_deletion timestamp without time zone,
  description_l text,
  type integer NOT NULL,
  utype character varying(100),
  version_id bigint NOT NULL,
  version_uv integer NOT NULL,
  version_dev integer NOT NULL,
  locked character varying(300),
  lockdate timestamp without time zone,
  lockcounter integer,
  ts_nr character varying(300),
  prg text,
  CONSTRAINT testdata_pkey PRIMARY KEY (id)
)

How to resolve:
http://stackoverflow.com/questions/1347646/postgres-error-on-insert-error-invalid-byte-sequence-for-encoding-utf8-0x0
Tagsbulk, dialect: postgresql

Relationships

related to 0002783 closed PostgresqBulk is failling with org.postgresql.util.PSQLException invalid UTF-8 sequence 

Activities

elong

2022-09-09 21:04

developer   ~0002188

How do you reproduce this? Is the character set and collation the same on each database? Is the table definition the same on each database? Do you see a null in the source data?

Issue History

Date Modified Username Field Change
2015-04-07 17:39 ondrejhala New Issue
2019-04-23 17:08 elong Tag Attached: bulk
2019-04-23 17:08 elong Tag Attached: postgresql
2019-04-23 20:50 admin Tag Renamed postgresql => dialect: postgresql
2019-04-26 12:57 elong Summary Error during initial load with postgres_bulk loader => Loading TEXT field with postgres_bulk loader: invalid byte sequence for encoding "UTF8": 0x00
2022-09-09 21:04 elong Status new => feedback
2022-09-09 21:04 elong Note Added: 0002188
2022-09-09 21:29 elong Relationship added related to 0002783
2023-09-13 17:25 emiller Status feedback => closed