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

Resetting Ownership to "None" in EP 8.3

Started by dermeister, 11 Feb 2009 09:52:32 AM

Previous topic - Next topic

dermeister

We are in the process of migrating EP 8.3 contributor apps to QA and Production. We need to reset ownership to "none", from the latest editors, during these moves. Is there a way to reset the field in the existing apps?

Thanks in advance for any help.

dermeister

I forgot to mention that this used to be accomplished by deleting users and rights from Access Manager in 7.3, but this is not an option for 8.3.

craig_karr

During the GTP you have the option under workflow states. Change from "Leave" to "Reset"

dermeister

Thanks for the reply.

The workflow status will reset to "Not Started"; however, for any node that has been opened, the person's name remains in the web grid for that node.

It's not the status that's the problem, it's the person's name as owner instead of "None", which is present for each node on a new application.

moocher

i suspected this would happen, but i am not in a Cognos environment right now so was unable to test.

isnt it just a case of removing all the rights from contributor, running a GTP, then adding them back in and running another GTP. again, i dont have access to Cognos right now to test this....

sascha

Check on the applications NODESTATE table and clear dataownerguid.
But try on your own responsibility ;-)

dermeister

Thanks again for the responses.

Unfortunately the removing rights and running GTP method does not work...it did in 7.3, but no longer.

Sascha-
I would write to the table, but we don't have that type of access. We're in a very "locked-down" environment.

Any other ideas out there??

moocher

Do you need the data? If not, delete the elist items, GTP, add them back in and GTP again.

A fairly crude method though, must be something better.  ???

sascha

#8
The reference from the dataownerguid to the users is done by means of the authid of the CAM objects assigned. Assuming you use Cognos groups and roles for you CAC rights you can try to delete and readd these groups and reassign the new ones in the rights.

dermeister

Thanks very much for the replies.

Deleting the group or role, and then reassigning the rights does not work.

Deleting the Elist node works, but isn't a viable solution. Nevertheless, I thought that fact may be helpful in solving the problem.

moocher

Two more suggestions....

Create a new user called "None" - log in as this user and take ownership of every elist item

Create a new application in contributor - using deployment export and import - this application can then have all elist items removed and then added back in - the data can then be copied across from the original application using admin links

sascha

I still prefer inviting your DBA for a couple of beers and ask for access to the db table  ;D

candre

#12
Thanks for your help