[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1331
  • Last Modified:

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

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
benj707
Asked:
benj707
  • 4
  • 3
3 Solutions
 
GMGeniusCommented:
when you attemp to login to GoldMine, Hold down the CTRL key and perform maintenance, select individual files and select the USERS table
0
 
benj707Author Commented:
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
 
GMGeniusCommented:
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
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

 
GMGeniusCommented:
I should also add.

Make sure the G:\ drive is accessible.
0
 
benj707Author Commented:
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
 
GMGeniusCommented:
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
 
benj707Author Commented:
Thanks! ( replacing the files worked, didn't see your initial replies)
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now