EHP1 : Phase MAIN_SWITCH/DB_ACTION_GENTRUNC Missing file SELTRIG.LOG

[Former Member]

SAPEHPI etrminates in MAIN_SWITCH/DB_ACTION_GENTRUNC with the following error :

Checks after phase MAIN_SWITCH/DB_ACTION_GENTRUNC were negative!

Last error code set: Cannot open 'L:\EHPI\abap\log\SELTRIG.LOG': The system cannot find the file specified.

The file 'L:\EHPI\abap\log\SELTRIG.LOG' does not exist, and I can't find any reference to say how to generate this file.

There is no option to bypass this step.

I've looked at other upgrades, that were done using the standard upgrade program SAPUP, and this file is generated forthe other upgrades.

Any thoughts on how to generate SELTRIG.LOG ?

Regards

Min Chauhan

[Former Member]

Hi Minesh,

This error is quite strange as this phase generates the script to truncate tables in shadow instance. And file for which upgrade is looking is generally generated by upgrade in this phase only.

Could you please check the logs carefully of this phase and also check space in upgrade directory.

Please paste logs here for this phase and as well as last 2 log files.

Thanks

Sunny

[Former Member]

Hi Sunny

Thanks for this info.

There is ~3GB space in the upgrade directory, so space is not an issue.

The log for Phase "DB_ACTION_GENTRUNC " - GENTRUNC.SAV shows the following error show at the end of the message.

It seems that there were errors running running the script :

2EETQ278 Errors during execution of SQL-script "SELTRIG.XQL"

I'm checked the SQL database to see if there any errors there , but that looks fine

Regards

Min

#----

---

#---- MASKING file GENTRUNC.LOG from L:\EHPI\abap\log

#---- TIME: 20090704055327

#----

---

1 ETQ201 Entering upgrade-phase "DB_ACTION_GENTRUNC" ("20090704045848")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '03', GwService = 'sapgw03'

4 ETQ399 Environment variables:

4 ETQ399 dbs_mss_schema=bw1

4 ETQ399 auth_shadow_upgrade=0

4 ETQ380 computing toolpath for request "TP_DEFAULT"

4 ETQ382 translates to group "R3UP_TOOL_GROUP_OLD"

4 ETQ383 translates to path "E:\usr\sap\BW1\DVEBMGS03\exe"

4 ETQ383 translates to path "exe"

4 ETQ399 Set environment for standard connect:

4 ETQ399 ENV: dbs_mss_schema=bw1

4 ETQ399 ENV: auth_shadow_upgrade=0

4 ETQ399 Set RFC variables for standard connect:

4 ETQ399 System-nr = '03', GwService = 'sapgw03'

4 ETQ399 Set tool parameters for standard connect:

4 ETQ399 default TPPARAM: DEFAULT.TPP

1 ETQ206 Executing pre-phase DB specific actions.

1 ETQ206 Executing pre-phase OS specific actions.

1 ETQ200 Executing actual phase 'MAIN_SWITCH/DB_ACTION_GENTRUNC'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'GEN_TRUNCATE_TRIGGERED'

2 ETQ399 Arg[1] = 'SELTRIG.XQL'

2 ETQ399 Arg[2] = 'SELTRIG.LOG'

2 ETQ399 Arg[3] = 'TRUNCTAB.XQL'

2 ETQ399 Arg[4] = 'TRUNCTAB.LOG'

2 ETQ399 Generate script to select tables tables.

2 ETQ399 The selection is on tables where the tigger fired.

4 ETQ276 Executing SQL-script "SELTRIG.XQL"

3EETQ253 Read error on file "SELTRIG.LOG" in directory "L:\EHPI\abap\log"

2EETQ278 Errors during execution of SQL-script "SELTRIG.XQL"

1 ETQ207 Executing post-phase DB specific actions.

1 ETQ207 Executing post-phase OS specific actions.

4 ETQ010 Date & Time: 20090704045848

[Former Member]

Hi,

Have you upgraded your kernel with latest R3trans ?

Is R3trans -d is working ?

>2EETQ278 Errors during execution of SQL-script "SELTRIG.XQL"

Have you checked logs in ora_sid.log and also in upgrade logs why it is not able to execute this script ?

Thanks

Sunny

[Former Member]

Hi Sunny

I found the problem.

SAPEPHPI does not copy the kernal to the newly created Shadow Instance directory :

E:\usr\sap\BW1\DVEBMGS03\exe , where the Shadow Instance is 03 .

Once I had manually copied in the kernel files, it was ok.

[former_member269020]

hello, I have had the same problem, with the file SELALTAB.LOG and after copy manually the kernel files to the shadow instance, the SAPEHPi works fine.

thakns