Error during checkin after merge

[JamesThorpe]

I've just done a merge of a dev branch into another branch (something we do at least once a month, been fine until now), and hit an error upon checkin:

 

Arithmetic overflow error converting expression to data type int

 

The server log shows the below - looks like some suspect revision IDs are being passed into the stored procedure call.  Any ideas on how to proceed?

 

Thanks,

James.

 

2014-06-02 09:57:50,886 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - Error ExecuteNonQuery. SQL [iNSERT INTO revisionmerge  (iobjid, fidsourcerevision, fiddestinationrevision,  itype, fiddestinationchangeset, fidlinkrealization)  VALUES (@objid, @srcRevId, @dstRevId, @stype, @dstCsetId, @linkIdId) ]

2014-06-02 09:57:50,887 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - @objid = [919983]

2014-06-02 09:57:50,888 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - @srcRevId = [-9223372036854775756]

2014-06-02 09:57:50,889 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - @dstRevId = [-9223372036854775756]

2014-06-02 09:57:50,889 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - @stype = [16]

2014-06-02 09:57:50,890 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - @dstCsetId = [14759]

2014-06-02 09:57:50,890 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - @linkIdId = [919772]

2014-06-02 09:57:50,892 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR CmCommand - Exception: Arithmetic overflow error converting expression to data type int.

The statement has been terminated.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   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, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

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

   at Codice.CM.Data.CmCommand.ExecuteNonQuery()

2014-06-02 09:57:50,893 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR Operations - Plastic server version: 5.0.44.528

 

2014-06-02 09:57:50,893 8c8a38f1-e431-467f-8ac1-139a8d2b7d23 NT AUTHORITY\SYSTEM at JAMESTHORPE ERROR Operations - OnError catching exception Arithmetic overflow error converting expression to data type int.

The statement has been terminated.

 

2014-06-02 09:57:50,895  NT AUTHORITY\SYSTEM at  ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:There has been an unexpected error "Arithmetic overflow error converting expression to data type int.

The statement has been terminated.". For more information check the server log.

 

[calbzam]

Hi,

 

In the merge tab, could you click on the "Explain merge" button?  I would like to know if there are more than one base involved in the merge operation (clicking on this button you can check: source, base and destination).

 

I guess it could be a recursive merge scenario that we have recently fixed. More info about recursive merge at: http://codicesoftware.blogspot.com/2011/09/merge-recursive-strategy.html

 

 

We have fixed this issue at: Plastic 5.0.44.562.  Could you upgrade and try again?

 

Regards,

Carlos

[JamesThorpe]

Yes - it's showing as having 2 base changesets.  It just seems odd as this pattern of branching/merging is something we do every month - shouldn't be any different to any previous month.

 

I'll update the server (and the rest of the team!) and see if it fixes it.

 

Cheers,

James.

[JamesThorpe]

That's fixed it - thanks again for the swift response

 

James.

[calbzam]

Great!