ARC0116 LOG WHERE condition is too long to fit in the SQL buffer (%s characters too long). - Teradata Tools and Utilities

Archive/Recovery (ARC Prefix) Messages

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

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

Explanation:

The LOG 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 LOG WHERE condition. However, the buffer that is used to send the LOG WHERE condition to the database has a maximum length and the LOG 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 LOG WHERE condition can not be given. To aid the user in modifying the LOG 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 LOG WHERE condition during that specific execution of ARC. This number may not be valid during a subsequent execution of ARC.

Remedy:

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