import ABAP failed jobs

[Former Member]

Hi,

     I am trying to install ABAP application server with netweaver gateway trial version. While installing some jobs were failed.

java version "1.8.0_51"

Java(TM) SE Runtime Environment (build 1.8.0_51-b16)

Java HotSpot(TM) 64-Bit Server VM (build 25.51-b03, mixed mode)

Import Monitor jobs: running 1, waiting 5, completed 28, failed 0, total 34.

Import Monitor jobs: running 2, waiting 4, completed 28, failed 0, total 34.

Import Monitor jobs: running 3, waiting 3, completed 28, failed 0, total 34.

Loading of 'SAPSLOAD' import package: ERROR

Import Monitor jobs: running 2, waiting 3, completed 28, failed 1, total 34.

Loading of 'D010INC' import package: ERROR

Import Monitor jobs: running 1, waiting 3, completed 28, failed 2, total 34.

Loading of 'D010TAB' import package: ERROR

Import Monitor jobs: running 0, waiting 3, completed 28, failed 3, total 34.

Import Monitor jobs: running 1, waiting 2, completed 28, failed 3, total 34.

Import Monitor jobs: running 2, waiting 1, completed 28, failed 3, total 34.

Loading of 'SAPSLEXC' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 28, failed 4, total 34.

Loading of 'WBCROSSGT' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 28, failed 5, total 34.

How to resolve these failed jobs? I think because of these errors I am getting another error saying "Migration monitor exits error 103".

Could any body suggest me how to resolve those errors.

Thanks and Regards,

Teja.

[former_member182967]

Hi Teja,

Please check log SAPSLOAD.log and D010INC.log under installation log directory.

Regards,

Ning

[Former Member]

Hi Ning,

SAPSLOAD.log:

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160611172230

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Apr  8 2012 23:30:51

patchinfo (patches.h): (0.211) NewDB R3load support import splitting tables (note 1651927)

process id 6472

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe -ctf I D:\ABAP_Trial_7_02_SP11_Win_64_bit_Version_with_Gateway_2_0_SP04\NWABAPTRIAL70211_64_GW204\SAP_NetWeaver_702e_Export\DATA_UNITS\EXP1\DATA\SAPSLOAD.STR C:\Program Files\sapinst_instdir\NW702\AS-ABAP\ADA\CENTRAL\DDLADA.TPL SAPSLOAD.TSK ADA -l SAPSLOAD.log

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: job completed

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160611172230

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160611172232

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Apr  8 2012 23:30:51

patchinfo (patches.h): (0.211) NewDB R3load support import splitting tables (note 1651927)

process id 7112

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLOAD.cmd -dbcodepage 4103 -l SAPSLOAD.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

(DB) INFO: connected to DB

(DB) INFO: The MaxDB logwriter is switched off#20160611172234

(DB) INFO: Maxdb Kernel version 7.8.02.028                     

                         SQLDBC 7.8.2.028               

(GSI) INFO: dbname   = "NSP                                                                                                                             "

(GSI) INFO: vname    = "ADABAS D                        "

(GSI) INFO: hostname = "Welcome-PC                                                      "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "WELCOME-PC"

(GSI) INFO: release  = "6.1"

(GSI) INFO: version  = "7601 Service Pack 1"

(GSI) INFO: machine  = "2x AMD64 Level 6 (Mod 42 Step 7)"

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file D:\ABAP_Trial_7_02_SP11_Win_64_bit_Version_with_Gateway_2_0_SP04\NWABAPTRIAL70211_64_GW204\SAP_NetWeaver_702e_Export\DATA_UNITS\EXP1\DB/SQLFiles.LST

(SQL) INFO: D:\ABAP_Trial_7_02_SP11_Win_64_bit_Version_with_Gateway_2_0_SP04\NWABAPTRIAL70211_64_GW204\SAP_NetWeaver_702e_Export\DATA_UNITS\EXP1\DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file SLOAD.SQL

(SQL) INFO: SLOAD.SQL not found

