Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Sharepoint UserData table issue

  Asked By: Noah    Date: Dec 22    Category: Sharepoint    Views: 1690

I am
this error: "The list item could not be added because the length of
fields was too long. Please shorten the new entries or remove some
fields from this list."
I think the problem is with my trigger. It works fine on non-
Sharepoint databases. I don't know enough about Sharepoint to know
what the problem is. I created a table with a trigger and it inserts
the data into the Userdata table.

Is the error regarding to the fields in the database or the fields in
the Sharepoint form? The insert works when its just inserting into
the Sharepoint database, but not when the trigger is added to the
table. Also, because there is an error, it does not allow any of the
users to use the Sharepoint sites to create new records. Please help.



1 Answer Found

Answer #1    Answered By: Nisha Gadre     Answered On: Dec 22

First off, if you are not aware of it, adding triggers to the SharePoint
database is unsupported.

Thats said, the error  you are getting is likely the result of trying to add text
fields >256 chars in length. This limit is used throughout SharePoint and
cannot be changed.

Didn't find what you were looking for? Find more on Sharepoint UserData table issue Or get search suggestion and latest updates.