Article Original Creation Date: 2012-04-24

Overview

When we use IE we don’t see the select combo box in the Real-time Probe box on CSR window after patch 4.2.3. I instead use Chrome the selection box is shown correctly. I have checked using Soap log (Ctrl+f12) that the data received from sg is the same for both browsers. (I tested with Chrome but the result was the same as for IE and Firefox).

Environment

• Solaris 10
• Oracle 10
• WebLogic 9.2.3
• Apache 5.5.25

Root Cause

Probably in the SG4.1.3 one of the queries did not completely run:

SELECT 'INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES (''' || EC_GROUP_GUID || ''', ''1264fbde-9e00-11dc-8314-0800200c9a66'');' insert_stmt
 FROM SPRT_EC_GROUP_ROLE_XREF WHERE EC_ROLE_GUID='1264fbd2-9d0c-11dc-8314-0800200c9a66';

Because of that the different XREFs in the SPRT_EC_GROUP_ROLE_XREF table where not setup correctly between GROUP and ROLE. Causing the CSR: Select Real-Time Probe dropdown list being not available for the users within the CSR interface.

Resolution

Execute the SQL Query mentioned below:

SELECT 'INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES (''' || EC_GROUP_GUID || ''', ''1264fbde-9e00-11dc-8314-0800200c9a66'');' insert_stmt
 FROM SPRT_EC_GROUP_ROLE_XREF WHERE EC_ROLE_GUID='1264fbd2-9d0c-11dc-8314-0800200c9a66';

This query creates 7 other Insert queries:

INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES ('ffbad072-993d-11dc-9fca-4baa6c95bad5',
  '1264fbde-9e00-11dc-8314-0800200c9a66');
INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES ('7d58e05b-dbd0-11dd-9b79-af3314727408',
  '1264fbde-9e00-11dc-8314-0800200c9a66');
INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES ('b2328a54-dbd0-11dd-9b79-af3314727408',
  '1264fbde-9e00-11dc-8314-0800200c9a66');
INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES ('bbe3fe1b-fb75-11de-b9a5-85ff5264dcd8',
  '1264fbde-9e00-11dc-8314-0800200c9a66');
INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES ('ffbad071-993d-11dc-9fca-4baa6c95bad5',
  '1264fbde-9e00-11dc-8314-0800200c9a66');
INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES ('e9dce61a-7547-11df-b284-75fa6fc6bb01',
  '1264fbde-9e00-11dc-8314-0800200c9a66');
INSERT INTO SPRT_EC_GROUP_ROLE_XREF VALUES ('463a779e-dbd0-11dd-9b79-af3314727408',
  '1264fbde-9e00-11dc-8314-0800200c9a66');

Run these 7 queries manually, it is possible some of the error with a duplicate error, that is fine and end with a commit;

Let the users log out and in again and try the CSR interface and RTP again.