invalid byte sequence for encoding" UTF8 ": 0xf36e202d

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

invalid byte sequence for encoding" UTF8 ": 0xf36e202d

Postby cbraquehais » Thu May 23, 2013 2:51 am

I'm triying to make an sql query to a linked server and i have this error:

El proveedor OLE DB "PGNP" del servidor vinculado "ILION_OLEDB" devolvió el mensaje "Command is not prepared".
El proveedor OLE DB "PGNP" del servidor vinculado "ILION_OLEDB" devolvió el mensaje "ERROR: secuencia de bytes no válida para codificación «UTF8»: 0xf36e202d
HINT: Este error también puede ocurrir si la secuencia de bytes no coinciden con la codificación esperada por el servidor, lo cual es controlado por el parámetro «client_encoding».

In english
OLE DB provider "PGNP" for linked server "ILION_OLEDB" returned message "Command is not prepared".
OLE DB provider "PGNP" for linked server "ILION_OLEDB" returned message "ERROR: invalid byte sequence for encoding" UTF8 ": 0xf36e202d
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by the parameter "CLIENT_ENCODING".

In my query I have som spanish charcters like "ñ" or "ó" in columns alias.
If i remove this characters and query executes correctly, but I need to have them.

My linked server script is:

/****** Object: LinkedServer [ILION_OLEDB] Script Date: 05/23/2013 11:49:40 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'ILION_OLEDB', @srvproduct=N'PGPN', @provider=N'PGNP', @datasrc=N'172.18.254.10', @provstr=N'Extended Properties="FORCEUTF8=ON"', @catalog=N'ilionhq'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ILION_OLEDB',@useself=N'False',@locallogin=NULL,@rmtuser=N'postgres',@rmtpassword='########'

GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'collation compatible', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'data access', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'dist', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'pub', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'rpc', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'rpc out', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'sub', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'connect timeout', @optvalue=N'0'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'collation name', @optvalue=null
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'lazy schema validation', @optvalue=N'false'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'query timeout', @optvalue=N'0'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'use remote collation', @optvalue=N'true'
GO

EXEC master.dbo.sp_serveroption @server=N'ILION_OLEDB', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO

Is there any solution?

Thanks
cbraquehais
 
Posts: 1
Joined: Thu May 23, 2013 2:44 am

Re: invalid byte sequence for encoding" UTF8 ": 0xf36e202d

Postby Moderator » Mon May 27, 2013 1:27 am

Hi,
The bug was fixed in build 3154. We sent you an e-mail with the link to the working module.

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 302
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 2 guests

cron