C:\Automic\Automation.Platform\Utility\bin>c:\Automic\Automation.Platform\Agents\Windows\bin\UCXJWX6M.EXE JNR=0004817611 MNR=0100 PNR=2300 IPA=172.16.83.180 TYP=S TXT=" Job started" Program 'UC4 Job Messenger' version '12.0.1+build.632' started UCMDJP: ********************************************************************* UCMDJP: ** JOB 0004817611 (ProcID:0000065532) START AT 01.07.2020/05:33:31 ** UCMDJP: ** UTC TIME 01.07.2020/10:33:31 ** UCMDJP: ********************************************************************* Connected with agent 'PRD2K12AP14' Program 'UC4 Job Messenger' version '12.0.1+build.632' terminated normally C:\Automic\Automation.Platform\Utility\bin>UCYBDBun -B REORG 20200701/053331.621 - U00033125 Operating System: 20200701/053331.621 - U00038002 DLL 'ucybdbun', version '12.0.1+build.417'. Start parameter: '-B REORG ', (changelist '1480512411'). 20200701/053331.621 - U00038259 Build Date: '2017-01-19', '10:42:03' 20200701/053331.621 - ---------------------------------------------------------------------------------------------------- 20200701/053331.621 - [GLOBAL] 20200701/053331.621 - language = (E,D) 20200701/053331.621 - logging = ..\TEMP\ucybdbun_log_##.txt 20200701/053331.621 - logcount = 10 20200701/053331.621 - helplib = uc.msl 20200701/053331.621 - helpcache = ALL 20200701/053331.621 - docu_path = ..\..\Docu\uc4\htmlhelp 20200701/053331.621 - 20200701/053331.621 - OUTPUT = ..\db\uc_data.txt 20200701/053331.621 - 20200701/053331.621 - ;waittime in milliseconds (only in case of Reorg) 20200701/053331.621 - ;Reorg_Commit_Sleep=500 20200701/053331.621 - 20200701/053331.621 - ; command how to start the utility 20200701/053331.621 - cmd="javaw" -cp .;.\UC4LookAndFeel.jar -jar ucybdbun.jar 20200701/053331.621 - ; start path 20200701/053331.621 - path=. 20200701/053331.621 - ; sub string of Window title for end recognation 20200701/053331.621 - title=UCYBDBUn 20200701/053331.621 - 20200701/053331.621 - [ENVIRONMENT] 20200701/053331.621 - classpath=.;.\UC4LookAndFeel.jar 20200701/053331.621 - 20200701/053331.621 - 20200701/053331.621 - [TRACE] 20200701/053331.621 - file = ..\TEMP\ucybdbun_trace_##.txt 20200701/053331.621 - trccount = 10 20200701/053331.621 - database = 0 20200701/053331.621 - ; 0=no 20200701/053331.621 - ; 1=SQL 20200701/053331.621 - ; 2=OPC 20200701/053331.621 - ; 3=BindParam 20200701/053331.621 - ; 4=data fields 20200701/053331.621 - 20200701/053331.621 - [REORG] 20200701/053331.621 - suppress_output=1 20200701/053331.621 - ;no_archive_check=0 20200701/053331.621 - 20200701/053331.621 - [TRANSPORT] 20200701/053331.621 - ;all_entities=0 20200701/053331.621 - 20200701/053331.621 - 20200701/053331.621 - [ODBC] 20200701/053331.621 - ; ODBCVAR xxxxxxxx 20200701/053331.621 - ; |||||||+ type of SQL-Syntax N=SQL-SERVER O=ORACLE D=DB2 Z=DB2/OS390 20200701/053331.621 - ; ||||||+- R=compress messages and local memory 20200701/053331.621 - ; |||||+-- O = with userid, N = without userid 20200701/053331.621 - ; ||||+--- I=OCI/CLI N=ODBC 20200701/053331.621 - ; |||+---- not used 20200701/053331.621 - ; ||+----- J = compare fieldnames case-insensitiv (in case of ORACLE !!) 20200701/053331.621 - ; |+------ D = DB-Disconnect after 1000 commits (perhaps in case of Oracle memory leaks) 20200701/053331.621 - ; +------- S = use Server-Cursor (SQL-SERVER) 20200701/053331.621 - ; 20200701/053331.621 - ; SNNNNNRN for SQL-Server either Standard-Client or Native-Client without using Mars_Connection 20200701/053331.621 - ; NNNNNNRN for SQL-Server utilizing Native-Client (Mars_Connection=Yes is required) 20200701/053331.621 - ; NNJNIORO for Oracle 10.x with OCI (Oracle Call Interface) 20200701/053331.621 - ; NNJNIORD for DB2/NT/UNIX with CLI (Call Level Interface) 20200701/053331.621 - ; 20200701/053331.621 - ; SQL-Server with ODBC (either Standard-Client or Native-Client without using Mars_Connection) 20200701/053331.621 - SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,DSN=AUTOMIC;UID=AUTOMIC;PWD=??? 20200701/053331.621 - ; SQL-Server with ODBC (only applicable when using ?Native-Client', requires Mars_Connection=Yes) 20200701/053331.621 - ;SQLDRIVERCONNECT=ODBCVAR=NNNNNNRN,DSN=UC4;UID=uc4;PWD=???;Mars_Connection=Yes 20200701/053331.621 - ; Oracle with OCI 20200701/053331.621 - ;SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=UC4;UID=uc4;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15 20200701/053331.621 - ; DB2 with CLI 20200701/053331.621 - ;SQLDRIVERCONNECT=ODBCVAR=NNJNIORD,DSN=UC4;UID=uc4;PWD=??? 20200701/053331.621 - ---------------------------------------------------------------------------------------------------- 20200701/053331.621 - U00003545 UCUDB: Opening database ... 20200701/053331.621 - U00029112 UCUDB - Length of the DB-History area: 100 20200701/053331.652 - U00003592 UCUDB - Status: '01000' Native error: '5701' Msg: 'Changed database context to 'AUTOPRD'.' 20200701/053331.652 - U00003592 UCUDB - Status: '01000' Native error: '5703' Msg: 'Changed language setting to us_english.' 20200701/053331.652 - U00029115 UCUDB - OPEN Database handles DB-HENV: b56370 DB-HDBC: b56450 20200701/053331.652 - U00003535 DB INFO: 'DATABASE-NAME = AUTOPRD' 20200701/053331.652 - U00003535 DB INFO: 'DBMS-NAME = Microsoft SQL Server' 20200701/053331.652 - U00003535 DB INFO: 'DBMS-VER = 11.00.5058' 20200701/053331.652 - U00003535 DB INFO: 'ODBC-VER = 03.80.0000' 20200701/053331.652 - U00003535 DB INFO: 'DRIVER-NAME = SQLSRV32.DLL' 20200701/053331.652 - U00003535 DB INFO: 'DRIVER-ODBC-VER = 03.52' 20200701/053331.652 - U00003535 DB INFO: 'DRIVER-VER = 06.03.9600' 20200701/053331.652 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE = 2' 20200701/053331.652 - U00003535 DB INFO: 'TXN-CAPABLE = 2' 20200701/053331.652 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION = 2' 20200701/053331.652 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION = 0000000000001111B ( 15)' 20200701/053331.652 - U00003535 DB INFO: 'POS-OPERATIONS = 0000000000011111B ( 31)' 20200701/053331.652 - U00003535 DB INFO: 'POSITIONED-STATEMENTS = 0000000000000111B ( 7)' 20200701/053331.652 - U00003535 DB INFO: 'SCROLL-CONCURRENCY = 0000000000001111B ( 15)' 20200701/053331.652 - U00003535 DB INFO: 'SCROLL-OPTIONS = 0000000000010111B ( 23)' 20200701/053331.652 - U00003535 DB INFO: 'STATIC-SENSITIVITY = 0000000000000101B ( 5)' 20200701/053331.652 - U00003535 DB INFO: 'LOCK-TYPES = 0000000000000001B ( 1)' 20200701/053331.652 - U00003535 DB INFO: 'ODBC_TRACE = 0' 20200701/053331.668 - U00003532 UCUDB: Checking data source ... 20200701/053335.238 - U00003533 UCUDB: Check of data source finished: No errors. Performance CPU/DB: '60508396'/'448 (1000/2.229132 s)' 20200701/053335.238 - U00003544 UCUDB: Reference values tested with Windows 2003 on XEON 1500 MHz: CPU 813865, DB 470 20200701/053335.363 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'OPEN' time: '3:732.784.561' 20200701/053335.363 - U00003621 Version of Automation Engine database objects: '12.0.1+hf.5.build.856' 20200701/053335.490 - Module Version TimeStamp Size Base 20200701/053335.490 - ------------------------------------------------ ---------------- ------------------- ----------- -------- 20200701/053335.490 - C:\Automic\Automation.Platform\Utility\bin\ucyb12.0.1+build.338 2017-05-23 08:56:07 77.824 54180000 20200701/053335.490 - C:\Windows\SYSTEM32\ntdll.dll 6.3.9600.18217 2020-06-20 22:00:31 1.737.520 630f0000 20200701/053335.490 - C:\Windows\system32\KERNEL32.DLL 6.3.9600.18217 2020-05-10 04:24:35 1.311.768 62c20000 20200701/053335.490 - C:\Windows\system32\KERNELBASE.dll 6.3.9600.18217 2020-05-20 10:20:26 1.135.696 602f0000 20200701/053335.490 - C:\Windows\SYSTEM32\NETAPI32.dll 6.3.9600.17415 2014-11-21 20:45:20 80.056 5da50000 20200701/053335.490 - C:\Windows\system32\ADVAPI32.dll 6.3.9600.16384 2018-01-02 01:37:24 685.440 60cc0000 20200701/053335.490 - C:\Windows\SYSTEM32\netutils.dll 6.3.9600.17415 2014-11-21 20:44:17 44.368 5ebf0000 20200701/053335.490 - C:\Windows\SYSTEM32\srvcli.dll 6.3.9600.17415 2014-11-21 20:44:16 149.240 5ffa0000 20200701/053335.490 - C:\Windows\SYSTEM32\wkscli.dll 6.3.9600.17415 2014-11-21 20:44:16 86.744 5eeb0000 20200701/053335.490 - C:\Windows\system32\msvcrt.dll 7.0.9600.17415 2014-11-21 20:44:13 687.496 60a70000 20200701/053335.490 - C:\Windows\SYSTEM32\sechost.dll 6.3.9600.16384 2015-03-23 16:59:25 360.480 63020000 20200701/053335.490 - C:\Windows\system32\RPCRT4.dll 6.3.9600.16384 2019-10-15 00:55:25 1.308.256 60b80000 20200701/053335.490 - C:\Windows\system32\SspiCli.dll 6.3.9600.17415 2014-11-21 20:44:13 179.736 60470000 20200701/053335.490 - C:\Windows\SYSTEM32\cscapi.dll 6.3.9600.17415 2014-11-21 20:45:01 55.296 56fc0000 20200701/053335.490 - C:\Automic\Automation.Platform\Utility\bin\ucyb12.0.1+build.417 2017-05-23 08:56:09 641.960 42890000 20200701/053335.490 - C:\Automic\Automation.Platform\Utility\bin\ZU0012.0.1+build.770 2017-05-23 08:56:07 384.424 4ee90000 20200701/053335.490 - C:\Automic\Automation.Platform\Utility\bin\UCUD12.0.1+build.11172017-05-23 08:56:07 636.840 3e4a0000 20200701/053335.490 - C:\Windows\SYSTEM32\VERSION.dll 6.3.9600.17415 2014-11-21 20:46:18 29.960 5ae70000 20200701/053335.490 - C:\Windows\system32\USER32.dll 6.3.9600.16384 2020-04-11 13:39:07 1.542.696 62e80000 20200701/053335.490 - C:\Windows\system32\GDI32.dll 6.3.9600.19719 2020-05-13 12:49:07 1.368.592 624f0000 20200701/053335.490 - C:\Automic\Automation.Platform\Utility\bin\UCDB12.0.1+build.753 2017-05-23 08:56:10 5.563.816 379c0000 20200701/053335.505 - C:\Automic\Automation.Platform\Utility\bin\UCUO12.0.1+build.11172017-05-23 08:56:06 252.328 4f630000 20200701/053335.505 - C:\Windows\SYSTEM32\ODBC32.dll 6.3.9600.17415 2014-11-21 20:45:27 771.584 59e30000 20200701/053335.505 - C:\Windows\SYSTEM32\bcrypt.dll 6.3.9600.16384 2016-11-19 16:24:03 152.856 5fd00000 20200701/053335.505 - C:\Windows\system32\bcryptprimitives.dll 6.3.9600.18895 2018-01-02 02:56:21 397.224 60020000 20200701/053335.505 - C:\Windows\system32\SQLSRV32.dll 6.3.9600.17415 2014-11-21 20:45:29 799.744 59d20000 20200701/053335.505 - C:\Windows\system32\CRYPT32.dll 6.3.9600.18372 2017-03-31 18:16:45 1.968.408 604f0000 20200701/053335.505 - C:\Windows\system32\MSASN1.dll 6.3.9600.17415 2014-11-21 20:44:17 64.512 602d0000 20200701/053335.505 - C:\Windows\system32\DPAPI.DLL 6.3.9600.17415 2014-11-21 20:44:17 15.360 5eed0000 20200701/053335.505 - C:\Windows\system32\CRYPTBASE.dll 6.3.9600.17415 2014-11-21 20:44:15 31.528 60090000 20200701/053335.505 - C:\Windows\system32\odbccp32.dll 6.3.9600.17415 2014-11-21 20:45:28 129.536 59cd0000 20200701/053335.505 - C:\Windows\SYSTEM32\DBNETLIB.DLL 6.3.9600.17415 2014-11-21 20:45:29 130.560 52800000 20200701/053335.505 - C:\Windows\system32\WS2_32.dll 6.3.9600.16384 2016-05-14 15:01:15 363.104 62e20000 20200701/053335.505 - C:\Windows\system32\NSI.dll 6.3.9600.17415 2014-11-21 20:44:11 24.800 63000000 20200701/053335.505 - C:\Windows\SYSTEM32\security.dll 6.3.9600.16384 2013-08-22 06:43:13 5.120 572a0000 20200701/053335.505 - C:\Windows\SYSTEM32\SECUR32.DLL 6.3.9600.17415 2014-11-21 20:45:24 29.184 58c90000 20200701/053335.505 - C:\Windows\system32\msv1_0.DLL 6.3.9600.16384 2019-10-10 23:53:45 430.840 5f9e0000 20200701/053335.505 - C:\Windows\SYSTEM32\cryptdll.dll 6.3.9600.19343 2019-04-05 17:47:07 96.208 5fbd0000 20200701/053335.505 - C:\Windows\SYSTEM32\ntdsapi.dll 6.3.9600.17415 2014-11-21 20:45:20 148.480 5db00000 20200701/053335.505 - C:\Windows\SYSTEM32\DSPARSE.DLL 6.3.9600.18264 2016-03-10 12:03:19 30.208 5ae80000 20200701/053335.505 - C:\Windows\system32\mswsock.dll 6.3.9600.16384 2016-05-13 16:58:54 339.456 5fa50000 20200701/053335.505 - C:\Windows\SYSTEM32\DNSAPI.dll 6.3.9600.16384 2018-06-08 12:54:11 656.384 5f850000 20200701/053335.505 - C:\Windows\System32\rasadhlp.dll 6.3.9600.17415 2014-11-21 20:46:04 17.408 5b470000 20200701/053335.505 - C:\Windows\SYSTEM32\IPHLPAPI.DLL 6.3.9600.16384 2016-03-11 19:47:32 160.160 5d2d0000 20200701/053335.505 - C:\Windows\SYSTEM32\WINNSI.DLL 6.3.9600.17415 2014-11-21 20:44:11 33.032 5d210000 20200701/053335.505 - C:\Windows\System32\fwpuclnt.dll 6.3.9600.16384 2020-02-01 11:48:21 422.400 5cdb0000 20200701/053335.505 - C:\Windows\system32\schannel.DLL 6.3.9600.16384 2019-08-22 08:31:49 435.712 5f680000 20200701/053335.505 - C:\Windows\SYSTEM32\ncrypt.dll 6.3.9600.16384 2018-03-10 15:55:47 137.968 5fcd0000 20200701/053335.505 - C:\Windows\SYSTEM32\NTASN1.dll 6.3.9600.16384 2014-11-21 20:44:17 224.600 5fc90000 20200701/053335.505 - C:\Windows\system32\ncryptsslp.dll 6.3.9600.19420 2019-07-04 19:10:42 108.392 57210000 20200701/053335.505 - C:\Windows\SYSTEM32\netbios.dll 6.3.9600.17415 2014-11-21 20:46:01 17.920 59cc0000 20200701/053335.505 - C:\Windows\SYSTEM32\dbghelp.dll 6.3.9600.17787 2015-03-31 22:45:15 1.491.456 5db60000 20200701/053335.505 - U00021200 *********************************************ILM SETTINGS*********************************************** 20200701/053335.505 - U00021202 ILM installed N 20200701/053335.505 - U00021203 ******************************************************************************************************** 20200701/053335.505 - U00037058 Invalid batch mode: 'null' 20200701/053335.505 - U00003523 UCUDB: Maximum time required for a DB call: '3:732.784.561'. 20200701/053335.505 - U00003522 UCUDB: Database closed. Total time for DB calls: '3:861.909.250' seconds. 20200701/053335.505 - U00003549 UCUDB: ' 2507' 'OTHERS ' calls took '3:858.221.449' sec. 20200701/053335.505 - U00003549 UCUDB: ' 2' 'SELECT ' calls took '0:000.952.321' sec. 20200701/053335.505 - U00003549 UCUDB: ' 0' 'EXECUTE ' calls took '0:000.000.000' sec. 20200701/053335.505 - U00003549 UCUDB: ' 0' 'UPDATE ' calls took '0:000.000.000' sec. 20200701/053335.505 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec. 20200701/053335.505 - U00003549 UCUDB: ' 0' 'INSERT ' calls took '0:000.000.000' sec. 20200701/053335.505 - U00003549 UCUDB: ' 2' 'READ ' calls took '0:000.588.800' sec. 20200701/053335.505 - U00003549 UCUDB: ' 3502' 'CLOSESTMT ' calls took '0:001.683.085' sec. 20200701/053335.505 - U00003549 UCUDB: ' 1008' 'TRANSACT ' calls took '0:000.463.593' sec. ======================================================== Starting C++ batch mode loader... User account (user/domain) Startup parameter <-B REORG > Application name Launch from <.\> LoadLibrary <.\ucybdbun.dll> LoadLibrary pointer = <00007FFA42890000> Application return code = 1 C:\Automic\Automation.Platform\Utility\bin>c:\Automic\Automation.Platform\Agents\Windows\bin\UCXJWX6M.EXE JNR=0004817611 MNR=0100 PNR=2300 IPA=172.16.83.180 TYP=E RET=1 TXT=" Job ended with retcode" Program 'UC4 Job Messenger' version '12.0.1+build.632' started UCMDJP: ********************************************************************* UCMDJP: ** JOB 0004817611 (ProcID:0000065532) ABEND AT 01.07.2020/05:33:35 ** UCMDJP: ** UTC TIME 01.07.2020/10:33:35 ** UCMDJP: ** --------------------------------------------------------------- ** UCMDJP: ** RET-CODE: 1 ** UCMDJP: ** USED: 0.000 CPU ** UCMDJP: ********************************************************************* Connected with agent 'PRD2K12AP14' Program 'UC4 Job Messenger' version '12.0.1+build.632' terminated normally C:\Automic\Automation.Platform\Utility\bin>GOTO JOBENDE