iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Hello
We have a 64 bit web application running in IIS 7 using the IS Web grid components. The WebGrid is working fine but the export capability of the grid is not working in 64 bit.
It appears the grid is using external components for Export. Are there 64 bit version of dlls for these external components used by the Web grid. The dlls in question are
ActiveReports.dll
ActiveReports.XlSExport.dll
ActiveReports.PdfExport.dll
ActiveReports.HtmlExport.dll
ActiveReports.TextExport.dll
ActiveReports.RtfExport.dll
ActiveReports.TIFFExport.dll
At this point, none of the exports is working in our application. Would you be able to investigate this and get back to us on the possible resolutionf for it.
Thanks
Siva
Hi Siva,
Do you have any other export mechanism other than our export mechanism? We are using ISNet.ActiveReports.Exporting.dll. If you do, could you give me more detail about it?
Maybe you could try the export in our webgrid sample first and see whether it can export or not. It should be working fine in 64 bit.
Regards,
Lili Khiung
We don't have any other exporting mechanism other than the grid. I am attaching a file with the exception. It works fine when the app runs in 32 bit mode with.
The version of ActiveReports for .Net is 3.3.1.2009 from DaaDynamics. We are usinga older version of the IS WebGrid versioned at 7.0.7200.402.
The export we are talking about is the one on the lower toolbar of the grid.
Have you tried to run our sample? If our sample works fine, could you send me a runable simple sample that can replicate your issue?
Maybe you could update to the latest hotfix also to see if the problem still occurs or not.
Do you have a VS 2010 ASP.Net 4.0 Sample? I am unable to find a sample in the samples folder.
Can you email me a asp.net 4.0 sample project zipped to siva dot suthram at landisgyr dot com
I created a sample web project and am getting some error attached in the image. The site is running IIS 7.
You can try to set your pop-up blocker and security setting for download to be enabled. Please inform me whether the problem is still exist or not.
If you want to have our sample, you can download our WebUIStudio installer. It supports VS2010. Or, you can also try our live sample at http://live.intersoftpt.com
I disabled the pop up blocker and opened another IE windows too with no luck. Is there a way to escalate this defect so that you can have some one call me to work this out
I was able to repro this issue using a simple sample app on Windows 2008 R2 box with the app running in a 64 bit app pool. I am attaching the code sample. You may want to change the connect string , the query and the grid columns to test it out.
Let me know if you need more information.
We've been testing your sample, but it worked successfully. Please try to remove the other ActiveReports in your BIN folder because it might crash with our ActiveReports:
ActiveReports.dll, ActiveReports.HtmlExport.dll, ActiveReports.PdfExport.dll, ActiveReports.RtfExport.dll, ActiveReports.TextExport.dll, ActiveReports.TiffExport.dll, ActiveReports.Viewer.dll, ActiveReports.XlsExport.dll
For the deploying problem, you can try to use ASP.NET v4.0 or ASP.NET v4.0 Classic. Please also check your security settings and inform me about the result.
FYI, please don't attach any confidential information such as runtime license.
Hope it helps.
I removed those dlls and am still getting the error. The app pool is already using asp.net4.0 in integrated mode with enable 32 set to false. I will try changing the app pool to classic and let you know.
What security settings are we talking here and where are they
I also tried to run the sample in classic mode. Still the same issue. I looked asp net and CGI restrictions in IIS. They look to be fine with asp.net 4.0 isapi dlls allowed.
Did you try this sample on IIS 7.5 on Windows Server 2008 R2?
If I run the sampe app with enable 32 bit configured in app pool on windows server 2008 R2, it works fine but we still need to solve this problem
We tried your sample in IIS7 and windows server 2008. But to help you solve your problem, one of our technical support member will collaborate with you and he will be in charge to give you further assistance for your issue.
Thanks. Here is more information from the windows event viewer
An unhandled exception occurred and the process was terminated.
Application ID: /LM/W3SVC/1/ROOT/isweb
Process ID: 11840
Exception: System.TypeInitializationException
Message: The type initializer for 'DataDynamics.ActiveReports.ActiveReport3' threw an exception.
StackTrace: at DataDynamics.ActiveReports.ActiveReport3.Finalize()
InnerException: System.DivideByZeroException
Message: Attempted to divide by zero.
StackTrace: at DDCssLib.StyleSheet.-eccc()
at DDCssLib.StyleSheet..ctor(Boolean CreateDefault)
at DataDynamics.ActiveReports.ActiveReport3..cctor()
Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.TypeInitializationException
Stack:
at DataDynamics.ActiveReports.ActiveReport3.Finalize()
Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7afa2
Faulting module name: KERNELBASE.dll, version: 6.1.7601.17514, time stamp: 0x4ce7c78c
Exception code: 0xe0434352
Fault offset: 0x000000000000a49d
Faulting process id: 0x2e40
Faulting application start time: 0x01cbee1a2e675fad
Faulting application path: c:\windows\system32\inetsrv\w3wp.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: 5c11f5d5-5a10-11e0-bef9-001cc469a8f0
We are currently investigating the issue. Our technical support member will contact you for the details.
I work with Siva and I'm wondering if there is any update on this issue that has been out here since March of 2011. We just encountered this again when our application is running in 64-bit mode with Enable 32-bit applications set to false for the app pool our application is running in. The export capabilities work fine when Enable 32-bit applications is set to true, but not when it is set to false.
Thank you,
Tony
Hello Tony,
I am sorry for the late reply. Lili was not longer working at Intersoft anymore. Please allow me to help you. Based on the error it seems there are another Active Report besides Intersoft Active Report. Please remove them because Intersoft exporting might be crashed. Please also check GAC (C:\windows\assembly). Please ensure if there are no other Active reportes except, Intersoft. I attached you my video recording. As you can see it works fine in windows server 2008 R2.
Regards,Handy
Hi Handy,
Thanks for the quick reply. I'm doing some more research on this, and was able to get it to work on my Windows 7 64-bit system with my app running in 64-bit mode, but my system is not a deployed system. I am a developer and have the WebGrid developer tools installed locally with the WebGrid dlls in the GAC. Our deployed systems, of course, do not have the developer tools and do not have the dlls in the GAC. They are just in the bin directory of our application.
Is there a requirement that the dlls be in the GAC for a deployed 64-bit system? Was the sample you showed in the video on your development machine, or a deployed system? So far, that is the difference I see on my end. I'm hoping to get my hands on a deployed test system and try a few things like putting the dlls in the GAC to see if that fixes it.
Thanks,
In my last video, it was development. I tried now in deployment and works fine. Since, it is in deployment, you would need to remove all Intersoft assemblies that referred to GAC in your web.config. Then, add those assemblies to your project bin folder.
I have reproduced this error by creating a test project and deploying it to Windows Server 2008 R2 in an IIS 7 App Pool that has the Allow 32-bit applications property set to false. It seems that the only time the export works successfully in a 64-bit environment is when it is running on my local machine where I have the developer tools installed. I have included the solution in the attached file. We are going to download the latest evaluation version of the WebGrid to see if it is maybe just an issue with our licensed version 7.
I'm just following up on my January 20, 2012 response to see if my sample has been tested. Since I sent it, I have dowloaded updates for the WebGrid 7 and it still will not export when deployed in a 64-bit only app pool. It will export on my local machine when running in a 64-bit only app pool, but I don't consider that valid since that is where I have the developer tools.
Is there some IIS 7 setting or other configuration setting that could cause the grid to allow exporting in an app pool that is set to allow 32-bit applications, but not one that is set for only 64-bit?
I am sorry for the late response. I was not at office at previous week. As I said before, it worked fine. Your latest sample project also works fine in here (deployment and development). I enclose the screenshots about my IIS settings. Perhaps, we have different settings in our AppPool?
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname