ASP.NET Discussion Boards

Automatic update db on regular intervals mvc

Member 1402506315-Nov-18 18:10

15-Nov-18 18:10

I have InProc Session mode set to 20 min(web.config),
If the user is inactive after 20 min user gets logged off and that's fine but
i also want to check after 10min of user inactivity sql table value has to be updated.How to handle this?

Re: Automatic update db on regular intervals mvc

Member 1405668819-Nov-18 18:18

Member 14056688

19-Nov-18 18:18

Could take a look at web backgrounder https://github.com/NuGet/WebBackgrounder

Very basic and simple task runner. Check the related NuGet packages. For anything complex use quartz.net.

Re: Automatic update db on regular intervals mvc

Member 1402506319-Nov-18 18:37

Member 14025063

19-Nov-18 18:37

At the moment i'm using javascript timer but script(setInterval) is not applying on navigating among pages.
Can't I apply script all over app and run timer in background?

Re: Automatic update db on regular intervals mvc

Nathan Minier20-Nov-18 1:37

Nathan Minier

20-Nov-18 1:37

If you're using IIS, you don't. IIS will arbitrarily kill your process when it's not actively receiving requests, which will kill your timer.

"Never attribute to malice that which can be explained by stupidity."
- Hanlon's Razor

I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper15-Nov-18 6:30

simpledeveloper

15-Nov-18 6:30

Hi,

I am getting the following Exception, when I am trying to run my report on the Server, locally it is working fine, need some help please any help would be very helpful, thanks in advance my friends.

Error Message: Value cannot be null.
Parameter name: reportViewer
Error Source: ReportViewerForMvc
Error InnerException Message: 
Error TargetSite: System.Web.HtmlString GetIframe(Microsoft.Reporting.WebForms.ReportViewer, System.Object)
Error StackTrace:    at ReportViewerForMvc.ReportViewerForMvc.GetIframe(ReportViewer reportViewer, Object htmlAttributes)
   at ASP._Page_Views_Report_ShowLegalEntityReport_cshtml.Execute() in c:\PIMS\Views\Report\ShowLegalEntityReport.cshtml:line 7
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
   at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
   at System.Web.WebPages.StartPage.ExecutePageHierarchy()
   at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
   at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.<BeginInvokeAction>b__5(IAsyncResult asyncResult)
Error Controller: Report
Error Action: ShowLegalEntityReport

My code to generate report is as below:

 ReportViewer reportViewer = new ReportViewer();
                reportViewer.ProcessingMode = ProcessingMode.Local;
                reportViewer.SizeToReportContent = true;
                reportViewer.Width = Unit.Percentage(900);
                reportViewer.Height = Unit.Percentage(900);

                DataRetrieveServiceClient drsc = new DataRetrieveServiceClient();

                DataTable dt = CommonFunctions.ToDataTable(drsc.GetLegalEntityReport(legalEntityNumber, lENumOperator, legalEntityName, lENameOperator, taxId, taxIdOperator
                    , submittingCounty, submCountyOperator, legalEntityCity, lECityOperator));

                //reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\LegalEntityReport.rdlc";
                //reportViewer.LocalReport.ReportPath = "~/" + Request.ApplicationPath + @"/Reports/LegalEntityReport.rdlc";
                reportViewer.LocalReport.ReportPath = Request.MapPath("~/Reports/LegalEntityReport.rdlc");
                reportViewer.LocalReport.DataSources.Add(new ReportDataSource("LegalEntityDataSet", dt));
                reportViewer.LocalReport.Refresh();

                ViewBag.ReportViewer = reportViewer;
return View();

Please let me know if I am doing any mistake, please help thanks my friends.

modified 15-Nov-18 13:36pm.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

Richard Deeming15-Nov-18 8:05

Richard Deeming

15-Nov-18 8:05

The problem seems to be in your view:
c:\PIMS\Views\Report\ShowLegalEntityReport.cshtml, line 7

Can you post that line of your view, and perhaps a few lines from either side?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper15-Nov-18 8:52

simpledeveloper

15-Nov-18 8:52

Here is my code in the View, this is all I have, don't I have reference to ReportViewer added or some middle line in between the Controller Code is failing like Service Call etc which is making the ViewBag null, just not understanding, any help would be greatly helpful thanks my friend.

I just tested Report Path is also correct, I just put log and tested it, but the problem is, ReportPath is coming like this the Physical Path (C:\PIMS\Reports\LegalEntityReport.rdlc), this Physical Path is correct, I put the Virtual Path (full Path to report hard coded) also, in both cases it failed.

And another one I tested just now is that DataSet and DataTable both are not null values they have rows, so its not because I am passing null values, so it must be something related to setting in config etc.

I am not sure what's the reason for its failure, any config setting or etc, I don't know what it is, any help please

@using ReportViewerForMvc; 
@{
    ViewBag.Title = "Show Legal Entity Report";
    Layout = "~/Views/Shared/_LayoutFinal.cshtml";
}

@Html.ReportViewer(ViewBag.ReportViewer as Microsoft.Reporting.WebForms.ReportViewer)

modified 15-Nov-18 17:19pm.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

Richard Deeming16-Nov-18 1:08

Richard Deeming

16-Nov-18 1:08

Using Value as Type will return null if the value cannot be converted to the type.

Try using a cast instead, just in case the value is of the wrong type:

@Html.ReportViewer((Microsoft.Reporting.WebForms.ReportViewer)ViewBag.ReportViewer)

If you still get a NullReferenceException, then you'll need to debug your code to make sure you're actually setting the ViewBag value.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper16-Nov-18 7:17

simpledeveloper

16-Nov-18 7:17

Sorry Richard, it didn't fix the problem yet, is it because of any security hitch because we are using SSL on the Server or am I missing any other dll etc, I have all the dlls added and deployed on the Server, is it because using ReportViewerForMVC itself is a problem? I have not seen much support about that tool also and I don't know using it with SSL is bad combination, or SSL itself is a problem.

I have put the ignore Certificates code as well in Global.asax file, still not working, or just the Physical Path itself is a problem, but the report Viewers that are used by the iFrame are working fine in other applications - those applications are also using the MapPath code means Physical Path, they are on the same Server too, I thought this also works and internally this tool also uses a .aspx page just like their approach but in iFrame approach the code to generate report is written in the .aspx pages Code behind but in the ReportViewerForMVC the report generation code is written in the Controller, but not understanding Richard, not logging any information also.

MapPath is returning Physical Path, is it because of that, is it because Local not Remote, just don't know Richard, very sad in ending up in this way. If anybody can help me who gone through the same situations please help me, I really really thankful to you.

Quote:
If you still get a NullReferenceException, then you'll need to debug your code to make sure you're actually setting the ViewBag value.

How can I do it on the Server Richard, I am seeing the DataSet and DataTable are not null, I am not getting any information why is it failing, any help would be great for me Richard.

modified 16-Nov-18 13:49pm.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

Richard Deeming16-Nov-18 7:37

Richard Deeming

16-Nov-18 7:37

You're getting a NullReferenceException for the reportViewew parameter.

Either ViewBag.ReportViewer is null, or it is not an instance of the Microsoft.Reporting.WebForms.ReportViewer class.

If you can't work out how to debug it, then temporarily change your view to output the type of the value:

cshtml

@using ReportViewerForMvc; 
@{
    ViewBag.Title = "Show Legal Entity Report";
    Layout = "~/Views/Shared/_LayoutFinal.cshtml";
}

@* Comment out this line: *@
@* @Html.ReportViewer(ViewBag.ReportViewer as Microsoft.Reporting.WebForms.ReportViewer) *@

