Aspose Cells 64Bit Problems

nascom · October 14, 2009, 4:52am

Hi, does Aspose Cells Reporting Services Server support 64Bit?
Because were getting the Error “Connection failed! Please check url, username and password.” If we try to connect to the Reporting Server from Excel…We also tried re-registering the Aspose.Cells.ReportingServices.dll (located: C:\Program Files (x86)\Aspose.Cells.ReportingServices\Bin\SSRS2008) with Regasm.exe but then we get following Error: RegAsm : error RA0000 : Could not load file or assembly ‘Microsoft.ReportingServ
ices.ProcessingCore, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8
080cc91’ or one of its dependencies. The system cannot find the file specified.

We tried it with Excel 2003, 2007 and even 2010.

Heres the LogFile from a Client (Windows XP SP3 32Bit Excel 2003) after trying to connect through Excel with logger level set to Debug.

ASPOSE Alert @@ : Mittwoch, 14. Oktober 2009 11:46:25 : The underlying connection was closed: An unexpected error occurred on a receive.
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Aspose.Cells.ReportingServices.Services.ReportingService.ReportingService2005.ListChildren(String Item, Boolean Recursive)
at Aspose.Cells.ReportingServices.Services.MSReportingServiceHelper.ListChildren(String parentFolder)
at Aspose.Cells.ReportingServices.Services.MSReportingServiceHelper.x402164c6d8743e45(String xdb3ddbb9cbc638e5, CatalogItemImage x77e8d77b650d1b2f, ListMode xa4aa8b4150b11435)
at Aspose.Cells.ReportingServices.Services.MSReportingServiceHelper.x9809c6a1ffeedc95(TreeNode x8b2c3c076d5a7daf, CatalogItemImage x77e8d77b650d1b2f, ListMode xa4aa8b4150b11435)
at Aspose.Cells.ReportingServices.Services.MSReportingServiceHelper.ListChildrenNode(String parnetFolder, Boolean recursive, CatalogItemImage images, ListMode mode)
at Aspose.Cells.ReportingServices.Services.MSReportingServiceHelper.ListAllNodes(CatalogItemImage images, ListMode mode)
at Aspose.Cells.ReportingServices.AddIn.ReportItemTreeRefreshRunner.Run()

What does “The underlying connection was closed: An unexpected error occurred on a receive.” mean?

Thanks in Advance!

nausherwan.aslam · October 14, 2009, 6:42am

Hi,

Thank you for sharing the details about your issue.

Aspose.Cells for Reporting Services does support 64 bit machines. We will look into your provided log information and get back to you soon.

Thank You & Best Regards,

nausherwan.aslam · October 15, 2009, 1:37am

Hi,

Thank you for considering Aspose.

We have checked your log information. Please check following information.

Web services authentication and access control (See the attached file for reference).
Firewall setting.

Thank You & Best Regards,

nascom · October 15, 2009, 9:33am

Hi,

we don’t have installed IIS on this Server as SQL Reporting Server 2008 doesn’t need IIS to work.
Is IIS required for Aspose.Cells to run?
Firewalls are turned off as we are on a Domain Network.

Regards,
nascom GmbH

nausherwan.aslam · October 16, 2009, 1:09am

Hi,

Thank you for considering Aspose.

Please turn off firewall and set authenticated access for SSRS 2008 to integrated windows authentication.

Please perform the following test.

Open IE.
Input http://servername/reportserver.
Check if you can browse normally? If yes , Aspose.Cells for reporting services client is connected properly . if no ,please continue to modify authenticated access until connection succeeds.

Our test server environment: Windows XP, SQL Server 2008 Express with Advanced Configure information: use built-in account , integrated windows authentication and turn off firewall.

Thank You & Best Regards,

nascom · October 16, 2009, 5:51am

Hi,

We’ve now tested it again with Report Server Service Account set to “Use built-in account: Network Service”. Firewalls are turned off. With IE we can connect to the Report Server and generate Reports. Only the Remote Report Function in Excel can’t connect. We’ve tried connecting with Firefox which asks for UserName and Password. After entering the same user/pass as it is entered in the Remote Report Window in Excel its working with Firefox. We also checked if there is traffic from the Client to the Server with a Network Monitor. We see that the client gets following Page: http://servername/reportserver/reportservice2005.asmx. But we still get the “Connection failed! Please check url, username and passwod.” Error.

Would you guys like to have the Capture from the Microsoft Network Monitor 3.3?

Regards,
nascom GmbH

nascom · October 16, 2009, 6:23am

Hi again,

