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

Problem getting report in exce 2007

Started by megatrack67, 20 Feb 2012 09:08:29 AM

Previous topic - Next topic

megatrack67

we just upgraded from cognos 8.4.1 64 bit to cognos 10.1.1 64 bit

When running A report on C8 we have no issue getting the report in excel 2007 format
when doing the same thing in C10,
1. it takes longer
2. the report name is cognosisapi.dll
3. it is in read only

If you save the report it works fine
If you click on open it does not work

After a lot of testing we discovered that the source of the problem is the dns alias of our server (Which we are also using in C8)

If I configure our system with the server name or its IP address, everything is fine
As soon as we are using the alias excel 2007 does not work

Does anybody ran into that situation on dns alias and c10

Thank you for your help

Regards

Pc

Grim

Are you sure this is a DNS issue and not an Internet Exploder issue?
Does it do the same in Firefox?
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

megatrack67

I found the problem
The cause was not microsoft nor IIS nor the DNS
The problem comes from the parameter temporary objects location
By default C8 uses content store but c10 uses server file system
as soon as I changed it everything worked properly

Grim

Quote from: megatrack67 on 23 Feb 2012 01:32:51 PM
I found the problem
The cause was not microsoft nor IIS nor the DNS
The problem comes from the parameter temporary objects location
By default C8 uses content store but c10 uses server file system
as soon as I changed it everything worked properly

Thanks for the follow up!

For the uninitiated, this is what mega is referring too.
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id8029CMCacheLoad.html
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

PRIT AMRIT

Good piece of info Grim. Thanks for sharing this with us.