I found the following error message being returned from infusionsoft API, how to resolve this error?

<?xml version="1.0" encoding="UTF-8"?>
<value>DatabaseErrorQuery took too long and was cancelled</value>

What is the cause of this error message?

If it’s just an occasional message then it’s the DB service running out of resources from time to time (usually) but if you get this every time then it’s likely a DB authentication problem. In that case, the DBMS just sits there and doesn’t return anything until the server times it out.

Kumar, is this related to running a Query or Saved Search?

If the search is quite complex and running it on a big database, you will probably get these type of warnings.

If it is a Saved Search I would try reducing the number of fields you are displaying. Or try reducing the number of fields you are querying on to see if it makes a difference.

If you can provide more information that would help.