Issue w/ multiple Insert statements running parallel in ODBC
Posted: Thu Apr 12, 2018 10:59 pm
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
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