Skip to Content
author's profile photo Former Member
Former Member

UD Connect Not Automatically Establishing Connection

We've been successfully using UD Connect in our production system since July '07. However, we periodically run into a problem when we lose the connection between our BW 3.5 system and a source system (an SQL database residing on a microsoft server; our BW system is on AIX).

We've identified three causes of the lost connection: server reboot (for example, due to Windows patching); database stop and restart; network problems.

In each case, UD Connect doesn't re-establish the connection when it's lost. I would think that with today's technology it should be able to identify the lost connection and attempt to re-establish it.

Is anyone aware of a method to set up UD Connect to automatically re-establish a connection? Or at the very least, an automated way to check if the connection still exists so we can add it as a step in our jobs to prevent the process chains from failing? Note: the RFC still test successful when the connection is lost.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2007 at 03:34 PM


    Check here,

    Data Warehousing/Data Retrieval/Data Transfer with UD Connect/Checking Availability for UD Connect

    It talks about using CCMS for monitoring UD Connect... Never did it, but it might give you some ideas.

    Good luck!


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.