New Contributor Apps in IE

[StuartS]

Hello

I have an environment running Analyst, Contributor 8.1.

I am finding with each new application that is created in the PAD is not displayng in IE after a gtp.  The error seen is as described in cognos case,
http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=132982

I have a fix for this which involves the following steps.

Remove from PAD
Add to another PAD
Remove from other PAD
Delete namespace in SQL table dbo.adminoptions
Add to original PAD
GTP


My problem is that this is happening with EVERY new contributor app added.  (This is a development environment hence many new apps).

I have changed two settings in metabase.xml, AspMaxRequestEntityAllowed and AspBufferingLimit.

Case
http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=134954
Indicates that it is a namespace problem.

Has anyone any suggestions on how to fix.

Thanks

Stuart

[ykud]

You don't get new applications in application selection list? On planning40.asp page?
Never seen such error, so just a guess: try reconfiguring contributor website again using planning44.asp page.
And do standard "restart IIS, restart COM +, restart EP" service sequence

[StuartS]

Hello Ykud

The applications add to the CAC as normal, they run as normal, they go to production as normal.
Its just very strange that every time a NEW (in otherwords SQL tables not created) application is added then this IE error occurs.  Everything else is normal, no errors, no planningerrorlog entries.

When, as mentioned in my fix list, applications are re-added, they are in the application selection list as the SQL tables then exist.

The namespace, 'default' is in a LAE file.

Specific to your suggestions,
The server hostings the PAD has been rebooted several times, and the pad reconfigured through Planning44.

Confused...

Stuart

[SomeClown]

"Server hosting the PAD" - do you mean the server found in Tools |Options in the CAC?

Are the planning service and COM+ running under the same service account?

What database type?  How do you connect  -- Trusted or SQL account?  What permissions into the database does this account have?

[StuartS]

Hi

Server hosting the PAD.  Yes.

Planning service and COM+ are running under the same account.  As the server hosting the PAD is also the DNS Server and DHCP server, the authentication is domain administrator.

The database is SQL, and connection is through a defined account, not trusted connection.  Permissions of this account are as DB owner.

Stuart

[ducthcogtechie]

Setup IIS on a windows XP box, install the website part of contributor against the pad on the DB.
Does that website pick up changes in the published models list?

[SomeClown]

SQL acct has read/write permissions to the PAD databases (datareader/datawriter)?

[StuartS]

Hello

Sorry, should have explained the environment.

Windows 2003 Server Standard
SQL 2005 Standard
Analyst and Contributor 8.1

dutchcogtechie, yes the IIS XP machine(client) does pick up the website, and contributor model list in planning40.asp.  Two machines tested, one XP part of domain as client, and one XP machine just connected on LAN cable so through http.  Both worked.

SomeClown, yes the SQL account has full permissions, READ/WRITE.

Ive got some ideas to try from what you suggested so Ill try these and update.

Thanks

Stuart

[ducthcogtechie]

I meant using an XP machine as an additional webserver to rule out IIS configuration issues on the windows server 2003.

[StuartS]

Hello

Thank you all for your help.

Ive found a solution.

The solution I found seems a little simple, but never the less, its fixed my problem.

I was opening a remote session on the Server (running Cognos) with a user name different that which was used to install Cognos.  mstsc.exe.

In the cognos calls I referenced, the namespace in access manager was implicated.

As indicated above a LAE file was being used.

My solution was to run the Access Manager Configuration Wizard and explicitly reference the LAE file.  Access Manager had already found the LAE file based on Cognos Configuration, but it wanted me to configure Access Manager itself.

I hope this makes some sense.

Stuart

;D ;D ;D ;D ;D ;D ;D ;D ;D ;D

[ykud]

Use a directory server.

[SomeClown]

I've seen the need to run the Configuration Wizard before to create settings but not as that symptom (and using either LAE or an LDAP provider).  Not sure why it happens, might be a registry (HKCU) thing under certain circumstances.  Thanks for sharing the solution.