Hi friends,
We are in process of CRM 7.0 EHP1upgrade. There is no progress in SUBMOD_EHPPREPUT/JOB_MSSSPEXE_SHD_PRE phase of preprocessing roadmap of EHP upgrade process. The log generated in SLOG702 is below:
ERROR: Statement: GRANT ALL ON [dca].[VARIT~] TO dca_shd
ERROR: SQL ERROR 15151: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'VARIT~', because it does not exist or you do not have permission.
ERROR: Statement: GRANT ALL ON [dca].[VARIT~] TO dca_shd
ERROR: SQL ERROR 15151: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'VARIT~', because it does not exist or you do not have permission.
Phase JOB_MSSSPEXE_SHD_PRE:
Phase JOB_MSSSPEXE_SHD_PRE:
Phase JOB_MSSSPEXE_SHD_PRE:
Phase JOB_MSSSPEXE_SHD_PRE:
Phase JOB_MSSSPEXE_SHD_PRE:
h3 ANd also log of PMSSSEXE is below:h3
1 ETQ201 Entering upgrade-phase "JOB_MSSSPEXE_SHD_PRE" ("20110602094130")
4 ETQ399 Set environment for shadow connect:
4 ETQ399 Set RFC variables for shadow connect:
4 ETQ399 System-nr = '04', GwService = 'sapgw04'
4 ETQ380 computing toolpath for request "TP_SHADOW_CONNECT"
4 ETQ381 request "TP_SHADOW_CONNECT" means "tp needs to connect to shadow system"
4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
4 ETQ383 translates to path "exe"
4 ETQ383 translates to path "exe"
4 ETQ399 Set tool parameters for shadow connect:
4 ETQ399 default TPPARAM: SHADOW.TPP
2 ETQ366 Connect variables are set for shadow instance access
4 ETQ399 System-nr = '04', GwService = 'sapgw04'
4 ETQ399 Environment variables:
4 ETQ399 dbs_mss_schema=dca
4 ETQ399 auth_shadow_upgrade=1
1 ETQ206 Executing pre-phase DB specific actions.
1 ETQ200 Executing actual phase 'MAIN_SHDPREPUT/JOB_MSSSPEXE_SHD_PRE'.
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: 20110602094130
4 ETQ260 Starting batchjob "MSSSPEXE"
4 ETQ230 Starting RFC Login to: System = "DCA", GwHost = "", GwService = "sapgw04"
4 ETQ359 RFC Login to: System="DCA", Nr="04", GwHost="", GwService="sapgw04"
4 ETQ232 RFC Login succeeded
4 ETQ233 Calling function module "SUBST_START_BATCHJOB" by RFC
4 ETQ399 JOBNAME='MSSSPEXE', REPNAME='MSSSPEXE', VARNAME='', BATCHHOST='ctsusphxsapb', IV_SCHEDEVER=' '
4 ETQ234 Call of function module "SUBST_START_BATCHJOB" by RFC succeeded
4 ETQ399 Returned JOBCOUNT='09413000'
4 ETQ233 Calling function module "SUBST_CHECK_BATCHJOB" by RFC
And let me know, if you need any more logs.Pls suggest me to proceed further.
Regards,
Nageshwar