SAP Knowledge Base Article - Preview

2710323 - DCA error: Unable to create data table - Information Steward

Symptom

  • Data Cleansing Advisor error: Unable to create data table
  • ERROR: Unable to access staging tables for cleanse operation. Additional information: Error executing data load job.
  • EIMAdaptiveProcessingServer log contains an ODBC connection error
  • EIMAPS log contains error:  com.sap.dca.process.thread.FinishWizardThread||Unable to create data table. Additional information: Error creating datastore: Cannot open connection - openConnection remote error
  • SEVERE: Open connection remote error: ODBC call <SQLDriverConnect> to connect database <DCA> failed with error: <ODBC call <SQLDriverConnect> to connect database <DCA> failed with error: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified>.

Read more...

Environment

  • SAP Information Steward 4.2.SP11
  • Data Cleansing Advisor

Product

SAP Data Services 4.2 ; SAP Information Steward 4.2

Keywords

DCA, EIM APS, ODBC Driver Selector, SQL Anywhere , KBA , EIM-IS-DCA , Information Steward - Data Cleansing Advisor , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.