Showing posts with label uploaded. Show all posts
Showing posts with label uploaded. Show all posts

Saturday, February 25, 2012

ASPNETDB.MDF: The process cannot access the file because it is being used by another proce

Hi,

I'm trying to upload the ASPNETDB.MDF file to a hosting server via FTP, and everytime when it was uploaded half way(40% or 50%)

I would get an error message saying:

"550 ASPNETDB.MDF: The process cannot access the file because it is being used by another process"

and then the upload failed.

I'm using SQL Express. Does anybody know what's the cause?

Thanks a lot

It is because there are some users who are accessing the database through your web application. When the database is in process you cannot replace it. If you want to upload you need to make sure that no one is accessing your application. ASP.NET provides an easy way to disconnect all the clients to your web application with app_offline.htm file

Just create a simple html file with name app_offline. First upload this file to the web root of your application. Once this file was placed into the root directory, all clients will be disconnected and you can make some quick changes like replacing files etc, and after you finish replacing the files, delete the app_offline.htm file from the root.

You can also display a friend message in the app_offline like "Site under maintenance"

app_offline.htm file:

<html>
<body>
Site under maintenance!
</body>
</html>

Thanks

Posted by Chasidy at 8:45 PM 0 comments
Labels: , , , , , , , , , , , , , , , , , ,

Monday, February 13, 2012

Asp.net session has expired

Hi

I have designed reports using SQL Server Business Intelligence Development Studio tool (Sql Server reporting service). I have uploaded these reports to report manager.

I am displaying list of reports in tree view control, in my application. I am viewing report in Report Viewer control as per the report selection in tree view control, in same page. I am getting

