This content has been marked as final. Show 2 replies
Make Sure you dont have Any Consistency Errors/warnings in the RPD first.
Then debug step by step like query (in Answers)only only from each table and see whats happening thru physical query from backend.
Make sure you have correct joins in BMM.
Table or View doesnot exist occur when there is no table in the database, MAke sure your connection pool DSN is pointing correct!!
If possible try to paste the error.
Repository is being used by many people. Report is working fine if I give Inner join between WIP_V fiew and fact1. Only if give Right outer join between them, then it is throwing table view doesnot exit.
RPD is pointing to correct DB.
I belive OOB tables are causing problem here.
Let me know if you need more info