The main problem is :
I want to extract data from oracle. But when I'm creating the DB Conntect, the new created table/view doesn't appear in the table/view select area. And the deleted table/view is still in it.
Target DBMS is Oracle 10.2
BW is on Oracle, too
VCARDAGE20130608 has been replaced by VCARDAGE20130628, but VCARDAGE20130608 still appear in the select area and VCARDAGE20130628 can't be found.
The update in oracle surely has been submitted.
- SAP Managed Tags:
Accepted Solutions (0)
Answers (1)
Hi andrea
My colleague created the VCARDAGE20130608 on June 08. On that day, I can create db connect to extract the data from the view.
I did nothing to these object untill June 28. We added two fields to the view. After that, I wanted to edit my datasource. But I found that I can't add these two fields into the metadata. Then I deleted and recreate the datasource. Finally, the problem just like that I've said appeared.
The db connect information is as below：
| User | Count |
|---|---|
| 85 | |
| 10 | |
| 9 | |
| 9 | |
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.