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. Image for the cookie policy date
close icon

Changes from OlapClient to PivotClient

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

8 Replies

SP Sastha Prathap Selvamoorthy Syncfusion Team 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. 



NG Nate Greene 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


SP Sastha Prathap Selvamoorthy Syncfusion Team 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. 



NG Nate Greene 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








SP Sastha Prathap Selvamoorthy Syncfusion Team 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. 



NG Nate Greene 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


NG Nate Greene October 13, 2016 05:11 AM UTC

Screenshot mentioned in the last post

Attachment: syncfusionAssemblies_c255d4b3.zip


SP Sastha Prathap Selvamoorthy Syncfusion Team 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.

Loader.
Live Chat Icon For mobile
Up arrow icon