A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 7 (Corporate Edition) » Deleted indexes to CONTSUPP, now Goldmine won't open    View previous topic :: View next topic  Deleted indexes to CONTSUPP, now Goldmine won't open Posted: Sun May 17, 2009 8:46 am Points: 0 bsncp Experienced Miner Joined: 15 Feb 2008 Posts: 68 FrontRange believed we had some corruption in our CONTSUPP tables, so a proposed solution was to drop the indexes and do a Goldmine maintenance routine. Like this: "The indexes can be dropped in SQL management studio very simply, just right click and delete. The name of the table is CONTSUPP. You will want a full database backup again, and yes all users should be out when this and the maintenance is ran. After that is done…in Goldmine: Go to file >> maintain databases >> select all database files >> select files in GoldMine Directory & Current Contact Set Files >> on the rebuild, sort and verify database files screen do not check anything >> finish. This will re-index the database. Go to file >> maintain databases >> select all database files >> select files in GoldMine Directory & Current Contact Set Files >> on the rebuild, sort and verify database files screen select all options >> finish. This will re-build the database." The problem is we have deleted the indexes as instructed, but now we can't get into Goldmine to do the maintenance steps. We get an error message 'Unable to Open Table'. FrontRange provides little to no SQL support...any direction you guys can give me? We are using SQL 2005. _________________ Director of Marketing Goldbox 2009-E Goldbox-7 Goldmine 8.5.2.8 Posted: Sun May 17, 2009 9:54 am Points: 0 DougCastell GoldMine Guru Joined: 15 Jun 2006 Posts: 1639 Location: Los Angeles, CA Do this in SQL: Code: CREATE UNIQUE NONCLUSTERED INDEX [CNSRECID] ON [dbo].[CONTSUPP] (    [recid] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [CONTSPFD] ON [dbo].[CONTSUPP] (    [RECTYPE] ASC,    [U_CONTACT] ASC,    [U_CONTSUPREF] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [CONTSUPP] ON [dbo].[CONTSUPP] (    [ACCOUNTNO] ASC,    [RECTYPE] ASC,    [U_CONTACT] ASC,    [recid] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [cntsupaddr] ON [dbo].[CONTSUPP] (    [RECTYPE] ASC,    [U_ADDRESS1] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] _________________ Doug Castell GoldMine Sales and Support: http://www.castellcomputers.com/ office: (310)601-4738 Posted: Sun May 17, 2009 3:30 pm Points: 0 bgannett GoldMine Guru Joined: 07 Sep 2007 Posts: 1820 Location: Pacific NorthWest I agree with Doug's solution. _________________ Bob Gannett 253-627-2244 goldsupport@harbornet.com *** Providing AFFORDABLE GoldMine Supportsince 1990 Posted: Mon May 18, 2009 1:27 am Points: 0 ronanc GoldMine Veteran Joined: 10 Sep 2007 Posts: 723 As an alternative to Dougs script, you should be able to type the login details of a master user on the login screen, and hold CTRL when clicking OK, which will bring up the Open Database dialog box. Select your main database and click Maintain. This will allow you to reindex the table without having to log into GoldMine. Posted: Mon May 18, 2009 4:11 am Points: 0 bgannett GoldMine Guru Joined: 07 Sep 2007 Posts: 1820 Location: Pacific NorthWest If you can get that far, Ronan's suggestion is the easy way to go. _________________ Bob Gannett 253-627-2244 goldsupport@harbornet.com *** Providing AFFORDABLE GoldMine Supportsince 1990 Posted: Mon May 18, 2009 6:05 am Points: 0 bsncp Experienced Miner Joined: 15 Feb 2008 Posts: 68 Geez! I always forget about the CTRL button option. This allowed me to get in, run the maintenance, and now users are back in. THANK YOU. _________________ Director of Marketing Goldbox 2009-E Goldbox-7 Goldmine 8.5.2.8 Posted: Mon May 18, 2009 6:36 am Points: 0 ronanc GoldMine Veteran Joined: 10 Sep 2007 Posts: 723 Glad to help! Posted: Mon May 18, 2009 6:53 am Points: 0 bgannett GoldMine Guru Joined: 07 Sep 2007 Posts: 1820 Location: Pacific NorthWest Glad it worked. Thanks for the feedback _________________ Bob Gannett 253-627-2244 goldsupport@harbornet.com *** Providing AFFORDABLE GoldMine Supportsince 1990 Deleted indexes to CONTSUPP, now Goldmine won't open   ContactReview Forum Index » GoldMine 7 (Corporate Edition) You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum All times are GMT - 7 Hours   Page 1 of 1   All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First  Select a forum GoldMine----------------GoldMine 8 - 2019 (Premium Edition)GoldMine 7 (Corporate Edition)GoldMine 6GoldMine LegacyGoldMine Tips and TricksGoldMine CodersFAQOff-Topic GoldMine Addons----------------GoldBoxMastermineCompliance for GoldMineCrystal ReportsQuoteWerksDetails PlusIntelliClickCompanionlinkEndUserSoftwareGoldBookPapillon TechnologyAnvilInaportOpenOffice link Vertical Markets----------------Real EstateRecruitersFinancial   Brought to you by Castell Computers, Doug Castell, Admin Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin