on 09-16-2015 7:17 AM
Hello,
We are having an issue running in our R/3 system with BIREQU* jobs.
The job is taking long time after system's migration from another service provider.
The job which was taking around 1000 seconds before migration now takes approx. 30,000 seconds.
Also this happens only at a particular time (at around 17:30 CET) everyday.
The job runs at other times also but the run-time is normal (600 sec app.)
Please help me on this.
Thanks ,
Uday
Hi Uday ,
BIREQU * Jobs are BI Extraction Jobs . Though all of them start with BIREQU* , they might be essentialy totally different extraction Jobs .
You need to consult with your BI/BW team to confirm on the above and also find out what is the extraction which is running at around 5:30 PM
Possible cause 1 .
You may also need to check SMQS and SMQR and see how many trfc's process are allowed . , By default the number of parallel trfc's will be limited to 2 ( to a BI/BW system from R/3) , You might need to increase this to a higher value ( Depending on the number of dialog process you have )
Possible cause 2 .
The BI team might be doing a full extraction every time after the upgrade . If this is the case check with them whether delta extarctions are possible
Possible cause 3
Hardware bottleneck around that time . ( Like backup / other parallelly running jobs / Insufficient Dialog work process for th e TRFC
Take a trace of the job using ST12 , and see where the maximum runtime is cunsumed . Ie is it at the database / ABAP level .
Anyways you will need to closely work with the BW team to sort out this issue
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello there,
Is there any major difference between the "job log" from the execution with normal runtime and the affected ones?
Cheers,
Ian.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Udaya,
Could there be backup process running and locking the records at that time of the day?
Regards,
Yuksel AKCINAR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.