Please help!! can't start cognos server anymore :(

[theecw]

Hi All!

am new in this forum and i wish you help me with this issue.

I try to connect the source data with framework manager but when i connected i got this error QE-DEF-0368 Unable to decrypt user name and password credentials from the content store.

I found a solution from IBM support said;
. Close Framework Manager and stop any Cognos ReportNet or BI Server service on the laptop.

2. Open Windows Explorer and navigate to <install location>\crn\configuration directory.

3. Delete these three folders: csk, encryptkeypair, signkeypair.

4. Open Cognos Configuration, input the configuration of the target server, and click Save.

5. Start Cognos ReportNet or BI Server service and retry connecting with Framework Manager.

So i deleted the CSK folder and other but now cognos configuration is not working anymore
its show me this error when i tried to start the server, it  said " Problems were encountered during validation.CAM-CRP-1064 Unable to process the PKCS #7 data because of an internal error. Unable to find the common symmetric key with alias 'V3QvVBkAdUwT92kC6LNeVbsGsyk=' in the keystore 'C:/Program Files/ibm/cognos/c10_64/configuration/csk\jCSKKeystore'.
The parameter named 'External JMX credential' located in 'Environment' is currently invalid.CAM-CRP-1064 Unable to process the PKCS #7 data because of an internal error. Unable to find the common symmetric key with alias 'V3QvVBkAdUwT92kC6LNeVbsGsyk=' in the keystore 'C:/Program Files/ibm/cognos/c10_64/configuration/csk\jCSKKeystore'.
The parameter named 'Shared secret' located in 'Portal Services' is currently invalid.CAM-CRP-1064 Unable to process the PKCS #7 data because of an internal error. Unable to find the common symmetric key with alias 'V3QvVBkAdUwT92kC6LNeVbsGsyk=' in the keystore 'C:/Program Files/ibm/cognos/c10_64/configuration/csk\jCSKKeystore'.
The parameter named 'User ID and password' located in 'cognos_gis' is currently invalid.CAM-CRP-1064 Unable to process the PKCS #7 data because of an internal error. Unable to find the common symmetric key with alias 'V3QvVBkAdUwT92kC6LNeVbsGsyk=' in the keystore 'C:/Program Files/ibm/cognos/c10_64/configuration/csk\jCSKKeystore'.
The parameter named 'Account and password' located in 'Notification' is currently invalid."

I can't restore the folder because i delete them and it is not appear in the recycle! Also, i didn't create a backup to restore it!! Please help me i really don't know what to do to make cognos working again

thanks a lot in advance

[CognosPaul]

Did you only delete csk, or did you delete all three?

Make sure all three folders are deleted, and only those three. Next, rename cogstartup.xml to cogstartup.xml.bak. Open Cognos Configuration again, and redo all of the settings. Save and you should be good to go.

[theecw]

Thanks a lot for your respond!
I deleted all the three folder, but i didn't change the name.

I just changed the name as you mentioned, and when i started Cgonos configuration, i got this message;

The configuration data did not load.

The configuration files could not be located.

The default configuration files will be created.

then i tried to started the server, and give me all corrcet except when it come to start the server, this is the process in details;
[Launching a JVM using 'Maximum memory in MB']
Successfully launched a test JVM with the memory setting of '768'. Note that this does not guarantee that the IBM Cognos service will start and run successfully.

To see which JVM options are based on this setting, view ibmcognos_location/bin/bootstrap_<OS>.xml and see your JVM documentation for an explanation of those options.

[Start Service]
11:45:45, 'LogService', 'StartService', 'Failed'.
11:45:45, 'LogService', 'StartService', 'Failed'.
11:45:46, CAF input validation enabled.
11:45:46, CAF Third Party XSS checking disabled.
11:46:45, 'LogService', 'StartService', 'Failed'.
11:46:45, 'LogService', 'StartService', 'Failed'.
11:46:45, CAF input validation enabled.
11:46:45, CAF Third Party XSS checking disabled.
11:47:20, 'LogService', 'StartService', 'Failed'.
11:47:20, 'LogService', 'StartService', 'Failed'.
11:47:20, CAF input validation enabled.
11:47:20, CAF Third Party XSS checking disabled.
11:47:55, 'LogService', 'StartService', 'Failed'.
11:47:55, 'LogService', 'StartService', 'Failed'.
11:47:55, CAF input validation enabled.
11:47:55, CAF Third Party XSS checking disabled.
11:48:30, 'LogService', 'StartService', 'Failed'.
11:48:30, 'LogService', 'StartService', 'Failed'.
11:48:31, CAF input validation enabled.
11:48:31, CAF Third Party XSS checking disabled.
11:49:05, 'LogService', 'StartService', 'Failed'.
11:49:05, 'LogService', 'StartService', 'Failed'.
11:49:06, CAF input validation enabled.
11:49:06, CAF Third Party XSS checking disabled.
11:49:40, 'LogService', 'StartService', 'Failed'.
11:49:40, 'LogService', 'StartService', 'Failed'.
11:49:40, CAF input validation enabled.
11:49:40, CAF Third Party XSS checking disabled.
11:50:15, 'LogService', 'StartService', 'Failed'.
11:50:15, 'LogService', 'StartService', 'Failed'.
11:50:15, CAF input validation enabled.
11:50:15, CAF Third Party XSS checking disabled.
11:50:50, 'LogService', 'StartService', 'Failed'.
11:50:50, 'LogService', 'StartService', 'Failed'.
11:50:50, CAF input validation enabled.
11:50:50, CAF Third Party XSS checking disabled.
[Start Service]
[ ERROR ] CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.
11:56:05, 'LogService', 'StartService', 'Failed'.
11:56:05, 'LogService', 'StartService', 'Failed'.
11:56:05, CAF input validation enabled.
11:56:05, CAF Third Party XSS checking disabled.

