Fill Internal Header Table for VBUK via Doc. Flow Predeces.

[Former Member]

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

[former_member182566 · Accepted solution]

Hi Anatolii,

Check OSS Note 1256679. It should solve your problem.

Rui

[Former Member · Accepted solution]

Hi Rui,

I have installed patches till 12 for DMIS, DMIS_CNT, and 6 for DMIS_EXT, so i think the corrections are already included.

Is there antoher way.

thanks in advanced

Anatolii

[former_member182566 · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Rui,

Do i have to stop the activity to solve the performance issue or while its running i can make the change?

if yes for stoping how to make this activity repeatable?

Best Regards

Anatolii

[former_member182566 · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks Rui,

i will try to make this change. Another question, can i check the % that has been completed for this activity? Maybe some transaction 😃

Anatolii

[Former Member]

Hi Rui,

It didn't work, is there another way to resolve this problem?

Anatolii

[Former Member]

Hi,

I woud suggest you to open a OSS message.

Regards

Raghuram

[Former Member]

Hi Raghuram,

I already wrote a OSS message to SAP, they are requesting a connection to the systems, but there are network problems from the client side, the connection is on for 10 minutes then it fails.

Is there another way, maybe some notes or advices?

Thanks in advanced

Anatolii

[Former Member]

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

[former_member182566]

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

[Former Member]

Hi Rui,

The indexes are used and the statistics is updated till 11.2009 for this table.

Regards, Anatolii

[Former Member]

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

[Former Member]

Hi Anatolii,

Can you tell which SAP version and which database version is being used?

Best regards,

Louis

[Former Member]

Hi Louis,

SAP version = SAP ERP Central Component 5.0

Database Version= Oracle 10.2.0.4.0

Regards,

Anatolii

[Former Member]

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

[Former Member]

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

[Former Member]

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