COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: dermeister on 11 Feb 2009 09:52:32 AM

Title: Resetting Ownership to "None" in EP 8.3
Post by: dermeister on 11 Feb 2009 09:52:32 AM
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.
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: dermeister on 11 Feb 2009 09:54:33 AM
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.
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: craig_karr on 12 Feb 2009 06:08:13 AM
During the GTP you have the option under workflow states. Change from "Leave" to "Reset"
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: dermeister on 18 Feb 2009 04:03:42 PM
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.
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: moocher on 18 Feb 2009 06:39:50 PM
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....
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: sascha on 25 Feb 2009 02:09:32 PM
Check on the applications NODESTATE table and clear dataownerguid.
But try on your own responsibility ;-)
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: dermeister on 17 Mar 2009 09:36:40 AM
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??
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: moocher on 17 Mar 2009 03:37:37 PM
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.  ???
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: sascha on 17 Mar 2009 03:42:37 PM
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.
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: dermeister on 25 Mar 2009 09:03:13 AM
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.
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: moocher on 25 Mar 2009 05:34:05 PM
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
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: sascha on 25 Mar 2009 05:36:42 PM
I still prefer inviting your DBA for a couple of beers and ask for access to the db table  ;D
Title: Re: Resetting Ownership to "None" in EP 8.3
Post by: candre on 26 Mar 2009 03:13:55 AM
Thanks for your help