Background Daemon Issues in CC 5.2

[Former Member]

Hi folks,

I'm implementing CC 5.2 at a customer and have a question about the background daemon. I checked the URL specified in the install guide and verified that the daemon is running. However the background jobs scheduled haven't been run.

The error log says:

WARNING: Cannot get Application URL: String index out of range: -1. PLEASE SET 'Background Daemon URL' IN CONFIGURATION TAB

I went to the configuration tab, and reviewed all the options. The only URL I found for the background scheduling is for the spool files. Where do I go to set up the above information?

Thanks a lot.

Santosh

[Former Member · Accepted solution]

Hi everyone,

I have a server that SAP had setup prior to me coming onto this project. On that server, the background daemon has been setup correctly. On the secondary server, which is what I'm working on, it hasn't been setup properly. It is the secondary server that I'm working on.

I inserted values 105, 106 and 107 per the note number 999785. I then went to the server /virs/CCADStatus.jsp. The resulting page only had one line on it, "Analysis Engine Daemon Manager", and nothing else. The same page, on the primary CC box showed me various threads and their current state.

I'm trying to see why this is happening. Any suggestions?

Thanks,

Santosh

[Former Member · Accepted solution]

Hi,

this means there is probably something wrong in the URL of the 107 entry in VIRSA_CC_CONFIG.

Please re-check the correctness of this URL - the URLs in the SAP note do contain errors!

The correct URL should be something like:

http://<server>:<port>/webdynpro/dispatcher/virsa/ccappcomp/BgJobStart

for CC<5.1/SP06 and CC<5.2/SP05

or

http://<server>:<port>/webdynpro/dispatcher/sap.com/grc~ccappcomp/BgJobStart

for CC >= 5.1/SP06 and CC >= 5.2/SP05

Please also make sure that for the SQL statement the quotation marks ' ' for 107 are not missing.

Restart the server after entering the lines.

Regards,

Daniela

[Former Member · Accepted solution]

Hi Daniela,

Thanks a lot. Our wonderful hosting providers did some guess work for us and put in the URL for SP5 as opposed to my specified URL, which is the same as what you pointed out. Now that it's been corrected, we are looking at some additional data in the table specified in the note and I'm trying to determine the meaning behind value 113.

The values I'd inserted are 105, 106 and 107. Value 113 has a URL that points to a different GRC box that we have on side, the one SAP set up for us. The question is, should it be as such or not?

Thanks!

[Former Member · Accepted solution]

Yes, this table contains the CC configuration data. Try changing any configuration data in the CC configuration tab and you will see the changes reflected in the table.

Config entry 113 belongs to the "Custom tabs" entries.

Regards,

Daniela

[Former Member · Accepted solution]

Hi All

when I executed the http://hostname:50200/webdynpro/dispatcher/sap.com/grc~ccappcomp/BgJobStart?debug=1

INSERT INTO SAPC18DB.VIRSA_CC_CONFIG (CNFGPARAM, CNFGSEQ, CNFGVALUE, COMMENT) VALUES ('105', 0, 'http', 'J2EE Engine Protocol') in the link it showed "

" ERROR:"INSERT" statements cannot be executed by method "executeQuery()""

So how will we insert these values to SAPC18DB.VIRSA_CC_CONFIG ? Is it via sql*plus by logging to OS level? Is there any other tips?

[Former Member · Accepted solution]

I inserted the values by logging into sqlplus in oracle level. The insert command that specified in the note 999785 is not working . So I modified them as follows

##

INSERT INTO SAPSR3DB.VIRSA_CC_CONFIG VALUES ('105', 0, 'http', 'J2EE Engine Protocol');

INSERT INTO SAPSR3DB.VIRSA_CC_CONFIG VALUES ('106', 0, '50200', 'J2EE Engine Port');

INSERT INTO SAPSR3DB.VIRSA_CC_CONFIG VALUES (107, 0, 'http://hostname:50200/webdynpro/dispatcher/sap.com/grc~ccappcomp/BgJobStart', 'BgJobStart URL');

commit;

##

I hope this is how you all inserted the values to SAPSR3DB.VIRSA_CC_CONFIG . Please let me know if there is any alternative way.

[former_member196034 · Accepted solution]

This debug tool cannot be used to write to the DB because it only provides read-only access.

You will have to log into the DB directly and execute SQL statements there.

Microsoft SQL server has a nice visual interface where you can enter fields in a table directly without SQL statements.

[Former Member · Accepted solution]

Thanks Babak, your post really helped me work out how to find and edit this file. It's in the note 999785 and the two very useful GRC Background job .pdfs, but all these docs assume a certain level of J2EE Admin knowledge, which I was lacking.

[Former Member]

Following the suggestions, I still have a problem with this issue.

[koehntopp]

SAP Note 999785 is what you're looking for.

Frank.

[Former Member]

While my question hasn't been answered, I did find another thread that has already addressed this topic:

How to set 'Background Daemon URL' IN CONFIGURATION TAB ?

If it doesn't resolve my question, I shall re-post.

Thanks,

Santosh