ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

XMLA - wrong catalog -

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

[quote][i]Originally posted by meo[/i]
[br]hello,

i have two Servers
1) Live Server ( Name: Server_live)
2) developer with cubes (Name; Server_dev)

On Server Nr. 1 (Server_live) ist Reportportal installed.

When i want to go on the cubes on Server_dev(2) i get allways the catalog from Server_live (1)

the only way to get the right catalog, is to cut the connection information in the config file for xmla.
Is there a wrong caching ?

my config file for xmla:

<?xml version="1.0" ?>
<DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600" MaxRequestSize="128" AllowInsecureTransport="1" EnableNagleAlgorithm="1">
<DataSource>
	<DataSourceName>Live Server</DataSourceName>
	<DataSourceDescription></DataSourceDescription>
	<URL>http://localhost/xmla/msxisapi.dll</URL>
	<DataSourceInfo>Provider=MSOLAP.2;Data Source=Server_Live</DataSourceInfo>
	<ProviderName>Microsoft XML for Analysis</ProviderName>
	<ProviderType>
		<TDP/>
		<MDP/>
		<DMP/>
	</ProviderType>
	<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>

<DataSource>
	<DataSourceName>Dev Server</DataSourceName>
	<DataSourceDescription></DataSourceDescription>
	<URL>http://localhost/xmla/msxisapi.dll</URL>
	<DataSourceInfo>Provider=MSOLAP.2;Data Source=Server_dev</DataSourceInfo>
	<ProviderName>Microsoft XML for Analysis</ProviderName>
	<ProviderType>
		<TDP/>
		<MDP/>
		<DMP/>
	</ProviderType>
	<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>

</DataSources>

[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
meo	Posted - 07/16/2007 : 07:47:53 hello, i have two Servers 1) Live Server ( Name: Server_live) 2) developer with cubes (Name; Server_dev) On Server Nr. 1 (Server_live) ist Reportportal installed. When i want to go on the cubes on Server_dev(2) i get allways the catalog from Server_live (1) the only way to get the right catalog, is to cut the connection information in the config file for xmla. Is there a wrong caching ? my config file for xmla: <?xml version="1.0" ?> <DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600" MaxRequestSize="128" AllowInsecureTransport="1" EnableNagleAlgorithm="1"> <DataSource> <DataSourceName>Live Server</DataSourceName> <DataSourceDescription></DataSourceDescription> <URL>http://localhost/xmla/msxisapi.dll</URL> <DataSourceInfo>Provider=MSOLAP.2;Data Source=Server_Live</DataSourceInfo> <ProviderName>Microsoft XML for Analysis</ProviderName> <ProviderType> <TDP/> <MDP/> <DMP/> </ProviderType> <AuthenticationMode>Unauthenticated</AuthenticationMode> </DataSource> <DataSource> <DataSourceName>Dev Server</DataSourceName> <DataSourceDescription></DataSourceDescription> <URL>http://localhost/xmla/msxisapi.dll</URL> <DataSourceInfo>Provider=MSOLAP.2;Data Source=Server_dev</DataSourceInfo> <ProviderName>Microsoft XML for Analysis</ProviderName> <ProviderType> <TDP/> <MDP/> <DMP/> </ProviderType> <AuthenticationMode>Unauthenticated</AuthenticationMode> </DataSource> </DataSources>
1 L A T E S T R E P L I E S (Newest First)
admin	Posted - 07/18/2007 : 19:38:29 It seems that that you have troubles connecting from a web server (Server_live) to Analysis Services on another server (Server_dev). It is important that 1) Both servers belong to the same domain or workgroup 2) The anonymous user for XMLA virtual directory has full access to Analysis Services on the other server. Are you able to connect to the remote AS server by removing the entry to the local AS server in datasources.xml file?

ReportPortal