Linked Server Openquery select fails - Cannot create cursor

Report PGNP bugs.

Linked Server Openquery select fails - Cannot create cursor

Postby slitt » Tue Sep 13, 2011 8:23 am

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
slitt
 
Posts: 1
Joined: Tue Sep 13, 2011 8:15 am

Re: Linked Server Openquery select fails - Cannot create cursor

Postby Moderator » Thu Sep 15, 2011 8:54 am

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!
User avatar
Moderator
Site Admin
 
Posts: 305
Joined: Wed Oct 29, 2008 11:27 pm


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest

cron