Title
"OID connection misconfigured" when connecting to a Web Conference in OCS 9i

Date
2006-11-10

Summary
When connecting to a Web Conference, the user may encounter the following error:
    Internal Error.:

    OID connection misconfigured or other error detected. Please notify the system administrator.

    Click Login Again to access the application or click Contact Us to inform us of the problem you are experiencing.
To save processing time and increase performance, when a user logs into RTC (iMeeting) the USER_NAME and USER_GUID from OID are inserted into the RTC schema table called RTC_USERS. If, for some reason, the USER_GUID in OID and RTC_USERS do not match you will encounter this error while attempting to login to RTC.

The solutoin is to remove the username from the RTC.RTC_USERS table and attempt to log back into the RTC. This will recreate the user again in RTC.RTC_USERS table with the same USER_GUID that is stored in OID.

NOTE: Do not delete the seed users IMTTEST, IMTGUEST, RTCTEST, or RTCGUEST, otherwise you will destroy iMeeting.

Details
1. Before attempting anything, by querying the database, you will find that the user exists in the RTC.RTC_USERS table: 
SQL> SELECT * FROM rtc.rtc_users WHERE user_name = 'JDOE';

USER_SEQ_ID    USER_ID
----------- ----------
USER_GUID
----------------------------------------------------------------
OBJECT_VERSION_NUMBER CREATED_BY
--------------------- ----------
CREATION_TIMESTAMP
---------------------------------------------------------------------------
LAST_UPDATED_BY
---------------
LAST_UPDATE_TIMESTAMP
---------------------------------------------------------------------------
USER_NAME
--------------------------------------------------------------------------------
 PERSON_ID
----------
TIMEZONE_NAME
--------------------------------------------------------------------------------
DEFAULT_ROLE_ID DEFAULT_VOICE_VENDOR_ID
--------------- -----------------------
      10926      10926
0D584EAC339BE4E3E04010AC08110ACB
                    1          0
10-NOV-06 04.40.00.262396 PM
              0
10-NOV-06 04.40.00.262396 PM
JDOE
     19850
America/New_York
              2

2. Delete the user from the RTC.RTC_USERS table: 
SQL> DELETE FROM rtc.rtc_users WHERE user_name = 'JDOE';

3. The problem now is that the scheduled meetings are linked to the old USER_ID from RTC_USERS table. Recreating the same user in OID does not link it to the previously scheduled meetings.

To resolve this, insert the record back to RTC_USERS using the old USER_ID/PERSON_ID but with the new USER_GUID.

Applicable Versions
Oracle Web Conferencing 9i (9.0.4.2.0)

References
Oracle Note 312270.1
Ahmed Aboulnaga
.com .com