SSIS packages started to crash after PGNP upgrade

More
6 years 1 week ago #11092 by erdem.ozkan
erdem.ozkan created the topic: SSIS packages started to crash after PGNP upgrade
Today I upgraded the PGNP OLE DB connector to the new version(1.4.0.3248) by using the PGNPUpdate tool.

After the upgrade, every time I execute the same package, different data flow tasks in the package started to fail randomly. All data flow tasks in the package have PostgreSQL database as source and MSSQL database as destination. For each time error in the log is same as below :

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "ERROR: syntax error at end of input
LINE 1: FETCH FORWARD 10000 FROM

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "ERROR: syntax error at end of input
LINE 1: FETCH FORWARD 4100 FROM

Everything was back to normal after downgrading back to version [1.4.0.3206] .

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

More
6 years 1 week ago #11093 by Moderator
Moderator replied the topic: Re: SSIS packages started to crash after PGNP upgrade
Thank you for letting us know. Could you e-mail test package(s) to us? We are also going to re-test the build with our test packages.

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

Time to create page: 0.085 seconds
Powered by Kunena Forum