Error 'Could not find length-type delimiter' in Audit Trail when using WE8MSWIN1252 Database

(Doc ID 1348642.1)

Last updated on FEBRUARY 14, 2018

Applies to:

Siebel CRM - Version 8.1.1.3[21219] and later
Information in this document applies to any platform.

Symptoms

When attempting to access the Audit Trail Items view, the following error occurs:

Could not find length-type delimiter at index 2*C111*X_DESC_TEXT2*N11909*CTR: ...<Data from field> ... (SBL-DAT-60172)

or


Due to this issue, users cannot access their Audit Trail or create required reports from Audit Trail Item 2.

STEPS

The issue can be reproduced with the following steps:

- Siebel Database using WE8MSWIN1252 characterset

Scenario I:

  1. Define Audit Trail for Service Request Business Component, Description Field - e.g "geändert"
  2. Create a new Service Request record, inserting "special characters" in the Description field.
  3. Go to Site Map > Audit Trail > Audit Trail Items view.
  4. Query for the Service Request created in Step #2.

Scenario II:

  1. Go to Marketing Plans > Budget Request and create a new record
  2. Drilldown and go to "Audit Trail" View Tab

Error:

We detected an Error which may have occurred for one or more of the following reasons:

 Could not find length-type delimiter at index 2*C217*APPROVED_BDGT_AMT17*TOT_REQUESTED_AMT2*N21*01*02*O20*0*V in data '62'.(SBL-DAT-60172)

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms