ERROR: invalid byte sequence for encoding "UTF8": 0x96

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby ryansoc » Thu Oct 04, 2012 9:06 am

Can you assist in determining if this is a configuration problem or another issue?

I'm receiving the following error (PGNP-SE-1.4.3076):

OnError,POSTGRESDEV,DOMAIN\USERNAME,Data Flow Task 9,{1EE44D97-78DD-4175-8162-2520654A750A},{F27E0BD1-8850-4497-BD9B-BDAFA7BDA401},10/4/2012 8:46:13 AM,10/4/2012 8:46:13 AM,-1071636471,0x,SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "ERROR: invalid byte sequence for encoding "UTF8": 0x96
CONTEXT: COPY TransHist, line 390
".

OnError,POSTGRESDEV,DOMAIN\USERNAME,full_export_new,{79EBE819-217A-4AB2-BF58-45A6D6A3B4B8},{F27E0BD1-8850-4497-BD9B-BDAFA7BDA401},10/4/2012 8:46:13 AM,10/4/2012 8:46:13 AM,-1071636471,0x,SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "ERROR: invalid byte sequence for encoding "UTF8": 0x96
CONTEXT: COPY TransHist, line 390
".

OnError,POSTGRESDEV,DOMAIN\USERNAME,Data Flow Task 9,{1EE44D97-78DD-4175-8162-2520654A750A},{F27E0BD1-8850-4497-BD9B-BDAFA7BDA401},10/4/2012 8:46:13 AM,10/4/2012 8:46:13 AM,-1071607767,0x,SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (95)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (95)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

OnError,POSTGRESDEV,DOMAIN\USERNAME,full_export_new,{79EBE819-217A-4AB2-BF58-45A6D6A3B4B8},{F27E0BD1-8850-4497-BD9B-BDAFA7BDA401},10/4/2012 8:46:13 AM,10/4/2012 8:46:13 AM,-1071607767,0x,SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (95)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (95)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

OnError,POSTGRESDEV,DOMAIN\USERNAME,Data Flow Task 9,{1EE44D97-78DD-4175-8162-2520654A750A},{F27E0BD1-8850-4497-BD9B-BDAFA7BDA401},10/4/2012 8:46:13 AM,10/4/2012 8:46:13 AM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 40 - TransHist" (82) failed with error code 0xC0209029 while processing input "Destination Input" (95). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

OnError,POSTGRESDEV,DOMAIN\USERNAME,full_export_new,{79EBE819-217A-4AB2-BF58-45A6D6A3B4B8},{F27E0BD1-8850-4497-BD9B-BDAFA7BDA401},10/4/2012 8:46:13 AM,10/4/2012 8:46:13 AM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 40 - TransHist" (82) failed with error code 0xC0209029 while processing input "Destination Input" (95). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
ryansoc
 
Posts: 5
Joined: Mon Oct 01, 2012 2:04 pm

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby Moderator » Fri Oct 05, 2012 12:05 am

Could you send us the table DDL, and a sample row(s) that reproduces the error?

I suspect that there might be a bug in the data encoding...
User avatar
Moderator
Site Admin
 
Posts: 303
Joined: Wed Oct 29, 2008 11:27 pm

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby ryansoc » Fri Oct 05, 2012 10:11 am

From that error, is there a way to determine what row it's failing on?
ryansoc
 
Posts: 5
Joined: Mon Oct 01, 2012 2:04 pm

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby ryansoc » Fri Oct 05, 2012 11:04 am

So I changed the source to be a view limiting the row count...at 1000 rows it fails...at 999 it succeeds...so I tweaked the view to exclude the last row and it still fails at 1000.

I disabled that particular DataFlow item in the DTSX and notice fails in other DataFlows...all at the 1000th row...

Some Data Flow's with tables larger than 1000 rows seem to work fine...now trying to see what the similarities are in the failing tables.
ryansoc
 
Posts: 5
Joined: Mon Oct 01, 2012 2:04 pm

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby ryansoc » Mon Oct 08, 2012 9:10 am

On the tables that fail...it always occurs at the same row number as set in the BULK_INSERT value of the connection string. If it's set at 1000 it fails at the 1000th row..if it's set at 500 it fails at the 500th row. :?:
ryansoc
 
Posts: 5
Joined: Mon Oct 01, 2012 2:04 pm

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby Moderator » Mon Oct 08, 2012 9:11 pm

Would you send the table DDL?
User avatar
Moderator
Site Admin
 
Posts: 303
Joined: Wed Oct 29, 2008 11:27 pm

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby ryansoc » Tue Oct 09, 2012 8:52 am

I just sent the DDL for one of the tables that's failing.

I found if I change the connection string to BULK_INSERT=0 it succeeds.
ryansoc
 
Posts: 5
Joined: Mon Oct 01, 2012 2:04 pm

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x96

Postby Moderator » Tue Oct 09, 2012 10:02 am

Thank you for the DDL. We will try to fix the bug, and will update this thread.
User avatar
Moderator
Site Admin
 
Posts: 303
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests