Insert not working on remote machine! RSS

• • Reply
  

  jocker_wow

  Member

  129 Points

  89 Posts

  Insert not working on remote machine!

  Dec 13, 2007 01:29 PM|LINK

  Hi,

  In my localmachine everything is working fine. But online only Update, Delete and Select statements are working correctly, while INSERT doesn't work and I got a similar error to this when I try to insert any data into any table:

  Server Error in '/' Application.

  ---

  Cannot insert the value NULL into column 'messageId', table 'db.dbo.mail'; column does not allow nulls. INSERT fails.
  The statement has been terminated.

  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: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'messageId', table 'db.dbo.mail'; column does not allow nulls. INSERT fails.
  The statement has been terminated.
  
  Source Error:
  
  

  An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

  
  Stack Trace:
  
  

  [SqlException (0x80131904): Cannot insert the value NULL into column 'messageId', table 'db.dbo.mail'; column does not allow nulls. INSERT fails. The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +149 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +404 System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary values) +447 System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +72 System.Web.UI.WebControls.FormView.HandleInsert(String commandArg, Boolean causesValidation) +388 System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +602 System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) +95 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) +109 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

  
  

  ---

  Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

  So wat's wrong? 

  Note:
  1-The Insert statement work correctly in localmachine.
  2-The application and the sql database are both in remote hosts.
  3-The application configuration had been checked and is correct.
  

  Regards...
  M.Nagieb
  Sr. Web Developer
• • Reply
  

  gopalanmani

  Star

  7826 Points

  1320 Posts

  Re: Insert not working on remote machine!

  Dec 13, 2007 05:15 PM|LINK

    

  Incase in localy your database messageid column contain autoincrement. But remote server  does not.

  so compare the local and server database tables ('db.dbo.mail' )

  Regards,
  Gopalan Mani
  My Tech blog
  • Marked as answer by Nai-Dong Jin - MSFT on Dec 18, 2007 04:21 AM
• • Reply
  

  jocker_wow

  Member

  129 Points

  89 Posts

  Re: Insert not working on remote machine!

  Dec 14, 2007 10:30 AM|LINK

  Hey gopalanmani,

  I didn't thought about that before, I'll try soon just after my holiday!

  Thanks again!

  Regards...
  M.Nagieb
  Sr. Web Developer
• • Reply
  

  jocker_wow

  Member

  129 Points

  89 Posts

  Re: Insert not working on remote machine!

  Jan 07, 2008 06:54 AM|LINK

  Thanks a lot gopalanmani! It was all about autoincrement! When I copied the Database to the destination, id didn't copied the AutoIncrement condition, so I've done this manually and it works.

   Thanks again!

  Regards...
  M.Nagieb
  Sr. Web Developer