Delphix Products

Expand all | Collapse all

Failed to execute query during add dsource

  • 1.  Failed to execute query during add dsource

    Posted 11-04-2014 05:22:00 AM
    I got an error following message during add dsource.
    The connection to the source oracle is ok using sqlplus.
    What should be checked to solve this problem?

    Error:Failed to execute query on source database due to: Incorrect result size: expected 1, actual 0 . An error was received when executing the query. This typically indicates that the connection to the database has been lost.

    Error Code:
    exception.oracle.dbc.query.failed

    Suggested Action:
    Check connectivity.


  • 2.  RE: Failed to execute query during add dsource
    Best Answer

    Posted 11-04-2014 05:56:00 AM
    Hi,
    This is usually caused by an idle database. Please log into the dsource database and alter system switch logfile a number of times.
    Then try the db_sync again.
    Cheers,
    Dave G.


  • 3.  RE: Failed to execute query during add dsource

    Posted 11-04-2014 06:28:00 AM
    Thanks a lot !!!


  • 4.  RE: Failed to execute query during add dsource

    Posted 04-03-2015 12:30:00 PM
    I got the same problem, I solved just following your suggestion. Thanks a lot!!!!


  • 5.  RE: Failed to execute query during add dsource

    Posted 04-13-2015 11:49:00 AM
    Thanks a lot. It helps me too.