Support pack taking more time

[Former Member]

Dear Team,

When I am applying Basis Support pack KB70010 in my IDES.

It is executing last 4 hours in Import Queue

and bottum side is comming

EXECUTING OF REPORTS AFTER PUT.

What to do Now.

Manu

[Former Member]

Hi Manu ,

I suggest you to Run a Check and update optimizer statistics either using db13 or BRTOOLS

it should solve your problem

regards

George Varghese

[Former Member]

Hello manu

Just check the logs \usr\sap\trans\log\slog

\usr\sap\trans\log\ulog

\usr\sap\trans\log\alog for the status of process

if any any background jobs are scheduling or active,pause them using BTCTRNS1 program

resume them using BTCTRNS2 program

Regards

Amar

[former_member204746]

"REPORTS AFTER PUT" means that ABAP jobs are running.

so, in SM37, check for active jobs. if this is the case, continue to wait.

[Former Member]

I am checking in SM37.one Active job RDDEXECEL with DDIC user.

and I have check SM50 one Background job is running.

Now this job is run last 8 hours . What to do?

Thanks

manu

m

[markus_doehr2]

Is the system still doing something? You see activity on harddisk? CPU usage? If this is Oracle, you've got an archiver stuck? Did you update your database statistics before?

Markus

[Former Member]

Manu

couple of things

1. in SM50,is the background job doing some actions like updating,deleting or is it stuck up on one action only

2. I would suggest you to login in 000 and check for all the scheduled and released jobs with R*.

If they are in released status just start them and I assure you ur supposr pack will run through

If these thibgs dont help let me know

Rohit

[former_member204746]

Are you on ORacle? If so, at run this at OS level and cross your fingers.

brconnect -c -u / -f stats -t all

[Former Member]

hi Eric,

I dont think updating the stats is at all a gud option

[Former Member]

it still running . all drive space is ok. Cpu is ideal. what should activity i do at this time.

manu

[Former Member]

Hi Manu,

When you run the stats last time.

Try running the stats for all table.

Cheers

Deepanshu

[Former Member]

Hi Manu,

did u saw what I posted in the last note:

couple of things

1. in SM50,is the background job doing some actions like updating,deleting or is it stuck up on one action only

2. I would suggest you to login in 000 and check for all the scheduled and released jobs with R*.

If they are in released status just start them and I assure you ur support pack will run through

If these things dont help let me know

Rohit

[Former Member]

Dear Team

Now I have cancelled this Job. Now When I run Tcode SPAM .It show in Red color XPRA_EXECUTION

How I clear this Error Log. How I can Delete this Support pack from OS Level,

Thanks

Manu

[Former Member]

XPRA_EXECUTION is the very common error during SP upgrade. See notes 954792.

In a nutshell you can correct this error by performing "Modification Adjustment".

In SPAM go to 'Extras' -> 'Modification Adjustment'

Rgds,

SK

[Former Member]

Hi,

See if

SAP Note 822379

helps you.

Manoj

[former_member204746]

go into SPAM, client 000 and click on the TRUCK icon.

you must complete applying this support pack... or restore from last backup.

[Former Member]

Hi Manu,

tp showbuffer <SID> pf=\usr\sap\trans\bin\TP_DOMAIN_<SID>.PFL

Check the same or or restore from last backup.

Cheers

Deepanshu

[former_member204746]

were you able to complete the support packs?

Please don't leave hanging topic like this one and then close them one month later.

[Former Member]

Hi Manu,

When you run the stats last time.

Cheers

Deepanshu

[Former Member]

Is there any error in the import log?

Also check that your import log directory time to time...

Rgds,

SK

[Former Member]

Have you run it background in dialog? I would suggest Let it run for some more time

check in SM50 whether any processes are running for this pack upgrade,check in SM37 if there are any jobs stuck with released status during the period.

get this info.

Rohit