Troubleshooting Microsoft SSIS Connectors by Attunity

[Adeeb Mass'ad]

How to troubleshoot installation problems for Microsoft SSIS Connectors by Attunity?

SUMMARY

This step by step article describes how to troubleshoot the installation of the Microsoft SSIS Connectors by Attunity. We will start with the basic common problems and continue to generation a verbose log file if needed.

STEP 1

Common problems for a failing installation could be one of the followings:

PROBLEM 1
The system does not meet the basic Prerequisites

SOLUTION
Make sure the target system contains a Microsoft SQLServer 2008 installation along with the Microsoft Business Intelligence Development Studio for SQL Server 2008.

PROBLEM 2
Installing from a user without the proper permissions.

SOLUTION
Add the proper permissions to the user or perform the installation from a different privileged user. Note that the user should have permissions to install to the Prorgam Files directory and create/modify registery settings.

PROBLEM 3
Product files are being locked, getting access denied during the installation

SOLUTION
If you are installing a newer version of the Connectors make sure to quit the Microsoft Business Intelligence Development Studio, and stopping any running processes using the Connectors.

PROBLEM 4
Error Message: The installation package is not supported by this processor type.

SOLUTION
Make sure to install the proper kit, see the list of products in the APPLIES TO section.

STEP 2

If the installation fails without a self explanatory error message, the next step is to check the Windows Event Viewer.

The Event Viewer is located in the Control Panel/Administrative Tools.

Installation errors will normally be logged in the Application section of the Event Viewer.

STEP 3

If the error is persistant we recommend running the installation with verbose debugging. This could help the user/support engineer understand the actions which could have caused the failure.

To run the installation with verbose logging perform the followings:

- Click the Windows Start menu, and then click Run (advanced users may want to run it from the command prompt).
- Write the full path to the installation kit including the logging flag, for example:

C:\Kits\AttunitySSISOraAdaptersSetup.msi /L*v! C:\ora_install.txt

This command will execute the specific kit with Verbose logging. The log file will be created at "C:\ora_install.txt".

APPLIES TO

• Microsoft SSIS Connector for Oracle by Attunity
• Microsoft SSIS Connector for Oracle by Attunity - Itanium IA64
• Microsoft SSIS Connector for Oracle by Attunity X64
• Microsoft SSIS Connector for Teradata by Attunity
• Microsoft SSIS Connector for Teradata by Attunity X64