How to Insert values in virsa_cc_config table?- Post Installation of RAR5.3

[Former Member]

Hi Experts,

We checked in the debugger that the values 105,106 &107 are not added in the virsa_cc_config table.

Where to add the values in the table? In J2ee database or in server database (which is oracle for us)? When we searched in oracle data base this table doesnot exist.

So we believe it has to be inserted in J2EE database. If yes, can somebody help us how to check and insert the values in the respective table in J2ee database

Thanks and Best Regards,

Srihari.K

[Former Member · Accepted solution]

Dear Sri,

Yes this table resides in database where GRC is installed.

To insert these lines, you need to login into GRC server-

if it is windows goto -

sqlplus /nolog

connect /as sysdba

run this command

INSERT INTO SAPSR3DB.VIRSA_CC_CONFIG (CNFGPARAM, CNFGSEQ, CNFGVALUE) VALUES

('105', 0, 'http')

INSERT INTO SAPSR3DB.VIRSA_CC_CONFIG VALUES ('106', 0, '<port number>', 'J2EE Engine Port')

INSERT INTO SAPSR3DB.VIRSA_CC_CONFIG VALUES (107, 0,'http://<fully qualified hostname>:<port number>/webdynpro/dispatcher/sap.com/grc~ccappcomp/BgJobStart','BgJobStart URL')

Commit;

Put your hostname and port accordingly and run.

Let me know if it works.

Regards,

Sabita