We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Changes from OlapClient to PivotClient

Thread ID:

Created:

Updated:

Platform:

Replies:

126232 Oct 3,2016 07:58 AM UTC Oct 14,2016 10:06 AM UTC ASP.NET MVC 8
loading
Tags: PivotClient
Nate Greene
Asked On October 3, 2016 07:58 AM UTC

I see that in the newest release that OlapClient has been changed to PivotClient, does this require many changes for existing OlapClients that want to upgrade?
From what I can tell the documentation has not been updated since the most recent release will an updated version be available online soon with the changes?

Thanks,

Nate

Sastha Prathap Selvamoorthy [Syncfusion]
Replied On October 4, 2016 11:11 AM UTC

Hi Nate, 
 
Please find the response below. 
 
I see that in the newest release that OlapClient has been changed to PivotClient, does this require many changes for existing OLAPClient that want to upgrade? 
No need major changes, only minor changes will be enough to upgrade to latest version and all existing functionalities working as in the previous versions. If you want any further assistance when you upgrading, please let us know. 
From what I can tell the documentation has not been updated since the most recent release will an updated version be available online soon with the changes? 
Currently we are working on this with high priority. We’ll update the online document once get it done. 
 
Regards, 
Sastha Prathap S. 


Nate Greene
Replied On October 6, 2016 05:54 AM UTC

The last update broke the OlapClient for my application. I cannot seem to use the EJ().Pivot().PivotClient() syntax as PivotClient is not an option under the pivot class.  When I use the old syntax of Html.EJ().Olap().OlapClient("OlapClient1").Url(Url.Content("api/OlapClient")) then I get this error:

Server Error in '/' Application.

Could not load type 'Syncfusion.JavaScript.OlapClientDisplayMode' from assembly 'Syncfusion.EJ, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.TypeLoadException: Could not load type 'Syncfusion.JavaScript.OlapClientDisplayMode' from assembly 'Syncfusion.EJ, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89'.

Source Error: 


Line 6:  }
Line 7:  
Line 8:  @Html.EJ().Olap().OlapClient("OlapClient1").Url(Url.Content("api/OlapClient"))

Source File: c:\Users\administrator.BLUESTREAK\Documents\Syncfusion MVC\Projects\BlueStreakReporting\Views\PivotClient\PivotClient.cshtml    Line: 8 

Stack Trace: 


[TypeLoadException: Could not load type 'Syncfusion.JavaScript.OlapClientDisplayMode' from assembly 'Syncfusion.EJ, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89'.]
 ...

Here is a list of my assemblies from the Web.config:

<assemblies>
        <add assembly="Syncfusion.Compression.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Presentation.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.XlsIO.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Pdf.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.DocIO.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.DocToPDFConverter.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ.PdfViewer, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Chart.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ.ReportViewer, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Gauge.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.ReportControls.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.ReportWriter.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.SFMaps.WPF, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Shared.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ.Mvc, Version=14.3500.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Linq.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ.Olap, Version=14.2450.0.26, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Olap.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
      </assemblies 

Any help would be greatly appreciated,
Nate

Sastha Prathap Selvamoorthy [Syncfusion]
Replied On October 7, 2016 11:52 AM UTC

Hi Nate, 
 
Sorry for the inconvenience caused. 
 
We would like to inform you that, from our current version (14.3.0.49), we have started providing support for both Relational and OLAP data source at both client side and server side in Client control. So, we have renamed the control, class, namespace and assembly accordingly from “OlapClient” to “PivotClient”. We have also mentioned these details in our current release notes link. Please find the following release notes link for your reference.  
 
 
Also, please find the following online sample browser link for your reference. 
 
 
Local Sample Location: <System drive>:\Users\User Name\AppData\Local\Syncfusion\EssentialStudio\14.3.0.49\MVC\Samples\web\Views\PivotClient 
 
Regards, 
Sastha Prathap S. 


Nate Greene
Replied On October 11, 2016 04:43 PM UTC

Hey Sastha,

I took a look at the examples and made the namespace changes as you suggested and have been able to get it running just fine on my locally hosted(iis express) dev machine but when I publish it to the server I get an ambiguous call error :

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. 

Compiler Error Message: CS0121: The call is ambiguous between the following methods or properties: 'Syncfusion.JavaScript.EJExtension.PivotGrid(Syncfusion.JavaScript.Pivot, string)' and 'Syncfusion.JavaScript.EJExtension.PivotGrid(Syncfusion.JavaScript.Pivot, string)'

Source Error:


Line 135:        }
Line 136:    </script>
Line 137:    @Html.EJ().Pivot().PivotGrid("PivotGrid1").EnableGroupingBar(true).IsResponsive(true).EnableConditionalFormatting(true).Url(Url.Content("~/api/OLAPGrid"))
Line 138:    <hr />
Line 139:    @Html.EJ().Pivot().PivotSchemaDesigner("PivotSchemaDesigner").Layout(PivotSchemaDesignerLayout.Excel)

Source File: c:\inetpub\wwwroot\BlueStreak\Site\Views\PivotChart\SalesPivot.cshtml    Line: 137 

I understand what the error message is saying but I am unsure how there are duplicate methods of the same name that are causing this name in the firstplace.

Any help with this will be greatly appreciated.

Thanks,

Nate







Sastha Prathap Selvamoorthy [Syncfusion]
Replied On October 12, 2016 06:15 AM UTC

Hi Nate, 
 
We think that the reported problem occurred when both the assemblies “Syncfusion.EJ.Olap”(older version) and “Syncfusion.EJ.Pivot”(current version) were referred in your project assembly reference. Please find the sample screen shot for your reference. 
 
 
 
So, please make sure that the older version assembly “Syncfusion.EJ.Olap” has been removed completely from your project and web.config. After removed the assembly, please re-build your project before publishing it to the server. 
 
IMPORTANT NOTE: Please remove the “bin” and “obj” folder before you re-build your project. 
 
Regards, 
Sastha Prathap S. 


Nate Greene
Replied On October 13, 2016 05:10 AM UTC

Hey Sastha,

The same error is occuring I have made sure that EJ.Olap was removed and deleted the bin and obj folders. I have enclosed a screenshot of all my assembles as well as the system.web section in the web.config file.  Are there any other assemblies that call this method? 

<system.web>
    <authentication mode="None" />
    <compilation debug="true" targetFramework="4.6">
      <assemblies>
        <add assembly="Syncfusion.Compression.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Presentation.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.XlsIO.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Pdf.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.DocIO.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.DocToPDFConverter.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ.PdfViewer, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Chart.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ.ReportViewer, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Gauge.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.ReportControls.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.ReportWriter.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.SFMaps.WPF, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Shared.Wpf, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.EJ.Mvc, Version=14.3500.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Linq.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
        <add assembly="Syncfusion.Olap.Base, Version=14.3460.0.49, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
      </assemblies>
    </compilation>
    <httpRuntime targetFramework="4.6" />
    <pages>
      <namespaces>
        <add namespace="System.Web.Helpers" />
        <add namespace="System.Web.Mvc" />
        <add namespace="System.Web.Mvc.Ajax" />
        <add namespace="System.Web.Mvc.Html" />
        <add namespace="System.Web.Optimization" />
        <add namespace="System.Web.Routing" />
        <add namespace="System.Web.WebPages" />
        <add namespace="Syncfusion.EJ.ReportViewer" />
        <add namespace="Syncfusion.JavaScript" />
        <add namespace="Syncfusion.JavaScript.DataVisualization" />
        <add namespace="Syncfusion.MVC.EJ" />
        <add namespace="Syncfusion.JavaScript.Olap" />
      </namespaces>
    </pages>
    <httpHandlers>
      <add verb="*" path="captimage.axd" type="Syncfusion.JavaScript.ImageHandler, Syncfusion.EJ, Version=14.2450.0.26, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" />
    </httpHandlers>
  </system.web>

Any help will be greatly appreciated.

Thanks,

Nate

Nate Greene
Replied On October 13, 2016 05:11 AM UTC

Screenshot mentioned in the last post

Attachment: syncfusionAssemblies_c255d4b3.zip

Sastha Prathap Selvamoorthy [Syncfusion]
Replied On October 14, 2016 10:06 AM UTC

Hi Nate,   
   
We think that the older version of “Syncfusion.EJ.Olap.dll” may still be referred from the GAC_MSIL path. It may also cause the reported problem. Please make sure that the folder “Syncfusion.EJ.Olap” has been removed from GAC_MSIL path.   
   
Please find the system location and screenshot for Assemblies in GAC_MSIL for your reference.   
   
GAC_MSIL:    
<System Drive>:\Windows\Microsoft.NET\assembly\GAC_MSIL\Syncfusion.EJ.Olap   
   
Screen-shot:   
     
   
IMPORTANT NOTE: Please rebuild the project after removing the assembly “Syncfusion.EJ.Olap” from GAC_MSIL location. Also please make sure that the “bin” and “obj” folder have been removed from the project before you rebuild the project every time.   
   
Regards,   
Sastha Prathap S.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;