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

API Q&A
1 
<?xml version="1.0" encoding="UTF-8"?>
 <methodResponse>
<fault>
<value>
<struct>
<member><name>faultCode</name>
 <value><i4>4</i4></value></member>
 <member><name>faultString</name>
<value>DatabaseErrorQuery took too long and was cancelled</value>
 </member>
</struct>
</value>
</fault>
</methodResponse>

What is the cause of this error message?

2

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.

3

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.

Thanks