Article - CS275621
Failed to save layout information in Type Manager with error "java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000" in Windchill
Modified: 05-Jun-2021
Applies To
- Windchill PDMLink 11.0 M010
- FlexPLM 11.0 M030
Description
- Failed to save layout information in Type and Attribute Management
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
- Modify any attribute or layout on Material type in Type Manager， throws error.
INFO [ajp-bio-127.0.0.1-8010-exec-1] wt.system.out wcadmin -: QueryTaskrunPreparedStatementQuery: EXCEPTION OCCURED ON STATEMENT: SELECT AttributeGroupAccessRule.idA3A4, AttributeGroupAccessRule.idA2A2, AttributeGroupAccessRule.groupName FROM AttributeGroupAccessRule WHERE AttributeGroupAccessRule.idA3A4 IN( INFO [ajp-bio-127.0.0.1-8010-exec-1] wt.system.err wcadmin - java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 INFO [ajp-bio-127.0.0.1-8010-exec-1] wt.system.err wcadmin -
This is a printer-friendly version of Article 275621 and may be out of date. For the latest version click CS275621