Any ideas how to find some duplicates?

How much data do you have in the tables?

All of them have around 290,000 records except contactcalldetail that has around 700,000. Still executing, 8 min now

I finally get an error… isn’t this frustratring?

Error: Cannot write sorted rows.
SQLState:  IX000
ErrorCode: -567
Error: ISAM error: no free disk space for sort
SQLState:  IX000
ErrorCode: -179
Position: -1

I’ll look at the query further because it doesn’t look like it’s doing things right…

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.