@if (ViewBag.ReportViewer == null)
{
    <p>ReportViewer is not set!</p>
}
else if ((ViewBag.ReportViewer as Microsoft.Reporting.WebForms.ReportViewer) is null)
{
    <p>ReportViewer is the wrong type: @ViewBag.ReportViewer.GetType()</p>
}
else
{
    <p>Everything looks OK...</p>
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper16-Nov-18 7:50

simpledeveloper

16-Nov-18 7:50

Thanks a lot Richard.

I just saw it, ViewBag is not null hence it is displaying the text "Everything looks OK..." but, now its going to the home page of the application, is it because of the Path Problem or Security Problem not understanding. Just asking, can we put try catch in cshtml to catch an Exception if its raised and log it on a file or db or even at least JavaScript console is also fine or can I hard-code and assign a reports Virtual Path directly to the ReportViewer tool directly, then deploy and see if it is just the Path not being able to access. It seems like one of these two might be the problem clearly, any help my friend, please?

modified 16-Nov-18 14:10pm.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

Richard Deeming16-Nov-18 8:11

Richard Deeming

16-Nov-18 8:11

If you're getting "Everything looks OK", then you must be hitting an unknown bug in the ReportViewerForMvc library[^].

Make sure you're using the latest version. Triple-check that you've spelled the ViewBag.ReportViewer correctly in your view. If it still doesn't work, you'll have to raise an issue on GitHub[^].

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper16-Nov-18 9:02

simpledeveloper

16-Nov-18 9:02

hi Richard, yes you are very true, I changed the approach, I have used the iFrame approach I am getting the following error

An error occurred during local report processing.
 The definition of the report 'C:\PIMS\Reports\LegalEntityReport.rdlc' is invalid.
 An unexpected error occurred in Report Processing.
 Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

but the report is in the same path, is it something related to Path or any other library issue, can you please let me know, thanks a lot my friend.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

Richard Deeming16-Nov-18 9:11

Richard Deeming

16-Nov-18 9:11

You're missing the SQL Server spatial types assembly from your server.

You can download the installers from Microsoft and install them on the server:
Download Microsoft® SQL Server® 2012 Feature Pack from Official Microsoft Download Center[^]
(Links under Instructions ⇒ Microsoft® System CLR Types for Microsoft® SQL Server® 2012)

32-bit version[^];
64-bit version[^];

Or you can install v11 of the NuGet package[^], which will copy the files to your application so that you can copy them up to the server.

Install-Package Microsoft.SqlServer.Types -Version 11.0.0

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper16-Nov-18 9:30

simpledeveloper

16-Nov-18 9:30

hurrayyyyyy !.... yes this fixed the problem, but still I don't understand why it didn't work with ReportViewerForMVC approach - just took lot of effort and stress my friend.

And thanks a lot for being with me, its great and absolutely great, you are awesome person - thanks a lot again.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper16-Nov-18 11:46

simpledeveloper

16-Nov-18 11:46

hi Richard mate - one more thing I have identified, that ReportViewerForMVC is also working fine now, so was it the Microsoft.SqlServer.Types that was missing, if it is then why didn't the ReportViewerForMVC inform me in Exception or etc? Where as the iFrame approach has informed me so that I could able to fix the issue. It would have been easier if I would have known this dll that was missing, it left very bad impression around colleagues that it is simple and I am not able to fix the issue.

Thanks for helping me all the way along this issue mate. Hope you don't mind me calling you - mate Smile | :)

modified 16-Nov-18 17:59pm.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

Richard Deeming19-Nov-18 2:01

Richard Deeming

19-Nov-18 2:01

simpledeveloper wrote:
why didn't the ReportViewerForMVC inform me in Exception or etc?

Probably worth raising this as an issue on the GitHub project, so the developers can address it in a future release. Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper19-Nov-18 6:29

simpledeveloper

19-Nov-18 6:29

Can you please let me know website or some email where I can raise this issue my friend, yeah it is important it seems - thank you so much again.

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

Richard Deeming19-Nov-18 7:50

Richard Deeming

19-Nov-18 7:50

Issues · armanio123/ReportViewerForMvc · GitHub[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: I am using ReportViewerForMVC tool for my rdlc reports, I am getting the following exception on server but not locally, am I missing reference or something

simpledeveloper20-Nov-18 10:18

simpledeveloper

20-Nov-18 10:18

Yes I did, thanks my friend, happy thanks giving

What technique can be used for printing ALL PAGES from crystal report?

Member 1405550514-Nov-18 23:09

Member 14055505

14-Nov-18 23:09

I am a beginner in vb.net and asp.net.

I have been researching and experimenting a few methods for this one week, none worked, most of the methods will only print one page (current page) in the crystal report.

Meanwhile, the default print button in the crystal report viewer has only the export option, in the pop menu that comes out when the button is clicked. 

I want to have an external button in which when its clicked it opens the print preview page, displaying all pages of the report from the crystal report viewer, where the user can select the printer, adjust whatever settings, and choose the pages to be print.

IS THIS EVEN POSSIBLE? what would be the best method? please give me some example code. Thanks in advance

modified 21-Nov-18 2:59am.

Re: What technique can be used for printing ALL PAGES from crystal report?

Member 1405668818-Nov-18 17:27

Member 14056688

18-Nov-18 17:27

Hi,

Check this example. Now please take its reference and correct your code.

Using the below article I have created the example.

Generate Crystal Reports using Strongly Typed DataSet in ASP.Net using C# and VB.Net

https://www.aspforums.net/Threads/129462/Print-all-pages-from-Crystal-Report-on-Button-click-using-C-and-VBNet-in-ASPNet/

Please refer this thread to get solutions.

Thank you.

WCF Service is giving faulted Exception

simpledeveloper13-Nov-18 7:10

simpledeveloper

13-Nov-18 7:10

Hi friends,

My WCF Service that's deployed is giving me the faulted Exception as below:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Loggedin User: DHSINTRA\AAleemMo
Error Message: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
Error Source: mscorlib
Error InnerException Message: 
Error TargetSite: Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
Error StackTrace: 
Server stack trace: 
   at System.ServiceModel.Channels.CommunicationObject.Close(TimeSpan timeout)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at System.ServiceModel.ICommunicationObject.Close(TimeSpan timeout)
   at System.ServiceModel.ClientBase`1.System.ServiceModel.ICommunicationObject.Close(TimeSpan timeout)
   at DHCS.BH.Provider.WebApp.Common.WebAppLogger.LogError(String applicationName, String version, Exception exception, Nullable`1 dateTS, String appUsername, String nameSpace, String class, String method, Int32 enumPriority)
   at DHCS.BH.Provider.WebApp.Filters.BHPRVAuthorizeAttribute.LoadUserAuthorizationDetails(AuthorizationContext filterContext, String userName)
   at DHCS.BH.Provider.WebApp.Filters.BHPRVAuthorizeAttribute.OnAuthorization(AuthorizationContext filterContext)
   at System.Web.Mvc.ControllerActionInvoker.InvokeAuthorizationFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.<BeginInvokeAction>b__0(AsyncCallback asyncCallback, Object asyncState)
Error Controller: LegalEntity
Error Action: ListLegalEntities

I read online, they are suggesting to implement the WCF Extension class, but I am not in a stage to change the whole process or architecture again, is there any other solution that can help me please or is it really failing because of the timeout, any help a code snippet, a link or even a suggestion helps me a lot - thanks in advance my friends.

Re: WCF Service is giving faulted Exception

Ali Al Omairi(Abu AlHassan)14-Nov-18 6:05

Ali Al Omairi(Abu AlHassan)

14-Nov-18 6:05

this exception means that you have some thing wrong n the server side and you cant use this channel any more see this page

Help people,so poeple can help you.

Re: WCF Service is giving faulted Exception

simpledeveloper14-Nov-18 8:56

simpledeveloper

14-Nov-18 8:56

Is there anyway how can I find what is the Problem that I am having on Server Side, because the exception doesn't give me any specific reason to fix the problem. Please any help would be great-full my friend - thanks in advance.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.