Skip to Content

SAP B1 Project Management Module - Issue of SQL maximum parameters of 2100

Dears,

We have a subproject which has stages and under one of the stage, there are a lot of documents (2100 documents), we are trying to add more documents under the stage but it does not accept more, it gives the following SQL error:

[Microsoft][SQL Server Native Client 11.0][SQL Server]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. '' (PMG4) (Tables List: PMG4, OPMG) # # TID=28268 BO=Project Management Subproject BOID=711 Customized=0

Is there a solution or workaround for this error?

Thanks

Samer

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 21 at 01:58 PM

    Hi,

    Looks line application error. Please submit ticket to SAP.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23 at 06:45 PM

    check on support portal for relevant documentation may be its b1 limit to have maximum records in this table or raise an incident to SAP

    Add comment
    10|10000 characters needed characters exceeded