hold process while install SAPK-746AHINBICONT

[Former Member]

We have SAP NW 7.31 system on ORACLE 11.2.0.3.0 (Windows)

and during the installation of BI-CONT 7.46 in stage IMPORT_PROPER of installation process is frozen. In SM50 it looks

11    BGD    2684    On Hold    RFC    Yes

974    SAPLSTPA    000    DDIC

and in detail

Waiting for

Function / Conversation ID

since

Gateway BPC10.world.su

CMRCV / 26175095 / SYNC_CPIC

23:37:01

SMGW issues log, which I attached as a file to the message. In what could be the problem? Why "freeze" setting?

GM trace file.txt.zip

[Former Member · Accepted solution]

Thank you all! The problem was solved.

solution is to install two patches to the base ORACLE, with preliminary setback to the state "before patching",

p14543814_112030_MSWINx86
p14828076_112030_MSWINx86

After installing the patch ORACLE SAP was produced upgraded to SP6.

After restarting the system is working properly

[Former Member]

Hi Michael,

1)Check whether tp is connected to DB or not from STMS check tranport tool.

2) check if any tablespace is close to being full, if yes extend it by few GB.

3) paste the logs of /trans/tmp directory.

Thanks,

Het

[Former Member]

Think that transport logs would be very useful.

Please check them in STMS -> (F5)->Your System->Goto->tp System log

[Former Member]

In the log shows that the process can not access the file SAPKK-746ARINBICONT.BPC

slog1304.txt.zip

[Former Member]

Looks like tp process hangs.

1. Stop import process.
2. Kill all tp process on OS level.
3. Check DB for locks(DB01 transaction), if have any lock from tp process kill it.
4. Try import again.

[Former Member]

And, please, check oracle alert log for ORA-* errors.

You can find them here:

DBACOCKPIT-> Perfomance->Additional Functions->Alert Log

[Former Member]

Hi,

Please try to stop the system ->  make sure in OS Level that no sap services are running. If yes, kill it

Start the system and try to import it.

Thanks and Regards,

Vimal

[Former Member]

1. Process stoped

2. All process killed

3. No locks found in this transaction

4. trying it... but see in attached - no progress

1.txt.zip

[Former Member]

checked alerts, but see no havy problem. Although maybe I'm wrong

(see atached files)

alertlog_DBACOCPIT.txt.zip

alertlog_DBACOCPIT_onlyallerts.txt.zip

[Former Member]

More detailed guide to fix and clear hanging transport system:

http://basisbibo.blogspot.ru/2010/03/sap-transport-hang-transport.html

[Former Member]

Thank you, problem solved

http://scn.sap.com/message/13807482#13807482

[former_member185239]

Hi Michael,

Cancel the process and start it in dialog mode.

With Regards

Ashutosh

[Former Member]

On the stage "MAIN_IMPORT" another freeze, with no progress in clock

[Former Member]

Can you please provide the info that I requested?

Please check in SM21 any logs are getting updated as well as in ST22.

Thanks and Regards,

Vimal

[Former Member]

in ST22 no runtime error found.

in sm21 files is attached

sm21_log.txt.zip

[Former Member]

Hi,

Can you please check whether  any tablespaces are full?

Please attached the work processes of the background process which is in ONHOLD  to analyse further.

Thanks and Regards,

Vimal

[Former Member]

How do I determine whether or not enough tablespace oracle? Where to view messages or data that the Oracle of something missing?

I attached the data for the process (double click on the process, which has been frozen). This is what you asked for, or need any information? If so, tell me where they get here?

1.txt.zip

[Former Member]

Please go to DB02 -> Tablespaces -> overview -> See what is the space utilization.

Secondly, please attach the file of the background work process that is in on hold state . The file will be available in /usr/sap/SID/DV*/work

You can check the name of the file with the work processes number.  If you are unable to get it, please attach the screenshot SM50 . I will tell you the name of the file.

Thanks and Regards,

Vima

[Former Member]

All (and some files over) presents in attach.

in DB02  (DB02 -> Tablespaces -> overview) Table is empty but see info (in attached file - Tablespaces_detailed.txt) in detailed

Thank you for your support and interest in the my problem.

sm21_log.txt.zip

Tablespaces_detailed.txt.zip