SAP Knowledge Base Article - Preview

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

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
  • Data Cleansing Advisor
  • Supported Windows platform

Product

SAP Data Services 4.2 ; SAP Information Steward 4.2

Keywords

DCA, EIM APS, ODBC Driver Selector, SQL Anywhere, BOIS, IS , 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 for Me (Login required).

Search for additional results

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