Oracle client provider is not installed on the sql server, you are trying to connect. SSMA Extension Pack is not installed on SQL Server Oracle Client may not be accessible to the DataMigrator utility from Extension Pack. Error: 'system.data.oracle client requires 8.1.7 or greater' Please bear in mind this error is not related to Alteryx but to Oracle. This error message is returned from the Oracle Database, therefore please check with your DBA about the configuration and set up of your machine and server before reaching out to support@alteryx.com.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
August 4, 2009 at 6:07 am | Posted in SSMA Oracle Errors, SSMA Oracle Knowledgebase | Leave a comment
Symptom
When doing data migration you may get the following error. Following message may be displayed on the console.
Migrating data…
Analyzing metadata…
Preparing data migration package…
Starting data migration agent…
Yahoo Messenger 8.1
Starting data migration…
Exception during processing: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Data migration complete.
0 table(s) successfully migrated.
0 table(s) partially migrated.
1 table(s) failed to migrate.
Cause
This error may be caused due to one the following reasons:
·Oracle client provider is not installed on the sql server, you are trying to connect.
Oracle Client Software Version 8.1 7 Or Greater Freeware
·SSMA Extension Pack is not installed on SQL Server
·Oracle Client maynot be accessible to the DataMigrator utility from Extension Pack. This utility is started with the same account used to run SQL Agent.
Resolution
SSMA Data Migrator needs Oracle client provider installed on the SQL Server machine to perform data migration. When it does not find Oracle Client provider it gives this error.
·Install the Oracle Client provider on your sql server and verify data migration.
·Cross check Extension pack is installed on your sql server machine
·Oracle Client maynot be accessible to the BCPDataMigrator utility from Extension Pack. This utility is started with the same account used to run SQL Agent. Make sure this account has access to the Oracle client folder and it’s contents.
More Information
Article Id: KBO2SS1001
Applies to
·SSMA 2005 for Oracle
·SSMA 2008 for Oracle