4 Replies Latest reply on Nov 21, 2016 7:41 AM by Daniel Kaehler

    BCO_DB_FAIL103

      Share This:

      I am getting this error, but the database server is up.  Any help on what I could look at to resolve this issue would be greatly appreciated.

       

      Alert Error Code: BCO_DB_FAIL103

       

      BCO_DB_FAIL103: Loader: SQL*Loader-605 - Non-data dependent ORACLE error occurred. Check database availability and instane status.

       

      [2013-04-24 12:29:05,819]

        • 1. Re: BCO_DB_FAIL103

          Were you able to solve your problem? did you also check DB connectivity?

          Otherwise I would recommend contacting our Tech Support

          thanks,

          G

          • 2. Re: BCO_DB_FAIL103

            yes we were able to resolve this problem thank you

            • 3. Re: BCO_DB_FAIL103

              we do see same issues and messges , However rest of BCO works fine , it occurs during certain tasks .

              Connected with DBs and found no issues and instances which were down. Is it a bug ??

              below is the error code associated with it  getting BCO_DB_FAIL_103 ERROR which is Availability/Connectivity: the DB instance seems to be DOWN or not reachable 

               

              Here the logged message :-

               

               

              Error executing request    http://bco url  wizard/reportwizard.do   ( this is temp url format)
              StackTrace: com.neptuny.cpit.entity.ExceptionContainer:
              com.neptuny.cpit.querymanager.QueryException - message: [java.sql.SQLRecoverableException] - No more data to read from socket
              query-name: Task.selectCustomByReportTypeid
              sql-code : SELECT taskid, name, description, enabled, tasktypeid, startts, endts, period, taskgroupid, schedulerid, srcid, licmodid, etlmodid FROM TASK t
              WHERE tasktypeid in (3,29)
              AND EXISTS
              (SELECT NULL
              FROM task_pset tp
              WHERE t.taskid = tp.taskid AND active = 1
              AND EXISTS
              (SELECT NULL
              FROM task_pset_props
              WHERE taskpsetid = tp.taskpsetid
              AND name ='reportexecutor.report.typeidlist'
              AND ? IN
              (SELECT *
              FROM TABLE(SPLIT (
              VALUE,';'))))) ORDER BY tasktypeid,enabled,period
              param 1: 0 - java-type: java.math.BigDecimal - sql-type: NUMBER
              com.neptuny.cpit.entity.EntityException - message: SELECT_CUSTOM_FAILED
              Class --> com.neptuny.cpit.entity.base.Task
              Attributes --> taskid=null;name=null;description=null;enabled=null;tasktypeid=null;startts=null;endts=null;period=null;taskgroupid=-1;schedulerid=0;srcid=null;licmodid=null;etlmodid=null;

              at com.neptuny.cpit.entity.EntityDBHelper.selectCustomByParameters(EntityDBHelper.java:554)
              at com.neptuny.cpit.entity.EntityDBHelper.selectCustomByParameters(EntityDBHelper.java:529)
              at com.neptuny.cpit.entity.DatabaseFacade.getCustomByParameters(DatabaseFacade.java:185)
              at com.neptuny.cpit.coreclient.CoreClient.getCustomByParameters(CoreClient.java:1311)
              at com.neptuny.cpit.util.ReportUtil.buildPublicationPeriodCollection(ReportUtil.java:109)
              at com.neptuny.cpit.util.ReportUtil.buildPublicationPeriodCollection(ReportUtil.java:92)
              at com.neptuny.cpit.web.struts.common.AbstractReportAction.buildPublicationPeriodCollection(AbstractReportAction.java:162)
              at com.neptuny.cpit.web.struts.wizard.ReportWizardAction.prepareMailTypeSelect(ReportWizardAction.java:663)
              at com.neptuny.cpit.web.struts.wizard.ReportWizardAction.prepareChoosePeriod(ReportWizardAction.java:612)
              at com.neptuny.cpit.web.struts.wizard.ReportWizardAction.evaluateStep(ReportWizardAction.java:427)
              at com.neptuny.cpit.web.struts.wizard.WizardAction.doStrutsExecution(WizardAction.java:106)
              at com.neptuny.cpit.web.struts.AbstractAjaxAction.execute(AbstractAjaxAction.java:146)
              at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
              at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
              at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
              at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
              at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
              at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
              at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
              at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
              at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
              at com.neptuny.cpit.web.servlets.filters.breadcrumb.BreadCrumbFilter.doFilter(BreadCrumbFilter.java:69)
              at org.apache.cata...

              • 4. Re: BCO_DB_FAIL103
                Daniel Kaehler

                Hi,

                 

                How were you able to resolve this issue?