Alerts

After upgrade to TeamTrack 6.6.1.17 or TeamTrack 6.6.1.18, some attachments may not be accessible on items.



ID:    A40
Published:    10 December 2009
Updated:    11 December 2009

Operating System(s)

  • All Windows
  • Linux
  • Solaris

Product(s)

  • TeamTrack
 

Description

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

 

 

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs