Return Codes - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Return Codes

Teradata ARC provides a return (or condition) code value to the client operating system during termination logic. The return code indicates the final status of a task.

Return code integers increase in value as the events causing them increase in severity, and the presence of a return code indicates that at least one message that set the return code is printed in the output file. Any number of messages associated with a lesser severity might also be printed in the output file. For more information about error messages, see Messages.

Table 16 lists the Teradata ARC return codes, their descriptions, and the recommended solution for each.

 

Table 16: Return Codes 

Return Code

Description

Recommended Action

0

A normal termination of the utility.

 

4

At least one warning message is in the output listing.

Review the output to determine which warnings and possible consequences are printed.

8

At least one nonfatal error message is in the output listing.

A nonfatal error normally indicates that a request could not be met. A nonfatal error does not adversely affect other requests nor does it terminate task execution.

Review the output to determine which errors are listed, and then deal with each error accordingly.

12

A fatal error message is in the output listing.

A fatal error terminates execution. Restarting the task might be possible.

Review the output to determine which error occurred and its cause.

16

An internal software error message is in the output listing.

An internal error terminates execution.

Gather as much information as possible (including the output listing), and contact Teradata customer support.

Table 17 lists the Teradata Database error message numbers, their associated severity levels, and the associated return codes.

The six error messages listed as NORMAL severity are restartable errors that indicate the Teradata Database failed. Teradata ARC waits for the Teradata Database to restart before it automatically resubmits or restarts any affected requests or transactions.

Any other message numbers not shown in this table are treated as FATAL.

 

Table 17: Database Error Messages 

Database Error Message Numbers

Severity Level

Return Code

2825

2826

2828

3119

3120

3897

 

 

NORMAL

0

2123

2631

2639

2641

2654

2805

2835

2837

2838

2840

2921

2971

2972

3111

3598

3603

3803

3804

3805

5312

5419

5512

5588

6933

7485

7486

7535

8234

8258

8261

 

 

8267

8268

8269

8270

8271

 

 

8274

8295

8297

9012

9017

9019

9020

9021

9136
94379486973398519901

WARNING

4

2815

2830

2897

2920

2926

3523

3524

3566

3613

3656

3658

3737

3802

3807

3824

3853

3873

3877

3916

3933

5310

8232

8298

 

ERROR

8

2538

2541

2644

2801

2809

2828

2843

2866

2868

3596

8228

8229

8230

8231

8242

8243

8244

8245

8246

8247

8248

8249

8250

8251

8252

8253

8254

FATAL

12

None

 

 

 

 

INTERNAL

16

Note: The DBSERROR command line parameter allows the specification of a different severity level for any of the Teradata Database error codes listed above. See “DBSERROR” on page 114 for more details.

Table 18 lists the error message numbers that are generated on the client side, their associated severity levels, and associated return codes.

 

Table 18: Client-Generated Error Messages 

Client Generated Error Message Number (ARCxxxx)

Severity Level

Return Code

5

6

12

13

18

20

22

101

103

104

106

107

111

113

118

120

122

126

128

203

225

703

706

707

708

721

725

726

809

1001

1003

1004

1005

1006

1010

1011

1012

1014

1015

1016

1022

1023

1024

1025

1026

1027

1029

1031

1032

1033

1034

1036

1201

1213

1214

1217

1218

1223

1225

1226

1228

1232

1235

1239

1240

1241

1242

1244

1245

1249

1250

1251

1254

1256

1257

1263

1266

1267

1269

1272

1274

1277

1278

1032

1033

1034

1401

1402

1403

1404

1501

1800

1801

1803

1804

1805

1900

2202

WARNING

4

108

119

715

727

728

729

730

802

1013

1017

1030

1035

1200

1202

1206

1227

1248

1268

1273

1406

1407

1408

1409

1410

2100

2102

2103

2104

2107

2201

ERROR

8

3

4

7

8

9

10

11

14

15

16

17

19

21

23

24

25

26

27

28

29

30

31

32

100

102

105

109

110

112

114

115

116

117

121

123

124

125

127

200

201

202

204

205

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

600

601

700

701

702

704

705

710

711

712

713

714

716

717

718

719

720

722

723

724

731

800

801

803

804

805

806

807

808

1000

1002

1018

1019

1020

1021

1028

1201

1203

1204

1207

1208

1209

1210

1211

1215

1216

1219

1220

1221

1222

1230

1231

1233

1234

1236

1237

1238

1243

1246

1247

1252

1253

1255

1258

1259

1260

1261

1262

1264

1265

1270

1271

1275

1276

1279

1280

1400

1405

1500

1802

1806

1901

2000

2001

2002

2003

2004

2101

2105

2106

2200

2203

2204

2205

2206

FATAL

12

1

206

 

 

 

INTERNAL

16