on 04-07-2014 3:23 PM
Hi,
We are currently trying to use Data Services to extract data from ECC to HANA using standard Business Content extractors. BW is beyond the scope of this project and we want to build a custom SQL data mart using Data Services and HANA.
We would like to use the extractor 2LIS_11_VAHDR to extract Sales Order Header information. However, when we try to fill the setup tables for application 11, we see the error ‘No extraction structure active or no BW connected’:
We have confirmed that the data sources are active in both t-codes RSA6 and LBWE. We are also able to pull the DataSource up in t-code RSA3 but obviously no records are returned because the setup tables are empty.
RSA6
LBWE
RSA3
Please advise as to any other steps needed to allow the filling of the setup tables. Your help is highly appreciated.
Thanks,
Abhi
We were able to resolve this issue with SAP's help. Here is the solution.
If you want to be able to execute OLI7BW, you need to either connect a BW system to the source system or create at least one subscription within Operational Delta Queue.
If you do not want to connect a BW system, this means you would first have to issue a CDC request from Data Service for a 2LIS_11* data source (e.g. 2LIS_11_VAITM) with an empty setup table.
This will create an active subscription, enabling you to start the setup program OLI7BW.
After this you should be able to request a second initial load from Data Services, by temporarily setting property "Initial load" to "Yes". This will be the "real" delta init, providing the data from the setup tables to Data Services.
Hope it helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Abhishek,
go through the link No extraction structure active or no BW connected | SCN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Abhishek,
Make sure remaining data sources are also active (vaitm,vascl....) see the picture attached by you.. it shows remaining ds's are in yellow ... make them green..
since setup tables will fill all the datasource's belongs to application 11.
let us know the result once after activating remaining ds's
Regards
Subbarao M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Before you go to RSA6 . First you activate the data source T-code RSA5 . Then you replicate.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.