ARC0115 PARTITIONS WHERE condition is too long to fit in the SQL buffer (%s characters too long).

Archive/Recovery (ARC Prefix) Messages

brand
Teradata Tools and Utilities
prodname
Teradata Tools and Utilities
vrm_release
15.10
category
Programming Reference
featnum
B035-1096-151K

ARC0115 PARTITIONS WHERE condition is too long to fit in the SQL buffer (%s characters too long).

Explanation:

The PARTITIONS WHERE condition that was specified is too long to fit in the SQL buffer so the SQL request can not be sent to the database. There is no explicit maximum length for a PARTITIONS WHERE condition. However, the buffer that is used to send the PARTITIONS WHERE clause to the database has a maximum length and the PARTITIONS WHERE condition must fit completely within that buffer. Since other data may exist in the buffer and may be variable in length, a max size for a PARTITIONS WHERE condition can not be given. To aid the user in modifying the PARTITION WHERE condition, the number of characters exceeding the buffer length is given.

For Whom:

 End User.

Notes:

The number of characters given in the error message is the number of excess characters in the PARTITIONS WHERE condition during that specific execution of ARC. This number may not be valid during a subsequent execution of ARC.

Remedy:

Modify the PARTITIONS WHERE condition to reduce its size by at least the number of characters indicated in the error message and resubmit the job.