If you are unable to create a new account, please email support@bspsoftware.com

 

server migration : do i need to export current cognos content store to new ?

Started by nsaxena, 12 Oct 2015 06:20:04 AM

Previous topic - Next topic

nsaxena

Hi All ,

We had cognos installed on one server,and now we have to move to the whole setup to  different server.

In new server,cognos 10.2.2 version is installed and database used is IBM db2(v.9.7).
Content Store database(COGNOSCS) is created and linked to cognos configuration.

We are migrating from 10.2.1(installed in current server) to 10.2.2(new server) with same database version on both database.

Now,as next step we need to export data from current database server to new one. In current server we have existing cognos content store database,and one database(schema) having database objects(non cognos)

My question is :- Do i need to export current content store database with all its content and copy to new content store database(COGNOSCS)?

Please suggest me approach for this.

There is no database admin,and we need to prepare a plan for approval. I need help.
Many thanks in advance!


cognostechie

Hi -

You can wither use the Cognos deployment feature of exporting the entire Content Store and importing it into the new Environment

OR

you can backup the Content Store from 10.2.1  and restore it into the Content Store of 10.2.2. Backup and Restore using the database utility.
Once it is restored into 10.2.2, you can use this in the Cognos Configuration of 10.2.2

I have done it both ways and I prefer to do Backup and Restore.

sdf


nsaxena

Hi All ,

Thanks for suggesting option and i will go for "backup and restore" as you all suggested.
I could see backup and restore option in control center,and tried testing on small database.

But i selected everything default in backup and re-store, can anyone advice me which settings i need to choose during "backup and restore"
Or any document/link.

Thanks again!

nsaxena

Quote from: cognostechie on 12 Oct 2015 12:05:26 PM
Hi -

You can wither use the Cognos deployment feature of exporting the entire Content Store and importing it into the new Environment

OR

you can backup the Content Store from 10.2.1  and restore it into the Content Store of 10.2.2. Backup and Restore using the database utility.
Once it is restored into 10.2.2, you can use this in the Cognos Configuration of 10.2.2

I have done it both ways and I prefer to do Backup and Restore.

Hi ,
We performed the backup and restore option and successfully copied current verison 10.2.1 content store database to new version database.

But i noticed one thing,i could see now two dispatchers URL (the extra URL is pointing to old SERVER URL).
Is this due to we copied content store of old sever into new,hence URL information is also copied?
or is something wrong?

I tested  OLD Server dispatcher URL and its failing, with error as :-
Handler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler [the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [adminRequestChain] com.cognos.pogo.handlers.logic.ChainHandler [AdminRequestHandler] com.cognos.pogo.handlers.configurable.AdminRequestHandler

Should i remove this url?

Kindly advice!

Thanks!

cognostechie

Is your installation on a single server or distributed on multiple servers? Considering the fact that you did not ask any questions for distributed
install, I would presume that 10.2.2 is installed on a single machine. Also, can you confirm if a brand NEW database was created for 10.2.2 and then
10.2.1 was restored into that?

Presuming both of the above are true, this is probably what happened. The dispatcher from 10.2.1 came into 10.2.2 but obviously it cannot access the earlier
environment so it is throwing that error. When Cognos service was started on 10.2.2, it registered a new dispatcher with the URL of the 10.2.2 server so now you have two dispatchers.

You can 'unregister' the dispatcher of 10.2.1 and after that open the Cognos Configuration and make sure that all dispatcher URLs are pointed to the dispatcher which has the URL of the new server (10.2.2 environment - the dispatcher that was created in 10.2.2). Again, this is considering you have Cognos installed on one server. For distributed installs, there are multiple dispatcher settings in Configuration some of which can be different than others.

nsaxena

Hi ,

Thanks for suggesting.
Yes installation was on single server and on 10.2.2 database we had database created first COGNOSCS and then we re-store the 10.2.1 database CS into COGNOSCS .

cognostechie

You can just 'unregister' the dispatcher which came from the earlier version.