on 02-02-2016 12:27 PM
Hi Experts,
There is an issue in report which populates wrong old data and new data. I checked the source script for the read from task. Tables used in SQl query are MXWV_approval. MXI_approval. But when I execute queries like "Select * from MXWV_APPROVAL or select * from MXI_APPROVAL" on DB I face "table or View does not exist"
How this is possible ? could you please help?
Thank you
Ranjan
Hello Ranjan,
that can happen, if you use a user (probably mxmc_rt) for the SQL query, that has no permission to "see" those tables.
Regards,
Steffi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ranjan,
Check if the table or view exists in database and also in which schema?
select * from all_objects where object_type in (`TABLE','VIEW') and object_name = `MXWV_APPROVAL`
select * from all_objects where object_type in (`TABLE','VIEW') and object_name = `MXI_APPROVAL`
Also, I cannot see MXWV_APPROVAL in my database either. I guess it should be MXPV_APPROVAL. SAP add/delete/remove some tables and view during upgrades, may be you have to update the query to use the current table or view.
Kind regards,
Jai
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.