Failed to execute query during add dsource

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
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:

Suggested Action:
Check connectivity.
Photo of HJ


  • 540 Points 500 badge 2x thumb

Posted 5 years ago

  • 0
  • 1
Photo of David Gillespie

David Gillespie, Employee

  • 1,010 Points 1k badge 2x thumb
Official Response
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.
Dave G.