"No catalogs are available in the current session"   

I'm getting the following error:

XA:XMLAnalysisError.88BA0904 No catalogs are available in the current
session. urn:schemas-microsoft-com:xml-analysis

There is one cube in a catalog the server but can't even enumerate the
catalogs via XMLA...

Changing the "enforce on" setting from "client" to "server" seems to
have solved the problem in a few cases, but not reliably (in the past).


We can't figure out how to make our "big" AS server respond via XMLA to
enumerate the catalogs, let alone any cubes...  we just get the same
"No catalogs are available in the current session" error.

Clearly there are catalogs, with cubes, no less.

This setup is using "unauthenicated" XMLA implementation (ie not
https)...  Is that part of the problem? Additionally, the XMLA provider
is not running on the same system as the AS server that we're having
the problem "enumerating cubes" with.


but other AS servers we have don't seem to have this problem...


Please help...  ! 


-Eric

date: 20 Sep 2005 18:01:41 -0700   author:   Eric S

Re: "No catalogs are available in the current session"   

Eric, here are a couple of guesses:

1.
    - your XMLA virtual directory is configured to allow Anonymous
authentication
    - your client is sending a request and is being authenticated as the IIS
anonymous user "IUSR_xxx" or "IWAM_xxx"
    - this user doesn't have permission to any of the catalogs on your
server and so when XMLA SDK tries to connect it cannot access any catalogs
and fails.

2.
    - you are using Windows authentication
    - your AS server is on a different machine
    - your client is on a third machine
    - Windows NTLM credentials cannot be delegated over a double-hop (this
is a classic issue)
    - So IIS will be running as the anonymous user and encounter the same
issue as above

Either way, the main thing is to make sure that XMLA SDK connects as a user
with permission to the catalogs:
    - either use Basic authentication over HTTPS
    - or give the anonymous user permission to the AS catalogs (if that is
feasible for your business)
    - or use Kerberos with delegation to solve the double-hop problem (this
is non trivial)
    - or move the XMLA SDK onto the same machine as the AS server

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Eric S"  wrote in message
news:1127264501.103407.124080@o13g2000cwo.googlegroups.com...
> I'm getting the following error:
>
> XA:XMLAnalysisError.88BA0904 No catalogs are available in the current
> session. urn:schemas-microsoft-com:xml-analysis
>
> There is one cube in a catalog the server but can't even enumerate the
> catalogs via XMLA...
>
> Changing the "enforce on" setting from "client" to "server" seems to
> have solved the problem in a few cases, but not reliably (in the past).
>
>
> We can't figure out how to make our "big" AS server respond via XMLA to
> enumerate the catalogs, let alone any cubes...  we just get the same
> "No catalogs are available in the current session" error.
>
> Clearly there are catalogs, with cubes, no less.
>
> This setup is using "unauthenicated" XMLA implementation (ie not
> https)...  Is that part of the problem? Additionally, the XMLA provider
> is not running on the same system as the AS server that we're having
> the problem "enumerating cubes" with.
>
>
> but other AS servers we have don't seem to have this problem...
>
>
> Please help...  !
>
>
> -Eric
>

date: Tue, 20 Sep 2005 21:16:49 -0700   author:   Akshai Mirchandani [MS]