Solved

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

Posted on 2011-03-23
7
1,268 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 12

Expert Comment

by:GMGenius
Comment Utility
I should also add.

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

Author Comment

by:benj707
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks! ( replacing the files worked, didn't see your initial replies)
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

762 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

11 Experts available now in Live!

Get 1:1 Help Now