RE:[sap-basis] error in shadow import phase in ecc 6.00 upgrade
Posted by
Admin at
Share this post:
|
0 Comments
Posted by Ismet (Basis) on May 21 at 12:34 AM | Mark as helpful |
I hv follow instruction that you stated above but the extraction part for PREP_IMPORT/RUN_GENPUTTBSHD taking me more than 8 hours now..I check RSPTBINI.log and it showed below:
1 ETQ201 Entering upgrade-phase "RUN_GENPUTTBSHD" ("20100520024407")
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00'
4 ETQ399 Environment variables:
4 ETQ399 dbs_ada_schema=SAPQS1
4 ETQ399 auth_shadow_upgrade=0
4 ETQ399 Set environment for standard connect:
4 ETQ399 ENV: dbs_ada_schema=SAPQS1
4 ETQ399 ENV: auth_shadow_upgrade=0
4 ETQ399 Set RFC variables for standard connect:
4 ETQ399 System-nr = '00', GwService = 'sapgw00'
4 ETQ399 Set tool parameters for standard connect:
4 ETQ399 default TPPARAM: DEFAULT.TPP
1 ETQ200 Executing actual phase 'PREP_IMPORT/RUN_GENPUTTBSHD'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[0] = 'RS_GENERATE_PUTTB_SHD'
2 ETQ399 Arg[1] = 'SAP_TMPLOG'
2 ETQ399 Arg[2] = 'NO-IGNORE'
2 ETQ399 Arg[3] = 'RS_GENERATE_PUTTB_SHD\.$(SAPSID)'
2 ETQ399 Arg[4] = '5'
2 ETQ399 Arg[5] = 'PUTTB_SHD generation'
2 ETQ399 Arg[6] = 'RSPTBINI.ELG'
4 ETQ010 Date & Time: 20100520024407
4 ETQ265 Starting report "RS_GENERATE_PUTTB_SHD" with variant "SAP_TMPLOG" in batch
4 ETQ359 RFC Login to: System="QS1", Nr="00", GwHost="QANTAS", GwService="sapgw00"
4 ETQ232 RFC Login succeeded
4 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC
4 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded
4 ETQ239 Logging off from SAP system
4 ETQ311 Batch job "RS_GENERATE_PUTTB_SHD" with job count "02441000" scheduled
4 ETQ359 RFC Login to: System="QS1", Nr="00", GwHost="QANTAS", GwService="sapgw00"
4 ETQ232 RFC Login succeeded
i dont think there are lot more information inside it. Is there any way that i can check the log or solve this solution?
Btw, i check RS_GENERATE_PUTTB_SHD in SM37 and state that the Status is Active and Duration(sec.) is 67.033..i think the process still running but why it take so long..Currently i try to upgrade to EHP4 in MaxDB with windows server 2008. i dont want to stop the installation first but is it worth for me to wait for it?
.Any idea guys?
thanks
---------------Original Message---------------
From: vaskoty madhukar
Sent: Wednesday, December 03, 2008 12:10 AM
Subject: error in shadow import phase in ecc 6.00 upgrade
> while upgrading sap 4.7 to ecc 6.00, i am encountering/struckup at PSCRGEN_DROP_SHD_TABLE PHASE in shawdow import phase..the process hanged/running for hours and seems to be never ending ...
>
> the following lines were extracted from SQLDRSHD.LOG file in /usr/sap/put/log directory..
>
> 4 ETQ399 System-nr = '00', GwService = 'sapgw00'
> 4 ETQ399 Environment variables:
> 4 ETQ399 dbs_ora_schema=SAPPRD
> 4 ETQ399 auth_shadow_upgrade=0
> 4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
> 4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
> 4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
> 4 ETQ383 translates to path "exe"
> 4 ETQ383 translates to path "exe"
> 4 ETQ399 Reading definition file
> 4 ETQ389 reading file "PSCRGEN.GRP" in directory "D:\usr\sap\put\bin".
> 2 ETQ355 '104' lines read
> 2 ETQ399 '0' definitions found
> 2 ETQ399 PUTTB_SHD Selector:
> 4 ETQ399 Reading definition file
> 4 ETQ389 reading file "SCRCLASS.DAT" in directory "D:\usr\sap\put\bin".
> 2 ETQ355 '130' lines read
> 2 ETQ399 '9' definitions found
> 4 ETQ399 Generating sql script 'SELPTBSHD.XQL'
> 4 ETQ276 Executing SQL-script "SELPTBSHD.XQL"
> 2 ETQ277 SQL-script "SELPTBSHD.XQL" executed successfully
> 4 ETQ399 Generating sql script 'TSHDDR00.XQL'
> 4 ETQ399 Purpose: 'drop shadow tables not switched'
> 4 ETQ399 Generating sql script 'TSHDDR01.XQL'
> 4 ETQ399 Purpose: 'drop shadow tables not switched'
> 4 ETQ399 Generating sql script 'TSHDDR02.XQL'
> 4 ETQ399 Purpose: 'drop shadow tables not switched'
> 4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
> 4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
> 4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
> 4 ETQ383 translates to path "exe"
> 4 ETQ383 translates to path "exe"
> 4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
> 4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
> 4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
> 4 ETQ383 translates to path "exe"
>
> thanks in advance ..
>
> regards
>
> madhukar
__.____._ 1 ETQ201 Entering upgrade-phase "RUN_GENPUTTBSHD" ("20100520024407")
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00'
4 ETQ399 Environment variables:
4 ETQ399 dbs_ada_schema=SAPQS1
4 ETQ399 auth_shadow_upgrade=0
4 ETQ399 Set environment for standard connect:
4 ETQ399 ENV: dbs_ada_schema=SAPQS1
4 ETQ399 ENV: auth_shadow_upgrade=0
4 ETQ399 Set RFC variables for standard connect:
4 ETQ399 System-nr = '00', GwService = 'sapgw00'
4 ETQ399 Set tool parameters for standard connect:
4 ETQ399 default TPPARAM: DEFAULT.TPP
1 ETQ200 Executing actual phase 'PREP_IMPORT/RUN_GENPUTTBSHD'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[0] = 'RS_GENERATE_PUTTB_SHD'
2 ETQ399 Arg[1] = 'SAP_TMPLOG'
2 ETQ399 Arg[2] = 'NO-IGNORE'
2 ETQ399 Arg[3] = 'RS_GENERATE_PUTTB_SHD\.$(SAPSID)'
2 ETQ399 Arg[4] = '5'
2 ETQ399 Arg[5] = 'PUTTB_SHD generation'
2 ETQ399 Arg[6] = 'RSPTBINI.ELG'
4 ETQ010 Date & Time: 20100520024407
4 ETQ265 Starting report "RS_GENERATE_PUTTB_SHD" with variant "SAP_TMPLOG" in batch
4 ETQ359 RFC Login to: System="QS1", Nr="00", GwHost="QANTAS", GwService="sapgw00"
4 ETQ232 RFC Login succeeded
4 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC
4 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded
4 ETQ239 Logging off from SAP system
4 ETQ311 Batch job "RS_GENERATE_PUTTB_SHD" with job count "02441000" scheduled
4 ETQ359 RFC Login to: System="QS1", Nr="00", GwHost="QANTAS", GwService="sapgw00"
4 ETQ232 RFC Login succeeded
i dont think there are lot more information inside it. Is there any way that i can check the log or solve this solution?
Btw, i check RS_GENERATE_PUTTB_SHD in SM37 and state that the Status is Active and Duration(sec.) is 67.033..i think the process still running but why it take so long..Currently i try to upgrade to EHP4 in MaxDB with windows server 2008. i dont want to stop the installation first but is it worth for me to wait for it?
.Any idea guys?
thanks
---------------Original Message---------------
From: vaskoty madhukar
Sent: Wednesday, December 03, 2008 12:10 AM
Subject: error in shadow import phase in ecc 6.00 upgrade
> while upgrading sap 4.7 to ecc 6.00, i am encountering/struckup at PSCRGEN_DROP_SHD_TABLE PHASE in shawdow import phase..the process hanged/running for hours and seems to be never ending ...
>
> the following lines were extracted from SQLDRSHD.LOG file in /usr/sap/put/log directory..
>
> 4 ETQ399 System-nr = '00', GwService = 'sapgw00'
> 4 ETQ399 Environment variables:
> 4 ETQ399 dbs_ora_schema=SAPPRD
> 4 ETQ399 auth_shadow_upgrade=0
> 4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
> 4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
> 4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
> 4 ETQ383 translates to path "exe"
> 4 ETQ383 translates to path "exe"
> 4 ETQ399 Reading definition file
> 4 ETQ389 reading file "PSCRGEN.GRP" in directory "D:\usr\sap\put\bin".
> 2 ETQ355 '104' lines read
> 2 ETQ399 '0' definitions found
> 2 ETQ399 PUTTB_SHD Selector:
> 4 ETQ399 Reading definition file
> 4 ETQ389 reading file "SCRCLASS.DAT" in directory "D:\usr\sap\put\bin".
> 2 ETQ355 '130' lines read
> 2 ETQ399 '9' definitions found
> 4 ETQ399 Generating sql script 'SELPTBSHD.XQL'
> 4 ETQ276 Executing SQL-script "SELPTBSHD.XQL"
> 2 ETQ277 SQL-script "SELPTBSHD.XQL" executed successfully
> 4 ETQ399 Generating sql script 'TSHDDR00.XQL'
> 4 ETQ399 Purpose: 'drop shadow tables not switched'
> 4 ETQ399 Generating sql script 'TSHDDR01.XQL'
> 4 ETQ399 Purpose: 'drop shadow tables not switched'
> 4 ETQ399 Generating sql script 'TSHDDR02.XQL'
> 4 ETQ399 Purpose: 'drop shadow tables not switched'
> 4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
> 4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
> 4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
> 4 ETQ383 translates to path "exe"
> 4 ETQ383 translates to path "exe"
> 4 ETQ380 computing toolpath for request "TP_EXECDBSCRIPT_NEW"
> 4 ETQ381 request "TP_EXECDBSCRIPT_NEW" means "execdbscript with 46A feature"
> 4 ETQ382 translates to group "R3UP_TOOL_GROUP_NEW"
> 4 ETQ383 translates to path "exe"
>
> thanks in advance ..
>
> regards
>
> madhukar
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
_.____.__ White Papers
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage