Hi Torben Schiper,
I tried to upgrade my cognos production environment from Cognos 11.0.13(LTS) to 11.1.7. I received below error message while trying to start the cognos dispatcher/Appserver after upgrade.
2020-12-19T11:06:13.719-0500 INFO startup.Audit.CAM.AAA [pool-59-thread-1] NA StartService Failure camAsyncService <messages xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="bus:message[3]"><item xsi:type="bus:message"><messageString xsi:type="xsd:string" xml:space="preserve">AAA-SYS-0002 The service cannot process the request because it has not been initialized.</messageString></item><item xsi:type="bus:message"><nestingLevel xsi:type="xsd:integer">1</nestingLevel><messageString xsi:type="xsd:string" xml:space="preserve">AAA-SYS-0001 An internal error occurred.</messageString></item><item xsi:type="bus:message"><nestingLevel xsi:type="xsd:integer">2</nestingLevel><messageString xsi:type="xsd:string" xml:space="preserve">com.cognos.cclcfgapi.CCLConfigurationException: Illegal character in name: ' CM.MULTIPARTREQUESTMAXLENGTH'.</messageString></item></messages>
2020-12-19T11:06:13.797-0500 INFO startup.Audit.CAM.AAA [pool-59-thread-37] NA StartService Failure SACamService <messages xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="bus:message[3]"><item xsi:type="bus:message"><messageString xsi:type="xsd:string" xml:space="preserve">AAA-SYS-0002 The service cannot process the request because it has not been initialized.</messageString></item><item xsi:type="bus:message"><nestingLevel xsi:type="xsd:integer">1</nestingLevel><messageString xsi:type="xsd:string" xml:space="preserve">AAA-SYS-0001 An internal error occurred.</messageString></item><item xsi:type="bus:message"><nestingLevel xsi:type="xsd:integer">2</nestingLevel><messageString xsi:type="xsd:string" xml:space="preserve">com.cognos.cclcfgapi.CCLConfigurationException: Illegal character in name: ' CM.MULTIPARTREQUESTMAXLENGTH'.</messageString></item></messages>
Could you please help us what went wrong in my upgrade. I successfully upgraded Development and Non-Prod environments with out any issue.
Thanks,
Srini.
------------------------------
Srinivasulu Reddy R
------------------------------
Original Message:
Sent: Thu August 06, 2020 02:17 AM
From: Torben Schipper
Subject: Cognos 11.1.7 upgrade problem: SACamService and camAsyncService failures
Hi Michael,
Sent you a direct message with the possible workaround.
The issue is known, a defect exist but I do not have the number at the moment, The root cause is the trailing slash in the parameter name
RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE\ =TRUE
Since the workaround mean to "edit" the database I do not want to share this info to the public. For all who have this issue please open a case with IBM Support.
Kind regards
Torben
------------------------------
Torben Schipper
Original Message:
Sent: Wed August 05, 2020 03:19 PM
From: Michael Sullivan
Subject: Cognos 11.1.7 upgrade problem: SACamService and camAsyncService failures
Hi everyone,
Following the upgrade from 11.1.6, starting the Cognos service led to these errors:
11:14:34, 'SACamService', 'StartService', 'Failure'.
AAA-SYS-0002 The service cannot process the request because it has not been initialized.
AAA-SYS-0001 An internal error occurred.
com.cognos.cclcfgapi.CCLConfigurationException: Illegal character in name: 'RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE '.
11:14:34, 'camAsyncService', 'StartService', 'Failure'.
AAA-SYS-0002 The service cannot process the request because it has not been initialized.
AAA-SYS-0001 An internal error occurred.
com.cognos.cclcfgapi.CCLConfigurationException: Illegal character in name: 'RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE '.
Any thoughts on this?
One thing I noticed was that the original dispatcher.properties file was changed by the upgrade from this entry:
advancedSettings=<settings><setting name\="RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL">TRUE</setting><setting name\="RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL">TRUE</setting><setting name\="RSVP.EXCEL.NUMBEREDSHEETNAMES">FALSE</setting><setting name\="RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE ">TRUE</setting></settings>
To individual entries like this apparently wrong one:
RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE\ =TRUE
Manually adjusting the dispatcher.properties file didn't help. When the service started, the adjustment was overlaid with the original (wrong) entry presumably from the Content Store
And I'm not sure if the only problem indicated by the error messages relates to the properties for the dispatcher. Testing locally in Cognos Configuration before starting the service was all successful.
Thanks for any thoughts
Mike
--
Michael Sullivan
978 762 4218
North Shore Community College
#CognosAnalyticswithWatson