Symptom
Customer has a ODBC SAS connection, when they run a simple job from the server machine the job runs but when they create ODBC connections the same job fails with "access violation" and the following call stack:
System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
Call stack:
0x0000000080006000, SQLDriverConnectW()+3008 byte(s)
0x00000000EA7FDE90, SQLBindParameter()+1856 byte(s)
0x00000000EA803A4B, SQLSetEnvAttr()+3835 byte(s)
0x00000000EA7FBF1F, SQLDriverConnect()+0527 byte(s)
0x00000000E41724B3, ConnODBC::SQLDriverConnect()+1075 byte(s)
0x00000000E4182A61, ConnODBC::open()+17953 byte(s)
0x00000000E416D43E, ConnPoolODBC::getNewConnection()+3550 byte(s)
0x00000000E416EBFC, ConnPoolODBC::simpleGetConnection()+0588 byte(s)
0x00000000E416C63C, ConnPoolODBC::getConnection()+0028 byte(s)
0x00000000E41678AD, ConnectionManager::GetConnection()+0653 byte(s)
0x00000000E3EBF2FA, OdbcDB::open()+1866 byte(s)
0x00000000E3B55906, DataStoreDef::process_dbtype()+11254 byte(s)
0x00000000E3B52048, DataStoreDef::process_db_datastore_options()+0072 byte(s)
0x00000000E3B4D1AC, DataStoreDef::processObjectDef()+0060 byte(s)
0x00000000E3D057CF, TrCallStatement::process_db_ds_options()+1055 byte(s)
0x00000000E3D139D0, TrCallStatement::process_sql_xform()+0304 byte(s)
0x00000000E3D0EE05, TrCallStatement::process_predef_xform_options()+0613 byte(s)
0x00000000E3BE5083, TrCallStatement::processStatement()+0947 byte(s)
0x00000000E3BE5B83, ViewStatement::processStatement()+0147 byte(s)
0x00000000E3C9648F, LoadStatementFile::processStatement()+4863 byte(s)
0x00000000E3AF7942, DataFlowDef::processStatements()+0130 byte(s)
0x00000000E3AE5B79, DataFlowDef::buildGraph()+2089 byte(s)
0x00000000E3AF4F94, DataFlowDef::processObjectDef()+6196 byte(s)
0x00000000E3C5253D, CallStep::processStep()+3133 byte(s)
0x00000000E3C54692, Step::processStepBlock()+0802 byte(s)
0x00000000E3C532F1, CompoundStep::processStep()+0049 byte(s)
0x00000000E3B36C39, PlanDef::processObjectDef()+3577 byte(s)
0x00000000E360AAB8, AE_Main_Process_Options()+63304 byte(s)
0x00000000E363A315, AE_Main()+2869 byte(s)
0x000000005AA08167
0x000000005AA09C1B
0x000000005AA0A729
0x00000000FB4113D2, BaseThreadInitThunk()+0034 byte(s)
0x00000000FC1054F4, RtlUserThreadStart()+0052 byte(s)
Registers:
RAX=00000000FFFFFFF9 RBX=0000000000000006 RCX=0000000000000007 RDX=0000000000000000 RSI=0000000040DF6400
RDI=00000000439DE0BE RBP=000000003D7FF780 RSP=000000003D7FF680 RIP=0000000080006000 FLG=0000000000010206
R8=0000000000000000 R9=0000000044521300 R10=0000000000000000 R11=00000000100DA8D0 R12=0000000000000000
R13=0000000000000000 R14=00000000000000F9 R15=00000000439DE0B0
Exception code: C0000005 ACCESS_VIOLATION
Read more...
Environment
SAP Data Services 4.2 SP9
SAP Information Steward 4.2 SP9
SAS ODBC driver 32bit
SAS Datawarehouse
Product
Keywords
SAS ODBC Data Services Access Violation. , KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.