Entity framework give error on live server

Ajitender Vijay

13y5.9k.NET

Hi,

I am get issue pls help me to fix this

The data reader returned by the store data provider does not have enough columns for the query requested.

Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ajitender Vijay13y ago

yes...
Dorababu Meka13y ago

Are you able to see you column information as per marked in the red or you are getting that error while importing a function
Ajitender Vijay13y ago
Yes... i had created a new complex of all return column
Dorababu Meka13y ago
Ok are you able to see the column information when you generate a New complex type?
Ajitender Vijay13y ago
by importing as function in EF model
Dorababu Meka13y ago
Hi how you are calling your stored procedure, by importing as function in EF model or using StoreCommand
Ajitender Vijay13y ago
Hi babu,

Yes you are right i am using stored procedure.

here is the SP code but it's working fine on development environment

CREATE PROCEDURE [dbo].[GetInstallersByNameCode]
    -- Add the parameters for the stored procedure here
    @installerName nvarchar(50),
    @installerCode nvarchar(50)
AS
BEGIN TRY
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.



SELECT TOP 50 [Installer].[InstallerCompanyID],
        [Installer].[CompanyName],
               [InstallerAddress].[PostCode]PostCode,
               [InstallerAddress].[Town]
FROM [ARC_Ordering].[dbo].[Installer]
inner join
   [ARC_Ordering].[dbo].[InstallerAddress]
   ON Installer.AddressID = InstallerAddress.AddressID
where IsActive = 1
AND
(CompanyName like '%'+@installerName+'%' OR InstallerCode like '%'+@installerCode+'%')
ORDER BY CompanyName ASC

END
END TRY
BEGIN CATCH
EXEC USP_SaveSPErrorDetails
--RETURN -1
END CATCH
Dorababu Meka13y ago
Are u using stored procedure to get the data if so can you post that procedure