then it show this error! do you know why i get this error please

[CognosPaul]

You need to recreate all of the settings. Check the dispatcher and gateway URIs (they default to localhost), create the connection to the content manager database. If you have, create the connections to the audit and notification databases. Set up your authentication provider. Set up the SMTP server.

If you don't know the correct settings, open up cogstartup.xml.bak in notepad and read the settings from there. You won't be able to see the passwords for the connections, as those are encrypted, but you should be able to recreate everything else.

[simi123]

Hi,

  I am also getting same Issue.


But I did the same steps many times and can't resolve the error.

I don't know, where should I start from...

Please anyone help me to sove this issue.

Thanks,
Miru

[sunosoft]

@simi123
Please try to copy the deleted folders from some other server ? did you try this ?

Also if you are going to rename cogstarup.xml file, please make sure to take backup of configuration. Renaming congstarup.xml file is nothing but the backup. Along with this take screenshots of your whole configuration.

Also save the configuration from file menu --
Open the confuguration
Go to file-->save the configuration. It will ask you to wether to save the configuration in decrypted mode. Say yes and save that file.

Now once you rename the cogstarup.xml file, you can open the obove saved file from configuration. And you will have the screenshots also if you miss anything.

[simi123]

@sunosoft,

  i tried that way...But no lucks...

can you please let me know whether do the cognos configuration form frmaework manager or cognos server.

FYI- I could see csk, encrptkeypair,signkeypair in cognos configuration from cognos server. But couldn't see csk except signkeypair, encryptkaypair in cognos configuration from framework manage. Also, i have deleted the AD namesapce from cognos configuration.
And also deleted everyone group from sysadmin role because of  AD namespace access.

So, is that causing error.

please help me..................................

[sunosoft]

Framework manager configuration and server configuration are totally different things.

For which exactly you are facing issue to start?  FM or cognos server ?

If cognos server, then first we should concentrate on it. You are saying you deleted AD namespace, so the server should be the the content manager server. You will need this AD namespace..right ? so you can configure it. What about the remaining servers ? All other servers are fine ?

[simi123]

@sunosoft

  WE have 2 servers both have FM and Cognos server. But different gatway URI one is cognos.cgi and an another one is cognosisapi.dll.

The cognos.cgi gatway URI is working fine. But the Gateway URI cognosisapi.dll is not working.

The other server(cognos.cgi) is working fine and if I add everyone group on to sysadmin then I can access the BI portal.

But, cognosisapi.dll - here, I ahve deleted the AD namespace and removed everyone group from sysadmin role. But, first I have to restart the server with anonymous access. In FM cognos configuration, it is getting issue like
R ]" CAM-CRP-1132 An error occurred while attempting to request a certificate from the Certificate Authority service. An error occurred while attempting to request a certificate from the Certificate Authority service."
when I try to save the configuration.

IN cognos server configuration, It is getting error like
Validation]
[ ERROR ] CAM-CRP-1064 Unable to process the PKCS #7 data because of an internal error. Unable to find the common symmetric key with alias 'SRyi7YWCz1R3Bpckecr7IesOuxc=' in the keystore 'D:/IBM/configuration/csk\jCSKKeystore'.
The parameter named 'External JMX credential' located in 'Environment' is currently invalid.
[ ERROR ] CAM-CRP-1064 Unable to process the PKCS #7 data because of an internal error. Unable to find the common symmetric key with alias 'SRyi7YWCz1R3Bpckecr7IesOuxc=' in the keystore 'D:/IBM/configuration/csk\jCSKKeystore'.
The parameter named 'Account and password' located in 'Notification' is currently invalid.
, when I try to save the configuration.

So, I don't know where should I start to fix first.
Please help me to resolve this issue.

[sunosoft]

Ok....

You should start from server only. Once server starts sucessfully FM will also start.

I did some google, everywhere I am finding the solution like reconfigure the whole things again.

Did you try the below option after renaming the constarup.xml file ?
Copying the all contents of saved configuration from file menu into the cogstarup.xml file ? this will ensure that you have cogstarup.xml file while starting the configuration.

[simi123]

@sunosoft,

Can you tell me the steps to follow that,
So, I can configure correctly.

Thanks
Miru

[sunosoft]

I am not sure if you followed the below link or not....

http://www-01.ibm.com/support/docview.wss?uid=swg21340413

[simi123]

@sunosoft,

   When I try to open the cognos configuration, I am getting issue like,
CAM-CRP-1280 An error occurred while trying to decrypt using the system protection key. Reason: javax.crypto.BadPaddingException: Given final block not properly padded.

I don't know, need to reinstall again...

Please help me to resolve this issue.

Thanks,
Simi

[sunosoft]

I am assuming after following the above link you are getting this error.

Found in some forum, after renaming below two files can resolve this error.
caSerial (if exist) and cogconfig.prefs files in the configuration directory

But not sure...anyways we dont have any other option rather than giving try....please do not delete any file....take backup of any file for which you are making the changes.

[simi123]

@sunosoft,

   When I try to open the cognos configuration, the error messages is popup like
CAM-CRP-1280 An error occurred while trying to decrypt using the system protection key. Reason: javax.crypto.BadPaddingException: Given final block not properly padded

then I click 'Ok' to the message then the cognos configuration is disappeared. can't access to that..

I am facing new issue everytime.

Can you please give some idea to rectify this issue..

I don't know, I have to do reinstall again.

Thanks in advance,
Simi

[sunosoft]

Did you try this also ?

rename files caSerial (if exist) and cogconfig.prefs files in the configuration directory

Keep reinstalltion as a last option.

[simi123]

I didn't do anything after you said the steps.
Because the cognos configuration is not appeared after cloick ok to the error message.
So, I am still worrying how can I backup those files and save the configuration.

If once the took the backup files and when i try to open the cognos configuration then it will open then we can have option to save and restart the server again,,

But, now the issue is can't access to cognos configuration.

so, do you want me to do all the steps even if the cognos configuration is not appeared.?

Thanks,
Simi

[simi123]

@sunosoft,

At last, I connected to cognos configuration.
I followed your steps that you shared the link to resolve the issue
But trying to resolve the content store...


Thanks a lot and no words to say :) :) :) :) :) :) :) :) :)

Simi

[sunosoft]

Great....:)

let me know if you are facing any other issue while doing the same.

Today, my environment seems to be stable :) ....seem like users went for holidays...hence I dont have much work ;)  so if possible we can give try for other issue also :)

[simi123]

@sunosoft,

  Yes, issues are always keep coming with us...
:) :) :) :) :)
Here is the new issue,

Trying to test the content store , geeting error like

Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

please let me know the idea you have...


Simi

[sunosoft]

This is bit strange...if its testing successfully then it should connect also...

Which DB you are using as content store. Please check if domain name or somethin else need to be added to the DB server name or schema name.

Also try to ping Db server from the cognos server, check if its happening or not.
If its oracle DB try to do the TNS ping for the schema.

[simi123]

@sunosoft - We are using Microsoft Sql server as content store.
But, you know, earlier I was working fine with that. Now, it showing up error like "Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

I am keep trying to resolve that issue..

BTW, please let me know, if u have any idea!!!!!!!!!!!!!!


Thanks,
Simi

[MFGF]

What happens if you create a new database in SQL Server and point your Cognos instance to this as the content store? Does it initialize properly and give you a working instance?

MF.

[simi123]

Yes Sunosoft,

  I noticed that because of admin privileges problem.
If I changed the instance number then it tested successfully. So, I will try to get admin privilleges and resolve the Issue.

BTW, After created AD name space and give access to user to access the package, you know some times the BI welcome page is taking longer time to open and  sometimes working fine. I don't have any idea..I will send you the error from log file..

Thanks,
Simi

[simi123]

@suno soft,

Here is the new issue - When I try to start the server, still starting and giving the same message like

09:38:31, CM-REQ-2378 A request was received to start the negotiation process to determine which Content Manager instance should become active.
09:38:31, CM-REQ-2378 A request was received to start the negotiation process to determine which Content Manager instance should become active.
09:38:31, CM-REQ-2378 A request was received to start the negotiation process to determine which Content Manager instance should become active.
09:38:31, CM-REQ-2378 A request was received to start the negotiation process to determine which Content Manager instance should become active.


Thanks,
Simi