We are receiving the following error everytime 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 morning (08/14/2017) but we have not made any change in the SSIS Package we execute.
We only have this issue if the " OLEDB data source task" (PGNP) use a query instead a table reference.
SQL SERVER:
Microsoft SQL 2014 Server Enterprise (64-bit)
PGNP Driver:
Type License : 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
".
Hi! Please update the product to the latest build. If the update will not help, please either collect detailed trace (Comment Level 2) in the PGNProfiler and email to our Support, or send us steps on how to reproduce the issue.
