• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

Database Engine Error: Index does not exist.

Hi
I am facing an issue while running a dBase applicaton it throws following error:
Database Engine Error:  Index does not exist.
The reason what I believe is that I have moved all the database to one single server where we have hosted both the database that exist on 2005 and 2000.
Kindly please help me to resolve this issue.

Thanks in advance
0
desaiviveks
Asked:
desaiviveks
  • 5
  • 3
1 Solution
 
desaiviveksAuthor Commented:
Require urgent attention
0
 
pcelbaCommented:
If your application is really dBase then it seems you did not move all necessary files. Databases have DBF extension, indexes should have MDX, NDX, or eventually IDX and CDX if you are using FoxPro.

If you are using SQL Server then indexes are inside the database and your problem is somewhere else. Yo should check database integrity by DBCC CHACKDB command.

So, you should say what database engine are you using and the check if all files were moved properly.
0
 
pcelbaCommented:
The SQL command to check the database integrity is

DBCC CHECKDB (DatabaseName)

You should also post more info about the error. I don't believe it is so short without details.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
desaiviveksAuthor Commented:
04/22/2010 05:47:21.07
R:\RLEB\RLEB.exe
R:\RLEB\zcontrol.cc
ZTEXT::INIT
1299
239
Database Engine Error:  Index does not exist.
--
Here is the error message
0
 
desaiviveksAuthor Commented:
Please see the result after running the
DBCC CHECKDB (DatabaseName)

CHECKDB found 0 allocation errors and 0 consistency errors in database <DatabaseName>
0
 
pcelbaCommented:
The problem is definitely not on SQL Server but in your dBase application.

It means you did not copy all necessary files or the files are in different folder or this application (RLEB.EXE) does not support data folder change.

If you have source code available then you may look into file zcontrol.cc (probably line no. 1299) what index is necessary. The object is called ZTEXT and the error is in its Init method most probably.

If you have no source code available then you have to ask the application vendor what is the right scenario to move data to another server and what configuration changes it requires.
0
 
desaiviveksAuthor Commented:
Appreciate your quick reply. Let me check out with my Vendor.
0
 
desaiviveksAuthor Commented:
Got the solution with the clue provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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