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:
exception.oracle.dbc.query.failed

Suggested Action:
Check connectivity.
Photo of HJ

HJ

  • 540 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of David Gillespie

David Gillespie, Employee

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