1 ETQ201 Entering upgrade-phase "MAIN_SWITCH/SQLSELEXE_TRUNCLOAD_SWITCH" ("20200722230417") 4 ETQ380 computing toolpath for request "TP_DEFAULT". 2 ETQ367 Connect variables are set for standard instance access. 4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000' 1 ETQ200 Executing actual phase 'MAIN_SWITCH/SQLSELEXE_TRUNCLOAD_SWITCH'. 1 ETQ399 Phase arguments: 2 ETQ399 Arg[0] = 'LOADTABLES' 2 ETQ399 Arg[1] = 'TRUNC_TABLES' 2 ETQ399 Arg[2] = 'SCRCLASSID' 4 ETQ399 Mapping SCR class 'LOADTABLES' to actual condition. 3 ETQ399 Selecting from 'PUTTB_SHD' with condition '( PACKETNR == "0" and WCONTENT == "D" )'. 4 ETQ601 Table "CO2MAP" 4 ETQ601 Table "CO2MAPINF" 4 ETQ601 Table "COVMOD" 4 ETQ601 Table "COVREF" 4 ETQ601 Table "COV_GENDATA" 4 ETQ601 Table "COV_METADATA" 4 ETQ601 Table "D342L" 4 ETQ601 Table "D345T" 4 ETQ601 Table "D346T" 4 ETQ601 Table "DDFTX" 4 ETQ601 Table "DYNPLOAD" 4 ETQ601 Table "DYNPTXTLD" 4 ETQ601 Table "O2PAGINC" 4 ETQ601 Table "O2PAGRT" 4 ETQ601 Table "REPOLOAD" 3 ETQ399 15 entries matched. 1 ETQ399 Selected 15 entries from SCR class id 'LOADTABLES'. 1 ETQ399 Preparing and running task id 'TRUNC_TABLES' for 15 entries. 2 ETQ399 Requested task ID is 'TRUNC_TABLES', to be executed in parallel. 3 ETQ399 'LIST': Distributed 15 statements. 3 ETQ399 Reducing parallel processes from 16 to 15 since only that many statements are found. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT01.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT01.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT02.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT02.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT03.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT03.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT04.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT04.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT05.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT05.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT06.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT06.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT07.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT07.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT08.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT08.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT09.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT09.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT10.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT10.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT11.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT11.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT12.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT12.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT13.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT13.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT14.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT14.OUT'. 3 ETQ399 Generated TQL file 'SQLDBSCRIPT15.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT15.OUT'. 2 ETQ399 Distributed 15 statements, 15 actual ones are written to TQL files. 2 ETQ399 Running 15 scripts in parallel, writing to 'LOADTRUNCSWTCH.ELG'. 2 ETQ000 ================================================== 2 ETQ100 Executing 15 processes in total - will run 8 in parallel. 3 ETQ121 20200722230417 #1 (1): PID 4952 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT01.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.001'. 3 ETQ121 20200722230417 #2 (2): PID 2624 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT02.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.002'. 3 ETQ121 20200722230417 #3 (3): PID 852 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT03.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.003'. 3 ETQ121 20200722230417 #4 (4): PID 1260 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT04.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.004'. 3 ETQ121 20200722230417 #5 (5): PID 4944 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT05.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.005'. 3 ETQ121 20200722230417 #6 (6): PID 1888 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT06.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.006'. 3 ETQ121 20200722230418 #7 (7): PID 2388 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT07.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.007'. 3 ETQ121 20200722230418 #8 (8): PID 2236 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT08.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.008'. 3 ETQ123 20200722230418 (7): PID 4952 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT01.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (6): PID 2624 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT02.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (5): PID 852 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT03.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (4): PID 1260 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT04.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (3): PID 4944 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT05.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (2): PID 1888 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT06.SQL' (time: 0.00 real) 3 ETQ121 20200722230418 #9 (3): PID 1736 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT09.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.009'. 3 ETQ121 20200722230418 #10 (4): PID 2232 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT10.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.010'. 3 ETQ121 20200722230418 #11 (5): PID 5592 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT11.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.011'. 3 ETQ121 20200722230418 #12 (6): PID 5376 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT12.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.012'. 3 ETQ121 20200722230418 #13 (7): PID 5168 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT13.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.013'. 3 ETQ121 20200722230418 #14 (8): PID 4700 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT14.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.014'. 3 ETQ123 20200722230418 (7): PID 2388 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT07.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (6): PID 2236 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT08.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (5): PID 1736 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT09.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (4): PID 2232 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT10.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (3): PID 5592 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT11.SQL' (time: 0.00 real) 3 ETQ123 20200722230418 (2): PID 5376 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT12.SQL' (time: 0.00 real) 3 ETQ121 20200722230418 #15 (3): PID 3404 execute '~\bin\SAPuptool execdb ..\var\SQLDBSCRIPT15.SQL' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.015'. 3 ETQ123 20200722230418 (2): PID 5168 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT13.SQL' (time: 0.00 real) 3 ETQ123 20200722230420 (1): PID 4700 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT14.SQL' (time: 0.00 real) 3 ETQ123 20200722230420 (0): PID 3404 exited with status 0 'TRUNC_TABLES:SQLDBSCRIPT15.SQL' (time: 0.00 real) 1 ETQ000 ================================================== 4 ETQ010 Date & Time: 20200722230420 2 ETQ102 Finished execution of 15 process(es). 3 ETQ128 Interval: 20200722230417-20200722230420, time 3.0 real 2 ETQ108 Analyzing logs for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT01.OUT' from offset 114 to 479 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT02.OUT' from offset 114 to 482 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT03.OUT' from offset 114 to 479 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT04.OUT' from offset 114 to 479 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT05.OUT' from offset 114 to 484 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT06.OUT' from offset 114 to 485 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT07.OUT' from offset 114 to 478 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT08.OUT' from offset 114 to 478 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT09.OUT' from offset 114 to 478 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT10.OUT' from offset 114 to 478 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT11.OUT' from offset 114 to 481 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT12.OUT' from offset 114 to 482 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT13.OUT' from offset 114 to 481 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT14.OUT' from offset 114 to 480 for errors. 1 ETQ124 Scanned file 'log\SQLDBSCRIPT15.OUT' from offset 114 to 481 for errors. 3 ETQ114 Analyzed 15 log files. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT01.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT02.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT03.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT04.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT05.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT06.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT07.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT08.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT09.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT10.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT11.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT12.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT13.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT14.OUT'. 3 ETQ399 Reading SQL output from 'SQLDBSCRIPT15.OUT'. 4 ETQ010 Date & Time: 20200722230420 1 ETQ202 Upgrade phase "SQLSELEXE_TRUNCLOAD_SWITCH" completed successfully ("20200722230420")