This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.
LinkedIn
Copied!

Table of Contents

Troubleshooting: "maximum row size" error for pr4_rule table in V4.2 installation (SQL Server)

Symptom

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.

Solution

Resolution

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.

 
Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.