hI Susan, I have never attempted to change a table ID, never had the need. I would never attempt it either... Having said that, and to answer your question, you would need to do a fair amount of updates in the tables that comprise the "Remedy data dictionary"
The table ID is actually the schemaId in many such tables, so you would need to find all the rows in all the tables to update that schemaId. A good place to start would be to take a look at the BMC document called Database reference guide, or something like that, and see where that schemaId is... In any case, as you know, make sure you have a good database backup before proceeding, and the DBA has actually tested it.... as you know this is one of these tasks were BMC support will not help you, and people from the list won't be of much assistance either if things go wrong. So... do yourself a favor and DON"T do this....instead of importing data on the T tables, use the database views that are automatically created for each table, and for which the view name is similar to the form name. Guillaume ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of Susan Palmer [[email protected]] Sent: Wednesday, July 28, 2010 11:22 AM To: [email protected] Subject: ARS v7.5 - importing forms changed Table ID ** Hi Everyone, We gave up trying to do the ARS v7.5 platform upgrade on our servers. Five months was enough time to waste on that. Yes, we tried everything ... that's not my question here today. Sooooo, we decided to build a new server (vm) and start from scratch with a brand new ARS v7.3 P3 install. That worked great. ITSM is NOT involved in this process at all. Then I exported forms and other workflow objects and did the imports. Kind of a long job because the new server database is on a very slow SAN (nothing I can fix right now). It had not occurred to me that I would loose my original Table ID associated with that form on another server. This is a problem since there is workflow with SQL statements which of course I can change. But, we also have numerous programs pulling data from Remedy that use the Table ID's created by another development group. This would require them to change their programs, possibly dblinks etc. Not a prospect I'm looking forward to. I've only imported data in a couple of forms so far (12 hours worth) and don't want to proceed if I'm going to delete it anyway. I'm using rrrChive for the data and thankfully it's bringing over the correct field 1 values. I do have to figure out how to use rrrChive to include a date modified parameter to get updates. Has anyone been successful at changing a Table ID and how did you do it? Were there any ramifications? Appreciate your help, thanks, Susan Oracle 10g ARS 7.5P3 Solaris 10 Susan Palmer ShopperTrak 200 W Monroe St Floor 11 Chicago, IL 60606 312-529-5325 [email protected]<mailto:[email protected]> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
