Follow

Oracle Troubleshooting Hub

Introduction

This article contains three sections: general guidance on potential pain points for the Oracle data source, a list of troubleshooting articles by symptom, and a list of Oracle bugs that have been patched out of our software.  We hope that this article will prove to be a one-stop resource for problems related to the Oracle data source, but if you do not see your problem addressed here, please submit a ticket and we will do our best to assist you.

For guidance on the Oracle data export, please see the guide here.

 

General Guidance

Connecting to an Oracle data source can some times be difficult for two primary reasons: extra software is required to allow SQL Server and Oracle to communicate, and Oracle and SQL Server data types do not always match up.

The Oracle Data Provider

The extra software needed to connect SQL Server and Oracle is called the Oracle Data Provider (ODP), and you can find our guide to installing it here.  The ODP software can present difficulties because a mistake during the installation process can cause the data source not to work correctly, no matter how it is later configured. 

If you are having issue getting your Oracle data source set up for the first time, a problem during the ODP installation process is by far the most probable cause.  Checking to ensure the ODP and your TX DWA software are using the same bit version and reinstalling the ODP will often resolve these first-time setup woes.

Data Type Clashes

The other common problem with the Oracle data source occurs because Oracle data types are often larger than the data types used by TX DWA's default settings, especially text data types and date-time data types. Selecting Force Unicode Conversion and converting dates to in-range values, re-synchronizing, and re-deploying will resolve these problems quickly.

 

Problems by Symptom:

I can't set up the Oracle data source

I can't synchronize the Oracle data source

I can't synchronize or deploy Oracle data source tables

I can't deploy Oracle data source tables

I can't execute Oracle data source tables

 

List of Patched Bugs:

To review the list of fixes in a TimeXtender release, visit the download page and review Release Notes for any specific version.

 

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.