Difference between revisions of "ITrack/Error 1050: Table Already Exists"

From ISoft Wiki
Jump to navigationJump to search
(New page: ==Cause== The last time the report was run, it created what was supposed to be a temporary table. For whatever reason, that temporary table turned out not to be very temporary and it stil...)
 
(Added to Error Messages category)
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
This error will sometimes appear when attempting to print a report that uses a prequery.
==Cause==
==Cause==
The last time the report was run, it created what was supposed to be a temporary table.  For whatever reason, that temporary table turned out not to be very temporary and it still hanging around.
If this error occurs while attempting to print a report, it happens because the table created the last time the report was run did not get cleaned up correctly.


==Solution==
==Solution==
Try running the report a couple more times in ITrack.  That should clear the table out of memory correctly and allow you to run the report smoothly once again.
Immediately after the error message is displayed, ITrack should clean up the table for you.  Attempting to run the report again should yield appropriate results.


[[Category:Printing Error Messages (ITrack)]]
[[Category:ITrack/Problems/Printing]]
[[Category:Error Messages (ITrack)]]
[[Category:ITrack/Problems/Error Messages]]

Latest revision as of 09:37, 14 July 2009

This error will sometimes appear when attempting to print a report that uses a prequery.

Cause

If this error occurs while attempting to print a report, it happens because the table created the last time the report was run did not get cleaned up correctly.

Solution

Immediately after the error message is displayed, ITrack should clean up the table for you. Attempting to run the report again should yield appropriate results.