prostrct repair dbname - cannot repair DB coppied to new server host.

arnisraido

New Member
I have new server, where I have installed Progress and wants to copy old DB for test purposes.
I have coppyed all files from old server, but when starting DB, it says:

Code:
22:19:20 BROKER  0: F:\db\name.db is a copy of E:\DB\SERV\name.db. Database cannot be opened. (598)

So - I must run prostrct. But When I execute it, it cannot repair database and retursn error code:

Code:
proenv>prostrct repair F:\db\name
PROGRESS Version 9.1D05 as of Wed Feb 12 06:16:04 EST 2003
Error: repair for file F:\db\name cannot add or delete entries (9883)

What am I doing wrong?
When executing prostrct on old server, everything works fine.
 

TomBascom

Curmudgeon
Did you provide a structure file with the same storage areas in it?

For instance -- if you were moving the db from the F: drive to the E: drive you would copy all of the name.db, name.a*, name.b*, name.d* files as well as name.st (if you don't have a .st file first run "prostrct list". You would then edit name.st to change all references to F: to E: and make any other path changes. You then do "prostrct repair name". If you didn't copy & edit the name.st file you could get a message like what you describe.

9.1D05 -- ancient, obsolete, unsupported and buggy. You should upgrade.
 

arnisraido

New Member
Great!

Thank You! I created a copy of all db files (including .st) from old server to new one, and then edited .st file (as it did not have any pathes at all) to direct to right location.

Then prostrct completed successfuly and DB started.
 
Top