We now went a bit deeper using Fiddler v.2.2.4.6 on the Client and discovered some interesting Issues with your Authentication.
If we use the Excel Remote Report Function we get a 401 Result (Unauthorized) three times.
If we then connect to the Report Server Page with IE and rerun the Excel Remote Report Function we get a Result 200 (OK). The Response from the Server is also included but your Remote Report Server Function doesn’t recognize it as a successfull connection attempt. We still get the “Connection failed! Please check url, username and password.” Error.
It looks like that your Authentication Function has some Problems…
We would appreciate it if you guys could fix these Problem and tell us a Workaround for the meantime…

As you see we do everything to make it easier for you guys so please help us get this running as we want to use Aspose.Cells in a Project for one of our Customers.

Here is the Response (200) from the Server to the Client after connecting to the Page with IE and retrying it with the Excel Remote Report Function:

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=“XML Schema”>soap:Header2007.100.1600.22DeveloperMicrosoft SQL Server Reporting Services Version 10.0.2531.02009-10-16T13:05:51</soap:Header>soap:Body209e8206-5888-44ed-bec3-75b588ed540fData Sources/Data SourcesFolder2009-10-16T12:39:40.872009-10-16T12:39:40.87NASCOM_DE\userNASCOM_DE\user5de48dcb-e838-46cc-a6e7-9f6cc5638c2cReport Project1/Report Project1Folder2009-10-16T12:39:38.482009-10-16T12:39:42.96NASCOM_DE\userNASCOM_DE\user</soap:Body></soap:Envelope>

Regards,
nascom GmbH

nausherwan.aslam · October 16, 2009, 7:01am

Hi,

Thank you for the feedback and sharing further details.

We will look into your issue and get back to you soon.

Thank You & Best Regards,

nausherwan.aslam · October 19, 2009, 2:03am

Hi,

Thank you for your help and support.

Please provide us your complete system environment details. we will create new virtual environment in order to test and solve your issue.

Aspose.Cells for Reporting Services Client sets NetworkCredential in order to connect to the report server.

NetworkCredential.UserName is the username of report server url setup information.

NetworkCredential.Password is the password of report server url setup information.

NetworkCredential.Domain is the server name of report server url setup information.

We think that domain may cause Aspose.Cells for Reporting Services client connection failure. We will check this issue in detail and fix the issue. Your Issue has been registered in our Issue Tracking System with issue id CELSSREP-11085.

Thank You & Best Regards,

nascom · October 19, 2009, 6:42am

NetworkCredential.Domain is the server name of report server URL setup information. <-- This seems to be the Problem.
You can’t specify the Domain Name. The Computer and Domainname are always different. The User we want to use is a Domain User because in a Domain you don’t use Local User Accounts.
Can you guys add a Domain Box?

Regards,
nascom GmbH

nausherwan.aslam · October 19, 2009, 9:21am

Hi,

Thank you for the feedback.

We will look into this issue and get back to you soon.

Thank You & Best Regards,

nascom · October 19, 2009, 9:56am

Hi,

we tried it now with a Local User Account. Now it seems that the Authentication works but the Excel Remote Export Function shows us the same “Connection failed! Please check url, username and password.”-Error.
We guess Aspose Cells for Reporting Services (Server) did not install correctly.
Could you guys please check the Response below and verify that your Code expects something like that.

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=“XML Schema”>soap:Header2007.100.1600.22DeveloperMicrosoft SQL Server Reporting Services Version 10.0.2531.02009-10-19T16:53:44</soap:Header>soap:Body209e8206-5888-44ed-bec3-75b588ed540fData Sources/Data SourcesFolder2009-10-16T12:39:40.872009-10-16T12:39:40.87NASCOM_DE\userNASCOM_DE\user5de48dcb-e838-46cc-a6e7-9f6cc5638c2cReport Project1/Report Project1Folder2009-10-16T12:39:38.482009-10-16T12:39:42.96NASCOM_DE\userNASCOM_DE\user</soap:Body></soap:Envelope>

Regards,
nascom GmbH

nausherwan.aslam · October 20, 2009, 2:59am

Hi,

Thank you for considering Aspose.

Please try the latest version by downloading from the following location.

https://forum.aspose.com/t/70436

We have added the function of setting domain . If you still face any issue, please check install.log and post it here. install log file is located in your ${installation folder}.

Thank You & Best Regards,

nascom · October 20, 2009, 3:31am

Hi,

we’ve downloaded and installed the new Version on the Server and the Client.
Authentication seems to work now (at least in looks like in Fiddler) but still the same Error.

Install.Log from Client:

Dienstag, 20. Oktober 2009 10:19:34 :: Unloading add-in of office 8.0
Dienstag, 20. Oktober 2009 10:19:34 :: UnloadAddinManager :Software\Microsoft\Office\8.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:19:34 :: Unloading add-in of office 9.0
Dienstag, 20. Oktober 2009 10:19:34 :: UnloadAddinManager :Software\Microsoft\Office\9.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:19:34 :: Unloading add-in of office 10.0
Dienstag, 20. Oktober 2009 10:19:34 :: UnloadAddinManager :Software\Microsoft\Office\10.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:19:34 :: Unloading add-in of office 11.0
Dienstag, 20. Oktober 2009 10:19:34 :: UnloadAddinManager :Software\Microsoft\Office\11.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:19:34 :: valuename
Dienstag, 20. Oktober 2009 10:19:34 :: OPEN
Dienstag, 20. Oktober 2009 10:19:34 :: Software\Microsoft\Office\11.0\Excel\OptionsOPEN
Dienstag, 20. Oktober 2009 10:19:34 :: OPEN1
Dienstag, 20. Oktober 2009 10:19:34 :: Software\Microsoft\Office\11.0\Excel\OptionsOPEN1
Dienstag, 20. Oktober 2009 10:19:34 :: Unloading add-in of office 12.0
Dienstag, 20. Oktober 2009 10:19:34 :: UnloadAddinManager :Software\Microsoft\Office\12.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:19:34 :: valuename
Dienstag, 20. Oktober 2009 10:19:34 :: OPEN
Dienstag, 20. Oktober 2009 10:19:34 :: Software\Microsoft\Office\12.0\Excel\OptionsOPEN
Dienstag, 20. Oktober 2009 10:22:20 :: Install Desginer
Dienstag, 20. Oktober 2009 10:22:20 :: Create the HKEY_LOCAL_MACHINE\SOFTWARE\Aspose\Aspose.Cells.ReportingServices key
Dienstag, 20. Oktober 2009 10:22:20 :: Get user the key value ,first
Dienstag, 20. Oktober 2009 10:22:20 :: Registry.LocalMachine.OpenSubKey
Dienstag, 20. Oktober 2009 10:22:20 :: regKey.GetValue
Dienstag, 20. Oktober 2009 10:22:20 :: GetUserKeyValue
Dienstag, 20. Oktober 2009 10:22:20 :: Registry.LocalMachine.OpenSubKey
Dienstag, 20. Oktober 2009 10:22:20 :: regKey.GetValue
Dienstag, 20. Oktober 2009 10:22:20 :: =================Start loading client program ===================
Dienstag, 20. Oktober 2009 10:22:20 :: Check Client Condition
Dienstag, 20. Oktober 2009 10:22:26 :: Installing desginer is question.
Object reference not set to an instance of an object.
Aspose.Cells.ReportingServices.Installer
at Aspose.Cells.ReportingServices.Installer.ExtensionInstaller.x3bf937048ada3d5c()
Dienstag, 20. Oktober 2009 10:22:26 :: Register Assembly
Dienstag, 20. Oktober 2009 10:22:27 :: Login Client
Dienstag, 20. Oktober 2009 10:22:27 :: Add add-in Manager of office 8.0
Dienstag, 20. Oktober 2009 10:22:27 :: Registry.CurrentUser.OpenSubKey
Dienstag, 20. Oktober 2009 10:22:27 :: regKey.GetValue
Dienstag, 20. Oktober 2009 10:22:27 :: Installing desginer is error in excel 8.0
Object reference not set to an instance of an object.
Aspose.Cells.ReportingServices.Installer
at Aspose.Cells.ReportingServices.Installer.ExtensionInstaller.x2bd213e01baf15ec(String x272bc993a9d89cb6, String x3228e1e96681c1c1)
Dienstag, 20. Oktober 2009 10:22:27 :: Add add-in Manager of office 11.0
Dienstag, 20. Oktober 2009 10:22:27 :: Registry.CurrentUser.OpenSubKey
Dienstag, 20. Oktober 2009 10:22:27 :: regKey.GetValue
Dienstag, 20. Oktober 2009 10:22:27 :: Add add-in Manager of office 12.0
Dienstag, 20. Oktober 2009 10:22:27 :: Registry.CurrentUser.OpenSubKey
Dienstag, 20. Oktober 2009 10:22:27 :: regKey.GetValue
Dienstag, 20. Oktober 2009 10:22:27 :: Configure Aspose.Cells.ReportingServices.Dll for Client
Dienstag, 20. Oktober 2009 10:22:27 :: =================Loading client program is over ===================

Install.Log from Server:

