community.borland.com

Article #25580: What could cause a request synchronization error?

Problem:
What could cause a request synchronization error?

Solution:
Note: The information in this document refers to InterBase version 5.X

Here are some possible causes of the request synchronization error.
This is not an all inclusive list.  It is meant as a guide to help
narrow down what could cause this in a customer's application.

1. Corrupt database .
 try 
    gfix -v -f 
  followed by
    gfix -m

 gfix is located in the interbasebin directory on 
 the machine that houses your InterBase server.


2. recursive triggers


3. Trying to use a same cursor on a different selects
   in a trigger that has already been defined to another
   select statement.


4. Trying to use a cursor name of a cursor that was
   already open on a different table.

5. Trying to fetch past the end of the rows in query results.

6. Improper variable initialization.  
   One customer found that when someone incorrectly defined
   a variable that should have been a long as a short, they
   got this error.

7. Using a computed field that accidentally winds up dividing 
   by zero. 

Last Modified: 26-OCT-00