Welcome to Sign in | Help
in Search

exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

Last post 11-18-2009, 7:38 PM by ignatandrei. 3 replies.
Sort Posts: Previous Next
  •  11-18-2009, 5:05 PM 7834

    exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

    Exista vreun workaround la eroarea asta.Idee este ca ,query-ul meu generat de linq2sql are un where cu "In" in care sunt mai mult de 2100 de parametriu ceva de genul:
    WHERE [t8].[ElementID] IN (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54,

    Multumesc
    Secolul XXI ori va fi religios ori nu va fi deloc
  •  11-18-2009, 5:15 PM 7835 in reply to 7834

    Re: exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

    ce pot sa zic e ca 2100 e by default
    http://msdn.microsoft.com/en-us/library/ms143432.aspx
    Poti sa mai combini din parametri (intr-un xml, de ex ) ca sa ai mai putin de 2100
    Dar cum naiba ai facut asa ceva ? L2S sau EF?

    Ignat Andrei
    http://serviciipeweb.ro/iafblog
  •  11-18-2009, 6:27 PM 7836 in reply to 7835

    Re: exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

    ignatandrei:
    ce pot sa zic e ca 2100 e by default
    http://msdn.microsoft.com/en-us/library/ms143432.aspx
    Poti sa mai combini din parametri (intr-un xml, de ex ) ca sa ai mai putin de 2100
    Dar cum naiba ai facut asa ceva ? L2S sau EF?

    Cu linq2sql functia Contains a arrayului ala mare

     


    Secolul XXI ori va fi religios ori nu va fi deloc
  •  11-18-2009, 7:38 PM 7837 in reply to 7836

    Re: exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

    crestinul:

    ignatandrei:
    ce pot sa zic e ca 2100 e by default
    http://msdn.microsoft.com/en-us/library/ms143432.aspx
    Poti sa mai combini din parametri (intr-un xml, de ex ) ca sa ai mai putin de 2100
    Dar cum naiba ai facut asa ceva ? L2S sau EF?

    Cu linq2sql functia Contains a arrayului ala mare

     


    Ok, poti face asa  : daca numarul de parametrii sunt > 2000, inserezi intr-o tabela si chemi o SP in care faci diferenta...

    Ignat Andrei
    http://serviciipeweb.ro/iafblog
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems