Jump to content


Photo

Truncate Surveyresponders Table


  • This topic is locked This topic is locked
No replies to this topic

#1 dfoster

dfoster

    Advanced Member

  • Moderators
  • PipPipPip
  • 238 posts
  • Gender:Male
  • Location:Winter Park FL
  • Interests:Guitar

Posted 25 September 2009 - 11:00 AM

ISSUE UPDATE 9/28/09

After further review, we have fixed the growing surveyresponders table, but now we are running some truncate code in SQL that needs admin permissions to run, so if you are connecting to the database in a DBO role, you will get the error.

This is fixed and we plan to get an udpate out asap as soon as we are done with final testing. FYI, this will be SQL update release 10.5.7 and the auto updates will be working if you upgrade from 10.5.4 or 10.5.6 versions.

---------------------------------------------

Hi AccuSQL users,

As some of you may know, we recently found a bug where the surveyresponders table is growing very large. We tested and believed this was fixed in AccuSQL 10.5.6, but a related issue is still being reported.

This issue may result in the following error in AccuSQL under certain conditions:

"OLE IDispatch exception code 0 from Microsoft SQL native client: cannot find the object SURVEYRESPONDERS because it does not exist or you do not have permissions"

We will get a fix out asap, but in the meantime, you should run the following queries in SQL Server Management Studio against the database that is problematic:

-- COMMENT LINE ONLY let's see how many rows you have. I have 5100, but users have reported much larger numbers (based on number of students/tutors they have)...
select * from surveyresponders
-- COMMENT LINE ONLY and dump it
truncate table surveyresponders

David Foster
Engineerica Systems Support





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users