Skip to main content

MarkView - KTM Extraction Error

Article # 304287 - Page views: 262



Applies To

  • ERP System: All
  • MarkView Version: All


  • The batch errors out during KTM Server extraction process (KTM Server queue), in Quality Control following error shows up for the failed batch:
    "BeforeExtraction: BeforeExtract: Script execution has been stopped because of runtime error:
    Line 554, Offset 0, (16389) [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

Note: To see the full error msg, Right click on the batch in QC queue > Properties > Advanced > Error.

Know Causes

  • Oracle Data Access Components (ODAC) might not be installed properly on the server..


  • Ensure that Oracle Data Access Components (ODAC) is installed properly on the server.
  • And ORACLE_HOME bin directory defined in your Windows OS path:'|
    Start > Right Click on Computer > Properties > Advanced System Settings > Advanced Tab > Environment Variables > 
    Check the PATH variable and make sure it includes the ORACLE_HOME bin directory

Keywords: KTM, QC, Error, ODBC, Driver