The server method...failed. SPRadGridDesigner Data binding

[Dave]

I am have been unable to set up data binding for a SPRadGrid Web Part on a SharePoint 2013 site.  After adding the Web Part, I open 'SPRadGrid Designer'.  The upper treeview shows TelerikSPRadGrid1>MasterTable.  In the lowertree view, MasterTable offers General Settings and Data Binding.  General Settings are all selected.  Under databinding>SQL is SQL Server Instances.  When I click to expand the node, it tells me "the server method 'GetData' failed".  The Excel tab is blank.  Under SharePoint lists, attempting to expand the node (SP Lists) returns the similar error "the server method 'GetSPListData' failed.  

I suspect there is a rather simple explanation for why I cannot bind to data, but I am lost.  Anyone assist?  

[Tsvetoslav]

Hello Dave,

Could you open IIS, expand the node of your SharePoint application web site,then the _vti_bin folder and see if Anonymous Authentication is enabled for the Telerik.Ajax.SharePoint that's inside the latter.
 
Regards,
Tsvetoslav
Telerik

[Vamsi]

I am having the same issue and Anonymous authentication is enabled in IIS web application for Telerik.Ajax.SharePoint inside _vti_bin folder. Please advise. Its happening on SharePoint 2013 environment. This is the first time we are using Telerik in SharePoint.

[Tsvetoslav]

Hi Vamsi,

Does disabling forms authentication make any difference?
 
Regards,
Tsvetoslav
Telerik

[Vamsi]

Its not allowing me to disable Forms Based Authentication from IIS web application for Telerik.Ajax.SharePoint inside _vti_bin folder. How do I disable it. Should I make a change on web.config.

[Vamsi]

Hi Tsvetoslav ,

I am getting ‘Cannot import webpart’ error when trying to add Telerik SPRad Grid Webpart in one of my other sites. I checked the log and this is the error message I see:

 

“8l4f       Monitorable       Error importing WebPart. Assembly       Telerik.Ajax.SharePoint,      Version=2013.2.612.45, Culture=neutral,      PublicKeyToken=aa9e5f693af67c7b    , TypeName. Telerik.Ajax.SharePoint.TelerikSPRadGridWebPart. Cannot import this Web Part.”

 

If you look at the version, it says 2013.2.612.45. It should have been 2013.2.717.45. Could you please let me know why this is happening.

Thanks,
Vamsi

[Tsvetoslav]

Hello Dave,

Please, try uninstalling the telerik controls for sharepoint on that site, remove any telerik dlls from the GAC and bin folder of the SP application and reinstall the package. 
 
Regards,
Tsvetoslav
Telerik

[Ilya]

Hi,
I have the same problem.
I installed SPRagGrid and when i open the Designer, i receive this message.

If i user WebPart - edit webpart, the grid doesnot show any rows, when i connect it to some list.

Additional question, Do you have any log, where i check my problems?

[Tsvetoslav]

Hi Ilya,

Our development team further investigated the issue and it proved to be an error in the build scripts for the installer. It is expected to be fixed for the official release that's coming out very soon - around the middle of October. Meanwhile, please, open the

SPRadGridWebPartDesignerService.asmx

file that should be looked under:
Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Telerik.Ajax.SharePoint

and change its version number to the version number of the Telerik.Ajax.SharePoint.dll that's in your GAC.

It should be: 2013.2.717.45
 
Regards,
Tsvetoslav
Telerik

[BoGreece]

I have the same problem - the server method getsplistdata failed.
I've done the authentication (proposed at Posted on Jul 29, 2013 )but with no luck.
I've included the prinscreen.
I've downloaded yesterday.

[Marin]

Hello,

 Please verify that you are using and referencing the latest version of the assemblies everywhere in the project (in GAC, Bin folder, and web.config should point to the same version). The issue with the designer should have been fixed in the latest version.

Kind Regards,
Marin
Telerik

[Elizabeth]

I am now having the exact same issue in SP2010.

I have tried all suggested remedies in this thread and nothing has fixed it. I am running version 2013.3.1114.35.

Are there any other options?

[Centaur]

Hello,

Iam having the same problem on Sharepoint Server 2010, tried all the above but nothing worked. The two issues Iam having are:

1. In General Settings (SPRadGrid Designed - MasterTable), 5 out of 9 options are disabled, I cannot check/uncheck, they are selected (Enable Insert, Enable Update, Enable Delete, Enable Client Row Selection, Enable Columns Reorder).
2. By select Data Binding - SharePoint Lists, on trying to expand SP Lists I also get the message "The served method 'GetSPListData' failed".

Will this problem be fixed? Would like to know if there is anything else I can try for it to work, or try another solution.

Thank you.

[Marin]

Hello,

We are aware of the problem, it has been forwarded to our development team and we will try to resolve it as soon as possible.

Kind Regards,
Marin
Telerik

[Charles]

Hi,

I have had the same problem although I am using the latest build. I have tried all the tricks suggested but have not succeed.

[Marin]

Hello,

The issue has been logged here:
http://feedback.telerik.com/Project/108/Feedback/Details/66612-spradgridwebpart-desginer-does-work-correctly-in-some-cases
We will try to resolve for future versions of the controls. Meanwhile you have use the default editor of the web part to databind and configure it.

Regards,
Marin
Telerik

[Marin]

Hi,

A temporary workaround about the problem with the SPRadGridDesigner can also be applied in the following way:
open the ISAPI folder of the 15 hive of your SharePoint installation - it is located at:
...Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI
and edit the SPRadGridWebPartDesignerService.asmx file changing the version number within to be the same the version of the Telerik.Web.UI you are referencing everywhere else (e.g. 2013.3.1114.35 - for the latest version)
An official fix will be available in the next service pack of the controls.

Kind Regards,
Marin
Telerik

[Sambathraj]

Thanks for posting this workaround. It worked. When I try to connect to the SQL Instance, it gives me Login Failed error. What is the correct way to configure the SQL Instance?

[Marin]

Hello,

This is a general SQL error and no specific configuration in the Sharepoint environment is required. Make sure your login credentials are valid in the current SQL instance and whether Windows Authentication is enabled on the SQL server if necessary.

Regards,
Marin
Telerik

[Sambathraj]

I am sysadmin on the SQL Server and have full access. I am using windows authentication in the SQL server. I am still getting this error.

Thanks,

Sambath

[Marin]

Hi,

You can check in the error logs (for SQL or Sharepoint) what credentials exactly are used when the error happens and then try to log in with them through the SQL management studio to verify they work as expected.
Additionally please verify that you have anonymous authentication enabled in the vti_bin folder in the IIS Sharepoint application (Sharepoint-80).
You should also have administrator rights in the current site collection in Sharepoint when configuring the web part.

Regards,
Marin
Telerik

[Charles]

Thanks for this. It does work. However, wouldn't be nice if one can have the ability of binding to an SQL Server View?  Your thoughts please.

[Marin]

Hi,

Indeed it seems like a nice suggestion although CRUD operations in the control in this case might present some challenges since not all SQL Views are updateable by default.
You can also suggest new features and improvements in our feedback portal: http://feedback.telerik.com/Project/108

Regards,
Marin
Telerik