This project is read-only.
1
Vote

Error when Page Description is longer than 255 characters

description

This is a bit of a minor error really because the Page Description being imported probably shouldn't be that long. This is the error being received:
 
Insert of '21558530-154c8534-bded-4748-917f-f473b52d2f6c' failed: Telerik.OpenAccess.RT.sql.SQLException: String or binary data would be truncated.
The statement has been terminated.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
INSERT INTO [sf_page_data] ([html_title_], [html_title_bg], [html_title_de], [html_title_en], [html_title_es], [html_title_fr], [keywords_], [keywords_bg], [keywords_de], [keywords_en], [keywords_es], [keywords_fr], [addtnl_rls_rdrct_t_default_one], [allow_multiple_urls], [buffer_output], [cache_duration], [cache_output], [cache_profile], [comments_count], [crawlable], [culture], [enable_event_validation], [enable_session_state], [enable_theming], [enable_view_state], [enable_view_state_mac], [error_page], [external_page], [head_tag_content], [include_script_manger], [is_auto_created], [last_control_id], [localization_strategy], [locked_by], [maintain_scroll], [master_page], [multiple_navigation_nodes], [page_languagelink_id], [require_ssl], [response_encoding], [sliding_expiration], [template_id], [theme], [trace], [trace_mode], [translation_initialized], [ui_culture], [url_evaluation_mode], [validate_request], [view_state_encryption], [description_], [description_bg], [description_de], [description_en], [description_es], [description_fr], [title_], [title_bg], [title_de], [title_en], [title_es], [title_fr], [url_name_], [url_name_bg], [url_name_de], [url_name_en], [url_name_es], [url_name_fr], [allow_comments], [allow_track_backs], [app_name], [approve_comments], [content_id], [content_state], [date_created], [default_page_id], [draft_culture], [email_author], [expiration_date], [last_modified], [last_modified_by], [original_content_id], [ownr], [post_rights], [publication_date], [source_key], [status], [vrsion], [views_count], [visible], [votes_count], [votes_sum], [voa_version]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: String or binary data would be truncated.
The statement has been terminated.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
at DynamicModule.ns.Wrapped_OpenAccessPageProvider_23329686a9d6403f912b4f67ddb265fe.CommitTransaction()
at Telerik.Sitefinity.Data.ManagerBase`1.SaveChanges()
at Migration.Classes.MigrationPages.ImportPage(MigrationPageGroup pageGroupContent) in \SitefinityMigration\Classes\MigrationPages.cs:line 312
at Migration.MigrationModule.ImportPages() in\SitefinityMigration\MigrationModule.cs:line 1052
 
 
But what does happen is once this fails any other inserts get an error of:
You are trying to access item that no longer exists. The most probable reason is that it has been deleted by another user.
followed by:
No active transaction.
 
I have noticed this a couple of times, is it possible that when a save fails that either it quits after that point or that it can continue?

comments

smolam wrote Feb 21, 2011 at 8:30 AM

The same goes for the keywords field. One thing worth noting which maybe needs to be addressed in the data layer for pages is that PageNode.Description and PageData.Description have different lengths?

wrote Feb 13, 2013 at 1:24 AM