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

created duplicate tables in content store

Started by smtest, 24 Apr 2007 07:38:39 AM

Previous topic - Next topic

smtest

hi all,
i am using sql server as a content store. What happened, in the sql server database, cognos created two sets of tables one for dbo and one for cognosadmin. But it suppose to be as dbo. Because of this, it is giving problem in cognos connection while connecting to sql server.
pls advice

kattaviz

Hi,

Which user name was specified at the time of setting Cognos Configuration settings.Try deleting the content store and create again using only the user name "cognosadmin" in the configuration settings.

hth
thanks & regards
Satish Katta

smtest

i did that and it works fine but i need data from other database. I tried to do whole content store export. it gives me this error:
CM-REQ-4248 Unable to access the account "CAMID("NA_AD:u:16cc853142edda45ab3d5e0810a74c0e")" in an external security system
and in this way, it is missing 24 users. I dont know why i am getting this error. We are only using Active directory and i have admin rights.
Because of this , i decided to do it from database.
pls advice

larsonr

That error means the account or AD Role/Group associated with that CAMID that you created in your Congos Groups and roles is no longer valid in Active directory.

Also what data are you talking about getting from other databases.  You should really only have one content store, right?  The other databases are your data warehouses and other datasources? Or are you talking about from the other "dbo" user. 

I don't think you can really merge data from both content stores, its one or the other I believe. If you really want the dbo as your content store, then use that when setting up your cognos configuration.  Then run your export.  If you wish to run this instance as the other user, then have your DBA drop the tables from that user.  Then set up Cognos Configuration to use the new user "cogadministrator".  This will recreate the unpopulated tables under this user.  Afterwards run the export you made from the dbo user content store and now you should have the same data from "dbo" in "cogadminstrator". 

smtest

My situation is , i have in my content store database two sets of tables one own by dbo and the other one by cognosadmin. Right thing, i should only have cognosadmin tables not dbo. So i deleted all the tables with dbo owner. Then it gave me an error while connecting to database. I am trying to move from mr1 to mr2. It worked fine before. But after i install a hotsite that fixes the validation issue in mr2. It started giving me this error.
Now i am trying to do it through cognos connection by migration whole content store. As i said it didnt include 24 users (i got a camid error).
My main concern is if i use the content store package (instead of doing a database way). It does not exclude the reports created by users in their personal folder. Bottom line is , it should not affect the existing or active users.
pls advice.
thanks

smtest

I would also like to add, when i try to import the content store package in mr2. What would be the impact. Because i dont want to loose more information in that import.
pls advice

COGNOiSe administrator

The reson why you have two set of tables could be that your priviliges within the DB changed or the DB account you've used to configure CRN with was changed.

You may safely ignore CAMID errors like the one you've mentioned. My recommendation would be to bring up a new CS DB, deploy your package in there and make sure everything works. This way you always ahve something to fall back on.

smtest

Thats what i did, I created a new datasource for mr2. Now planning to move mr1 content store package there.  I was kind of concerned because of those camid errors. As i spoke with cognos. They gave me a reason, which is similar to yours. But then they told me there is also no guarantee that it may not leave something. That statement made me worried.
thanks for your help