Server Error in '/Application_name' Application or

  • ASP.NET session has expired error frequently while switching between various reports. Kindly provide me solution

  • .

  • Regards

    Sagayaraj Rayappan

    Are you reseting the Report Path each time they click on an item or are you saving the ExecutionID off? You will need to set the report path each time and not try and use the existed execution ID unless you can keep the session alive yourself.|||

    Thanks for the information. I am resetting Report Path each time when we clicked on an item. How to keep the session alive myself?. What is ExecutionID and how to use it?. Kindly give more details on this.

    |||

    You do not want to use the ExecutionID, I just wanted to rule that out first.

    Is the error occuring from within the report viewer or the entire page?

    |||This error occurs for entire page.|||Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.|||

    Hi i am also getting the same error.In my web page i refer the reportviewer and showing different reports.While navigate to different reports randomly i am getting this error.

    Can anyone suggest how to solve this?

    Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

    [AspNetSessionExpiredException: ASP.NET session has expired]
    Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +683
    Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +553
    Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10
    System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

    Thanks in advance,Tom

    |||

    Daniel Reib wrote:

    Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.

    Hi I'm getting this error from with the ReportViewer control... I've tried to change the session timeout with the following code but it still times out earlier then the timeout value stated...? Is there some other attribute that needs to be changed also?

    rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"

    Many thanks in advance,

    Rob.

    |||

    Did you get a solution to this? The setting you have changed is on the reportserver, your problem is on the app that contains the reportviewer. Look at my post here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=371287&SiteID=1&PageID=2

    |||

    Hi Mark,

    My issue was slightly different. Because of the nature of our reporting system, users may leave a report open for a long period of time (maybe hours) and then come back to it and attempt to run a drillthrouhgh report from where they left off.

    My solution to this was to increase the session timeout in the application pool which has worked well. I'm lucky I guess that the user base for the system is very small, i.e. no more than twenty users, so we should run into any resource issues (finger crossed).

    Regards,

    Rob.

    • Posted by Chasidy at 11:38 PM 0 comments
    Labels: , , , , , , , , , , , , , , , , , ,

    Asp.net session has expired

    Hi

    I have designed reports using SQL Server Business Intelligence Development Studio tool (Sql Server reporting service). I have uploaded these reports to report manager.

    I am displaying list of reports in tree view control, in my application. I am viewing report in Report Viewer control as per the report selection in tree view control, in same page. I am getting

    Server Error in '/Application_name' Application or

  • ASP.NET session has expired error frequently while switching between various reports. Kindly provide me solution

  • .

  • Regards

    Sagayaraj Rayappan

    Are you reseting the Report Path each time they click on an item or are you saving the ExecutionID off? You will need to set the report path each time and not try and use the existed execution ID unless you can keep the session alive yourself.|||

    Thanks for the information. I am resetting Report Path each time when we clicked on an item. How to keep the session alive myself?. What is ExecutionID and how to use it?. Kindly give more details on this.

    |||

    You do not want to use the ExecutionID, I just wanted to rule that out first.

    Is the error occuring from within the report viewer or the entire page?

    |||This error occurs for entire page.|||Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.|||

    Hi i am also getting the same error.In my web page i refer the reportviewer and showing different reports.While navigate to different reports randomly i am getting this error.

    Can anyone suggest how to solve this?

    Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

    [AspNetSessionExpiredException: ASP.NET session has expired]
    Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +683
    Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +553
    Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10
    System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

    Thanks in advance,Tom

    |||

    Daniel Reib wrote:

    Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.

    Hi I'm getting this error from with the ReportViewer control... I've tried to change the session timeout with the following code but it still times out earlier then the timeout value stated...? Is there some other attribute that needs to be changed also?

    rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"

    Many thanks in advance,

    Rob.

    |||

    Did you get a solution to this? The setting you have changed is on the reportserver, your problem is on the app that contains the reportviewer. Look at my post here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=371287&SiteID=1&PageID=2

    |||

    Hi Mark,

    My issue was slightly different. Because of the nature of our reporting system, users may leave a report open for a long period of time (maybe hours) and then come back to it and attempt to run a drillthrouhgh report from where they left off.

    My solution to this was to increase the session timeout in the application pool which has worked well. I'm lucky I guess that the user base for the system is very small, i.e. no more than twenty users, so we should run into any resource issues (finger crossed).

    Regards,

    Rob.

    • Posted by Chasidy at 11:38 PM 0 comments
    Labels: , , , , , , , , , , , , , , , , , ,

    Asp.net session has expired

    Hi

    I have designed reports using SQL Server Business Intelligence Development Studio tool (Sql Server reporting service). I have uploaded these reports to report manager.

    I am displaying list of reports in tree view control, in my application. I am viewing report in Report Viewer control as per the report selection in tree view control, in same page. I am getting

    Server Error in '/Application_name' Application or

  • ASP.NET session has expired error frequently while switching between various reports. Kindly provide me solution

  • .

  • Regards

    Sagayaraj Rayappan

    Are you reseting the Report Path each time they click on an item or are you saving the ExecutionID off? You will need to set the report path each time and not try and use the existed execution ID unless you can keep the session alive yourself.|||

    Thanks for the information. I am resetting Report Path each time when we clicked on an item. How to keep the session alive myself?. What is ExecutionID and how to use it?. Kindly give more details on this.

    |||

    You do not want to use the ExecutionID, I just wanted to rule that out first.

    Is the error occuring from within the report viewer or the entire page?

    |||This error occurs for entire page.|||Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.|||

    Hi i am also getting the same error.In my web page i refer the reportviewer and showing different reports.While navigate to different reports randomly i am getting this error.

    Can anyone suggest how to solve this?

    Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

    [AspNetSessionExpiredException: ASP.NET session has expired]
    Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +683
    Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +553
    Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10
    System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

    Thanks in advance,Tom

    |||

    Daniel Reib wrote:

    Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.

    Hi I'm getting this error from with the ReportViewer control... I've tried to change the session timeout with the following code but it still times out earlier then the timeout value stated...? Is there some other attribute that needs to be changed also?

    rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"

    Many thanks in advance,

    Rob.

    |||

    Did you get a solution to this? The setting you have changed is on the reportserver, your problem is on the app that contains the reportviewer. Look at my post here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=371287&SiteID=1&PageID=2

    |||

    Hi Mark,

    My issue was slightly different. Because of the nature of our reporting system, users may leave a report open for a long period of time (maybe hours) and then come back to it and attempt to run a drillthrouhgh report from where they left off.

    My solution to this was to increase the session timeout in the application pool which has worked well. I'm lucky I guess that the user base for the system is very small, i.e. no more than twenty users, so we should run into any resource issues (finger crossed).

    Regards,

    Rob.

    • Posted by Chasidy at 11:38 PM 0 comments
    Labels: , , , , , , , , , , , , , , , , , ,

    Thursday, February 9, 2012

    ASP.NET 2.0 database with login

    Hi,

    I very new with ASP.Net 2.0 and I am CONFUSED. I have a website that includes a login that works fine locally, but when I uploaded it to my web host (GoDaddy) the login fails. I get the error

    Server Error in '/' Application.

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    (I checked to make sure that remote connections ARE allowed. I'm using SQL Server 2005.)

    The site was done using VS 2005. The ASPNETDB.MDF database was created the the App_Data folder for the login info. I thought that because this was created automatically that I didn't need to create another database on the server. I haven't found any beginner tutorials that go into enough detail about this. Can someone PLEASE point me in the right direction. Some of the FAQ's on the GoDaddy site give information about importing data into a SQL Server Database, saying to use the CSV wizard. Can an .mdf file be converted to a .csv file, and if so, how is it done? I did create a database in my GoDaddy account today, but I'm not sure how to import the data or even if I need to. Do I need to change the name of the ASPNETDB.MDF database to the same as the one on the server?

    hi,

    You should appropriate an applicationName to each provider :

    <membership defaultProvider="CustomizedMembershipProvider">

    <providers>

    <add name="CustomizedMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="conStr"applicationName="YourApplicationName"/>

    </providers>

    </membership>

    |||

    Hi,

    I have done this. It still doesn't work.

    |||

    Hi,

    From your description, you are using ASPNETDB in your project, right?

    Before deploying your project onto the live server, could you please make sure if your host support Microsoft SQLExpress?

    If not, you should convert your ASPNETDB database to Microsoft SQLServer. You can use aspnet_regsql.exe tool to achieve that. And then, then you can upload the database to your server by using DTS(For SQL2000) or SSIS (For SQL2005).


    For more information on this tool, see:
    http://msdn2.microsoft.com/en-us/library/ms229862(VS.80).aspx


    Thanks.

    Posted by Chasidy at 11:49 PM 0 comments
    Labels: , , , , , , , , , , , , , ,
    Subscribe to: Posts (Atom)