Changes from OlapClient to PivotClient

[Nate Greene]

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]

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]

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]

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.  

 

Release Notes: https://help.syncfusion.com/js/release-notes/v14.3.0.49?type=all#ejpivotclient 

 

Also, please find the following online sample browser link for your reference. 

 

Sample browser: http://mvc.syncfusion.com/demos/web/pivotclient/relationaldefault 

 

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]

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]

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]

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]

Screenshot mentioned in the last post

Attachment: syncfusionAssemblies_c255d4b3.zip

[Sastha Prathap Selvamoorthy]

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.