Database View is not working on prod

[VasanthReddyP]

One of my database views is not working on prod returning no records on prod and the same database view in lower regions working fine

[AndersBGS]

Hi @VasanthReddyP ,

Ok, have you verified that your instances are aligned, and that your database view configuration is correct in PROD? If you need any additional help, please share some more details together with a snip.

[GlideFather]

Hi @VasanthReddyP 

• only the one database view doesn't return no record or none of the views?
  • is it a single view related or to all views?
• what is lower region?
  • is it sub-prod environment or any other (which?) parts of PROD?
• Is it related to a single user or more
  • what roles have you tested?

The more details you provide, the better others can help you

[VasanthReddyP]

Hi @GlideFather ,

I have verified the database view it is not working only in prod and tested and working fine in dev region.
I have tested all the roles for both the table ACL's and tested for multiple users it is working in dev region and missing in prod returning 0 records in prod

[Dr Atul G- LNG · Accepted solution]

Hi @VasanthReddyP 

Please check the individual tables to see if they contain any records.

• If they do, try to identify if there’s any common record between the two tables (you can check this using list view or form view).

• If you do not find any common records, it means the database is working correctly.

• However, if you are getting common records when comparing the two tables in list view, then please recheck your database logic or where clause