1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Custom module SQL Error after upgradinbg to 4.1 SP1

Custom module SQL Error after upgradinbg to 4.1 SP1

4 posts, 0 answered
  1. Vincent
    Vincent avatar
    41 posts
    Registered:
    21 Sep 2007
    24 May 2011
    Link to this post
    Hi,

    I have created a simple contact module based on the JobsIntermediate module with SSDK 4.0.
    After upgrading to 4.1 SP1, and changing code to be compatible (FluentMapping etc...)  I get an error executing the SaveChanges method :

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
      
    Exception Details: Telerik.OpenAccess.RT.sql.SQLException: Impossible d'insérer la valeur NULL dans la colonne 'voa_version', table '...\WWW-ASALOG-COM-V4\APP_DATA\SITEFINITY.MDF.dbo.ContactsModule'. Cette colonne n'accepte pas les valeurs NULL. Échec de INSERT.
    L'instruction a été arrêtée.
      
    Source Error: 
      
      
    Line 144:            application.SentMessage = this.SentMessage;
    Line 145:
    Line 146:            manager.SaveChanges();
    Line 147:
    Line 148:            NotificationMessage.ShowPositiveMessage(Res.Get<ContactsResources>().NotificationMessage);
       
      
    Source File: D:\DOSSIERS\D02100 - asaLog Site web v4\www-asalog-com-v4\ContactsIntermediate\PublicControls\ContactApplicationSubmit.cs    Line: 146 
      
    Stack Trace: 
      
      
    [SQLException: Impossible d'insérer la valeur NULL dans la colonne 'voa_version', table '...\WWW-ASALOG-COM-V4\APP_DATA\SITEFINITY.MDF.dbo.ContactsModule'. Cette colonne n'accepte pas les valeurs NULL. Échec de INSERT.
    L'instruction a été arrêtée.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute() +919
       OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute() +119
       OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes) +2477
      
    [DataStoreException: Insert of '153943282-92306fc9-d4ab-47e8-a8d0-c55e08874702' failed: Telerik.OpenAccess.RT.sql.SQLException: Impossible d'insérer la valeur NULL dans la colonne 'voa_version', table '...\WWW-ASALOG-COM-V4\APP_DATA\SITEFINITY.MDF.dbo.ContactsModule'. Cette colonne n'accepte pas les valeurs NULL. Échec de INSERT.
    L'instruction a été arrêtée.
       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 [ContactsModule] ([email], [first_name], [last_name], [phone], [referral], [description_], [title_], [url_name_], [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]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    (set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: Impossible d'insérer la valeur NULL dans la colonne 'voa_version', table '...\WWW-ASALOG-COM-V4\APP_DATA\SITEFINITY.MDF.dbo.ContactsModule'. Cette colonne n'accepte pas les valeurs NULL. Échec de INSERT.
    L'instruction a été arrêtée.
       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)]
       DynamicModule.ns.Wrapped_OpenAccessContactsDataProvider_778aa3be9445475d98068bc8cbd43d92.CommitTransaction() +342
       Telerik.Sitefinity.Data.ManagerBase`1.SaveChanges() +53
       ContactsIntermediate.PublicControls.ContactApplicationSubmit.ContactApplicationSubmit_Click(Object sender, EventArgs e) in D:\DOSSIERS\D02100 - asaLog Site web v4\www-asalog-com-v4\ContactsIntermediate\PublicControls\ContactApplicationSubmit.cs:146
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +145
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3410
      
      

    I have tried to delete the table to see if it will be recreated but have an other error (object name not valid)

    Thank you

    Regards
    Vincent
  2. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    25 May 2011
    Link to this post
    Hi Vincent,

    The error states that the column voa_version in the table ContactsModule does not allow NULL values to be inserted. You can go and modify the database table to allow nulls which should fix the issue immediately. If you allow the column to accept nulls you will not get the error, but there is some issue with your project ( or module ).

    Kind regards,
    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Vincent
    Vincent avatar
    41 posts
    Registered:
    21 Sep 2007
    25 May 2011
    Link to this post
    Hi Victor,

    Thank you for getting back to me and giving me a workaround.
    I would like to know what is this issue coming from because :
    1/ my custom module was working fine in 4.0
    2/ voa-version is a hidden field, meaning  it is managed by OpenAccess internaly though I don't know what I need to change, the field voa_version is not even apparent in the code

    Regards
    Vincent
  4. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    26 May 2011
    Link to this post
    Hello Vincent,

    The error may be result of the upgrade process not conducted properly. You can change the settings of the voa_version column through the sql management tool by running such the query ( make sure to change the tables so they match yours ):

    ALTER TABLE [YOURDATABASE].[dbo].[YOURTABLE]
    ALTER COLUMN THECOLLUMNTHATHASTOBECHANGED varchar(20) NOT NULL;
    GO


    Best wishes,
    Victor Velev
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
4 posts, 0 answered