04-08-2009 04:17 PM - edited 04-08-2009 04:18 PM
Deleting fields from primary table will not moving existing fields to it. If you create a new field, it will be assigned to the primary table. The workaround is to delete unused fields from the primary table and then create new fields that you frequently sort by and copy your existing data to the new fields.
Another workaround is to rollback to 11.0 (only if you have a backup prior to upgrading to 11.1).
We are currently working a fix and hopefully it will be released soon. At this time I do not have a date on which it will be released.
04-09-2009 04:11 AM
Thank you for the suggestions David but they are not viable for my business. I already removed all my unused fields and I can't remove any more without negatively impacting my business. By my math, we only have about 100 fields left in the test database I mentioned and I don't know how many other businesses use, but I don't consider 100 fields excessive.
Also, our last pre-upgrade backup was two weekends ago and we cannot lose two weeks of work. If I had known about this issue prior to upgrading, I would have stuck with my previous problems and not bothered. Shame on me for installing a service pack the week it comes out, I should have known better. What bothers me most is that we didn't have problems with our old version and spent thousands to upgrade to a product that has been problematic since day one. I know you can't help this David, I'm venting publicly so other people could possibly learn from our error.
If anyone else is thinking of upgrading to 11.1, I'd advise you to make a backup of your database, do a "Restore As" and create a new test database, upgrade one unused machine to the new version and upgrade the Restored database. Or just stick with what works, I wish I did.
05-04-2009 06:58 AM
Hotfix 1 has been released to address this issue. You can find more information in the knowledgebase article linked below.
06-17-2009 07:06 AM
I have the same problem in ACT! and when I tried to apply hotfix, I got error message "Hotfix failed to apply". Anybody knows what does it mean??
thanks in advance
06-18-2009 04:49 AM
06-18-2009 06:11 AM
I just want to make sure that you're currently on 11.1. Can you verify by going to Help > About ACT!? If you're not on 11.1, please apply the 11.1 update that will already include the hot fix.
Please send me a private message if you're already on 11.1.
06-19-2009 12:09 AM - edited 06-19-2009 12:23 AM
I 've sent you a private message with my ACT! version number
06-23-2009 06:32 AM