Support pack implimentation error

[Former Member]

I have installed a new BI system. And completed the patching for JAVA Stack. Now i started with ABAP and in need to install some add-on as well.

My deployment has been stopped with below error.

SQL error 121 occured: TCP Provider: The semaphore timeout period has expired.Communication link failure

Here is the complete error from sapmnt\trans\log\SAPIIBIII1.<SID> file

[dev trc ,00000] ParamStmtExec: line 13472. hr: 0x80004005 Communication link failure

4 ETW000 175 425.786448

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13472]: Error/Message: (err 121, sev 0), Communication link failure

4 ETW000 70 425.786518

4 ETW000 [dev trc ,00000] Procname: [##Y4GOLITSAPqbg00000042840000177083154655]

4 ETW000 30 425.786548

4 ETW000 [dev trc ,00000] sloledb.cpp [ParamStmtExec,line 13472]: Error/Message: (err 121, sev 0), TCP Provider: The semaphore timeout period has expired.

4 ETW000 120 425.786668

4 ETW000 [dev trc ,00000] Procname: [##Y4GOLITSAPqbg00000042840000177083154655]

4 ETW000 29 425.786697

4 ETW000 [dev trc ,00000] dbdsmss: DBSL99 SQL121 49 425.786746

4 ETW000 [dev trc ,00000] TCP Provider: The semaphore timeout period has expired.Communication link failure

4 ETW000 33 425.786779

4 ETW000 [dbds ,00798] ***LOG BY2=>sql error 121 performing EXE [dbds#1 @ 798]

4 ETW000 28291 425.815070

4 ETW000 [dbds ,00798] ***LOG BY0=>TCP Provider: The semaphore timeout period has expired.Communication link failure [dbds#1 @ 798]

4 ETW000 35 425.815105

1AETW000 SQL error 121 occured: TCP Provider: The semaphore timeout period has expired.Communication link failure

2EETW000 Please contact the SAP support.

4 ETW000 [dev trc ,00000] RollbackTx: line 7599. hr: 0x8000ffff Unable to open a logical session

4 ETW000 17231 425.832336

4 ETW000 [dev trc ,00000] sloledb.cpp [RollbackTx,line 7599]: Error/Message: (err -1, sev 0), Unable to open a logical session

4 ETW000 49 425.832385

4 ETW000 [dev trc ,00000] Procname: [ROLLBACK] 17 425.832402

4 ETW000 [dev trc ,00000] sloledb.cpp [RollbackTx,line 7599]: Error/Message: (err -1, sev 0), SMux Provider: Physical connection is not usable [xFFFFFFFF].

4 ETW000 104 425.832506

4 ETW000 [dev trc ,00000] Procname: [ROLLBACK] 17 425.832523

4 ETW000 [dev trc ,00000] Rollback Work (8) 25 425.832548

4 ETW000 [dbcon ,02947] ***LOG BZY=>unexpected return code 8 calling DbSlRollba [dbcon#7 @ 2947]

4 ETW000 9269 425.841817

4 ETW000 [dbcon ,02950] ***LOG BYJ=>database function ROLLBACK for connection R/3 failed [dbcon#7 @ 2950]

4 ETW000 36 425.841853

4 ETW000 [dbcon.c ,00000] *** ERROR => DISTRIBUTED_TA_FAILED: 35 425.841888

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = ACTIVE , perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 38 425.841926

3WETW000 ROLLBACK failed (15951307).

4 ETW000 End of Transport (0016).

4 ETW000 date&time: 14.04.2009 - 15:54:01

4 ETW000 1 warning occured.

4 ETW000 2 errors occured.

1 ETP154 MAIN IMPORT

1 ETP110 end date and time : "20090414155401"

1 ETP111 exit code : "16"

1 ETP199 ######################################

Can somebody help me..please

Regards

Jose

[JPReyes · Accepted solution]

Is the CI and DI in the same host?

Usually this error happens when a connection to a remote SQL db timeout and the connection drops...

Theres quite a few notes in MS technet about it... most of then refering to a network issue.

Regards

Juan

[Former Member · Accepted solution]

Hello Juan,

Yes.. CI and DI on different host.... If this causing the issue, Wt's the work around ?

Jo

[JPReyes · Accepted solution]

This must be a one off thing maybe a blink on your network... have you tried to resume the patching?....

Regards

Juan

[Former Member · Accepted solution]

Yes.. i resume it.. It's at the same phase.. Not yet pop-up any errors...But i don't see any progress as well..no new logs are written at OS level. No DIA is running in SM50... if i see at action log of queue

Import phase 'AUTO_MOD_SPDD' (16.04.2009, 09:09:22)

Import phase 'AUTO_MOD_SPDD' was already processed -> skip phase

Import phase 'RUN_SPDD_?' (16.04.2009, 09:09:22)

Import phase 'RUN_SPDD_?' was already processed -> skip phase

Import phase 'DDIC_ACTIVATION' (16.04.2009, 09:09:22)

Import phase 'DDIC_ACTIVATION' was already processed -> skip phase

Import phase 'IMPORT_PROPER' (16.04.2009, 09:09:22)

yesterday full night it was running.. now i stopped and restarted agian.. it's running from the last 1 and half hours now..

jo

[former_member185031 · Accepted solution]

What i have seen in my experiences on Distrributed Environments, If you have extraced the file into the EPS/in directory of CI then You should start the SPAM from CI only, otherwise it gives some error because it is not able to read the queue if you start the SPAM from your DI

Regards,

Subhash

[Former Member · Accepted solution]

Hello Subhash,

I am running the SAINT ( not SPAM ) from the CI host only. i have installed sapgui on that server and running the patchng..

Anyidea..where can i check the network timeouts.. !!

Tnx...Jo

[Former Member · Accepted solution]

Error at "SAINT: Action log of Queue "

Import phase 'IMPORT_PROPER' (14.04.2009, 14:51:15)

Error during executing the tp command 'tp IMPORT all QBG ...'

Could not start transport control program tp

Interrupt the import due to an error situation (14.04.2009, 15:54:14)

Display detailed informations concerning the error in phase 'IMPORT_PROPER'

Abort the import due to an error situation (14.04.2009, 15:55:04)

Tnx - Jo

[Former Member · Accepted solution]

Hello Jose,

We had similar issues, and has been solved by a tp upgrade. You could try that, if not yet

Regards

Dinu

[Former Member · Accepted solution]

Hi,

It helped me..It seems to be running now.

Thx..Jo

[Former Member]

Hi Jose,

This is likely to be a connectivty or a configuration issue. Are you applying the packages across a mounted file system (check on possible timing issues)? That might be one place to look.

Hope that is helpful.

J. Haynes

[Former Member]

Hello Joe,

The trans directory is local for this system. It's like this
<local host>\sapmnt\trans ...

Does it have an impact ??

FYI: i have windown + SQL ( Distributed installation )

Jo