Dienstag, 20. Oktober 2009 10:17:05 :: Unloading add-in of office 8.0
Dienstag, 20. Oktober 2009 10:17:05 :: UnloadAddinManager :Software\Microsoft\Office\8.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:17:05 :: Unloading add-in of office 9.0
Dienstag, 20. Oktober 2009 10:17:05 :: UnloadAddinManager :Software\Microsoft\Office\9.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:17:05 :: Unloading add-in of office 10.0
Dienstag, 20. Oktober 2009 10:17:05 :: UnloadAddinManager :Software\Microsoft\Office\10.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:17:05 :: Unloading add-in of office 11.0
Dienstag, 20. Oktober 2009 10:17:05 :: UnloadAddinManager :Software\Microsoft\Office\11.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:17:05 :: Unloading add-in of office 12.0
Dienstag, 20. Oktober 2009 10:17:05 :: UnloadAddinManager :Software\Microsoft\Office\12.0\Excel\Add-in Manager
Dienstag, 20. Oktober 2009 10:17:25 :: Install Services
Dienstag, 20. Oktober 2009 10:17:25 :: Create the HKEY_LOCAL_MACHINE\SOFTWARE\Aspose\Aspose.Cells.ReportingServices key
Dienstag, 20. Oktober 2009 10:17:25 :: Get user the key value ,first
Dienstag, 20. Oktober 2009 10:17:25 :: Registry.LocalMachine.OpenSubKey
Dienstag, 20. Oktober 2009 10:17:25 :: regKey.GetValue
Dienstag, 20. Oktober 2009 10:17:25 :: GetUserKeyValue
Dienstag, 20. Oktober 2009 10:17:25 :: Registry.LocalMachine.OpenSubKey
Dienstag, 20. Oktober 2009 10:17:25 :: regKey.GetValue
Dienstag, 20. Oktober 2009 10:17:25 :: =================Start loading server program ===================
Dienstag, 20. Oktober 2009 10:17:25 :: Start assemble server program for MSSQLSERVER
Dienstag, 20. Oktober 2009 10:17:25 :: Start config the rsreportserver.config of MSSQLSERVER
Dienstag, 20. Oktober 2009 10:17:25 :: Start config the rssrvpolicy.config of MSSQLSERVER
Dienstag, 20. Oktober 2009 10:17:25 :: Start config Aspose.Cells.ReportingServices.dll.config of MSSQLSERVER
Dienstag, 20. Oktober 2009 10:17:25 :: ================= Loading server program is over! ===================

Regards,
nascom GmbH

nausherwan.aslam · October 20, 2009, 3:58am

Hi,

Thank you for considering Aspose.

We have checked your install.log file and the Installation is normal. Please provide us your complete system environment details. We will create new virtual environment in order to test and resolve your issue.

Thank You & Best Regards,

nascom · October 20, 2009, 4:19am

Hi,

our Testing and Development Environment is setup as follows:

Server: Windows 7 (x64) Ultimate. MS SQL 2008 (x64) Developer Edition. Reporting Services running in Native Mode. (As you currently not support Reporting Services Integration Mode.) Installed Aspose Cells for Reporting Services Server.

Client: Windows XP Professional (32) SP3. Office 2003 SP3. Installed Aspose Cells for Reporting Services Client.

Domain Network.
Firewalls turned off.

Regards,
nascom GmbH

nausherwan.aslam · October 20, 2009, 7:30am

Hi,

Thank you for the details regarding your system environment.

We will look into your issue and get back to you soon.

Thank You & Best Regards,

nascom · October 20, 2009, 8:40am

Hi,

we’ve now set up a virtual Windows 2008 Server and installed Aspose Cells for Reporting Services Server on it. Now the Excel Remote Report Function works. The only difference we can see in the Traffic with Fiddler is the ReportServerEdition… This one is Express and the one in our Development Environment is Developer.

Is it possible that Aspose Cells for Reporting Services is not working with a Developer Edition of SQL Server 2008?

Regards,
nascom GmbH

nausherwan.aslam · October 22, 2009, 2:14am

Hi,

Thank you for considering Aspose.

We have built new test environment as mentioned below.

Server: Windows 7 Ultimate 32bit ,MS SQL Server 2008 Evaluation. Reporting Services running in Native Mode.

When we change user account control settings to never notify, the Aspose.Cells for Reporting Services client can connect report server. Please try change user account control settings. If you still face the issue , please contact us any time. Also, we do not have MS SQL 2008 Developer Edition so we were unable to test it with that. We will test that later if you still face any issue.

Thank You & Best Regards,

nascom · October 22, 2009, 4:40am

Hi,

User Account Control is the first thing we deactivate (set to never notify) after installing any Machine.
So that can’t be our Problem.

Regards,
nascom GmbH