Hi,

 we recently upgraded from Axosoft OnTime 8.1 to 9.1.3

On OnTime version 8.1, we had setup a SQL replication so that we could transfer data between two sites & make the accesibility to the DB more efficient.(slow using the web).

 The replication was stopped between the 2 sites

The DB was upgraded to 9.1.3 and the replication between the 2 sites was recreated. (new nsnapshot).

 we have found that the replication fails due to a ROWGUID COLUMN error.....please see below......

************** Exception Text **************

System.Data.SqlClient.SqlException: Insert Error: Column name or number of supplied values does not match table definition.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Axosoft.Common.Data.SqlHelper.ExecuteNonQuery(TransactionHelper txnh, CommandType commandType, String commandText, SqlParameter[] commandParameters)

   at Axosoft.OnTime.DataLayer.Incidents.ProcessAddItem(TransactionHelper txnh, OnTimeItem item)

   at Axosoft.OnTime.DataLayer.Incidents.AddItem(OnTimeItem incident, AuditSources auditSource, Boolean processNotification, Boolean doWorkflowNotifications, Boolean processAlerts, TransactionHelper txnhelper)

   at Axosoft.OnTime.DataLayer.OnTimeItems.AddItem(OnTimeItem item, AuditSources auditSource, Boolean processNotification, Boolean doWorkflowNotifications)

   at Axosoft.OnTimeWinControls.AddEditIncidentForm.SaveItem()

   at Axosoft.OnTimeWinControls.BaseAddEditItemForm.saveButton_Click(Object sender, EventArgs e)

   at System.Windows.Forms.Control.OnClick(EventArgs e)

   at System.Windows.Forms.Button.OnClick(EventArgs e)

   at System.Windows.Forms.Button.WndProc(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)