Maximum number of Tables in a Join error

You might encounter this error if you trying to make new relations with table that already have high number of relations defined on it Like “InventTable”. On showing the field to form you might see a warning message that “The table exceeds the max join limit…….”

Solution:

Maximum number of Tables in a Join defined in the Server Configuration (System Administration > Setup > System > Server Configuration). There you need to change the number to allow more join tables. After that you also need to restart the AOS service to reflect this change on tables.

ac004

There is performance factor also, which is explained well on the Brandon’s Blog

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: