The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
v7 Upgrade and Deleting PKs and Indexes
Posted: 17 Oct 06 9:57 AM
|
fiogf49gjkf0d I am upgrading from 6.2.1 to 7.0. In the documentation (Upgrading Sage CRM SalesLogix to Version 7.0) step 19 states that it is converting currency values from float or real data to a number data type. The documentation states these changes will fail if there are primary or foreign key constraints or unique indexes on the tables being modified. If any of these conditions exist for the following tables, the keys and indexes should be removed before the Upgrade bundle is applied:
leadsource, literature, account, campaign, contract, contractincident, opportunity, opportunity_product, product, productprogram, quota
Sounded strange enough for me to call support. After some discussion on their end the answer came back that I should delete all the indexes and keys for the tables listed above before applying the upgrade bundle. So I go to do that and first table (leadsource) I try to do this to is giving me problems with deleting the primary key. It won't let me because of referential integrity.
I'm now restoring from a backup and writing here to find out what the experience has been with this step?
Thanks,
John G. |
|
|
| |
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 18 Oct 06 9:29 AM
|
fiogf49gjkf0d Ok.. I was using SQL 2005 Enterprise manager. Not sure if this was the issue. I will have to try to dig up a SQL 2000 QA.
So basically you did delete all what was recommended before applying the v7 upgrade bundle?
Thanks,
John G. |
|
|
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 19 Oct 06 9:23 AM
|
fiogf49gjkf0d Yes, for every upgrade except the first and that one was not fun 
I believe the upgrade work plan mentions another acceptable tool to make the change as well, don't remember what it was off the top of my head.
Brian |
|
|
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 06 Dec 06 8:32 AM
|
fiogf49gjkf0d I just ran my first test upgrade from 6.2 to 7. I got the messages about the indexes existing, but was able to complete the upgrade anyway. Should I delete the indexes and reinstall the bundle? If so, do I delete all indexes on the stated tables? When I look in the leadsource table for example, I see two indexes..
Thanks |
|
|
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 07 Dec 06 2:38 AM
|
fiogf49gjkf0d No, the index message you are seeing is simply because the bundle tries to create an index (email3 for example) and that index exists already. So, nothing to do. |
|
|
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 07 Dec 06 7:46 AM
|
fiogf49gjkf0d So what happens if you don't remove the existing indexes and primary keys?
Also, what is the best way to "put them back" when you are done? |
|
|
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 07 Dec 06 8:34 AM
|
fiogf49gjkf0d As far as I can tell - nothing. When this was queried with SLX during the beta process - they'd had one issue with an upgrade not going well (hence the need to remove). But, frankly, all mine have worked and I've not removed them.
In order to put them back - you have to script them [the indexes], drop them and then re-index afterwards. But, as a process this can't work in remotes situations as those items won't sync.
I wouldn't bother to be honest (and don't). |
|
|
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 07 Dec 06 8:52 AM
|
fiogf49gjkf0d Thank you, Mike. Since we are going to run this in dev and test environments first, I will give it a try without first and then deal with it afterwards if it doesn't work.
Regards, LaNae |
|
|
|
Re: v7 Upgrade and Deleting PKs and Indexes
Posted: 28 Dec 06 4:41 PM
|
fiogf49gjkf0d I'm facing the same issue when upgrading from 5.2 to 7.0. I asked the same question in the SalesLogix Newsgroups, and the responders said to first try it without removing the keys and indexes. I've already set up a separate server for Version 7, and I'd like to try it there. My little problem is that I think I first have to apply the upgrade bundles directly to the Version 5.2 database using the 5.2 Administrator. Is there anyway to first restore the 5.2 database to my 7.0 server (which already has the 7.0 programs) and apply the upgrades directly on the new server?
 |
|
|
| |
|