External BC problem

Hi,

We have a requirement to fetch data from external DB and show it in Siebel UI, we have to develop two Siebel views, we have to get them from External DB Views.

We have created Siebel Tables from views using the External table schema import option and created two Tables. We have also created two BC's added them to Account BO after configured proper link between Account BC and newly created BC's. For most of the Accounts, we are able to retrieve the data and showing it in Siebel views.

But sometimes, for one of the view we are not able to get all the records and for another view it is throwing some error when we try to access it, the error message is Error retrieving next record from the database.(SBL-DBC-00104)