cancel
Showing results for 
Search instead for 
Did you mean: 

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

shuqair_samer
Explorer
0 Kudos
420

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Abdul
Active Contributor
0 Kudos

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

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Looks line application error. Please submit ticket to SAP.

Regards,

Nagarajan