Can´t run on my IIS 5.0

35 views
Skip to first unread message

gjovan

unread,
Feb 12, 2010, 11:36:15 AM2/12/10
to Ranet.UILibrary.Olap
Hi,
I'm having trouble and I can´t run on my webserver. I've compiled the
application, added all MIME types for running Silverlight on my web
server but the "SilverliteApplication.htm" page sent a:

unhandled error in Silverlight application
code: 2104
Category: initializeError
Message: 2104 error

The Default.aspx page shows 2 string connections:

LocalSqlServer="data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User
Instance=true"
OLAPConnectionString="Data Source=localhost;Initial
Catalog=AdventureWorksDW"

but I can´t find the LocalSqlServer string to change the values.

Thanks in advance,

George Jovanovic

Anatoly

unread,
Feb 12, 2010, 1:54:31 PM2/12/10
to Ranet.UILibrary.Olap
Hi George,

You error is at client side. You browser cannot initialize silverlight
app.

It can be many causes why...
- incompatible os, browser or silverlight version
- xaf-file (built by you) is incorrect by some reason

Please specify you OS, Browser and Silverlight versions.

Have you all last updates installed?

Do you install all dependences specified at our readme file?

Please attach xaf-file content info (compiled sample silverlight app)

Regards,
Anatoly

Anatoly

unread,
Feb 12, 2010, 1:56:43 PM2/12/10
to Ranet.UILibrary.Olap
Can you run any other silverlight app from internet?
Please specify which pages with silverlight object you can see OK.

Anatoly

unread,
Feb 12, 2010, 1:58:29 PM2/12/10
to Ranet.UILibrary.Olap
What version of Ranet.UILibrary.OLAP do you use?

Galaktika OpenSource

unread,
Feb 12, 2010, 2:14:28 PM2/12/10
to Ranet.UILibrary.Olap
Please read info below:

http://forums.silverlight.net/forums/p/111126/309207.aspx
http://www.stellarpc.com/articles/board.aspx?id=42
http://www.google.com.by/search?q=unhandled++error+in+Silverlight+application+2104+&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:ru:official&client=firefox

George Jovanovic

unread,
Feb 12, 2010, 2:29:20 PM2/12/10
to ranet-uili...@googlegroups.com
Hi Anatoly,

following is the system info:

IIS v5
Internet Explorer 7.05730
Chrome 4.0249
SDKs and Silverlight versions same as in your install instructions.
OS Windows XP SP2

I've built using SharpDevelop 3.1

The Ranet msi is 1.2.6.0-6173

I can exceute and see the Silverlight interface from C:\.. (file system) but I can't execute as web application via HTTP (browser)

Regards,

George


2010/2/12 Anatoly <anatoly....@gmail.com>

George Jovanovic

unread,
Feb 12, 2010, 3:37:57 PM2/12/10
to ranet-uili...@googlegroups.com
Anatoly,

following is an extract from SilverliteApplication.htm file :

<body>
<form id="form1" runat="server" style="height: 100%">
<div id="silverlightControlHost">
<object data="data:application/x-silverlight-2," type="application/x-silverlight-2"
width="100%" height="100%">
<param name="source" value="ClientBin/UITest.xap" />
<param name="onError" value="onSilverlightError" />
<param name="windowless" value="true" />
<param name="enableHtmlAccess" value="true" />
<param name="background" value="white" />
<param name="minRuntimeVersion" value="3.0.40624.0" />
<param name="autoUpgrade" value="true" />
<a href="http://go.microsoft.com/fwlink/?LinkID=149156&v=3.0.40624.0" style="text-decoration: none">
<img src="http://go.microsoft.com/fwlink/?LinkId=108181" alt="Get Microsoft Silverlight"
style="border-style: none" />
</a>
</object>
<iframe id="_sl_historyFrame" style="visibility: hidden; height: 0px; width: 0px;
border: 0px"></iframe>
</div>
</form>
</body>

Is it ok the reference to Silverlight 2 ?

Regards,

George
2010/2/12 Galaktika OpenSource <galaktika....@gmail.com>

Galaktika OpenSource

unread,
Feb 13, 2010, 4:04:55 AM2/13/10
to Ranet.UILibrary.Olap
Please try to download (save file from IIS to local drive) ..you
webserver address../ClientBin/UITest.xap by any downloader (i.e.
flashget, reget, Firefox)

If you can not do this then please check MIME types, other IIS
settings again and restart IIS.

If you can download xap-file then we will analyze other posibilities.


Regards,
Anatoly

Galaktika OpenSource

unread,
Feb 13, 2010, 4:25:03 AM2/13/10
to Ranet.UILibrary.Olap
Do you have %you_virtual_catalog%\ClientBin\UITest.xap file?
If yes then chech IIS settings.
If no - lets analyse why (it was not build by your SharpDevelop 3.1)

Anatoly

Galaktika OpenSource

unread,
Feb 13, 2010, 4:27:43 AM2/13/10
to Ranet.UILibrary.Olap
My be you need simply copy it from UITest.Silverlight project results
to UITest.Web\ClientBin folder

George Jovanovic

unread,
Feb 13, 2010, 10:46:07 AM2/13/10
to ranet-uili...@googlegroups.com
Hi Anatoly,

Finally it works.

The problem was that SharpDevelop didn't create the "App_Data" and "ClientBin" (may be security settings) folders. Also I made a cpy from ..\UITest.Web\bin to 
..\UITest.Web\ClientBin.

The program is running but now I can't get access to database. The messages is the user has no access to the database or database doesn't exist.

Regards,
George

2010/2/13 Galaktika OpenSource <galaktika....@gmail.com>

Galaktika OpenSource

unread,
Feb 13, 2010, 11:57:56 AM2/13/10
to Ranet.UILibrary.Olap
> The program is running but now I can't get access to database. The messages
> is the user has no access to the database or database doesn't exist.

Go to MS SQL Management Studio, connect to Analysis Server and check
that database exists.
Then check identity at Default.aspx page.
Does ServerIdentity has rights to your OLAP database?

Anatoly

Galaktika OpenSource

unread,
Feb 13, 2010, 12:00:33 PM2/13/10
to Ranet.UILibrary.Olap
Is your database in online mode (is it processed)?
Can you execute any mdx query in MS SQL Management studio?

Galaktika OpenSource

unread,
Feb 13, 2010, 12:09:09 PM2/13/10
to Ranet.UILibrary.Olap
I propose to use last release
http://ranet-uilibrary-olap.googlecode.com/files/Ranet.UILibrary.Olap-1.3.2.0-6545.msi

Galaktika OpenSource

unread,
Feb 13, 2010, 12:14:09 PM2/13/10
to Ranet.UILibrary.Olap
Last release is 1.3.2.0
http://ranet-uilibrary-olap.googlecode.com/files/Ranet.UILibrary.Olap-1.3.2.0-6545.msi

George Jovanovic

unread,
Feb 13, 2010, 12:26:17 PM2/13/10
to ranet-uili...@googlegroups.com
Anatoly,

DB exists.

Following is part of Default.aspx:

Lets check that all is OK. 

You are at Url="http://localhost/ranet/Default.aspx" 
IsSecureConnection=False 
You are connected to your web server as UserIdentity='' 
IsAutentificated=False 
Identity.GetType()=WindowsIdentity 
AutentificationType= 
Your web server runs (or is impersonated) under ServiceIdentity="GJOVANOVIC\IUSR_GJOVANOVIC" 
This ServiceIdentity wil be used as OLAP connection identity. 

Connection strings which are specified in Web.config file: 

LocalSqlServer="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
OLAPConnectionString="Data Source=localhost;Initial Catalog=AdventureWorksDW"

OLAPConnectionString will be used if you will not explicitly set it at Configuration tab. 

I have no idea where the "LocalSqlServer" variable is set because I see only OLAPConnectionString at your source files.

George

2010/2/13 Galaktika OpenSource <galaktika....@gmail.com>
> The program is running but now I can't get access to database. The messages

George Jovanovic

unread,
Feb 13, 2010, 12:29:05 PM2/13/10
to ranet-uili...@googlegroups.com
Sure.

I'm running locally in my notebook. I can use MS SQL Mgmnt Studio and additionally I'm running StrategyCompanion's Analyzer (it uses ADO 9 but I have installed ADOMD 10 also)

2010/2/13 Galaktika OpenSource <galaktika....@gmail.com>

Galaktika OpenSource

unread,
Feb 13, 2010, 12:37:52 PM2/13/10
to ranet-uili...@googlegroups.com
>You are connected to your web server as UserIdentity='' 
>IsAutentificated=False

You connect to you virtual catalog anonymously.
To connect under your own identity you need to disable anonymous access at security tab of virtual catalog and enable basic authentification for example.


