We created a Generic DataSource on top of a Custom Built Z table . Replicated the DataSource (Solution Manager- DEV) Successfully to BI Dev enviornment. Extarcted data as well. Problem arises when we try to Transport the Generic Data Source from Solution Manager Dev to Solution Manager Prod enviornment.
1. Extract Structure is active for the Generic DataSource but activates with Error Message: TABL ZOXDEV0024 activated
Check table ZOXDEV0024
Enhancement category for table missing
Enhancement category for include or subtype missing
Table ZOXDEV0024 was checked with warnings
2.Transport Fails from DEV to PROD with following Error:
Post-import method RSA2_DSOURCE_AFTER_IMPORT started for OSOA L, date
and time: 20071210155151
Extract structure ZOXSMD0003 is not active
The extract structure ZOXSMD0003 of the DataSource
ZDATASOURCE is invalid
Errors occurred during post-handling RSA2_DSOURCE_AFTER_IMPORT for
RSA2_DSOURCE_AFTER_IMPORT belongs to package RSUM
The errors affect the following components:
BC-BW (BW Service API)
Post-import method RSA2_DSOURCE_AFTER_IMPORT completed for OSOA L,
date and time: 20071210155152
Post-import methods of change/transport request SMDK900294 completed
Start of subsequent processing ... 20071210155150
End of subsequent processing... 20071210155152
Thanks in advance!
Just a couple of checkpoints,
Please check if the table on top of which the datasource was created exists in the target system ( in this case the production system).
Also check if the datasource has been replicated in the system. Please go onto the source system in which the datasource exists (After it has been transported in that particular system) and replicate the Source system for the datasources.
That would bring in the extract structure from the source system into BW system. Once thats done you can go ahead and import the actual transport of the datasource and you should be fine.
Let me know if this answers your question. If so please award the points. If not let me know more details and I will provide you more details regarding the same.