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.
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.
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 |
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.
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 |