Solved

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

Posted on 2011-03-23
7
1,293 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

 
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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

Read about achieving the basic levels of HRIS security in the workplace.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

691 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