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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unable to backup entire content store

Started by Diaonic, 17 Oct 2018 09:29:05 AM

Previous topic - Next topic

Diaonic

EDIT:
Cognos 10.2.2 for reference

I'm having trouble getting an export of my entire content store. I've tried with and without user credentials. I've also run an internal consistency check which found items, and external consistency which found nothing.

My content store is telling me I need to restart it in order apply the find and fix from the consistency check. However, its telling me I could lose data, so I'm nervous about doing that without a full export.

What steps can I take to get a full export?
What steps can I take to protect myself from potential data loss here?

I need to move this content store to another fresh Cognos installation next week.

Here is the error I'm getting:
https://imgur.com/pROpamj

MFGF

Quote from: Diaonic on 17 Oct 2018 09:29:05 AM
EDIT:
Cognos 10.2.2 for reference

I'm having trouble getting an export of my entire content store. I've tried with and without user credentials. I've also run an internal consistency check which found items, and external consistency which found nothing.

My content store is telling me I need to restart it in order apply the find and fix from the consistency check. However, its telling me I could lose data, so I'm nervous about doing that without a full export.

What steps can I take to get a full export?
What steps can I take to protect myself from potential data loss here?

I need to move this content store to another fresh Cognos installation next week.

Here is the error I'm getting:
https://imgur.com/pROpamj

Hi,

It looks to me like the deployment folder the archive gets written to (in the filesystem) isn't there, or your Cognos instance doesn't have permission to see it? Have you changed the default deployment location? Take a look in Cognos Configuration - the first entry in the Environment section details where the Deployment files location is. Has it been changed from the default (../deployment)? Does the folder it points to exist? Does the Cognos service account have access to see/write to this folder?

Cheers!

MF.
Meep!

Diaonic

MF

Thanks for the reply. So the deployment folder does exist inside of the Cognos folder:
F:\Program Files\IBM\cognos\c10_64\deployment


Inside cognos configuration I see this:
https://imgur.com/a/xjxcMlO

When I do an export and choose select folders, then manually select all of the reporting structure folders the export works fine and ends up inside of the deployment folder. When I try to do the entire content store, it fails and it fails with or without user accounts included.

Is there a better way to migrate this cognos instance, user info and reports to a fresh cognos 10.2.2 install? That's the goal here.


sdf

Is doing it via content store db not an option for you?
Create a backup of your content store db and restore it to a new db.
Create a fresh install of cognos and configure it to use the restored copy of your current content store db.

Diaonic

The installation was installed using the builtin database. Wasn't really a challenged I wanted to deal with right now, just trying to get the server migrated to new hardware.

Do you know of some instructions on how to do this with builtin db? If it was DB2 I could do it easily, but its using some other tech right?


sdf

So you have Apache Derby for Content Store. I believe that's the built in one.
I am not sure if there's a way to get a backup of that db and restore it to the new instance.
I believe the location is \\<CognosInstallDirectory>apacheDerby..


Diaonic

After doing the consistency checks and doing a full system reboot. I was able to grab a full content store export (1.5GB).

Thanks for the help everyone