cancel
Showing results for 
Search instead for 
Did you mean: 

nw 70 request in status import a long time

Former Member
0 Kudos

I made next step for resolution this problem

I run RDDNEWPP in 000 and other client

I deleted all request with status import in Import Monitor

I checked free background processes.

But it is not help me.

What can i check yet?

PS

When the problem happened our developer made import with many request jobs(10000 per/hour).

I sheduled RDDNEWPP with priorytet A, But only one of two instance have convigured backround job class A.

START tp_getprots QUA Q 20110714124754 ANDRUH AlICE-QUA-DI 20110714124720865

STOP tp_getprots QUA Q 20110714124758 ANDRUH AlICE-QUA-DI 20110714124720865

STOP INFORM SAP-SYSTEM OF QUA Q 20110714124758 ANDRUH AlICE-QUA-DI 20110714124720865

START imp single QUA 20110714125238 ANDRUH AlICE-QUA-DI 20110714125237367

START DD IMPORT QUA H 20110714125238 ANDRUH AlICE-QUA-DI 20110714125237367

STOP DD IMPORT QUA H 20110714125245 ANDRUH AlICE-QUA-DI 20110714125237367

START DD ACTIVATION QUA A 20110714125245 ANDRUH AlICE-QUA-DI 20110714125237367

START tp_getprots QUA J 20110714125245 ANDRUH AlICE-QUA-DI 20110714125237367

START imp single QUA 20110714125916 LONG ClustErpQUA 20110714125915363

START DD IMPORT QUA H 20110714125917 LONG ClustErpQUA 20110714125915363

STOP DD IMPORT QUA H 20110714125919 LONG ClustErpQUA 20110714125915363

START tp_getprots QUA J 20110714125919 LONG ClustErpQUA 20110714125915363

START imp single QUA 20110714132306 ANDRUH AlICE-QUA-DI 20110714132305175

START DD IMPORT QUA H 20110714132306 ANDRUH AlICE-QUA-DI 20110714132305175

STOP DD IMPORT QUA H 20110714132308 ANDRUH AlICE-QUA-DI 20110714132305175

START tp_getprots QUA J 20110714132308 ANDRUH AlICE-QUA-DI 20110714132305175

STOP tp_getprots QUA J 20110714132357 ANDRUH AlICE-QUA-DI 20110714132305175

START DD ACTIVATION QUA A 20110714132427 ANDRUH AlICE-QUA-DI 20110714132305175

START tp_getprots QUA J 20110714132458 ANDRUH AlICE-QUA-DI 20110714132305175

STOP tp_getprots QUA J 20110714132530 ANDRUH AlICE-QUA-DI 20110714132305175

STOP DD ACTIVATION QUA A 20110714132601 ANDRUH AlICE-QUA-DI 20110714132305175

START DISTRIBUTION OF DD-O QUA S 20110714132632 ANDRUH AlICE-QUA-DI 20110714132305175

START tp_getprots QUA S 20110714132703 ANDRUH AlICE-QUA-DI 20110714132305175

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

now i have problem with realising request from dev(status : update required)

Former Member
0 Kudos

Thank all!!!!

Former Member
0 Kudos

It may be error when i tested tp with wrong parametr

c:\usr\sap\QUA\DVEBMGS06\exe>r3trans -d

This is r3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).

unicode enabled version

r3trans finished (0000).

c:\usr\sap\QUA\DVEBMGS06\exe>tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_D

OMAIN_PRD.PFL

initial value of NLS_LANG: '<NULL>'

This is tp version 372.05.17 (release 700, unicode enabled)

Connection to Database of QUA was successful.

This is R3trans.exe version 6.14 (release 700 - 19.01.11 - 11:44:00).

unicode enabled version

R3trans.exe finished (0000).

tp finished with return code: 0

meaning:

Everything OK

C:\usr\sap\QUA\D00\exe>tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMA

PRD.PFL

initial value of NLS_LANG: '<NULL>'

This is tp version 372.05.17 (release 700, unicode enabled)

Connection to Database of QUA was successful.

This is R3trans.exe version 6.14 (release 700 - 19.01.11 - 11:44:00).

unicode enabled version

R3trans.exe finished (0000).

tp finished with return code: 0

meaning:

Everything OK

C:\usr\sap\QUA\D00\exe>r3trans -d

This is r3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).

unicode enabled version

r3trans finished (0000).

C:\usr\sap\QUA\D00\exe>

Former Member
0 Kudos

SLOG

INFO TBATG CONVERSION OF QUA N not needed ANDRUH ClustErpQUA 20110714150124604

START tp_getprots QUA P 20110714165936 ANDRUH ClustErpQUA 20110714150124604

