| |
Results |
|
SBM Schema holds no information on fields added to SBM 2009 R3
|
In the table TS_ATTACHMENTS there are fields called: TS_VERSIONID, TS_CHECKEDOUTUSER, TS_ISCHECKEDOUT, TS_ISSPATTACHMENT, but in "sbm_schema_doc.pdf" there isn't any info about them.
|
|
|
|
Parent-Child (master-detail) relationships are not migrated from Tracker
|
Tracker project has parent child relationships. Using 6.6 these are not imported when importing into TeamTrack (nothing in the TS_Attachments table and nothing in the change history).
|
|
|
|
If you store attachments in the database, how do you know what blob it is?
|
The code looks at the ts_contents column in the ts_attachments table, matches that with the ts_name column in the ts_resources table, and then refers to the blobs table here via the ts_blobid column. Also, all file attachments will be ts_type = 4 in the ts_resources table.
|
|
|
|
Deleting attachment from database can take a long time
|
When deleting an attachment, one of the queries contains a text search for the name of the item being removed and, when there is a very large number of items in the ts_attachments table, this operation can take some time. A defect has been raised for this behaviour.
|
|
|
|
Advanced SQL report to list issues that have attachments
|
@WHERE TTT_ISSUES.TS_ID IN (SELECT TS_CASEID FROM TS_ATTACHMENTS WHERE TS_SRCTABLEID IN (SELECT TS_ID FROM TS_TABLES
|
|
|
|
Purging items from the archive does not remove TS_RESOURCES and TS_BLOBS entries for any attachments when stored in the database
|
If attachments are held in the database and you purge items from an archive then the entries in TS_RESOURCES and TS_BLOBS are not removed. The TS_ATTACHMENTS entries are removed fine.
|
|
|
|
Deadlock errors occur when loading an item with images where the "show attachment as image" option is checked
|
When loading an item with multiple images displayed on a page, deadlocks occur. The deadlock error causes the new record in the TS_ATTACHMENTS table to not be updated correctly
|
|
|
|
Searching for all Issues that are posted from Incidents
|
@WHERE databaseTableName.TS_ID IN (SELECT TS_CASEID FROM TS_ATTACHMENTS WHERE TS_TYPE = 64 AND TS_SRCTABLEID IN (SELECT TS_ID FROM TS_TABLES WHERE TS_DBNAME LIKE 'databaseTableName') AND TS_DESTTABLEID IN (SELECT TS_ID FROM TS_TABLES WHERE TS_DBNAME LIKE 'sourceTableName') )
|
|
|
|
Moving attachments from DB to file system (or vice versa) does not delete the rows from TS_RESOURCES and TS_BLOBS
|
(1) Make sure attachments are being stored in the database. Create an item and add some attachments. Check the size of TS_RESOURCES/TS_BLOBS and TS_ATTACHMENTS increases - this assumes you are sole user of the system
|
|
|
|
If a form field equals a certain value, require a file be attached before a transition can happen. Sample app script.
|
whereClause = "TS_CASEID=" & itemId set myAttachmentList = Ext.CreateAppRecordList(Ext.TableId(" TS_ATTACHMENTS ")) ok = myAttachmentList.ReadWithWhere(whereClause)
|
|
|
