All of a sudden I was getting the error "An error has occurred executing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)" in one of EBC based view. I am having trouble in loading only a particular record of the invoice otherwise for the other records I am able to view the data in this EBC based view. Finally after doing a research in Support web I come to understand the following:
One of the field length mentioned in the EBC and the table associated with EBC has a lesser length when compared to the actual table which resides outside the Siebel schema. Since its a EBC an external application accessing the application has accessed this field and updated with a greater length of data that is mentioned in the Siebel EBC and Table. Hence the above error occured. After correcting the BC field's length and column length and compiled these changes into SRF have resolved the above issue.
