Article - CS345627
Deleting attribute from top most Part Classification node gives an error "The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request" in Windchill PartsLink
Modified: 25-May-2021
Applies To
- Windchill PDMLink 11.1 M020
- Windchill PartsLink 11.1 M020
- The MethodServer throws following error in the logs :
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:444) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:582) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:540) at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:385) at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:337) at wt.pds.BasicResultCursor.next(BasicResultCursor.java:132) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:810)
Description
Deleting attribute from top most Part Classification node gives an error "The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request"
This is a printer-friendly version of Article 345627 and may be out of date. For the latest version click CS345627