This is a migrated thread and some comments may be shown as answers.

The server method...failed. SPRadGridDesigner Data binding

22 Answers 132 Views
WebParts for SharePoint
This is a migrated thread and some comments may be shown as answers.
Dave
Top achievements
Rank 1
Dave asked on 24 Jul 2013, 08:27 PM
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?  

22 Answers, 1 is accepted

Sort by
0
Tsvetoslav
Telerik team
answered on 29 Jul 2013, 10:28 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Vamsi
Top achievements
Rank 1
answered on 06 Sep 2013, 03:15 PM
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.
0
Tsvetoslav
Telerik team
answered on 09 Sep 2013, 10:33 AM
Hi Vamsi,

Does disabling forms authentication make any difference?
 
Regards,
Tsvetoslav
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Vamsi
Top achievements
Rank 1
answered on 09 Sep 2013, 04:27 PM
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.
0
Vamsi
Top achievements
Rank 1
answered on 09 Sep 2013, 05:51 PM
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
0
Tsvetoslav
Telerik team
answered on 12 Sep 2013, 11:56 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Ilya
Top achievements
Rank 1
answered on 24 Sep 2013, 07:33 AM
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?
0
Tsvetoslav
Telerik team
answered on 25 Sep 2013, 11:09 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
BoGreece
Top achievements
Rank 1
answered on 24 Oct 2013, 01:31 PM
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.
0
Marin
Telerik team
answered on 29 Oct 2013, 12:36 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Elizabeth
Top achievements
Rank 1
answered on 21 Nov 2013, 10:49 PM
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?
0
Centaur
Top achievements
Rank 1
answered on 25 Nov 2013, 10:48 AM
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.
0
Marin
Telerik team
answered on 25 Nov 2013, 04:37 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Charles
Top achievements
Rank 1
answered on 29 Nov 2013, 10:48 AM
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.
0
Marin
Telerik team
answered on 02 Dec 2013, 12:08 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Marin
Telerik team
answered on 14 Dec 2013, 10:05 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Sambathraj
Top achievements
Rank 1
answered on 16 Dec 2013, 06:06 AM
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?
0
Marin
Telerik team
answered on 17 Dec 2013, 09:54 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Sambathraj
Top achievements
Rank 1
answered on 18 Dec 2013, 03:51 AM

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

0
Marin
Telerik team
answered on 18 Dec 2013, 08:43 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Charles
Top achievements
Rank 1
answered on 18 Dec 2013, 02:01 PM
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.
0
Marin
Telerik team
answered on 18 Dec 2013, 02:21 PM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
WebParts for SharePoint
Asked by
Dave
Top achievements
Rank 1
Answers by
Tsvetoslav
Telerik team
Vamsi
Top achievements
Rank 1
Ilya
Top achievements
Rank 1
BoGreece
Top achievements
Rank 1
Marin
Telerik team
Elizabeth
Top achievements
Rank 1
Centaur
Top achievements
Rank 1
Charles
Top achievements
Rank 1
Sambathraj
Top achievements
Rank 1
Share this question
or