Linked Server Openquery select fails - Cannot create cursor

More
7 years 7 months ago #2537 by slitt
slitt created the topic: Linked Server Openquery select fails - Cannot create cursor
I am getting where my linked server open query statement is failing with the following error:
Code: 7412 SQL State: 01000 --- OLE DB provider "PGNP" for linked server "DDS_PRD_LOAD" returned message "ERROR: DECLARE CURSOR may only be used in transaction blocks
".

I am getting this error only sometimes, most of the time it works without error. The query is like:
insert into ddm_prd.dbo.agg_dmm select * from OPENQUERY(DDS_PRD_LOAD, 'select * from whse.agg_dmm where create_ts > ''1970-01-01 00:00:00.00000''::timestamp')

This SQL is run via EXEC command.

My fetch size is set to 100000 due to the fact that on many tables I am pulling large (over 1 million rows) of data to refresh my SQLServer reporting mart.

My source database is Greenplum version 4.0.5 (PG version 8.2)

Please help. I am just looking for how to make this connection more stable.

Thanks,
Shaun

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

More
7 years 7 months ago #2567 by Moderator
Moderator replied the topic: Re: Linked Server Openquery select fails - Cannot create cursor
Would you send the PGNP version number to support at pgoledb dot com? The issue might be fixed in one of the latest builds. We'll send you the latest build. Thank you!

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

Time to create page: 0.131 seconds
Powered by Kunena Forum