(SQL) INFO: Searching for SQL file D:\ABAP_Trial_7_02_SP11_Win_64_bit_Version_with_Gateway_2_0_SP04\NWABAPTRIAL70211_64_GW204\SAP_NetWeaver_702e_Export\DATA_UNITS\EXP1\DB/ADA/SLOAD.SQL

(SQL) INFO: D:\ABAP_Trial_7_02_SP11_Win_64_bit_Version_with_Gateway_2_0_SP04\NWABAPTRIAL70211_64_GW204\SAP_NetWeaver_702e_Export\DATA_UNITS\EXP1\DB/ADA/SLOAD.SQL not found

(DB) INFO: BADIISIMPLED created#20160611172236

(DB) INFO: BADIISIMPLED~0 created#20160611172236

(IMP) INFO: import of BADIISIMPLED completed (193 rows) #20160611172236

(DB) INFO: ENH4DELTAB created#20160611172237

(DB) INFO: ENH4DELTAB~0 created#20160611172237

(IMP) INFO: import of ENH4DELTAB completed (0 rows) #20160611172237

(DB) INFO: FIELDDIFTB created#20160611172237

(DB) INFO: FIELDDIFTB~0 created#20160611172237

(IMP) INFO: import of FIELDDIFTB completed (0 rows) #20160611172237

(DB) INFO: O2PAGTLIB created#20160611172237

(DB) INFO: O2PAGTLIB~0 created#20160611172238

(IMP) INFO: import of O2PAGTLIB completed (1052 rows) #20160611172238

(DB) INFO: SPROXMATCHINTF created#20160611172239

(DB) INFO: SPROXMATCHINTF~0 created#20160611172239

(IMP) INFO: import of SPROXMATCHINTF completed (7 rows) #20160611172239

(DB) INFO: SPROXMATCHINTF~ID created#20160611172240

(DB) INFO: SPROXSIG created#20160611172241

(DB) INFO: SPROXSIG~0 created#20160611172241

(IMP) INFO: import of SPROXSIG completed (7009 rows) #20160611172249

(DB) INFO: SPROXSIG~A created#20160611172251

(DB) INFO: SPROXSVARDAT created#20160611172251

(DB) INFO: SPROXSVARDAT~0 created#20160611172251

(IMP) INFO: import of SPROXSVARDAT completed (66 rows) #20160611172300

(DB) INFO: SPROXUITEXTS created#20160611172300

(DB) INFO: SPROXUITEXTS~0 created#20160611172300

(IMP) INFO: import of SPROXUITEXTS completed (0 rows) #20160611172300

(DB) INFO: SPROXUITEXTS~CMP created#20160611172300

(DB) INFO: SPROXUITEXTS~LAN created#20160611172300

(DB) INFO: SPROXXSL created#20160611172301

(DB) INFO: SPROXXSL~0 created#20160611172301

(IMP) INFO: import of SPROXXSL completed (5 rows) #20160611172302

(DB) INFO: SPROXXSL~NAM created#20160611172303

(DB) INFO: SPROXXSLT created#20160611172303

(DB) INFO: SPROXXSLT~0 created#20160611172303

(IMP) INFO: import of SPROXXSLT completed (0 rows) #20160611172303

(DB) INFO: SPROXXSLTN created#20160611172303

(DB) INFO: SPROXXSLTN~0 created#20160611172304

(IMP) INFO: import of SPROXXSLTN completed (0 rows) #20160611172304

(DB) INFO: SPROXXSLV created#20160611172304

(DB) INFO: SPROXXSLV~0 created#20160611172304

(IMP) INFO: import of SPROXXSLV completed (6 rows) #20160611172306

(DB) INFO: TDDIR created#20160611172306

(DB) INFO: TDDIR~0 created#20160611172306

(IMP) INFO: import of TDDIR completed (0 rows) #20160611172306

(DB) INFO: TDDIRS created#20160611172306

(DB) INFO: TDDIRS~0 created#20160611172307

(IMP) INFO: import of TDDIRS completed (0 rows) #20160611172307

(DB) INFO: WDR_RR_LOAD created#20160611172307

(DB) INFO: WDR_RR_LOAD~0 created#20160611172307

(IMP) INFO: import of WDR_RR_LOAD completed (1340 rows) #20160611172428

