RT 4.4: Leftover RTx Tables in DB

Been following/using RT’s Assets since the Extension days but had upgraded
to RT 4.4.0rc1 a while back now.

Came to run an SQL query, held in a file, against the underlying DB, so as
to produce some output in a format that matches that shown in a vendor’s
portal display.

Was mystified as to why a couple of recent additions to my Asset catalogs
were not showing up.

Eventually realied that the SQL query had been written thus

SELECT
SuppSNum.Content as ‘Serial Num’,
RPAD(RTxAssets.Name, 20, ’ ') as ‘Host name’,
SuppSite.Content as ‘Site Id’,
Warranty.Content as 'Expiration Date’
FROM RTxAssets,
ObjectCustomFieldValues as Warranty,
ObjectCustomFieldValues as SuppSNum,
ObjectCustomFieldValues as SuppSite

so against the old RT::Extension tables, which are clearly still within the DB.

Dropping the RTx so as to query the upgraded tables gave me the current details.

Can I just bin the (two ?) RTx tables ?

RTxAssets
RTxCatalogs

or are there “things to look out for” ?

Kevin M. Buckley

eScience Consultant
School of Engineering and Computer Science
Victoria University of Wellington
New Zealand

Hi Kevin,

Can I just bin the (two ?) RTx tables ?

RTxAssets
RTxCatalogs

or are there “things to look out for” ?

You can indeed get rid of those tables. We keep them around during the automatic upgrade scripts in an abundance of caution.

Kevin M. Buckley

Thanks,
Shawn

signature.asc (801 Bytes)