Troubleshoot > Troubleshooting: Common database errors > Message: Corresponding Join Not Defined

Message: Corresponding Join Not Defined

Message: Corresponding Join Not Defined

This message indicates that the report is attempting to join multiple tables that have not been properly joined in the database.

When designing reports, linking tables using the application is not sufficient to create a join. You must also configure Service Manager with the equivalent values.

To join the tables:

  1. Inspect the joined tables in your application. Arrows should connect to only the fields that you want to join between the tables.
  2. Make an unload of both tables before making modifications so that you can return to the original configuration if needed.
  3. Open Service Manager and compare the settings in the JOINDEF and ERDDEF tables to this linking scheme. You may need assistance from your administrator to confirm this task. Ensure that the following criteria apply:

    • The joins match exactly.
    • The join in Service Manager is unique, no other join connects the same tables in a different manner.
    • Stop, and then restart, the Service Manager server after creating the join.

Note Modify the JOINDEF and ERDDEF tables in Service Manager with caution and only with prior approval from an administrator.