unable to INSERT INTO values 105,106 and 107 "VIRSA_CC_CONFIG"

[Former Member]

Hello All,

I have installed CC5.2 and when i'm running background job, its in ready status but not processing...

i have referred the note number 999785..

which says to insert the values 105,106 and 107 in to VIRSA_CC_CONFIG.....i tried to insert the values by connecting to CAQ but its giving error.

can anyone please guide me with the exact steps to be done....

Details:

SID : CAQ

Database: oracle 10g

os : windows

schema: SAPSR3DB

Please guide me how i can insert a value into a java table

Edited by: Ravitej Ramanna on Mar 14, 2008 4:42 AM

[former_member184114 · Accepted solution]

Hi Ravitej,

Log on to the Oracle database and manually insert these values in the table VIRSA_CC_CONFIG. Then plz restart J2EE server and confirm with the URL provided in the note

Its better if you login using SAPSR3DB id

Regards,

Faisal

[Former Member]

Hi

I have done some modification for the below query, then it works for me. Please check the changes below.

ORIGINAL:

INSERT INTO <SCHEMA>.VIRSA_CC_CONFIG (CNFGPARAM, CNFGSEQ, CNFGVALUE, COMMENT) VALUES ('105', 0, 'http', 'J2EE Engine Protocol')

Modified:

INSERT INTO <SCHEMA>.VIRSA_CC_CONFIG (CNFGPARAM, CNFGSEQ, CNFGVALUE) VALUES ('105', 0, 'http')

ORIGINAL

INSERT INTO <SCHEMA>.VIRSA_CC_CONFIG (CNFGPARAM, CNFGSEQ, CNFGVALUE, COMMENT) VALUES ('106', 0, '5<nn>00', 'J2EE Engine Port')

Modified:

INSERT INTO <SCHEMA>.VIRSA_CC_CONFIG (CNFGPARAM, CNFGSEQ, CNFGVALUE) VALUES ('106', 0, '5<nn>00')

ORIGINAL

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

COMMENT) VALUES (u2018107u2019, 0, 'http://<server>:5<nn>00/webdynpro/dispatcher/virsa/ccappcomp/BgJobStart','BgJobStart URL')

Modified:

INSERT INTO SAPSR3DB.VIRSA_CC_CONFIG (CNFGPARAM, CNFGSEQ, CNFGVALUE) VALUES (u2018107u2019, 0, 'http://<server>:5<nn>00/webdynpro/dispatcher/virsa/ccappcomp/BgJobStart')

Thanks & Regards,

Mahendra Paruchuri

Edited by: Mahendra Parachuri on Jun 12, 2009 10:11 PM

[Former Member]

Don't forget the APPEND command.

Oh dear..I ment COMMIT.

Edited by: Vit Vesely on Jun 13, 2009 3:52 PM

[Former Member]

Hi,

Yes indeed the insertion was failing because of wrong input in the comment

...i corrected it ...it solved my problem

[Former Member]

Hi

I am having the same issue. When I try to insert values into the "VIRSA_CC_CONFIG" table it is showing up, invalid table column name on the comment column

Here is the SQL command I tried to execute at the DB level:

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

COMMENT) VALUES ('105', 0, 'http', 'J2EE Engine Protocol')

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

COMMENT) VALUES ('106', 0, '50000', 'J2EE Engine Port')

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

COMMENT) VALUES (u2018107u2019, 0,

'our local URL','BgJobStart URL')

But I still get the error. What change did you make the comment field values??

Appreciate your response.

Thanks

Siri

[Former Member]

Hi

I am having the same issue. When I try to insert values into the "VIRSA_CC_CONFIG" table it is showing up, invalid table column name on the comment column

Here is the SQL command I tried to execute at the DB level:

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

COMMENT) VALUES ('105', 0, 'http', 'J2EE Engine Protocol')

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

COMMENT) VALUES ('106', 0, '50000', 'J2EE Engine Port')

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

COMMENT) VALUES (u2018107u2019, 0,

'our local URL','BgJobStart URL')

But I still get the error. What change did you make the comment field values??

Appreciate your response.

Thanks

Siri

[Former Member]

hello Ravitej,

One probably reason might be that in your table "VIRSA_CC_CONFIG", values 105, 106 and 107 already exist therefore you should use UPDATE or DELETE&INSERT instead of using INSERT.

Take into account that from the URL provided in the SAP note, you are not able to UPDATE or DELETE so you should go to your ORACLE Database and update this information directly in the table (this change needs a Database/J2EE restart)

Kind regards,

José