Axosoft - Upgrade from 8.x to 9.x causes replication issues

isalgado — Mon, 21 Dec 2009 00:37:29 GMT

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)

************** Loaded Assemblies **************

we are wondering if there is a work around this issue. We had tested v9.0 (with replication) & this seem to work but on v9.1.3 replication IS NOT working due to the ROWGUID COLUMN error.

I found a previous post (by Dan Suceava @ Axosoft), where he managed to resolve this issue, so we are wondering if he could take a look at our issue & see if he can find a solution.

Thank You

regards

Ian Salgado

email: isalgado@quofore.com

Quofore P/L

OnTime General

Axosoft - Upgrade from 8.x to 9.x causes replication issues