Troubleshooting: "maximum row size" error for pr4_rule table in V4.2 installation (SQL Server)
For Microsoft SQL Server installations only :
When running the install script (
< database> _install0402.sql) or the upgrade script (
< database> _upgrade0402.sql ) to create tables in the relational database during the install or upgrade process, the following error may appear:
Warning: The table 'pr4_rule' has been created but its maximum row size (8506) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
This is a known limitation of Microsoft SQL Server. The message indicates that there are too many columns in the table, which is only an issue if data is present in all columns.
This message may be ignored.
When installed, Process Commander theoretically exceeds this limit, but in practice, the limit is not exceeded.
Many different rule types (Rule- classes) are mapped to the
pr4_rule table. The rows of the table do not each use all the columns (some rule types use some columns, other types use other columns, and some columns are used by all rule types).
Thus, every row has unused columns, which prevents the error warned of above.