Skip to Content
0
Former Member
May 02, 2007 at 03:52 PM

Analysis Daemon unable to start

10 Views

Hi all,

Has anyone ever implemented note 999785https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=999785&nlang=EN&smpsrv=https%3a%2f%2fwebsmp206%2esap-ag%2ede">999785>?

To me, there seems to be quite a bit wrong with this note. I've been able to figure out some of it, but I'm still stuck.

Issues:

1. The note requires you to execute 'INSERT' SQL statements to add config lines to the virsa_cc_config table. The trouble is, the note doesn't include the table columns in the insert statement, so it fails.

<b>Solution</b>

The INSERT statement should read:

INSERT INTO virsa_cc_config (CNFGPARAM, CNFGSEQ, CNFGVALUE, COMMENT) VALUES etc...

2. CNFGPARAM is a VARCHAR not an INT.

<b>Solution</b>

Quotes have to be inserted around the values for the field.. ie

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

My current issue:

When I go to execute the query, I get an error saying:

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

So, how do you execute these SQL statements using BgJobStart?debug=1 as per the note?