I am having problem while loading data from R/3 to BI 7. I have created a generic data source based on a view and I checked in rsa3 and it is fetching 19 records.
I replicated this data source in BI 7, created a cube, created transformations for the data source and then I schedule the info package and my requests are running for a very long time (about 10 hrs) in yellow status and finally failing. The processing step it has failed at is Call to BI. I checked the RFC connection to the source system and it is okay.
Here is the status:
Errors while sending packages from OLTP to BI
No IDocs could be sent to BI using RFC.
There are IDocs in the source system ALE outbox that did not arrive in the ALE inbox of BI.
Check the TRFC log.
You can access this log using the wizard or the menu path "Environment -> Transact. RFC -> In source system".
If the TRFC is incorrect, check whether the source system is fully connected to BI. In particular, check the authorizations of the background user in the source system.
Please let me know how to fix this problem.