KB73057917: WebCenter - SQL error when uploading file

Summary

When uploading a file via browser to WebCenter, error appears and the file is not uploaded.

Symptoms

When uploading a file via browser to WebCenter, the following error message appears: "The SQL request made is invalid. String or binary data would be truncated".

Solution

The total length of the path and the filename exceeds Operating System limits.

It can be either the filename or the path to the file. If the filename seems to be a reasonable length, try moving the file from a deep nested level or rename some of the folder names if they are of excessive length.

The SQL field (here filename) is limited to 255 characters.