Hi Trent,



Well - I can't replicate the issue - everything works as advertised.



I don't think trying to revert my system back to how it was is worth the effort. The way things work now with the BO truncating is great - we didn't realise the BO actually did this and it was something on a long term "things to do" list that we can now cross off.



We log all our exceptions and following is the one that started this thread. When the user called re the error we assumed it was sometype of 'string too long' issue and the Batch Number the user had entered was about 30 characters and the field size (at that time) was 20. We asked him to try again but keep the batch number to less than 20 characters and all was ok.



Cheers, Peter





Date and Time: 22/01/2010 11:47:25 AM

(Inner Exception)

Exception Source: .Net SqlClient Data Provider

Exception Type: System.Data.SqlClient.SqlException

Exception Message: String or binary data would be truncated.

The statement has been terminated.

Exception Target Site: OnError



---- Stack Trace ----

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

TMSBatchesMaint.exe: N 1953274

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

TMSBatchesMaint.exe: N 4849707

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

TMSBatchesMaint.exe: N 00194

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

TMSBatchesMaint.exe: N 02392

System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

TMSBatchesMaint.exe: N 00033

System.Data.SqlClient.SqlDataReader.get_MetaData()

TMSBatchesMaint.exe: N 00096

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

TMSBatchesMaint.exe: N 00297

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

TMSBatchesMaint.exe: N 00954

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

TMSBatchesMaint.exe: N 00162

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

TMSBatchesMaint.exe: N 00032

System.Data.SqlClient.SqlCommand.ExecuteReader(behavior As CommandBehavior, method As String)

TMSBatchesMaint.exe: N 00141

System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(behavior As CommandBehavior)

TMSBatchesMaint.exe: N 00012

System.Data.Common.DbCommand.ExecuteReader(behavior As CommandBehavior)

TMSBatchesMaint.exe: N 00010

MicroFour.StrataFrame.Data.DbDataSourceItem.InternalExecuteReader(Command As DbCommand, IsTransactional As Boolean, TransactionKey As String)

TMSBatchesMaint.exe: N 00244

MicroFour.StrataFrame.Data.SqlDataSourceItem.UpdateRow(QueryInfo As QueryInformation, RowToUpdate As DataRow, ConcurrencyHandler As ConcurrencyExceptionHandler, RowErrorHandler As AddRowErrorHandler, RecreateCommand As Boolean)

TMSBatchesMaint.exe: N 03833

MicroFour.StrataFrame.Data.DbDataSourceItem.UpdateRow(QueryInfo As QueryInformation, RowToUpdate As DataRow, ConcurrencyHandler As ConcurrencyExceptionHandler, RowErrorHandler As AddRowErrorHandler)

TMSBatchesMaint.exe: N 00053

MicroFour.StrataFrame.Data.DataLayer.UpdateDataTableThread(ThreadParams As Object)

TMSBatchesMaint.exe: N 00772







(Outer Exception)

Exception Source: MicroFour StrataFrame Business

Exception Type: MicroFour.StrataFrame.Data.DataLayerSavingException

Exception Message: String or binary data would be truncated.

The statement has been terminated.

Exception Target Site: UpdateDataTable



---- Stack Trace ----

MicroFour.StrataFrame.Data.DataLayer.UpdateDataTable(TableToUpdate As DataTable, Transactional As Boolean, TransactionKey As String)

TMSBatchesMaint.exe: N 01129

MicroFour.StrataFrame.Data.DataLayer.Save(TableToSave As DataTable, Transactional As Boolean, TransactionKey As String)

TMSBatchesMaint.exe: N 00479

MicroFour.StrataFrame.Business.BusinessLayer.Save(Transactional As Boolean, TransactionKey As String)

TMSBatchesMaint.exe: N 01784

MicroFour.StrataFrame.Business.BusinessLayer.Save()

TMSBatchesMaint.exe: N 00047

TMSBatchesMaint.frmBTC.CanAllocUnallocProcede(PUNIDAllocateList As String)

frmBTC.vb: line 1879, col 17, IL 0052

