Please use this SQL statement to determine if you may have issues viewing an attachment on an item after upgrade to TeamTrack 6.6.1.17 or .18

In certain circumstances, items stored in the database may not have the correct file size recorded in the TS_BLOBS table.  This SQL will identify any attachments with this issue.  We will be supplying an update statement to fix the issues very soon.

This will only affect attachments added to items before the upgrade, and will only affect attachments stored in the database.  Also, the attachment is not destroyed, just inaccessible, so there is no loss of data.

--SELECT FOR MS SQL
select [WRONG_RECORDS]=count(*) from TS_BLOBS where TS_FILESIZE <> datalength(TS_BLOB) and TS_BLOB is not null

--SELECT FOR ORACLE Please put in the correct tablespace name
select count(*) as WRONG_RECORDS from <TABLESPACE_NAME>.TS_BLOBS where TS_FILESIZE<>dbms_lob.getlength(TS_BLOB) and TS_BLOB is not null