Queries do not filter on tenant when deployed

Questions
1

We have the tenant flag set up on our database tables to segregate our data, and this works fine when testing locally, but when we deploy the application the app no longer tries to filter based on the tenant even when using the same database as we use locally.

For example, when testing locally we get info level logs like this “Analysing filters [TableFilter{_svy_tenant_id_table_filter}(prosoftcms,users) [DataproviderTableFilterdefinition[owner=LIV]]]”

However, on the deployed app we get logs like this “Analysing filters null”

Anyone have any ideas why this is happening?

2

I’ve investigated further and found that the column is not recognized as having the tenant flag set when the application is deployed. Still don’t know how to resolve, any help would be greatly appreciated.

3

We resolved our issue. The DBI files for certain tables were not being exported. We fixed it by setting the “Export all tables from referenced server” flag to true.