SQL Server Native Client 11.0 Invalid cursor state

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
DavidWipf
Participant
Posts: 2
Joined: Fri Dec 05, 2014 9:49 am

SQL Server Native Client 11.0 Invalid cursor state

Post by DavidWipf »

Sorry it is not obvious how to post a new topic.

DataStage 11.5, SQL Server 2005 with after update and after insert triggers on the table, OS windows 2012, using ODBS Stage.

on last run 89 records updated successfully and 44253 went to my error log. Nothing is wrong the the queries or the data. DataStage does not like the after triggers on the table and returns this error message with each row in the Errorlog table: "[Microsoft][SQL Server Native Client 11.0]Invalid cursor state".

It does not matter if I code this as an update then insert or separately do the updates and the inserts. It does not matter what I set the autocommit mode to. it does not matter if I run in parallel or sequential. the queries work in SQL Server management studio.

Is there anyway to get DataStage to behave correctly? Some coworkers have solved this by writing the data to a stage table that does not have triggers and then doing an after SQL out of the stage table and into the real table which removed DataStage from the picture doing the work purely in the DB. This works but seems a little extreme to me. Why doesn't DataStage work for this? Am I missing a patch?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No worries, split you off from the other post so this one can be all yours.

And just as an FYI, you can start a new post using the Post new topic link at the top and bottom of each forum page.
-craig

"You can never have too many knives" -- Logan Nine Fingers
DavidWipf
Participant
Posts: 2
Joined: Fri Dec 05, 2014 9:49 am

any ideas on an answer?

Post by DavidWipf »

Do you have any answers to my question?

by the way this is what is says on the bottom on my screen:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If I had answers, not to worry I would post them. Just "moderating" things in the forums at the moment, can't help with your specific issue.

And that's messed up, no clue why you would be seeing all of those "You cannot" messages. Does it matter what forum you are browsing, meaning some say that and some do not? You may need to contact the site owner, see about getting some help with your account. I'll dig that information up in a moment.

Edit Here it is, pulled from the Site forum:
Editor wrote:I am really only a phone call away. Please text me at 817 688 7181 with your name and username. I will respond within 8 hours of any contact. Sorry for any issues.

Dennis
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

Normally one sees the "you cannot" messages if one is connected to DSXchange without having logged in. One can view and search, as a guest, but not post or edit.

Some of the forums are restricted but, if you have no access to these, you won't even see them. Do contact Dennis (our Editor) who should be able to help with anything else.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Obviously, the "You cannot reply to topics in this forum" message isn't true or we wouldn't even be here. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply