Transports not working.. seems stuck in middle ....consistency check fails

[Former Member]

We are using 4.6C which oracle 10.

Transports in integration system seems stuck....There is this truck button for hrs.. tried deleting the request and reimporting again...nogo...

deleted the import queue,nogo..

STOP SET STOPMARK JVI 20100112085838 DDIC ssaptdb

INFO TBATG CONVERSION OF JVI N not needed DDIC ssaptdb

START tp_getprots JVI P 20100112085845 DDIC ssaptdb

Kindly help...

System Log: Local Analysis of ssaptdb 2

Time Ty. Nr Cl. Tcod MNo Text

02:54:04 BTC 41 090 D01 Transaction termination 15 100 ( )

08:46:09 BTC 39 000 F3T Invalid object name for TemSe object: "####################"

08:46:09 BTC 39 000 ECF Failed to create log for job

08:46:09 BTC 39 000 EAY Failed to read status entry for job

08:46:09 BTC 39 000 F20 Calling program reports invalid handle for TemSe object (magic==X'NULL-ptr')

Edited by: Priyanka Singh on Jan 12, 2010 11:19 AM

[Former Member]

Hi,

You may wish to review the following SAP notes:

Note 71353 - Transports hang during background steps

Note 690449 - Transport buffer lock file (.LOB) remains blocked on Windows

I have also seen the .LOB file issue on UNIX where the transport buffer lock file (<SID>.LOB) remains locked by the operating system.

Check in /usr/sap/trans/tmp for the presence of a file called .LOB

Regards,

Kevin (Revelation Software Concepts)

[Former Member]

Hi Priyanka,

Check the following if they are all ok.

1. Any file system full ,particularly /usr/sap/trans, /usr/sap/SID/<Instance>/work or /sapmnt/global

2. Check Tp connect command.Are you able to connect to database.

3. Check if you have free background processes while doing the transport and Check your spooler consistency with report RSPO1043 or sp12.

If every thing is ok.Kill tp for that particular transport,delete enteries from tables TRJOB and TRBAT and try running again.

Regards

Amit

Edited by: Amit Bangotra on Jan 13, 2010 4:42 PM

[Former Member]

Run an SP12 check. I also came across the same error here -> [Error at DB commit|http://sap.ittoolbox.com/groups/technical-functional/sap-basis/error-at-db-commit-return-code-001024-1317561]

[markus_doehr2]

Was that transport maybe created by a newer release than 4.6c?

Markus

[valeriocicchiel]

Hello Priyanka,

look at the log you posted, the problem is not strictly related to transport system

Check the fill level of file sytems, maybe you have a full file system

08:46:09 BTC 39 000 ECF Failed to create log for job

Valerio

[Former Member]

Hi,

I have checked the file system and datafiles and there is enough space..

kindly check.