SAP Knowledge Base Article - Preview

2590108 - Access violation error when using SAS ODBC driver - SAP Data Services 4.2 SP9

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

SAP Data Services 4.2

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.