START imp single QUA 20110714170222 DRIZIN AlICE-QUA-DI 20110714170223546

INFO TBATG CONVERSION OF QUA N not needed DRIZIN AlICE-QUA-DI 20110714170223546

START tp_getprots QUA P 20110714170223 DRIZIN AlICE-QUA-DI 20110714170223546

ULOG

APServiceQUA 20110714163141 RFC: tp SHOWPARAMS QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=3540)

APServiceDEV 20110714163558 RFC: tp EXPCHK DEVK908870 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=4236)

APServiceDEV 20110714163601 RFC: tp WRITELOG DEVK908870 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL e 0000 DEV -Dtransdir=
sap-trans\sapmnt\trans (pid=4236)

APServiceDEV 20110714163602 RFC: tp EXPWBO DEVK908870 client160 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL FEEDBACK ASYNCEXP -Dtransdir=
sap-trans\sapmnt\trans (pid=4236)

APServiceQUA 20110714163647 RFC: tp IMPORT DEVK908870 QUA clires150 U0 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL FEEDBACK ASYNCIMP -Dimpmon_mode=DETAILED -Dtransdir=
sap-trans\sapmnt\trans (pid=3492)

quaadm 20110714164152 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=7520)

licesqlstart 20110714164220 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=2008)

licesqlstart 20110714164245 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=2860)

licesqlstart 20110714164449 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=5708)

licesqlstart 20110714164656 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=5924)

APServiceDEV 20110714165322 RFC: tp SHOWPARAMS DEV pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=3592)

APServiceDEV 20110714165400 RFC: tp SHOWPARAMS DEV pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=4240)

APServiceDEV 20110714165441 RFC: tp SHOWPARAMS DEV pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=5096)

APServicePRD 20110714165505 RFC: tp SHOWPARAMS PRD pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=5144)

APServiceQUA 20110714165542 RFC: tp SHOWPARAMS QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=7084)

APServiceQUA 20110714165857 RFC: tp CONTP QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=7036)

APServiceQUA 20110714165857 RFC: tp CONNECT QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=7036)

APServiceQUA 20110714170010 RFC: tp CONTP QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=3880)

APServiceQUA 20110714170010 RFC: tp CONNECT QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=3880)

APServiceQUA 20110714170222 RFC: tp IMPORT DEVK908870 QUA clires150 U0 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL FEEDBACK ASYNCIMP -Dimpmon_mode=DETAILED -Dtransdir=
sap-trans\sapmnt\trans (pid=3584)

APServiceQUA 20110714170520 RFC: tp SHOWPARAMS QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=8160)

licesqlstart 20110714170939 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=4060)

licesqlstart 20110714170948 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=4728)

quaadm 20110714171058 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=4216)

quaadm 20110714171220 : tp connect QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL (pid=5048)

APServiceQUA 20110714171324 RFC: tp SHOWPARAMS QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=6436)

APServiceQUA 20110714171545 RFC: tp IMPORT SUBSET QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL FEEDBACK ASYNCIMP -Dimpmon_mode=DETAILED -Dtransdir=
sap-trans\sapmnt\trans (pid=4504)

SUBSET means in detail: DEVK908782 DEVK908863 (pid=4504)

APServiceDEV 20110714171741 RFC: tp EXPCHK DEVK908872 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=680)

APServiceDEV 20110714171745 RFC: tp WRITELOG DEVK908872 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL e 0000 DEV -Dtransdir=
sap-trans\sapmnt\trans (pid=680)

APServiceDEV 20110714171746 RFC: tp EXPWBO DEVK908872 client150 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL FEEDBACK ASYNCEXP -Dtransdir=
sap-trans\sapmnt\trans (pid=680)

APServiceQUA 20110714171817 RFC: tp IMPORT DEVK908872 QUA clires200 U0 pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL FEEDBACK ASYNCIMP -Dimpmon_mode=DETAILED -Dtransdir=
sap-trans\sapmnt\trans (pid=7160)

APServiceQUA 20110714172026 RFC: tp SHOWPARAMS QUA pf=
sap-trans\sapmnt\trans\bin\TP_DOMAIN_PRD.PFL -Dtransdir=
sap-trans\sapmnt\trans (pid=6936)

Edited by: Stanislav Drizin on Jul 14, 2011 3:22 PM

Edited by: Stanislav Drizin on Jul 14, 2011 3:25 PM

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

As you can clearly see in logs, tp is not able to connect to database. Run command R3trans -d and check whether system is able to connect to database or not.

Thanks

Sunny

former_member185031
Active Contributor
0 Kudos

Check the ULOG and SLOG file for more information in transport log directory.

Regards,

Subhash