COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos for MS Office => Topic started by: Dev1975 on 25 Feb 2014 05:40:10 AM

Title: COC-ERR-2021 using Go Office in Excel
Post by: Dev1975 on 25 Feb 2014 05:40:10 AM
Hi All,

I'm having a strange issue and not sure where to look for this, especially as Googling has yielded no results thus far. Hopefully someone else may have encountered this before....

Background: Customer has Cognos installed in a Citrix environment and is using Access Manager for security, They have a particular user who is not able to import report content into Excel through Cognos Go Office. I've created a test account and imported his security access settings into it, assigned my OS signon to that account and was able to not only log in to Cognos through Excel but also import the report successfully.

Problem: I removed my OS signon from the test account and added it to his, then fired up a new session in Excel and connected to Cognos. I then attempted the report import process and got the the following message:

COC-ERR-2021 No prompt URL location has been specified. Check ReportNet configuration.

I removed my OS signon from the user's Access Manager account, added it back to my test account and tried with my test account. Now I am getting the above error as well and am no longer able to import the report. I've checked the configurations on the Content Manager and  Dispatcher servers but nothing is amiss. Interestingly enough, outside of Go Office, I am able to run the report in the browser as both myself and the affected user.

Has anyone come across this message before? Any pointers/tips greatly appreciated.

Many thanks,
Dev
Title: Re: COC-ERR-2021 using Go Office in Excel
Post by: Grim on 25 Feb 2014 07:45:03 AM
"Rename" the users windows profile and have him login from scratch (Thus creating a new profile) and have him try again.

Also, can you confirm that the MS KB patch (KB908002) that comes with Cognos for MS Office was installed. It comes with the installer in the <installer>/winXX/go_office directory.
Title: Re: COC-ERR-2021 using Go Office in Excel
Post by: Dev1975 on 26 Feb 2014 04:05:01 AM
Thanks Grim, will give that a shot and let you know how we get on.