TMSBatchesMaint.frmBTC.btnAllocUnalloc_Click(sender As Object, e As EventArgs)

frmBTC.vb: line 1807, col 13, IL 1756

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

TMSBatchesMaint.exe: N 00111

DevExpress.XtraEditors.BaseButton.OnClick(e As EventArgs)

TMSBatchesMaint.exe: N 00069

DevExpress.XtraEditors.BaseButton.OnMouseUp(e As MouseEventArgs)

TMSBatchesMaint.exe: N 00112

System.Windows.Forms.Control.WmMouseUp(m As Message&, button As MouseButtons, clicks As Int32)

TMSBatchesMaint.exe: N 00654

System.Windows.Forms.Control.WndProc(m As Message&)

TMSBatchesMaint.exe: N 8788613

DevExpress.Utils.Controls.ControlBase.WndProc(m As Message&)

TMSBatchesMaint.exe: N 00063

System.Windows.Forms.ControlNativewindow.OnMessage(m As Message&)

TMSBatchesMaint.exe: N 00015

System.Windows.Forms.ControlNativewindow.WndProc(m As Message&)

TMSBatchesMaint.exe: N 00048

System.Windows.Forms.Nativewindow.Callback(hWnd As IntPtr, msg As Int32, wparam As IntPtr, lparam As IntPtr)

TMSBatchesMaint.exe: N 00089









Detailed System information follows:

Machine Name: TMSAPPSERVTWM

IP Address: 10.8.0.249 192.168.50.1 192.168.51.1

Current User: TMSTWMathan



Terminal Services: YES

Terminal Name: NATHAN

Terminal IP: 10.8.0.22

Terminal Display: 1024x768, 16-bit colour

Session Name: Office Sessions#5



Command Line: "C:\Program Files\Systems Engineering\TMS\TMSBatchesMaint.exe" BatchType=4



Application Domain: TMSBatchesMaint.exe

Assembly Codebase: file:///C:/Program Files/Systems Engineering/TMS/TMSBatchesMaint.exe

Assembly Full Name: TMSBatchesMaint, Version=2.0.0.5975, Culture=neutral, PublicKeyToken=72468ceb77b783ec

Assembly Version: 2.0.0.5975

Assembly Build Date: 27/11/2009 4:54:34 PM





---- File Versions ----

bartend.exe 9.10.2617.1857

psexec.exe 1.96

TMSBackup - Copy.exe 2.0.0.5900

TMSBackup.exe 2.0.0.5975

TMSBatchesMaint.exe 2.0.0.5975

TMSControlTableMaint.exe 2.0.0.5975

TMSDatabaseConfig.exe 2.0.0.5975

TMSERPInterface.exe 2.0.0.5975

TMSERPInterfaceControls.exe 2.0.0.5975

TMSGradingStation.exe 2.0.0.5975

TMSHousekeepingService.exe 2.0.0.5975

TMSInstall.exe 2.0.0.5975

TMSLaunchTerminal.exe 2.0.0.5975

TMSLocalisationMaint.exe 2.0.0.5975

TMSLogAccess.exe 2.0.0.5975

TMSMeasuringStation.exe 2.0.0.5975

TMSMenu.exe 2.0.0.5975

TMSOrderAlloc.exe 2.0.0.5975

TMSOrderAllocService.exe 2.0.0.5975

TMSOrders - Copy.exe 2.0.0.5900

TMSOrders.exe 2.0.0.5975

TMSPartPUNSum.exe 2.0.0.5975

TMSProductionMaint.exe 2.0.0.5975

TMSRecipes.exe 2.0.0.5975

TMSReplication.exe 2.0.0.5975

TMSReport.exe 2.0.0.5975

TMSSerial.exe 2.0.0.5975

TMSSerialTest.exe 2.0.0.5975

TMSStationMaint.exe 2.0.0.5975

TMSStationManning.exe 2.0.0.5975

TMSSystemTableMaint.exe 2.0.0.5975

BOAttributes.dll 2.0.0.5975

BOBatches - Copy (2).dll 2.0.0.5900

BOBatches - Copy.dll 2.0.0.5900

BOBatches.dll 2.0.0.5975

BOERPInterface - Copy.dll 2.0.0.5900

BOERPInterface.dll 2.0.0.5975

BOInventory.dll 2.0.0.5975

BOLocalisationEditor.dll 2.0.0.5975

BOOrders.dll 2.0.0.5975

BOProcStation - Copy.dll 2.0.0.5900

BOProcStation.dll 2.0.0.5975

BORecipes.dll 2.0.0.5975

BOReport.dll 2.0.0.5975

BOTableMaint.dll 2.0.0.5975

BOTMSSerial.dll 2.0.0.5975

DevExpress.BonusSkins.v9.2.dll 9.2.4.0

DevExpress.Charts.v9.2.Core.dll 9.2.4.0

DevExpress.Data.v9.2.dll 9.2.4.0

DevExpress.Utils.v9.2.dll 9.2.4.0

DevExpress.XtraBars.v9.2.dll 9.2.4.0

DevExpress.XtraCharts.v9.2.dll 9.2.4.0

DevExpress.XtraCharts.v9.2.UI.dll 9.2.4.0

DevExpress.XtraEditors.v9.2.dll 9.2.4.0

DevExpress.XtraGrid.v9.2.dll 9.2.4.0

DevExpress.XtraLayout.v9.2.dll 9.2.4.0

DevExpress.XtraNavBar.v9.2.dll 9.2.4.0

DevExpress.XtraPivotGrid.v9.2.Core.dll 9.2.4.0

DevExpress.XtraPivotGrid.v9.2.dll 9.2.4.0

DevExpress.XtraPrinting.v9.2.dll 9.2.4.0

DevExpress.XtraReports.v9.2.dll 9.2.4.0

DevExpress.XtraRichEdit.v9.2.dll 9.2.4.0

DevExpress.XtraScheduler.v9.2.Core.dll 9.2.4.0

DevExpress.XtraScheduler.v9.2.dll 9.2.4.0

DevExpress.XtraTreeList.v9.2.dll 9.2.4.0

DevExpress.XtraVerticalGrid.v9.2.dll 9.2.4.0

EnvDTE.dll 8.0.50727.1826 (QFE.050727-1800)

Interop.BarTender.dll 9.1.0.0

Interop.VBA.dll 6.0.0.0

MicroFour StrataFrame Base.dll 1.7.0.0

MicroFour StrataFrame Business.dll 1.7.0.0

MicroFour StrataFrame Inherited UI.dll 1.7.0.0

MicroFour StrataFrame Security.dll 1.7.0.0

MicroFour StrataFrame UI.dll 1.7.0.0

Microsoft.MSXML.dll 8.0.50727.1826 (QFE.050727-1800)

Microsoft.VisualStudio.OLE.Interop.dll 7.10.6070

Microsoft.VisualStudio.Shell.Interop.8.0.dll 8.0.50727.1826 (QFE.050727-1800)

Microsoft.VisualStudio.Shell.Interop.dll 7.10.6071

Microsoft.VisualStudio.TextManager.Interop.8.0.dll 8.0.50727.1826 (QFE.050727-1800)

Microsoft.VisualStudio.TextManager.Interop.dll 7.10.6070

SerialNET.dll 2.0.0.1

UtilBatches.dll 2.0.0.5975

UtilBOBase.dll 2.0.0.5975

UtilControls.dll 2.0.0.5975

UtilDeviceIO.dll 2.0.0.5975

UtilEnums.dll 2.0.0.5975

UtilExceptions.dll 2.0.0.5975

UtilForms.dll 2.0.0.5975

UtilHelp.dll 2.0.0.5975

UtilLabelPrint.dll 2.0.0.5975

UtilLocalisation.dll 2.0.0.5975

UtilLogging.dll 2.0.0.5975

UtilResource.dll 2.0.0.5975

UtilRunTimeEnvironment.dll 2.0.0.5975

UtilSecurity.dll 2.0.0.5975

UtilSundry.dll 2.0.0.5975

Yeah, that is a lot to dig through. If you can come up with a reproducible scenario, let me know and I will be more than happy to help. Glad you got it going forward!