on 11-19-2009 8:45 AM
Good Day,
I'd executed the step Fill Internal Header Table for VBUK via Doc. Flow Predeces in System Analysis Phase. It has been running for the past 7 days. We know that the problem might be that the "update statistics" is not updated since Febraury this year, this table has 20 million records.
Is there a possibility or how or where to find how much time is left, how many records it has been analyzed for this activity?
Thanks in advanced.
Anatolii
Hi Anatolii,
Check OSS Note 1256679. It should solve your problem.
Rui
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi again Anatolii,
I don't think the index on VBFA will be created by the SP's.
Actually, I would consider it bad news if TDMS support packages were messing with my ERP standard tables (and you can see in the note that it is considered a step to "further improve the performance").
Check table VBFA in the sender system, and create the index by MANDT + VBELN + VBELV + POSNV if it doesn't exist already.
I would try to create it while running: the database should be able to pick the index in the next select it makes to vbfa (you might need to update statistics for the index; talk to a db guy if you are not one).
If it doesn't work, you can cancel the activity and restart it, no problem with that either.
Hi Rui,
It didn't work, is there another way to resolve this problem?
Anatolii
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I would then recommend you to open connection to some other system and provide a SM59 connection thorugh the system where network is proper. Its really difficult to say without looking into the system.
Did you check if the index existed at DB level? Did you stop and restart the process?
Regards
Raghuram
Hi Anatolii,
To confirm you have the index created and working I would do the following:
1) Go to ST05 in the sender system, and choose button "Enter SQL statement"
2) Enter the following select:
SELECT *
FROM VBFA
WHERE MANDT = :A1
AND VBELN = :A2
3) Press button "Explain" and check in the execution plan if the index is being used (or post it here so we can analyse it).
If the index is being used, and just to be sure, you can also go to SM50 and there you should have a process running for user RFCTDMS (probably accessing table VBFA). Double click the table name, copy the SQL statement that is shown, and analyse it in ST05.
Edited by: Rui Pedro Dantas on Nov 23, 2009 12:44 PM
Raghuram,
The admins from the client side are trying to give some connection.
The indexes are used in DB and in ERP in the sender system.
First time execution the statistics where not update (since 02.2009) it lasted 8 days.
after the update it's still running (already 3 days)
Regards,
Anatolii
Edited by: Anatolii Kozub on Nov 23, 2009 12:59 PM
Hello Anatolii,
Is the VBUK activity still running at the moment?
If so can you execute transaction st04old and choose the detail analysis menu?
Afterwards choose oracle session and check which sql statement is being executed at the moment.
If you click the sql statement you will be able to explain and check if the index on vbfa is being used.
Kind regards,
Louis
Hi ...Try the following steps ..stop running job for VBUK and set the parameter P_CLU for the activites :
1. TD05X_FILL_VBUK
2. TD05X_FILL_VBUK_1
3. TD05X_FILL_VBUK_2
To set the parameter please select the activity and click on the
troubleshooing button.This would call the trouble shooter assigned for
the activity and there you can set the parameter P_CLU to X.
After setting the parameter please restart the activity
"TD05X_FILL_VBUK" from the process tree and once it is over then please
start the activity TD05X_FILL_VBUK_1.
Also, please create the secondary index on table VBFA in Sender
system as mentioned in note number 1256679.Once you have set the
parameter and created the index then you can start the activity from the process tree.ALso you can increase the value of parameter P_PARA if you have sufficient number of dialog processes available
Thank You very much dear colleagues for your advices and help!!!!!
I was able to resolve this problem with the following:
(as you told me before) Create standard M1 Index, in my case ZM1, with the field parameters VBEL, POSNV and VBELN ( MANDT it was not needed)
Using HINTS parameters from "Note 130480 - Database Hints in Open SQL for Oracle"
and changing the program: "CNV_TDMS_05_TI_I_CO_VBUK_2_C_N" in the sender system
before it was:
%_HINTS ORACLE 'full(VBFA) parallel(VBFA, 4)'. "#EC CI_NOFIRST
i was changed to:
%_HINTS ORACLE 'INDEX("&TABLE&" "VBFA~ZM1" "VBFA^ZM1")'. "#EC CI_NOFIRST
The Procedure finished successfully 😃
With best regards,
Anatolii
User | Count |
---|---|
86 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.