Error: General ODBC Error [Microsoft] [ODBC SQL Server Driver] Connection is busy with results for another hstmt Native Error: 0-when saving attendance for students

When entering attendance for selected students users may receive the following errors:
  1. Error: They key is already associated with an element  of this collection
  2. Error: General ODBC Error [Microsoft] [ODBC SQL Server Driver] Connection is busy with results for another hstmt Native Error: 0
  3. Run-time error '0'
  4. Error: Abnormal termination of BBElastic: 2 Interface reference(s) were not removed. Interfaces for the following objects still exist: Object Object\
The error has also appeared when trying to globally add attendance for students. When this error occurs, there may be a specific student or students causing the error.  

We are currently evaluating this issue and will update this article when we have more information. In the meantime, you can try the steps below :

 

Verify the student does not have duplicate course request


**Prior to dropping the student to delete the course request, run attendance repots, grab screenshots of assignment grades/skills that appear in FAWeb and any grades/skills in Education Edge.
 

  1. In Education Edge, Click Scheduling >  Click Open a Class > Open affected class
  2. Click on the Students tab
  3. Unmark Enrolled for affected student> Click Drop> Save and close the class record
  4. Click Enter course request by student > Search for affected student
  5. Click on the  affected Course with the duplicate course request > Press Delete on your keyboard
    1. If the student was withdrawn from a course, the student would need to be re-enrolled , dropped, and then the course request can be removed
  6. Re-enroll the student in the class> save and close
  7. Reenter any deleted grading (skills, grades, comments) and Attendance information



User-added image

User-added image

Steps to Duplicate

  1. Login as a user receiving this error message
  2. Go to Attendance>Enter Attendance by student and search for a student producing the error message
  3. Enter an attendance code for Class and click save 
  4. Receive series of error messages 

Environment

 Education Edge
 7.87

Was this article helpful?