Upgrade issue from cognos 11.0.7 to 11.0.13

[dougp]

Cognos 11.0.7
Windows Server 2012 R2
IIS
SQL Server 2016

Cognos 11.0.7 was running fine.  I installed 11.0.13 to the same location where 11.0.7 was installed.


I saw the post for Upgrade issue from cognos 11.0.9 to 11.0.13
I got the same error, but it was the last error in my startup.

It works for me : http://cogknowhow.tm1.dk/archives/1567  (Renew the keys)

Only worked in the sense that I don't get that specific error any more.


When I test my data sources, I get...

Code Select Expand

[Logging]
[ ERROR ] IPFTEST-006 Logging failed to connect to Database:jdbc:sqlserver://SERVERNAME\INSTANCE;databaseName=IBMCognosAudit;integratedSecurity=true

Code Select Expand

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] 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 found that the install process deleted by JDBC auth files (sqljdbc_auth.dll for x86 and x64).  Putting them back in the right place did not resolve the problem.
sqljdbc42.jar was still in the drivers folder.
The IBM Cognos service is configured to run as a MSAD service account.  I have verified that the service account has all the necessary permissions for both databases.  (The account has exactly the same permissions to the databases that it had when I began the install process -- when 11.0.7 was working.


When I try to start the service, I get...

Code Select Expand

CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-SYS-5003 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.
Cause: The connection to the host SERVERNAME, named instance INSTANCE failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434.  For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.


cogaudit.log is telling me that the logging service and the content manager service started successfully, then in the next few entries tells me it can't connect to either database.

This is wierd.  Anybody have any ideas?

[Reinhard]

Hi,

if you want files to not being deleted like your dll files in \bin and \bin64 then you can add them in the \configuration\preserve\preserve.txt

So you have not changed anything in the Cognos Configuration? So basically entries like servername, port and so on must still be correct.

Right mouse button > test on the CS entry shows the error too?

Did you check the Software compatibility matrix for C11.0.13 if you database version is still supported?

Regards
Reinhard