My Oracle Support Banner

How To Troubleshoot the error ORA-24345 "A Truncation or null fetch error occurred"? (Doc ID 476591.1)

Last updated on JULY 18, 2023

Applies to:

Siebel Tools - Version 7.5.3.9 [16194] and later
Siebel CRM - Version 7.5.3.9 [16194] and later
Information in this document applies to any platform.

Purpose

After applying a patch on the Siebel application, some views may generate an error whereas they did not before, for the same configuration and same data. The reason behind this behavior is that the Oracle connector has been modified. The result of this modification means that it no longer accepts fetching data from columns longer than the size of the field that the column is mapped to.
 
For example, a field with the Type property set to "DTYPE_ID" mapped to a column with a physical type of Varchar of 30 characters can lead to this error. The buffer reserved in memory for such a field has a length of 15 characters, as Ids are 15 characters long. If, AND ONLY IF, at least one of the records returned by the applet contains data in this column longer than 15 characters, the error occurs. If no records have data longer than 15 characters, the error does not occur.
 
Below are the mappings that can lead to this behavior:
 
 
 
 
 
Additionally, this error may also occur when there is a discrepancy between the logical (Siebel repository seen with Siebel Tools) and physical schema (use the SQL*Plus command "describe") for the columns of type Varchar. For example, assume the column X_MYCOLUMN defined in Siebel Tools with properties Physical Type set to Varchar and Text Length set to 50. In a business component, the corresponding field has properties Type set to DTYPE_TEXT and Text Length set to 100. However, the definition of the column in the database itself is VARCHAR2(100). In this scenario, if there is one row containing more than 50 characters in this column, the same error is encountered.

Scope

This document is informational and intended for any user.

Details

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
Scope
Details
 Troubleshooting steps
 Other possible causes for error ORA-24345
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.