Solved

the g:/users index file is missing or corrupt!

Posted on 2011-03-23
7
1,272 Views
Last Modified: 2013-11-15
the g:/users index file is missing or corrupt!
Goldmine will not function properly until this table is rebuilt!

When I click rebuild the file and provide my sql login information it takes me to the repair wizard but that shuts off after 5 seconds.

How can I fix this?

Thanks.
0
Comment
Question by:benj707
  • 4
  • 3
7 Comments
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
ID: 35197593
when you attemp to login to GoldMine, Hold down the CTRL key and perform maintenance, select individual files and select the USERS table
0
 
LVL 1

Author Comment

by:benj707
ID: 35197680
It takes me too the maintenance wizard if I do/don't hold down CRTL but that shuts off after 2 seconds.

"the g:/users index file is missing or corrupt!
Goldmine will not function properly until this table is rebuilt!

Would you like to rebuild this file now? (yes or no) "

after clicking yes ive got to provide my sql login it then runs the repair wizard but that just shuts off after a second.

Are there files that can be replaced, would replacing files overwrite any data? (ive got a backup) Where would the USERS files be located?

This problem started after someone ran the Maintain Databases.

Thank you.
0
 
LVL 12

Assisted Solution

by:GMGenius
GMGenius earned 500 total points
ID: 35197721
6.7 has the Users table in the root of the goldmine folder

USERS.DBF
USERS.DBT
USERS.MDX

Thes can be replaced from a backup. the SQL login should only be needed for the contact set and after you have logged in.

Try replacing these files from a backup
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 12

Expert Comment

by:GMGenius
ID: 35197730
I should also add.

Make sure the G:\ drive is accessible.
0
 
LVL 1

Author Comment

by:benj707
ID: 35197745
There are a whole bunch of  user files;

e.g. user_def.tbi        users.dbf      users.dbt    users.mdx

or does 'g:/users index file' mean something else? is it safe to just replace these with my backup?
0
 
LVL 12

Assisted Solution

by:GMGenius
GMGenius earned 500 total points
ID: 35197767
USERS.MDX is the index, the maintenance should re-create this

When replaceing dBase files you should always replace all that relate.

eg

USERS.*

USERS.DBF
USERS.DBT
USERS.MDX

These are where the login information and passwords are recorded
0
 
LVL 1

Author Closing Comment

by:benj707
ID: 35197855
Thanks! ( replacing the files worked, didn't see your initial replies)
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

GoldMine CRM has a fairly open database architecture , however in this case the email distribution list is stored in a quirky way and does not allow easy access for external use. This article will give details of this and provide a method to extr…
I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now