Unable to find relationship aos_products_purchases

👨‍💻 Development Help
1

Version: Version 8.7.0
SuiteCRM is quite slow, so found that on any action I’m getting all LOG with:

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Wed Oct 16 16:07:20 2024 [96050][1][ERROR] Unable to find relationship aos_products_purchases
Wed Oct 16 16:07:20 2024 [96050][1][WARN] aos_products_purchases for aos_products_purchases failed to load

Ive tried to rebuild, but still same issue. Maybe some one have any ideas how to fix it?

2

Is it customized module? :eyes:

3

No, ive customized only products, but just removed some fields, and none of relationsip had been removed.
This AOS relationships usig like Quotes and Invoice modules, but I see them in Studio.

I’m quite new to SuiteCRM, so have no idea where to find causes.

4

You can try running a few things from Admin / Repairs

  • quick repair and rebuild
  • rebuild relationships

After that, if you still see the errors in the logs, but the app works normally, I would just ignore the errors (maybe they are “false positives”)

5

It’s done, but still i see that SuiteCRM is to slow… is it possible that ERRORS can be false positives?
Actually it works, but…

6

To troubleshoot slow SuiteCRMs I always recommend starting by checking overgrown tables, please run the SQL command at the top of this post and show us the results:

7