DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
skp



Group memberships:
Premium Members

Joined: 26 Dec 2007
Posts: 135
Location: India
Points: 1335

Post Posted: Thu Apr 12, 2018 10:59 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Unix
Hi All,

9.1 datastage version we have designed one job which will have multiple insert statements in ODBC enterprise stage in Server job which is executing successfully. But when we tried to migrate the same job to 11.5 and replacing ODBC enterprise stage with connector and triggered the job but ODBC connector is trying to execute the insert queries parallel hence our job getting aborted with the error "IntfLeaseMasterInbound..TRN_MaptoAmtTrac: Exception thrown from CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 751: ODBC function "SQLRowCount" reported: SQLSTATE = HY010: Native Error Code = 0: Msg = [DataDirect][ODBC lib] Function sequence error"
When we checked with DBA they mentioned that multiple insert statements are executing in parallel on the same table hence it is getting aborted.

I tried to see the option where I can make insert statements run in sequential order but not able to find the option. Please suggest me how to fix this issue
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42748
Location: Denver, CO
Points: 220287

Post Posted: Fri Apr 13, 2018 7:14 am Reply with quote    Back to top    

It's always a good idea to include pertinent details of your issue, in this case exactly how/where you are performing these "multiple insert statements" in the stage rather than make people guess. And when I Googled for "HY010 Function sequence error" I didn't see anything in the results that implied you would have any control over it... it seems to be more about a coding error in either the driver itself or how it is being leveraged by the stage.

Meaning make sure you are current on fixpacks for your version and involve your official support provider. IMHO.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours