We’re linking Data Services to SAP BW for the first time.
We can load Master data and even high volume master data >70k data successfully.
We however experience a time out when loading Transactional data .
So far we have discovered that we can get data packages to load to the DSO only when we have a very low “Rows Per Commit” setting against the target in Data Services build.
Any higher values result in timeouts.
Any advice would be great
I should add that we’re not using a batch file here but calling jobs through the 3rd part settings using the Repo/Jobname ; JobServer and Advanced Parameters of -r50000 -Kspsysconfigname
Also that the job completes successfully in Data Services.
More Info:
The RFC shows three records for the Request as below :-
06/22/2012 14:25:45 [ FINE ] Started processing RFC call to function: BAPI_ISOURCE_DP_REQUEST
06/22/2012 14:25:45 [ FINE ] Load Data Request Id <REQU_4Q5BVL49VYK7VS1FKV78Y2PM9>
06/22/2012 14:25:46 [ FINE ] Finished processing RFC call to function: BAPI_ISOURCE_DP_REQUEST
The DSO shows the same request ID as in the RFC but not all the records feed in from the source. ie the Request ends at the no. of records it’s loaded at the same point in time that the RFC call ‘finished’ e.g. 06/22/2012 14:25:46 . The Infocpakage then remains in a state of ‘not yet finished’ with only a partial load of data.
Wylie_Coyote_ (BOB member since 2011-10-03)