Hello,
I current use the version of Innovator11SP12. I also has big Xclass tree for Part and has total over 2000 xp-propertys. When i maintain Part record,the SQL server always throw error message for me. The error message is “The number of elements in the select list exceeds the maximum allowed number of 4096 elements.”
So i using SQL server profiler watch execute SQL command! My jaw dropped .
OMG, Make me Amazing!
The Aras InnovatorCore will dynamic generate huge select fields in sql command.
Maximum Capacity Specifications for SQL Server limit for Columns per SELECT statement: 4096.
URL: docs.microsoft.com/.../maximum-capacity-specifications-for-sql-server
Just like this
exec sp_executesql N’SELECT
[PART].[APPLY_REASON] AS [APPLY_REASON],
[PART].[BOM_PLANT] AS [BOM_PLANT],
…….
PART_XPROPERTYVALUES22.[XP-PART_0101_CORE_SHAPE$IS_DEFINED] [XP-PART_0101_CORE_SHAPE$IS_DEFINED],
PART_XPROPERTYVALUES22.[XP-PART_0101_CORE_SHAPE_$_PERMISSION] [XP-PART_0101_CORE_SHAPE_$_PERMISSION],
[PART_XPROPERTYVALUES22].[XP-PART_0101_CORE_SHAPE] AS [XP-PART_0101_CORE_SHAPE],
— so huge xp property select fields , one xp property field will generate three select field
ON ([PART].team_id = fk12.id) LEFT JOIN [secured].[XPROPERTYVALUES22] ….
Then, it will generate total select fields over 4096 fields. Touch SQL Server limitation for max select fields.
Even i split one xclass tree to a lot of small tree not solve the problem.
How do i solve the problem?
