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

Error using Stored Procedure as source which contains a left or substring command

1 Answer 64 Views
This is a migrated thread and some comments may be shown as answers.
Top achievements
Rank 1
Dennis asked on 13 Jan 2016, 01:58 PM
 I'm using for the Grid a stored Procedure with a parameter as the source.
This stored Procedure works fine. but when i open the "configuration wizard" and i insert the value in context window "Refresh data source schema" i'm getting the error "unable to receive schema. ensure that the Connection string and Selectcommand property are valid. invalid length parameter passed to the LEFT or SUBSTRING function" 
When i run the page it woks fine! in case that i need to configure a hierarchical grid i like to open the wizard where i get the error :-(
this is my code:

 aspx page:
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <div class="demo-container no-bg">
        <div id="AlertDIV" runat="server" class="AlertBOX">
                    <asp:SqlDataSource ID="mnv" runat="server" ConnectionString="<%$ ConnectionStrings:connBTDashboard %>" SelectCommand="sp_Playground" SelectCommandType="StoredProcedure">
                            <asp:Parameter DefaultValue="1" Name="dfg" Type="Int32" />
                    <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="mnv" GroupPanelPosition="Top">
                        <GroupingSettings CollapseAllTooltip="Collapse all groups"></GroupingSettings>
                        <MasterTableView DataSourceID="mnv">
 ALTER proc [dbo].[sp_Playground]
@dfg int 

Declare @Cols varchar(max)= ''

DECLARE @SQL varchar(max)

select @Cols += '['+ [col_Name]+'],'from [dbo].[tbl_Conf_MultiNAV] where col_Group = @dfg

Set @COLS = left(@COLS,len(@COLS)-1)

select @Cols as Value 

--call of SP in Management Studio => works fine 
exec [sp_Playground] 1 

as a remark ... this code in my test to rebuild this error i have in another project  ;-) 

i'm using .net 4.0 and  UI Version 2015.3.1111.40 

 does anybody had that problem already ?     

thanks a lot 

1 Answer, 1 is accepted

Sort by
Maria Ilieva
Telerik team
answered on 18 Jan 2016, 12:48 PM

Can you please elaborate a bit more on how exactly the issue can be replicated? Are you using the RadGrid designer for entering the parameter? Providing step by step instructions for replicating the issue will help us investigate the problem locally and advise you further.

Maria Ilieva
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Asked by
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Share this question