Resolve inconsistencies in TABART-TABSPACE mapping

[Former Member]

Hi All,

I'm upgrading my ERP system from EhP4 ERP6 NW701 to EhP7 ERP6 NW74.

During the upgrade, at Extraction roadmap, the phase PREP_INIT/JOB_RSUPDTEC takes very long time.

The job was started at 4h ago and still running.

On the previous upgrade [Test System] this phase takes 5 minutos to complete. I really don't understand why this happen.

My Database version is Oracle 11.2.0.3. The OS is HP-UX.

Any ideas about how to solve this issue?

Thanks for advanced.

Regards, Serafim Carvalho

[Former Member · Accepted solution]

Hi All,

@Divyanshu

There is no log PSUPDTEC.ELG file. The only Log that exist is RSUPDTEC.LOG.

@ashish

This is weird because the table user_ind_columns that is shown by SM50 does not exist.

@Fernando

As you recommended, I increased the shared_pool_size to 2GiB and the sga_target to 3GiB. Then restarted the SAP and Database instance and the problem persists.

Thanks in advance,

Regards, Serafim Carvalho

[divyanshu_srivastava3 · Accepted solution]

Since you have done so many check, can please follow this note and try to do the analysis.

924840 - A background job unexpectedly runs for a long time

May be the job is completed but the status has not changed, select the job in transaction SM37 and choose 'Job -> check status' in the menu.

Regards,

Divyanshu

[ashish_vikas · Accepted solution]

please check below thread.. SAP had provided solution.

please also check below SAP Note which talks about performance problem for user_ind_columns

558197 - upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2,

best regards

ashish

best regards

ashish

[Former Member]

Hi All.

My problem is solved.

I tried everything you suggested but none of them works for me.

Then I check the thread that ashish vikas recommended. My problem was that the rule-based optimizer was set instead of cost-based optimizer.

I reset the parameter optimizer_mode as it was recomended from 1431798 - Oracle 11.2.0: Database Parameter Settings.

After the change, the phase took two minutes to be completed.

Thanks to you all for your answers and your time.

Regards, Serafim Carvalho

[Former Member]

That's good to hear!

[Former Member]

Thank you Serafim,

Your tip helped me.

Best Regards,

Claudio

[ashish_vikas]

please check below thread.. SAP had provided solution.

problem may be same for you.. user_ind_columns is view.

best regards

ashish

[ashish_vikas]

please also check below SAP Note which talks about performance problem for user_ind_columns

558197 - upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2,

best regards

ashish

[FFC]

Please check note 871455 - Bad performance acessing DBA and V$ views. 

[Former Member]

What is your Oracle patchlevel? And which kernel are you using now? Maybe you should patch both.

[Former Member]

Hi Daniel,

The oracle patchlevel is 11.2.0.3.5. The SAP Kernel is 720 PL400.

The upgrade of test and production system works fine.

Regards, Serafim Carvalho

[FFC]

Hi Serafim,

You need to check the running SQL statement and the shared_pool_size parameter.

Did you upgrade Oracle recently?

Regards,

[Former Member]

Hi All,

There is no log RSUPDTEC.<SID>. The only Log that exist is RSUPDTEC.LOG and it's updated with the following line:

2 ETQ399 'SUBST_CHECK_BATCHJOB' for JOBNAME='RSUPDTEC' JOBCOUNT='18414800' returns 'R'.

The full log is attached to this post.

Before the upgrade I have done the update statistics and the problem still the same.

When i check the session via transaction ST04 I found the PID of the process and the select that is being executed.

Any help is very welcome.

Thanks in advance,

Regards, Serafim Carvalho

PSUPDTEC.LOG.zip

[divyanshu_srivastava3]

Hi Serafim,

Can you also share PSUPDTEC.ELG file.

Regards,

Divyanshu

[ashish_vikas]

Hi Serafim,

please see details for that SQL, from which table it is reading data.

Try with manually creatig statistics for this table again and Repeat the phase.

best regards

ashish

[divyanshu_srivastava3]

Can you share current and last phase log files ?