>ServiceIdentity="GJOVANOVIC\IUSR_GJOVANOVIC" 
>This ServiceIdentity wil be used as OLAP connection identity.

OLAP server see you requests as made from "GJOVANOVIC\IUSR_GJOVANOVIC"
This identity has no rights to OLAP by default.
So OLAP server reject all requests.

You can simply add some rights to "GJOVANOVIC\IUSR_GJOVANOVIC" (for example you can make it OLAP administrator)

Galaktika OpenSource

unread,
Feb 13, 2010, 12:53:22 PM2/13/10
to Ranet.UILibrary.Olap
>I have no idea where the "LocalSqlServer" variable is set because I see only
OLAPConnectionString at your source files.

It is default setting at C:\Windows\Microsoft.NET\Framework
\v2.0.50727\CONFIG\machine.config
No problem - LocalSqlServer connection string is not used by our
control.

George Jovanovic

unread,
Feb 13, 2010, 2:11:55 PM2/13/10
to ranet-uili...@googlegroups.com
Already tested granting privileges and changing IIS authentications parameters to Windows Integrated security but still not able to access the cube.

I'll try with latest version of Ranet library and see what happens.

Thanks for your support

2010/2/13 Galaktika OpenSource <galaktika....@gmail.com>

Galaktika OpenSource

unread,
Feb 13, 2010, 2:18:04 PM2/13/10
to ranet-uili...@googlegroups.com
What do you see at default.aspx now?

Galaktika OpenSource

unread,
Feb 13, 2010, 2:24:31 PM2/13/10
to ranet-uili...@googlegroups.com
Check database name and server instance in OLAPConnectionString

Galaktika OpenSource

unread,
Feb 13, 2010, 2:26:32 PM2/13/10
to ranet-uili...@googlegroups.com
Send stacktrace you see when click CheckConnection

George Jovanovic

unread,
Feb 13, 2010, 2:55:45 PM2/13/10
to ranet-uili...@googlegroups.com
Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: El usuario 'GJOVANOVIC\George' no tiene acceso a la base de datos 'AdventureWorksDW' o no existe la base de datos.
   en Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IDiscoverProvider.Discover(String requestType, IDictionary restrictions, DataTable table)
   en Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Discover(AdomdConnection connection, String requestType, ListDictionary restrictions, DataTable destinationTable, Boolean doCreate)
   en Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.PopulateSelf()
   en Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Microsoft.AnalysisServices.AdomdClient.IObjectCache.Populate()
   en Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.PopulateCollection()
   en Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.get_Count()
   en Microsoft.AnalysisServices.AdomdClient.CubesEnumerator.MoveNext()
   en Microsoft.AnalysisServices.AdomdClient.CubeCollection.Enumerator.MoveNext()
   en UILibrary.Olap.UITestApplication.Web.OlapWebService.SetConnectionString(String argument)

2010/2/13 Galaktika OpenSource <galaktika....@gmail.com>

Galaktika OpenSource

unread,
Feb 15, 2010, 4:43:46 AM2/15/10
to Ranet.UILibrary.Olap
Hi George

You can see and debug that exception is in OlapWebService.asmx.cs
file.

There is NO Silverlight code, NO complex logic.

We check that user has right to enumerate cubes in OLAP database.
and OLAP server rejects request.

Please create simply application (for example console app) and execute

var connectionString="Data Source=localhost;Initial
Catalog=AdventureWorksDW";
using (var connection = new AdomdConnection(connectionString))
{
string s = "";
connection.Open();
foreach (var c in connection.Cubes)
{
s += c.Name;
}
}

When you can do this successfully we will continue to solve your
issue.

Regards,
Anatoly

George Jovanovic

unread,
Feb 15, 2010, 6:35:24 PM2/15/10
to ranet-uili...@googlegroups.com
Hi Anatoly,

Finally working!

I've made the test for checking if Ranet can access cubes and it's working.

I've build again all the solution and is working fine.

Very nice!

Where could I control time-outs?

Best regards,

George Jovanovic


2010/2/15 Galaktika OpenSource <galaktika....@gmail.com>

Galaktika OpenSource

unread,
Feb 16, 2010, 2:22:58 AM2/16/10
to ranet-uili...@googlegroups.com
Hi George


>Where could I control time-outs?

In OLAP server settings.

Or you can write special algorithm for prolonging olap connection life time as we do in commercial products.

Regards,
Anatoly


Reply all
Reply to author
Forward
0 new messages