MarkView - KTM Extraction Error

Applies To

• ERP System: All
• MarkView Version: All

Behavior

• 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..

Resolution

• 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