AnsweredAssumed Answered

Need Help on the DB Maintenance Job Error

Question asked by ShashankSingh606566 on Sep 27, 2016
Latest reply on Oct 1, 2016 by ShashankSingh606566
Hello,

I tried running the DB Maintenance job. Getting return code 1 and the job fails. Below is the job process and logs.
Can someone help me and suggest what is causing the error here.

Job Script for DB Reorg Job-

:RESTART CLNT_000, "Reorg for Client Zero"
UCYBDBre -B -S0000
!
@set retcode=%errorlevel%
@if NOT %ERRORLEVEL% == 0 goto :retcode
!
:RESTART CLNT_100, "Reorg for Client One Hundred"
UCYBDBre -B -S100
!
@set retcode=%errorlevel%
@if NOT %ERRORLEVEL% == 0 goto :retcode

Logs -

c:\uc4\utility\bin>C:\uc4\Agents\Windows\bin\UCXJWX6M.EXE
JNR=0007534005 MNR=0100 PNR=2302 IPA=10.XX.XX.75 TYP=S TXT="
Job started"
Program 'UC4 Job Messenger' version '9.00A' started
UCMDJP: *******************************************************************
UCMDJP: ** JOB 07534005 (ProcID:0000005776) START AT 27.09.2016/05:21:17 **
UCMDJP: *******************************************************************
Connected with agent 'WU****00'
Program 'UC4 Job Messenger' version '9.00A' terminated normally

c:\uc4\utility\bin>C:\uc4\Agents\Windows\bin\UCXJWX6M.EXE
JNR=0007534005 MNR=0100 PNR=2302 IPA=10.XX.XX.75 TXT="CLNT_000Reorg
for Client Zero"
Program 'UC4 Job Messenger' version '9.00A' started
UCMDJP: *******************************************************************
UCMDJP: ** RESTART: CLNT_000 - Reorg for Client Zero                     **
UCMDJP: *******************************************************************
Connected with agent 'WU****00'
Program 'UC4 Job Messenger' version '9.00A' terminated normally

c:\uc4\utility\bin>UCYBDBre -B -S0000
MsgNr <33106> / MsgInsert <..\TEMP\ucybdbre_log_00.txt>MsgNr <33105> /
MsgInsert <ucybdbre|9.00A216-341|-B -S0000 >MsgNr <32203> / MsgInsert
<TESTUC4QA/%>MsgNr <32206> / MsgInsert
<TESTUC4QA/%>========================================================
Starting C++ batch mode loader...
User account (user/domain) <TXXXXXXXA/FYYYYYL>
Startup parameter <-B -S0000 >
Application name <UCYBDBre>
Launch from <.\>
LoadLibrary <.\ucydbreorg.dll>
LoadLibrary pointer = <0000000010000000>
Application return code = 1

c:\uc4\utility\bin>C:\uc4\Agents\Windows\bin\UCXJWX6M.EXE
JNR=0007534005 MNR=0100 PNR=2302 IPA=10.XX.XX.75 TYP=E RET=1 TXT="
   Job ended with retcode"
Program 'UC4 Job Messenger' version '9.00A' started
UCMDJP: *******************************************************************
UCMDJP: ** JOB 07534005 (ProcID:0000005360) ABEND AT 27.09.2016/05:21:17 **
UCMDJP: ** ------------------------------------------------------------- **
UCMDJP: **                              RET-CODE:          1             **
UCMDJP: **                                  USED:          @ CPU         **
UCMDJP: *******************************************************************
Connected with agent 'WU****00'
Program 'UC4 Job Messenger' version '9.00A' terminated normally

c:\uc4\utility\bin>GOTO JOBENDE


Thanks,
Shashank

Outcomes