How To Troubleshoot the error ORA-24345 "A Truncation or null fetch error occurred"?
(Doc ID 476591.1)
Last updated on MARCH 06, 2018
Siebel Tools - Version 220.127.116.11  and later Siebel CRM - Version 18.104.22.168  and later Information in this document applies to any platform.
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:
Fields with Type property set to "DTYPE_ID" mapped to a column with a physical type of Varchar longer than 15 characters.
Fields with Type property set to "DTYPE_BOOL" mapped to a column with a physical type of Varchar longer than 1 character.
Fields with Type property set to "DTYPE_PHONE" mapped to a column with a physical type of Varchar longer than 40 characters.
Fields with Type property set to "DTYPE_TEXT" mapped to a column with a physical type of Date/Time.
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.
This document is informational and intended for any user.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!