.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

WCF Ria Services DataLoading problem

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :WCF

Hi, I have problem with loading data. My project - WCF Ria Services with Entity Framework. Loading of collection:

_icsDomainContext.Load(_icsDomainContext.GetAllICSActionsWithRelatedDataQuery()).Completed +=

(o, e) =>

{ ... }

If I change collection from other computer or directly in base and then on my computer load collection again I see that collection didn't change - load operation taking data not from data base but from any cashe. How to make loading from Data base? 

Thanks for answers.


View Complete Post

More Related Resource Links

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Problem with Subreports in Tablix in 2008 SQL Reporting Services

Hi,  I have set up a report to get data from an SQL Table to build a matrix of possible combinations of 2 products, works fine. For each combination a subreport should be called with row and colum value as parameter - also OK. But for most of the first and second column are the same column values handed to the subreport, for all other columns it works Deleting and recreating the matrix does not help   Thanks in advance

Problem in starting the SQL Server Reporting Services

Hi All,   I have a problem in deploying the reports. when i try to deploy the reports it shows that  Report Sever not working but when i try to start my SQL Server Reporting Services will get the below mentioned error so please can one could suggest me on  this. "Could not Start the SQL Server Reporting Services (MSSQLSERVER) service on local computer ERROR1053: Service didnt respond to start or control request in a timely fashion" Regards, Snusha  

Business Data Connectivity Services Problem

I'm having problems getting Business Data Services to work. When I go into: Central Administration -> Service Applications -> Business Data Connectivity Services I get the error 'keyset does not exist' I've been doing some reading and come to the conclusion it's something to do with authentication? We use NTLM authentication and I'm wondering if we need to set up sharepoint to use kerberos. Does anybody know about this problem? Thanks

Reporting Services timeout problem

Hi, We just started to use Reporting Services in integrated mode (SQL Server 2005, MOSS 2007). The huge problem is we unable to build models of big databases: "Server was unable to process request. ---> The operation has timed out " The process teminates correctly if database is small enouth to finish model building under appoximatly 100 sec. Curently I increased timeout values in site and RS service config files:  rsreportserver.config: <Add Key="SQLCommandTimeoutSeconds" Value="2400"/> <Add Key="DatabaseQueryTimeout" Value="9000"/>  site web.config    : <httpRuntime maxRequestLength="51200" executionTimeout="9000" />   Still having same problem. Any suggestions where I can find that 100 sec value? Please help.

Need help to solve a problem with services.

Hi all.

I have a problem with alerts. The problem is that immediate alerts work, but weekly and daily summary - alerts don't work. I think I have found what the problem is, it is with the timer service, but unofrtunately I don't know how to slove it.

I have checked this article http://technet.microsoft.com/en-us/library/cc561011(TechNet.10).aspx and still haven't manage to solve the problem.

Any ideas for me?

This is how my errors look like.


Problem Deploying the Reporting Services Web Parts to SharePoint



I am trying to install the RSWebParts.cab file - which contains the Report Viewer and Report Explorer web parts - to my SharePoint 2010 server.  I ran the following command in PowerShell: stsadm -o addwppack -filename path/to/RSWebParts.cab -globalinstall. And received "The solution was successfully deployed" message.

However when I go into the SharePoint Server web front-end, I cannot find any trace of the new web parts.  Going back into PowerShell I ran the Get-SPWebPartPack command and the following was returned:

Name                             SolutionId                                                Deployed

rsswebparts.cab               00000000-0000-0000-0000-000000000000    False


So it appears to me that the cab file was loaded but not deployed.  But I'm not sure what I need to do next in order to get this pac

Reporting Services 2008 - footer problem when exporting to Word


I have a footer that I want to show up on the last page only. 

I use the following expression for the text box under text box properties --> visability

=IIF(Globals!TotalPages = Globals!PageNumber,

False, True)

When I run the report in reporting services, it does only print the footer on the last page.  When exported to Word, footer prints on all pages.

My questions: 

1.  Is my expression ignored in Word for the footer, so I will not be able to do this in the footer?

2.  Is there another way to have something print at the bottom of the last page that will be recognized when exported to MS Word (report size will vary based on data returned)? 

Any help is appreciated.

Kind regards.

Reporting Services Chart in SharePoint Web Part, Broken Image Problem

I have a reporting services report that displays a dundas chart, it is a snapshot report executed daily.  When displaying the report inside a page viewer webpart or a report viewer web part in SharePoint, the first time after a recent snapshot occurs, the image shows up broken.  On refresh of the page the image is visible.

MOSS 2007
SQL Server 2005 Reporting Services NOT running in SharePoint Integration mode.

Any ideas or work arounds to get the image to display on the first load of the page or why the image is broken?  I've tried different report parameters, Format, ClearSesson with no luck.  Viewing the report in Report Manager works fine and also going directly to the ReportServer page is fine.  It only occurs when it's inside of SharePoint inside of the Page Viewer or Report Viewer web parts or even if I manually create an iframe in a content editor web part.


Reporting Services Report Parameters Problem


I have the next table, & I have the Id of the account as a report parameter @AccountID

|account |LastYear |Jan |Feb |Mar |Apr |May |jun |Jul |Aug |Sep |Oct |Nov |Dec |YTD  |Plan
| 00001  | 10.00    |  1   |  2  |  3  |   5 |  32  | 12 | 11| 10  |  8   | 87 | 54  | 54  | 123 | 250

I tried to build a Query that return me

Jan       |  1
Feb       |  2
Mar      |  3 ...

I already tried to build  a temporary table, but then Ignore my report parameter saying Must declare the scalar variable "@AccountID".
But If I eliminate the code of create #Table, The parameter works just fine.


