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