Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Sharepoint UserData table issue

  Asked By: Noah Scott         Date: Dec 22, 2009      Category: Sharepoint      Views: 337
 

I am
getting
this error: "The list item could not be added because the length of
the
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.

Tagged:        

 

1 Answer Found

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

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].