(DB) INFO: WDY_WB_GENINFO created#20160611172430

(DB) INFO: WDY_WB_GENINFO~0 created#20160611172431

(IMP) INFO: import of WDY_WB_GENINFO completed (8891 rows) #20160611172433

(DB) INFO: WDY_WB_GENINFO~001 created#20160611172433

(DB) INFO: WDY_WB_GENINF_VS created#20160611172434

(DB) INFO: WDY_WB_GENINF_VS~0 created#20160611172434

(IMP) INFO: import of WDY_WB_GENINF_VS completed (3 rows) #20160611172434

(DB) INFO: WDY_WB_SOURCEMAP created#20160611172435

(DB) INFO: WDY_WB_SOURCEMAP~0 created#20160611172435

(IMP) INFO: import of WDY_WB_SOURCEMAP completed (15123 rows) #20160611172452

ERROR : Execute for create index STERM_LINK~004 on STERM_LINK failed (dbrc=102).

  (SQL error -955)

  error message returned by DbSl:

SQL-Statement: CREATE  INDEX "STERM_LINK~004" ON "STERM_LINK" ( "CONCEPT"  ) 

POS(1) Duplicate name

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160611172453

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160611183612

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Apr  8 2012 23:30:51

patchinfo (patches.h): (0.211) NewDB R3load support import splitting tables (note 1651927)

process id 3892

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLOAD.cmd -dbcodepage 4103 -l SAPSLOAD.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: db_connect rc = 256

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: DbSlErrorMsg rc = 99

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160611183613

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160611184007

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Apr  8 2012 23:30:51

patchinfo (patches.h): (0.211) NewDB R3load support import splitting tables (note 1651927)

process id 3516

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLOAD.cmd -dbcodepage 4103 -l SAPSLOAD.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: db_connect rc = 256

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: DbSlErrorMsg rc = 99

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160611184008

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160611185918

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Apr  8 2012 23:30:51

patchinfo (patches.h): (0.211) NewDB R3load support import splitting tables (note 1651927)

process id 1392

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLOAD.cmd -dbcodepage 4103 -l SAPSLOAD.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: db_connect rc = 256

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: DbSlErrorMsg rc = 99

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160611185919

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160611190347

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Apr  8 2012 23:30:51

patchinfo (patches.h): (0.211) NewDB R3load support import splitting tables (note 1651927)

process id 1780

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLOAD.cmd -dbcodepage 4103 -l SAPSLOAD.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: db_connect rc = 256

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: DbSlErrorMsg rc = 99

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160611190347

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160611190509

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled Apr  8 2012 23:30:51

patchinfo (patches.h): (0.211) NewDB R3load support import splitting tables (note 1651927)

process id 1988

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLOAD.cmd -dbcodepage 4103 -l SAPSLOAD.log -nolog -c 50000 -force_repeat -loadprocedure dbsl

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: db_connect rc = 256

Database 'NSP' not running

DbSl Trace: Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

(DB) ERROR: DbSlErrorMsg rc = 99

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

F:\usr\sap\NSP\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160611190510

Almost 4 files contain the same errors.I think fixing one issue can solve all the four issues.

Thanks and Regards,

Teja.

[Former Member]

Hello Teja,

First have a look at the status of the DB with the Studio and also look in your knlmsg/knldiag files to see why the DB is down.

I'm half guessing you might have a log full situation.

KR,

Amerjit

[Former Member]

Hi Chahal,

I see something like PARAMETER="DATABASEFULL", PARAMETER="LOGFULL", PARAMETER="LOGSEGMENTFULL" PARAMETER="ThrowDatabaseFullEvent" in KnlMsg file.

Any Suggestions?

Thanks and Regards,

Teja.

[Former Member]

Hi Teja,

Please upload the two files.

Can you also take a log backup via the studio and then try to startup your DB again.

KR,

Amerjit

[Former Member]

Hi Chahal,

     The file is too long(10 MB) to be attached.

Thanks and Regards,

Teja

[Former Member]

Hello Teja,

Zip the file(s) or at least past in the last 150 lines. Also please look for errors in the files mentioned.

Have you tried taking a log backup and restarting the DB ?

KR,

Amerjit