Part of my query is :

Declare @IddeCuenta varchar(50)
set @IddeCuenta =

(Periodo varchar(30),
Informe_Ventas money)

INSERT INTO #VentasGraf VALUES ('LstYear',0)

    UPDATE #VentasGraf
    SET        Informe_Ventas =
    (SELECT  ISNULL(sum(new_acumula

Problem with Reporting Services -- Report Hangs sometimes, need to restart server



We are having an application in which we generate several kinds of reports. We have one report- person addresses, through which we generate the report for all the people whom we have to deliver the cards. This is one of our most frequently used reports.

Some time back, we started getting problems of reports hanging on blank white page and nothing comes up. We restarted the server and everything wents fine. After some more days, the problem occurs again and again we restarted the server.

From that time the problem is coming up again and again and everytime we needs to restart server to make it work. But we cant do that every time ..Can anyone please suggest what may be causing it?

Database server: sql 2000

reporting services : Microsoft SQL Server Reporting Services Version 8.00.1062.00

operating system on which report is running: Microsoft Windows NT 5.2.3790.0

Application is build in .Net 2003

Sometimes the problem comes in 2 weeks, and sometimes it comes twice in a week.

Excel Services Application - Trusted locations problem in SharePoint Office Excel Web App


Just deployed Office Web Apps to our SharePoint 2010 environment. This environment was upgraded from a fresh deployment of SharePoint 2007 SP2. Configured all of the Application Services per http://technet.microsoft.com/en-us/library/ff431687.aspx, but I cannot open an Excel workbook, receiving the error: "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator."

Our farm has a single front end server and a single database server. The shared application pool is called SSP1_v14 (renamed during the upgrade from SSP1?). Our existing site had its visual style upgraded during the conversion. An in-place upgrade had been performed.

I went to Central Administration > Excel Services Application > Trusted File Locations and the default entry for address http://, Location Type: Microsoft SharePoint Foundation, Trust Children had already been created. Various blog posts on the internet indicate that this entry is all that's needed to setup a trusted location for all SharePoint sites, but it's not working here. I've tested Word document viewing with the Word Web App and that works fine.

Any ideas?

Problem With CMIS Services in Sharepoint 2010


HI All,

i have installed CMIS Connector for Sharepoint 2010.

im trying to access API calls in CMIS Services from VS 2005 . im getting below error.this error is getting when im calling getrepositories method.

Client found response content type of 'multipart/related; type="application/xop+xml";start="";boundary="uuid:bbdf9092-141b-4882-81f2-c2311566dadc+id=50";start-info="text/xml"', but expected 'text/xml'.


Problem with install Reporting Services 2008



I'm configuring a new installation of SQL Server 2008 Express with Advanced Services, but the Reporting Services doesn't work.

When I open the page http://localhost/ReportServer, show the HTTP 500 Internal Server Error.

At the first time the error was:

Failed to initialize the AppDomain:ReportServer_MSSQLSERVER_0 Exception: System.Web.HttpException Message: The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files'.

I fixed this error givin permissions to Network Service to this directory. (http://technet.microsoft.com/en-us/library/bb418935.aspx)

But now show this message:

Failed to initialize the AppDomain:ReportServer_MSSQLSERVER_0 Exception: System.Configuration.ConfigurationErrorsException Message: Unrecognized element 'folderLevelBuildProviders'. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\web.config line 349) StackTrace: at System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost

Custom SessionState provider & web services problem


My .Net Framework 3.5 web application uses MySql database accessed by .Net Connector 6.3.3. I use it's membership provider too. Recently I replaced InProc SessionState provider to MySql custom provider.

After this web services in application stopped working. Instead of something useful any webservice method returns html page with description of web service generated by IIS/ASP.NET.

I'm not using session state in web methods and they are declared with simple [WebMethod] attribute, so EnableSession has its default value - false. I've tried also the simple Hello World web service to be sure I'm not doing something different in my web services.

This problem occurs only with SOAP. HTTP POST is ok, so invoking web service method  on  IIS generated page works as before.

Because I didn't find anything useful I'd like to ask if there is solution for this custom SessionState / webservice combination problem. I don't know if it is specific for MySql or not.

Windows Sharepoint Services Alert Problem


Hi all,

i had the following problem with alerts on wss, users get the first welcome alert notification but no other emails alerts when anything changed in a wss site, looking here found my solution but its gets more complex

here is my situation

i have move one site from my old wss3 server to an new wss3 server, everthing works fine execpt rules, users gets welcome alert notification but no other emails alerts on changes/add/remove,

on the same wss server i created a NEW site  (from scratch) with the name portalsrv/test THE ALERTS HERE WORKS FINE for all users!!!

doing some tests i discover that on site that i have the problem with alerts (portalsrv\it) if a change the user's wss group membership from MEMBERS of the site to OWNER of the site THE ALERTS WORKS FINE!!!

its problably something with permssions during the migration from the old wss3 to the new wss3 but i dont have idea where to start search

any help on this?????




Problem integrating SharePoint with Reporting Services across different servers using Kerberos

Hi Folks

Apologies for the long post but wanted to include as much detail as possible...

Edit - Sorry just realised I hadnt mentioned we are using SQL Server 2005 SP3

We have a problem with our SharePoint Reporting Services integration, we are using Kerberos authentication and our SharePoint installation and SQL Server databases are on separate servers.  I have listed details of our setup below and also the symptoms we are experiencing....


Setup details


ServerA (SharePoint Server) Windows Server 2003 R2 Enterprise x64 Edition SP2


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend