The Webi query cannot run because it contains objects that reference incompatible tables
Symptom
- Not able to run some queries after migrating universe from BI4.1 to BI4.2
- Error in Universe Designer "The query cannot run because it contains objects that reference incompatible tables.
- Incompatible combination of tables.
Environment
SAP BusinessObjects Business Intelligence platform 4.2
Reproducing the Issue
- Import a universe in Universe Designer BI4.2 created on BI4.1
- Go to business layer --> queries.
- Create a query by adding objects on specific order
- Not able to see SQL and not able to run the query
Cause
The query cannot run because it contains objects that reference incompatible tables.
Resolution
- Analyse which object and filter are causing the issue.
- Once you have identified the problematic object, navigate to the Universe Designer.
- Check the List of Values (LOV) associated with the specific object to see if any customizations exist.
- Verify the availability of all tables used in this object. If needed, recreate the LOV for the object and save it in the Universe Designer.
- Export the updated universe and perform a refresh to ensure that the changes are applied.
Ensure that all the below checks are validated.
- Check Data Source Compatibility:
- Ensure that the data sources (tables, views) referenced in your WebI query are compatible. Check if the tables have the same structure, data types, and are from the same source.
- Verify Universe or Data Connection:
- If you are using a universe or a data connection, make sure that it is correctly set up and that the objects in your report are based on compatible elements within the universe or data connection.
- Object Mapping:
- Verify that the objects (dimensions, measures) in your report are correctly mapped to the corresponding elements in the data source. Ensure that the objects in your report match the available fields in the tables you are using.
- Join Conditions:
- Check the join conditions between tables in your query. Ensure that the joins are correctly defined and that they make sense based on the relationships between the tables.
- Refresh Data:
- Try refreshing the data in your WebI report. Sometimes, data discrepancies can be resolved by refreshing the report data.
- Check for Filters:
- Review any filters applied to your report. Incorrectly applied filters might reference columns or tables that are not present or incompatible.
Conclusion: This blog helps resolve the issue where the Webi Report not running due to incompatible objects.
Feedback and comments are appreciated Thank you for stopping by, and hope this helps at least a few developers/users out there.,