In the Symantec Enterprise Vault Event Log:
Source: Accelerator Service Processor
Event ID: 245
Task Category: None
Level: Error
Keywords: Classic
Description:
APP AS - Customer ID: 2 - Error updating a Production. System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
at KVS.Accelerator.Production.Productions.UpdateDS(Int32 nCaseID, ProductionDS aDS)Source: Accelerator Service Processor
Event ID: 241
Task Category: None
Level: Error
Keywords: Classic
Description:
APP AS - Customer ID: 2 - An error occurred when saving a Production. System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at KVS.Accelerator.Production.Productions.UpdateDS(Int32 nCaseID, ProductionDS aDS)
at KVS.Accelerator.Production.ProductionRun.NewProductionRun(ProductionDS aProductionDS)
From a Dtrace log of the AcceleratorService process:
EV-H {-} Exception: Error Production_UpdateError Info:{ACCELERATOREVENT.EN_US} {C2.EN_US} Error updating a Production. System.Data.SqlClient.SqlException: String or binary data would be truncated.|The statement has been terminated.| at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)| at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)| at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)| at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)| at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)| at KVS.Accelerator.Production.Productions.UpdateDS(Int32 nCaseID, ProductionDS aDS) Diag: Type:System.Exception ST: Inner:None
EV-H {-} Exception: Error Production_SaveError Info:{ACCELERATOREVENT.EN_US} {C2.EN_US} An error occurred when saving a Production. System.Data.SqlClient.SqlException: String or binary data would be truncated.|The statement has been terminated.| at KVS.Accelerator.Production.Productions.UpdateDS(Int32 nCaseID, ProductionDS aDS)| at KVS.Accelerator.Production.ProductionRun.NewProductionRun(ProductionDS aProductionDS) Diag: Type:System.Exception ST: Inner:None
EV-H {-} Exception: String or binary data would be truncated.|The statement has been terminated. Info:{RBO_EXPORTPRODUCTION.EN_US} {C2.EN_US} Diag:Num:8152 State:13 Sev:16 Svr:SQL Proc:usp_Production_add Line:44 Type:System.Data.SqlClient.SqlException ST: at KVS.Accelerator.Production.ProductionRun.NewProductionRun(ProductionDS aProductionDS)| at KVS.Accelerator.RBO.RBO_ExportProduction.Add(ProductionDS NewOne) Inner:None
Attempting to create a Production export with a 'Prefix:' field containing more than 10 characters, the Production disappears, does not run, and throws Event ID 241 and 245 errors into the Symantec Enterprise Vault Event Log.
The total length of the Bates number would be up to 50 characters with the leading 9 or 10 allocated to the prefix and the remaining characters allocated to sequential numbering and separators (dashes). A 10 character limit on the "Prefix:" field should be sufficient as this total length may be dictated by the prefixes dictated by counsel and/or the courts.
The "Prefix:" field limit is 10 Characters and it should not contain any characters which are not valid in the File System(such as: spaces , \ / * ? | < >).