In CUP-- select * from tab where tname like '%AE%'; says no rows selected.

[Former Member]

Hi gurus,

We are trying to implement GRC suite. CC is working fine, but i am having issues with CUP Connector. When i test it, it fails. I am following Installation and configuration guides. I need solution in two scenarios.

1. How can i remove connector in CUP. I know in CC, SQL script can solve this issue. But how about CUP, if some one can provide me that script ??. How can we read cc/ae logs.

2. When i run SQL> select * from tab where tname like '%AE%';, it says no rows selected.

I will appreciate your reply and points will also be rewarded.

Best regards.

Priyanka

[former_member196034]

A connector can be removed from within CUP. Go to Configuration tab - Connectors - Available connectors.

Select a connector and click the Delete button.

Then you can go to the underlying Java system and modify the JCos.

As for SQL commands to view AE tables. If you are using the SQL Debug tool tab provided in GRC, then you will be unable to display VIRSA_AE* tables. This tool is restricted to displaying VIRSA_CC* tables.

As for reading CC/AE logs, this can be done by going to the Background jobs screens in GRC and viewing the logs.