EHP installing. Error in phase MAIN_SHDRUN/JOB_MSSSPEXE_SHD

[Former Member]

Hello all,

Dealing with ECC's EHP4 installation and having problem with step JOB_MSSSPEXE_SHD.

Firstly, want to give some system overview.

System was migrated from x32 non-Unicode to x64 Unicode through SystemCopy

OS: Windows Server 2008 SP2

DB: MS SQL Server 2008 version 10.0.2531.0

SAP: (only ABAP Web AS is installed)

NW 7.0, ECC 6.0 SPS 20, kernel version 7.0 236

java version - 1.4.2_17-x64

Now doing installation of ECC EHP 4 / NW 7.01 SPS6 .

Using SAPehpi 710 2.005.001 package 24

Using latest dbmsslib.dll (released 05/12/2010)

Had no problems till the Preprocessing Step

Error that EHPi produced is:

Severe error(s) occured in phase MAIN_SHDRUN/JOB_MSSSPEXE_SHD!

Last error code set: BATCHJOB MSSSPEXE on shadow instance FAILED: Batchjob MSSSPEXE aborted.

JOBLOG.LOG :

------------------------------------------------------------------------------------------------------- 
|Time |User |Program |Priority|Grp|N|Text | 
------------------------------------------------------------------------------------------------------- 
|09:25:07|SAPSYS|RSBTCRTE| |EB |E|Failed to read step $$$$$ of job (database error code: 00064)| 
|09:25:07|SAPSYS|RSBTCRTE| |EB |C|> Job MSSSPEXE | 
|09:25:07|SAPSYS|RSBTCRTE| |D0 |1|Transaction Canceled 00 529 ( 001 ) | 
-------------------------------------------------------------------------------------------------------

PMSSSPEXE.LOG:

1 ETQ200 Executing actual phase 'MAIN_SHDRUN/JOB_MSSSPEXE_SHD'. 
1 ETQ399 Phase arguments: 
2 ETQ399 Arg[0] = 'MSSSPEXE' 
2 ETQ399 Arg[1] = '' 
2 ETQ399 Arg[2] = 'NO-IGNORE' 
2 ETQ399 Arg[3] = '' 
2 ETQ399 Arg[4] = '5' 
2 ETQ399 Arg[5] = 'MSSQL SPECIFIC ACTIONS' 
2 ETQ399 Arg[6] = 'PMSSSPEX.ELG' 
4 ETQ260 Starting batchjob "MSSSPEXE" 
4 ETQ010 Date & Time: 20100625092507 
4 ETQ260 Starting batchjob "MSSSPEXE" 
4 ETQ230 Starting RFC Login to: System = "PRD", GwHost = "SAP", GwService = "sapgw01" 
4 ETQ233 Calling function module "SUBST_START_BATCHJOB" by RFC 
4 ETQ399 JOBNAME='MSSSPEXE', REPNAME='MSSSPEXE', VARNAME='', BATCHHOST='SAP', IV_SCHEDEVER=' ' 
4 ETQ234 Call of function module "SUBST_START_BATCHJOB" by RFC succeeded 
4 ETQ399 Returned JOBCOUNT='09250700' 
4 ETQ233 Calling function module "SUBST_CHECK_BATCHJOB" by RFC 
4 ETQ010 Date & Time: 20100625092512 
4 ETQ234 Call of function module "SUBST_CHECK_BATCHJOB" by RFC succeeded 
4 ETQ239 Logging off from SAP system 
2EETQ262 Batchjob "MSSSPEXE" aborted 
4 ETQ359 RFC Login to: System="PRD", Nr="01", GwHost="SAP", GwService="sapgw01" 
4 ETQ232 RFC Login succeeded 

Next I've connected to shadow instance, increased Trace level of batch process to 3 and went to ST11.

dev_w12 log:

L BtcAuthSet: Begin: username=DDIC 
L BtcAuthSet: zttabtckln = 500 
L BtcAuthSet: jobname=MSSSPEXE , jobcount=09250700, status=S 
L BtcAuthSet: jobgroup=%_IMMEDIATE , stepcount=0 
L BtcAuthSet: authcknam= , authckman=000 
L BtcAuthSet: step_cnt=33679104 
L BtcAuthSet: step_ptr->stepcount=1 
B { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TBTCPV' ) {btcjcntl.c:941} 
B NTAB: tabname: TBTCPV , fcode: 1 
M PfSetActDBConRec: record found for dbcon <> 
M PfStatBegin: open DBCON rec with opcode 10 
M push timestack[0] = STAT_READDIR 
M pop timestack[0] = STAT_READDIR 
M PfStatEnd: close DBCON rec after opcode 10 
M PfSetActDBConRec: record found for dbcon <> 
M PfStatBegin: open DBCON rec with opcode 10 
M push timestack[0] = STAT_READDIR 
M pop timestack[0] = STAT_READDIR 
M PfStatEnd: close DBCON rec after opcode 10 
B } db_rtab( fcode = 'RT_READ_ONLY', retcode = 64 ) 
L *** ERROR => BtcAuthSet: db_rtab-call failed, rc: 64 [btcjcntl.c 946] 
A + SAPSYS 40088 BATCH 00 529 rlv=clean 
A RFC> get SPA_SESSION_ARFC: NORMAL 
A RFC> ab_RfcTraceConnInfo (OFF) (handle: 0, dump_connection_info: 0) 
A ab_rfcclose_ex: closed 0 handles for owner 39368 (0 skipped) 
A RFC> not running in Plugin session 

Free space is about 50 Gb on server. Database files have unrestricted growth.

I have no idea what kind of error is "db_rtab-call failed, rc: 64"

Any help will be highly appreciated.

Thank you

Alexey

[markus_doehr2]

> 2 ETQ399 Arg[6] = 'PMSSSPEX.ELG'

Do you have that logfile?

Markus

[i_itdept]

null

[Former Member]

Hi Markus,

Yes, I have PMSSSPEX.ELG . That file contains suggestions that I have already made.

PMSSSPEX.ELG :

See file JOBLOG.LOG in directory D:\usr\sap\EHPi\abap\log for the
job log, SYSLOG, and short dump of the
aborted job MSSSPEXE,
or use transactions SM37, SM21, and ST22.

Regards,

Alexey

[Former Member]

Hi everybody,

I solved this issue.

The problem was in following:

Views was imported to a new DB with old schema.

For example on old DB there was a view [dbo].[/1CN/ABPSAP001]. On a new DB this view have to be [prd].[/1CN/ABPSAP001]. But I realized that on the new DB all views had a [dbo] schema. SAP was starting well (I guess because the view names were correct and presented on DB) so I didn't noticed this schema issue.

So I deleted all views and recreated under proper schema.

Then I've created view [prd_shd].[TBTCPV] and everything went ok.

Thanks everyone for participating.

Regards,

Alexey

[Former Member]

Hi

I am getting error in MSSSPEXE job in Preprocessing phase in Ehp6 upgrade.

MAIN_SHDPREPUT/JOB_MSSSPEXE_SHD_PRE

MSSSPEXE job aborted
Batchjob 'MSSSPEXE' with id '11484300' aborted

Reviewing Short dump is says the following:

Runtime Errors         SYNTAX_ERROR
Date and Time          03.11.2013 00:47:55

Short Text
     Syntax error in program "SAPLMSSPROCS ".

What happened?
     Error in the ABAP Application Program

     The current ABAP program "MSSSPEXE" had to be terminated because it has
     come across a statement that unfortunately cannot be executed.

     The following syntax error occurred in program "SAPLMSSPROCS " in inclu
      "LMSSPROCSUXX " in
     line 9:
     "INCLUDE report "LMSSPROCSU04" not found"
     " "
     " "
     " "

     The include has been created and last changed by:
     Created by: "SAP "
     Last changed by: "SAP "
     Error in the ABAP Application Program

     The current ABAP program "MSSSPEXE" had to be terminated because it has
     come across a statement that unfortunately cannot be executed.

Runtime Errors         SYNTAX_ERROR
Date and Time          03.11.2013 00:47:55

Short Text
     Syntax error in program "SAPLMSSPROCS ".

What happened?
     Error in the ABAP Application Program

     The current ABAP program "MSSSPEXE" had to be terminated because it has
     come across a statement that unfortunately cannot be executed.

     The following syntax error occurred in program "SAPLMSSPROCS " in inclu
      "LMSSPROCSUXX " in
     line 9:
     "INCLUDE report "LMSSPROCSU04" not found"
     " "
     " "
     " "

     The include has been created and last changed by:
     Created by: "SAP "
     Last changed by: "SAP "
     Error in the ABAP Application Program

     The current ABAP program "MSSSPEXE" had to be terminated because it has
     come across a statement that unfortunately cannot be executed.

Regards

[nelis]

Have you tried connecting to Shadow instance and then checking in SM37 for the actual job MSSSPEXE ? It may display more useful information in the job log from SM37 or if it displays an ABAP error check ST22.

Nelis

[Former Member]

Hi Nelis,

Yes, I've already tried to look in SM37 on shadow instance.

There is no job MSSSPEXE.

Alexey