Cursor pgnpcsrXX does not exist

More
3 months 2 days ago #14416 by pablo.carro@stlonia.com
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
".


Thank you very much

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

More
3 months 2 days ago #14417 by admin
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.

Thank you!

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

Time to create page: 0.126 seconds
Powered by Kunena Forum