Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Invisi on 10 Jan 2017 09:22:16 AM

Title: Use existing Content Store for new install of 10.2.1?
Post by: Invisi on 10 Jan 2017 09:22:16 AM
I am installing a new Cognos server, 10.2.1 (IBM refuses to download older versions and I only have 32 bit of current version 10.1 here at client...). In my old Cognos 8 days, I was able to tell Cognos the location of an existing Content Store (a copy of course) and during the installation it would recognize this repository and migrate it to the new version. Now when I install, it ignores my existing repository content. What am I doing wrong?
Title: Re: Use existing Content Store for new install of 10.2.1?
Post by: Invisi on 10 Jan 2017 09:57:39 AM
I found the (first) culprit: the database I copied (SQL Server...) is not on the regular dbo, but on 'Cognos8'... I will see how I can change that.
Title: Re: Use existing Content Store for new install of 10.2.1?
Post by: smiley on 10 Jan 2017 11:51:58 AM
Either look for a script to change all Cognos8.table to dbo.table ownership, or on your new sql server create user Cognos8
Then run the following stored procedure against your restored database to activate the Cognos8 user.

EXECUTE sp_change_users_login 'Update_One', 'Cognos8', 'Cognos8'
Title: Re: Use existing Content Store for new install of 10.2.1?
Post by: Invisi on 11 Jan 2017 02:46:16 AM
smiley, thanks for the tip!

I have chosen to go for the formal way, with an export and import...  :o
Title: Re: Use existing Content Store for new install of 10.2.1?
Post by: smiley on 11 Jan 2017 03:29:12 AM
That´s even better, due to bypassing the "crap out, crap in" that way.
Text only | Text with Images