SAP Knowledge Base Article - Public

1554505 - "String Data, Length Mismatch" error occurs when insert data to Audit DB


When insert data to Audit DB, the "String Data, Length Mismatch" error occurs frequently in application log of Windows Event Viewer.


  • BusinessObjects Enterprise XI 3.1
  • Microsoft Windows Server 2003 R2 Standard x64 Edition Service Pack 2
  • SQL 2008 workgroup Japanese version

Reproducing the Issue

  1. Login to CMC.
  2. Enable Audit event of CentralManagementServer and WebIntelligenceProcessingServer.
  3. Login to InfoView.
  4. Use any universe(eg: eFashion) to create a Web Intelligence document.
  5. Save the Web Intelligence document.
  6. Wait for a few minutes.
  7. Check application log of Windows Event viewer.
  8. The following error occurs frequently.
    The description for Event ID ( 63127 ) in Source ( BusinessObjects_CMS ) could not be found. It
    contains the following insertion string(s): .
    [Microsoft][SQL Server Native Client 10.0]"String Data, Length Mismatch".
    * This issue only occurs in 64bit OS, and Japanese specific.


The issue has been identified and tracked under ID ADAPT01509599.


The issue has been fixed in BusinessObjects Enterprise XI 3.1 FP3.5.


BOE XI 3.1, audit, insert, app log, event log, SQL workgroup, Japanese version , KBA , BI-BIP-SL , Semantic Layer , Bug Filed


Crystal Reports 2008 V1