ERROR: cursor pgnpcsrXX does not exist

More
1 year 6 months ago #14415 by pablo.carro@stlonia.com
pablo.carro@stlonia.com created the topic: ERROR: cursor pgnpcsrXX does not exist
We are receiving the following error every time we execute our SSIS process with many different values in the numeric portion of the pgnpcsrNN text of the message. We have this issue since monday this week , but we have the same SSIS process than before.

Making some test to identify the issue, we only have the problema if we inform a query in the origin OLEDB task .... but if we select a table, the SSIS Works.



SQL SERVER:
Microsoft SQL 2014 Server Enterprise (64-bit)

PGNP:
License Type: Server Edition
License Version: 1.4.0.3439

ERROR:

Error: 0xC0202009 en Tarea Flujo de datos, Origen de OLE DB [79]: Código de error SSIS DTS_E_OLEDBERROR. Error de OLE DB. Código de error: 0x80040E21.
Hay un registro OLE DB disponible. Origen: "Intellisoft OLE DB Provider for PostgreSQL" Resultado: 0x80004005 Descripción: "ERROR: cursor "pgnpcsr6" does not exist
".


Thanks

Please Log in or Create an account to join the conversation.

Time to create page: 0.095 seconds
Powered by Kunena Forum