Error Retrieving Next Record From The Database.sbl-dbc-00104
we did in our Siebel application and became a learning lesson for us.While navigating to "All ora-24345: a truncation or null fetch error occurred Quotes View", system was giving the error : "Error retrieving next record oracle support from the database. (SBL-DBC-00104)". But when I tried navigating to "My Quotes View", no issues. Since the Applet, Business Component, Business Object, PDQs etc etc, being used in both the views were the same, the only thing which was different is "Data". That means there is something wrong with the data which is creating this problem.So, as generally we do, I checked the Siebel Object Manager log and tried to find out what exactly was happening in the background. I queried for error code "(SBL-DBC-00104)" in the log file and found an Oracle code with error saying : "ORA-24345 Truncation or Null Fetch Error".I checked for the possible reason due to which Oracle returns this error. Oracle says : "Please ensure that the buffer size is long enough to store the returned data.".That means I was going into the right direction and data which is being displayed in "All Quotes View" was creating this problem. If I could relate this particular issue with Siebel, we have one Field User Property : "Text Length Override", which restricts the field to display some specific number of characters, no matter what is there in the database.So, when I checked for all the fields in "Quote" business component, there was one field "Comments" which has been restricted to show only 500 charcters while its length was 1000. Now the only thing I need to confirm was if there is any record in S_DOC_QUOTE table having comments > 500 characters.select row_id, commentsfrom S_DOC_QUOTEwhere len(comments) > 500And I was lucky to find one. So I just truncated it to 500 characters and again tried navigating to "All Quotes View" and eveything worked fine.
Feb, 2015 Configuration I have seen multiple instances and variations of the following error:Error retrieving next record from the database.(SBL-DBC-00104)You will get this error when you navigate to one or more specific views. You will hardly find any associated debugging information in the logs, which makes it a little harder to solve.The debugging becomes a lot easier to know what you're looking for, and that is the purpose of this post.The first and foremost thing you do is to find iny other errors in the log file. Go to the http://siebelmantra.blogspot.com/2009/01/error-retrieving-next-record-from.html end of the log file, and find for "Error " (without quotes). There are a few typical errors that eventually lead to the above error.1. ORA-24345: A Truncation or null fetch error occurredAs the code suggests, this is an error thrown by the database. This happens when there is a discrepancy between the type/length http://crmcog.com/error-retrieving-next-record-in-siebel/ at the BC field level and column of the table.For example: Contact.First Name is of type "Text" with a length of 50 characters. S_CONTACT.FST_NAME is the underlying column that is a varchar of length 100 characters.Siebel ignores the length specified against a Text field. You can ignore that default behaviour by defining a field user property:Name: Text Length Override Value: 50This raises a conflict between business layer, and the definition in data layer. When you have any existing data that is going beyond 50 characters in FST_NAME, that leads to "truncation or null fetch error".There can happen to other data types as well -Field of DTYPE_ID containing values of length greater than 15 charactersField of type DTYPE_BOOL having more than one character in the databaseField of type DTYPE_PHONE having values more than 40 characters in lengthColumn of type "Numeric" having more than 16 digits (15 digits when data has a decimal point)The solution is quite simple. Yo
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please https://community.oracle.com/thread/2490922 type your message and try again. More discussions in General CRM All PlacesOracle CommunityArchived ForumsSiebel Archived ForumsGeneral CRM This discussion is archived 1 Reply Latest reply on Jan 22, 2013 5:03 PM by 962517 SBL-DBC-00104 error using External Business Component 962517 Jan 21, 2013 6:09 PM Hi all, I'm trying to use a EBC for querying datas in the Export View. It works fine the most of the times but error retrieving in some querys, it shows the error SBL-DBC-00104: Error retrieving next record from the database. ORA-24345: A Truncation or null fetch error ocurred Looking for the cause of these errors, I have discovered it ocurrs in a calculated field. This field has this calculated value [Accion Cargo Modificado por] + ' - ' + [Updated By] The problem of this is in [Accion Cargo Modificado por] value. In database, this field error retrieving next has the value "RED_DESARROLLORED_SUP" and, after looking for SBL-DBC-00104 in google, I thought that the reason could be the length of this value, too long, but the fields [Accion Cargo Modificado por] and [Updated By] have the same length that the fields in database. Any idea about how put a length limit in a calculated value? can it be wrong because is a EBC? (I haven't this error in a similar BC with the same fields) thanks in advance I have the same question Show 0 Likes(0) 2292Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: SBL-DBC-00104 error using External Business Component 962517 Jan 22, 2013 5:03 PM (in response to 962517) I have discovered the error. The text length in EBC had the same length that the fields in my table in database BUT the columns of that table in Siebel Tools hadn't the same length. That was why my EBC didn't work. Like Show 0 Likes(0) Actions Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3