Skip to Content
0
Former Member
Jun 03, 2011 at 04:04 PM

Error in EHP1 upgrade of CRM7.0

36 Views

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.

  1. Phase JOB_MSSSPEXE_SHD_PRE:

  2. Phase JOB_MSSSPEXE_SHD_PRE:

  3. Phase JOB_MSSSPEXE_SHD_PRE:

  4. Phase JOB_MSSSPEXE_SHD_PRE:

  5. 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